Carrrealestategroupllc.com Search Results

$1,038,389

Outstanding opportunity to acquire a fully occupied mixed-use investment property in the heart of Delmar's highly desirable Four Corners. Prominently positioned along Delaware Avenue, Delmar's primary retail corridor, the property is surrounded by established retail, commercial and residential uses in a walkable Main Street-style setting. The two-story building features approximately 3,000 SF of first-floor retail space occupied by long-term tenant Perfect Blend, which has operated at the property since 2016. The second floor consists of a spacious 1,242 SF two-bedroom apartment occupied by a long-term residential tenant. Additional features include rear parking with a formal shared-parking agreement, a full basement used for retail storage, separate residential access and Hamlet zoning. A rare opportunity to acquire a stabilized, income-producing asset in one of the Capital Region's most desirable communities.

3 Baths ⋅ 202624754 MLS

Outstanding opportunity to acquire a fully occupied mixed-use investment property in the heart of Delmar's highly desirable Four Corners. Prominently positioned along Delaware Avenue, Delmar's primary retail corridor, the property is surrounded by established retail, commercial and residential uses in a walkable Main Street-style setting. The two-story building features approximately 3,000 SF of first-floor retail space occupied by long-term tenant Perfect Blend, which has operated at the property since 2016. The second floor consists of a spacious 1,242 SF two-bedroom apartment occupied by a long-term residential tenant. Additional features include rear parking with a formal shared-parking agreement, a full basement used for retail storage, separate residential access and Hamlet zoning. A rare opportunity to acquire a stabilized, income-producing asset in one of the Capital Region's most desirable communities.

376-378 Delaware Avenue

$1,295,000

Offered for the first time, this exceptional all-brick luxury estate home is gracefully set on 1.5 picturesque acres in sought-after Slingerlands. A grand brick-paver circular drive welcomes you to the striking double Honduran mahogany entry doors, setting the tone for the elegance within. Spanning 4,737 square feet, the residence showcases soaring cathedral ceilings, abundant natural light, exquisite custom millwork, and a stunning blend of marble and hardwood floors. Dramatic windows frame captivating views of the beautifully landscaped grounds and inviting inground pool, creating a truly remarkable setting for refined living and effortless entertaining. The chef-inspired kitchen offers custom cabinetry, expansive island, subzero refrigerator and freezer; opens to the impressive family room with two-story stone fireplace. The first-floor primary suite is a private retreat with marble Jacuzzi bath, steam shower, dual onyx vanities, generous walk=in closet, fireplace and French doors to the tiered patio and inground pool. Library styled study/office , sweeping front staircase and 3-car garage, create an exceptional blend of elegance and everyday convenience. Upstairs offers 3-spacious bedrooms with baths, plus skylit loft, private rear staircase and additional cedar storage closet. Ideally located in sought-after Bethlehem Schools, Albany hospitals, shopping and rail trail. A timeless estate for gracious entertaining and family living.

4 Beds ⋅ 5 Baths ⋅ 202624584 MLS

Offered for the first time, this exceptional all-brick luxury estate home is gracefully set on 1.5 picturesque acres in sought-after Slingerlands. A grand brick-paver circular drive welcomes you to the striking double Honduran mahogany entry doors, setting the tone for the elegance within. Spanning 4,737 square feet, the residence showcases soaring cathedral ceilings, abundant natural light, exquisite custom millwork, and a stunning blend of marble and hardwood floors. Dramatic windows frame captivating views of the beautifully landscaped grounds and inviting inground pool, creating a truly remarkable setting for refined living and effortless entertaining. The chef-inspired kitchen offers custom cabinetry, expansive island, subzero refrigerator and freezer; opens to the impressive family room with two-story stone fireplace. The first-floor primary suite is a private retreat with marble Jacuzzi bath, steam shower, dual onyx vanities, generous walk=in closet, fireplace and French doors to the tiered patio and inground pool. Library styled study/office , sweeping front staircase and 3-car garage, create an exceptional blend of elegance and everyday convenience. Upstairs offers 3-spacious bedrooms with baths, plus skylit loft, private rear staircase and additional cedar storage closet. Ideally located in sought-after Bethlehem Schools, Albany hospitals, shopping and rail trail. A timeless estate for gracious entertaining and family living.

1648 New Scotland Road

$1,875,000

Sitting gracefully along the Hudson River, this spectacular waterfront estate offers breathtaking panoramic scenery of an unparalleled luxury lifestyle. Beautifully designed, every room captures the property in all its glory. You can immerse yourself in the waterfront views plus views of the gunite infinity pool, tennis court & guest cottage from almost anywhere in the home. The guest house features 3BR's, parking + deck overlooking 300ft of beach front. Features incl gourmet kitchen, 1st flr office+ library. Master suite w/private terrace, large great room, lower level recreation room & more. This is a one of a kind property in Bethlehem School District.

4 Beds ⋅ 5 Baths ⋅ 202617794 MLS

Sitting gracefully along the Hudson River, this spectacular waterfront estate offers breathtaking panoramic scenery of an unparalleled luxury lifestyle. Beautifully designed, every room captures the property in all its glory. You can immerse yourself in the waterfront views plus views of the gunite infinity pool, tennis court & guest cottage from almost anywhere in the home. The guest house features 3BR's, parking + deck overlooking 300ft of beach front. Features incl gourmet kitchen, 1st flr office+ library. Master suite w/private terrace, large great room, lower level recreation room & more. This is a one of a kind property in Bethlehem School District.

248 Van Wies Point Road

$1,075,000

A rare opportunity to own a nearly new custom built 5 bedroom, 4.5 bath home without the wait of New Construction. Built just three years ago by Hanifin Home Builders and set on 2.22 private acres backing to forever wild & nature trails, this residence offers a refined blend of privacy, craftsmanship, and modern design within the Bethlehem School District. Thoughtfully designed for both everyday living and multigenerational flexibility, the home offers a first-floor primary suite featuring a true spa-like en suite with a soaking tub, oversized walk-in shower w/ double shower heads, separate vanities, and a private water closet, along with its own dedicated laundry. A second first-floor bedroom with a private bath provides ideal guest or in-law accommodations. The heart of the home is an expansive chef's kitchen with a statement island, double wall ovens, shrock cabinetry, prep sink & area, opening seamlessly to a sunlit breakfast nook, an incredible custom pantry and a generous formal dining room, all open to a dramatic great room with cathedral ceilings and gas fireplace. Upstairs, a private bedroom suite is complemented by two additional bedrooms, a full bath, and a second-floor laundry. Quality finishes carry throughout, including LVP flooring and an elegant oak tread staircase. 3-car garage with EV charger provides ample space for vehicles and hobbies, and complete lawn sprinkler system.The sprawling unfinshed basement is complete with egress and workshop area ~offers exceptional potential for future finished space. This property balances luxury, comfort, and peace in a way that's rarely available as ''new'' homes like this are rare to find. Just waiting to welcome you HOME.

5 Beds ⋅ 5 Baths ⋅ 202615097 MLS

A rare opportunity to own a nearly new custom built 5 bedroom, 4.5 bath home without the wait of New Construction. Built just three years ago by Hanifin Home Builders and set on 2.22 private acres backing to forever wild & nature trails, this residence offers a refined blend of privacy, craftsmanship, and modern design within the Bethlehem School District. Thoughtfully designed for both everyday living and multigenerational flexibility, the home offers a first-floor primary suite featuring a true spa-like en suite with a soaking tub, oversized walk-in shower w/ double shower heads, separate vanities, and a private water closet, along with its own dedicated laundry. A second first-floor bedroom with a private bath provides ideal guest or in-law accommodations. The heart of the home is an expansive chef's kitchen with a statement island, double wall ovens, shrock cabinetry, prep sink & area, opening seamlessly to a sunlit breakfast nook, an incredible custom pantry and a generous formal dining room, all open to a dramatic great room with cathedral ceilings and gas fireplace. Upstairs, a private bedroom suite is complemented by two additional bedrooms, a full bath, and a second-floor laundry. Quality finishes carry throughout, including LVP flooring and an elegant oak tread staircase. 3-car garage with EV charger provides ample space for vehicles and hobbies, and complete lawn sprinkler system.The sprawling unfinshed basement is complete with egress and workshop area ~offers exceptional potential for future finished space. This property balances luxury, comfort, and peace in a way that's rarely available as ''new'' homes like this are rare to find. Just waiting to welcome you HOME.

279 Bender Lane

$1,525,000

Welcome to 394 Orchard Street. Custom built in 2006 by Hanifin Home Builders, set on 3.1 acres offering space, privacy and a beautiful natural setting within the town of Bethlehem. Thoughtfully designed for family, multi-generational and au pair lifestyles. The gourmet chef's kitchen is the heart of this home, seamlessly connecting to the family room, accented by wine/beverage wet bar and flowing into the formal dining room. The adjoining living room, home office, sitting room, powder rooms, and built-in bench and cubby area complete the main level. The primary suite features a large walk-in closet spa-like bathroom, and private retreat space. Four additional bedrooms are anchored by Jack and Jill bathrooms, and the spacious laundry room includes and ironing board and sink. The lower level offers a full bath, bedroom and flexible workout or playroom space. Outside, a stunning heated saltwater pool with covered decking and BBQ entertainment area sets the stage for effortless entertaining. A Zen-inspired koi pond with a water feature completes this backyard oasis.

6 Beds ⋅ 6 Baths ⋅ 202613017 MLS

Welcome to 394 Orchard Street. Custom built in 2006 by Hanifin Home Builders, set on 3.1 acres offering space, privacy and a beautiful natural setting within the town of Bethlehem. Thoughtfully designed for family, multi-generational and au pair lifestyles. The gourmet chef's kitchen is the heart of this home, seamlessly connecting to the family room, accented by wine/beverage wet bar and flowing into the formal dining room. The adjoining living room, home office, sitting room, powder rooms, and built-in bench and cubby area complete the main level. The primary suite features a large walk-in closet spa-like bathroom, and private retreat space. Four additional bedrooms are anchored by Jack and Jill bathrooms, and the spacious laundry room includes and ironing board and sink. The lower level offers a full bath, bedroom and flexible workout or playroom space. Outside, a stunning heated saltwater pool with covered decking and BBQ entertainment area sets the stage for effortless entertaining. A Zen-inspired koi pond with a water feature completes this backyard oasis.

394 Orchard Street

$1,330,090

SOLD BEFORE PRINT. JJ Cillis Builders New Construction at Mystic Woods! 3,500 sf 2story French Country Farmhouse design. Open Floor Plan with soaring ceilings! First Floor Master Bedroom Suite! 3 Car Side Entry Garage!

3 Beds ⋅ 3 Baths ⋅ 202527836 MLS

SOLD BEFORE PRINT. JJ Cillis Builders New Construction at Mystic Woods! 3,500 sf 2story French Country Farmhouse design. Open Floor Plan with soaring ceilings! First Floor Master Bedroom Suite! 3 Car Side Entry Garage!

37 Capricorn Lane

$1,500,000

LOCATION, LOCATION, LOCATION! Location:Approx. 1 mile south of exit 23 on I87 NYS Thruway,I787 and roughly 7.5 miles to exit 24 I90West/87North. Location:Rural Light Industrial, zoning. numerous uses & potential uses! It's currently used as Auto body shop w/towing business. Location:Just north of shopping plazas including Lowes,Walmart,Restaurants (several chain restaurants), Market 32,Tractor Supply **Possible owner financing! This 4,500 sq foot ''free span'' Morton building measuring 60'X75' (w/plenty of room for expansion) sitting on 1.5 acres. Plenty of parking and outside storage, Offers 1-12' & 5 10' overhead doors (easy to convert to 12'') a small office area, storage rooms, paint booth & large bays to work in. Zoned RLI (Rural Light Industrial) see docs for uses.

1 Baths ⋅ 202515324 MLS

LOCATION, LOCATION, LOCATION! Location:Approx. 1 mile south of exit 23 on I87 NYS Thruway,I787 and roughly 7.5 miles to exit 24 I90West/87North. Location:Rural Light Industrial, zoning. numerous uses & potential uses! It's currently used as Auto body shop w/towing business. Location:Just north of shopping plazas including Lowes,Walmart,Restaurants (several chain restaurants), Market 32,Tractor Supply **Possible owner financing! This 4,500 sq foot ''free span'' Morton building measuring 60'X75' (w/plenty of room for expansion) sitting on 1.5 acres. Plenty of parking and outside storage, Offers 1-12' & 5 10' overhead doors (easy to convert to 12'') a small office area, storage rooms, paint booth & large bays to work in. Zoned RLI (Rural Light Industrial) see docs for uses.

43 Frontage Road

$1,300,000

This custom mansion is a stunning blend of elegance and modern luxury! Sitting on 7.3 park like acres including woodlands the home boasts 5 bedrooms and 3 1/2 baths. Upon entering the home you are greeted by a coffered ceiling foyer, formal dining room, and a formal living room and den with stunning custom wood floors. The recently renovated kitchen overlooks the property and features Thermador appliances including two dishwashers, a sub zero fridge, trash compactor and drink fridge. Endless entertaining spaces include a second story family room, a 3rd floor rec room, a home theater with reclining seats, a large outdoor deck and a beautiful salt water heated pool. 6 car heated garage. Walk in steam shower in primary bath and heated tile floors throughout the house. A must see!

5 Beds ⋅ 4 Baths ⋅ 202512588 MLS

This custom mansion is a stunning blend of elegance and modern luxury! Sitting on 7.3 park like acres including woodlands the home boasts 5 bedrooms and 3 1/2 baths. Upon entering the home you are greeted by a coffered ceiling foyer, formal dining room, and a formal living room and den with stunning custom wood floors. The recently renovated kitchen overlooks the property and features Thermador appliances including two dishwashers, a sub zero fridge, trash compactor and drink fridge. Endless entertaining spaces include a second story family room, a 3rd floor rec room, a home theater with reclining seats, a large outdoor deck and a beautiful salt water heated pool. 6 car heated garage. Walk in steam shower in primary bath and heated tile floors throughout the house. A must see!

261 Bender Lane

$1,190,000

Sold Before Print.

4 Beds ⋅ 4 Baths ⋅ 202426626 MLS

Sold Before Print.

362 Orchard Street

$1,500,000

68.79 Acres accessible at Oakwood Road 142' frontage (off Bender Lane.) Zoned RA in highly rated Bethlehem School District at the main thoroughfares (I-87/I-90/I-787) of the Capital District. Possible for Solar, large estate lots. This parcel has the first right of refusal for 193 Bender Lane 3.66 acres (296' frontage) ML#202525759 (for sale separately by the same owner). 68.79 acres is Bounded by Delmar Bypass Route 32 on the north and west, single family homes on the south and the Shiffendecker Preserve with trails on the east. Note: 2008 Zoning Map on file at TOB and shown here is incorrect; new Zoning is proposed. Go to AlbanyCounty Tax Maps for accurate up to date Map. See Documents for add. details

202422227 MLS

68.79 Acres accessible at Oakwood Road 142' frontage (off Bender Lane.) Zoned RA in highly rated Bethlehem School District at the main thoroughfares (I-87/I-90/I-787) of the Capital District. Possible for Solar, large estate lots. This parcel has the first right of refusal for 193 Bender Lane 3.66 acres (296' frontage) ML#202525759 (for sale separately by the same owner). 68.79 acres is Bounded by Delmar Bypass Route 32 on the north and west, single family homes on the south and the Shiffendecker Preserve with trails on the east. Note: 2008 Zoning Map on file at TOB and shown here is incorrect; new Zoning is proposed. Go to AlbanyCounty Tax Maps for accurate up to date Map. See Documents for add. details

L16 Oakwood Road

$1,675,000

Elegant, contemporary, with a touch of avant-garde. Casablanca is perched atop a hill on historic Van Wies Point, overlooking the Hudson River. The river views are unobstructed, panoramic, and serene. Spacious and airy, Casablanca is an elegant estate that offers modern architecture unrivaled in the greater Capital Region. From all angles the river and state buildings are visible in the skyline. Sit in the riverside gazebo and watch the fish jump, turtles sun, and listen to the birds sing. The fenced grounds feature vibrant flowers, mature trees, and perennials that line the pristine blue stone paths to secret gardens and private hideaways. No estate is complete without an indoor pool, solarium, and greenhouse making home feel like weekend getaway. Offering ample square footage, this home once hosted large elegant parties and charitable events. This expansive home is the total package for entertaining complete with electric gate, circular driveway, privacy, and a convenient location. Travel to the Capitol in fifteen minutes, Kinderhook in twenty five, Upper West Side in two hours and fifteen minutes, and the shops of Glenmont in a quick six minutes. This iconic Hudson River estate is recognized throughout the Capital Region as one of the most unique homes in the area and is now ready for someone new to continue its rich legacy.

4 Beds ⋅ 4 Baths ⋅ 202422225 MLS

Elegant, contemporary, with a touch of avant-garde. Casablanca is perched atop a hill on historic Van Wies Point, overlooking the Hudson River. The river views are unobstructed, panoramic, and serene. Spacious and airy, Casablanca is an elegant estate that offers modern architecture unrivaled in the greater Capital Region. From all angles the river and state buildings are visible in the skyline. Sit in the riverside gazebo and watch the fish jump, turtles sun, and listen to the birds sing. The fenced grounds feature vibrant flowers, mature trees, and perennials that line the pristine blue stone paths to secret gardens and private hideaways. No estate is complete without an indoor pool, solarium, and greenhouse making home feel like weekend getaway. Offering ample square footage, this home once hosted large elegant parties and charitable events. This expansive home is the total package for entertaining complete with electric gate, circular driveway, privacy, and a convenient location. Travel to the Capitol in fifteen minutes, Kinderhook in twenty five, Upper West Side in two hours and fifteen minutes, and the shops of Glenmont in a quick six minutes. This iconic Hudson River estate is recognized throughout the Capital Region as one of the most unique homes in the area and is now ready for someone new to continue its rich legacy.

115 Van Wies Point Road

$1,200,000

SOLD BEFORE PRINT Welcome to 386 Orchard St! Nestled on a 3.09 acre estate this exquisite property offers an unparalleled living experience. Every inch is finished to the highest standards, w/ attention to detail from top to bottom. The heart of this home is its gourmet kitchen, with top-of-the-line apps, ample counter space & custom cabinetry. Enjoy the fam rm w/natural light beaming through your wall of windows, vaulted ceilings & a gas FP. W/ 5 bedrms, it's designed to accommodate large families, in-laws or guests. The LL includes a workout rm/5th bed, a cozy rec rm & a dedicated wine storage rm for the connoisseur. Step outside to discover your outdoor oasis, - a stunning in-ground pool & a custom stone patio & deck. For the car enthusiasts there are 6 garage spaces.

5 Beds ⋅ 6 Baths ⋅ 202420364 MLS

SOLD BEFORE PRINT Welcome to 386 Orchard St! Nestled on a 3.09 acre estate this exquisite property offers an unparalleled living experience. Every inch is finished to the highest standards, w/ attention to detail from top to bottom. The heart of this home is its gourmet kitchen, with top-of-the-line apps, ample counter space & custom cabinetry. Enjoy the fam rm w/natural light beaming through your wall of windows, vaulted ceilings & a gas FP. W/ 5 bedrms, it's designed to accommodate large families, in-laws or guests. The LL includes a workout rm/5th bed, a cozy rec rm & a dedicated wine storage rm for the connoisseur. Step outside to discover your outdoor oasis, - a stunning in-ground pool & a custom stone patio & deck. For the car enthusiasts there are 6 garage spaces.

386 Orchard Street

$1,325,000

Sold before print

4 Beds ⋅ 5 Baths ⋅ 202419891 MLS

Sold before print

308 Orchard Street

$899,900

Exceptional home has it all! Lovely colonial + carriage house offers forest views in the rear. Coveted Bethlehem schools, a great place to live. Updated w/ upgraded moldings, hardwood flrs, renovated bathrooms, primary bath with a full-body spray shower & heated flrs. 50+ windows, abundant natural light. Convenience abounds with 1st & 2nd Fl laundry. Finished b'ment incl full bath. Slider opens to extensively landscaped yard with ingrnd heated pool, gazebo, fire pit & gas outdoor BBQ hookup. Carriage house has a 1st Fl half bath, ideal for guests/pool. Upstairs, versatile living w/ full kitchen, LR, full bath, balcony, laundry conn. 3-car garage w/radiant heat fl + the 2-car garage of main house = ample storage. Generator. Embodies luxury, convenience, comfortable living & entertaining

4 Beds ⋅ 6 Baths ⋅ 202325508 MLS

Exceptional home has it all! Lovely colonial + carriage house offers forest views in the rear. Coveted Bethlehem schools, a great place to live. Updated w/ upgraded moldings, hardwood flrs, renovated bathrooms, primary bath with a full-body spray shower & heated flrs. 50+ windows, abundant natural light. Convenience abounds with 1st & 2nd Fl laundry. Finished b'ment incl full bath. Slider opens to extensively landscaped yard with ingrnd heated pool, gazebo, fire pit & gas outdoor BBQ hookup. Carriage house has a 1st Fl half bath, ideal for guests/pool. Upstairs, versatile living w/ full kitchen, LR, full bath, balcony, laundry conn. 3-car garage w/radiant heat fl + the 2-car garage of main house = ample storage. Generator. Embodies luxury, convenience, comfortable living & entertaining

9 Prestwick Drive

$1,200,000

Stunning inside and out, this spectacular home offers more than 6,000 sq. ft. of living space and is tucked away on a 4.2 acre park-like lot. Offering complete privacy and tranquility, you'll enjoy the expansive wrap around composite deck overlooking a private forest and creek. Upgrades include new custom mudroom, finished walk-out basement with high industrial ceilings, built-ins, laundry and fitness rooms, new and refinished Jacobean solid oak floors, three remodeled bathrooms, and many new appliances. Gorgeous sunroom and first floor guest room suite. This home is the perfect combination of elegance and comfort. Close to area hospitals, restaurants, parks and houses of worship. Top rated Bethlehem Schools.

6 Beds ⋅ 6 Baths ⋅ 202322397 MLS

Stunning inside and out, this spectacular home offers more than 6,000 sq. ft. of living space and is tucked away on a 4.2 acre park-like lot. Offering complete privacy and tranquility, you'll enjoy the expansive wrap around composite deck overlooking a private forest and creek. Upgrades include new custom mudroom, finished walk-out basement with high industrial ceilings, built-ins, laundry and fitness rooms, new and refinished Jacobean solid oak floors, three remodeled bathrooms, and many new appliances. Gorgeous sunroom and first floor guest room suite. This home is the perfect combination of elegance and comfort. Close to area hospitals, restaurants, parks and houses of worship. Top rated Bethlehem Schools.

19 Eliot Drive

$1,750,000

Fantastic opportunity in the town of Bethlehem. Just over 103 acres with access to city sewer, soon to be zoned Mixed Industrial. This land has been family owned and cared for, it is time for them to pass it on. Take advantage of this great investment opportunity.

202315768 MLS

Fantastic opportunity in the town of Bethlehem. Just over 103 acres with access to city sewer, soon to be zoned Mixed Industrial. This land has been family owned and cared for, it is time for them to pass it on. Take advantage of this great investment opportunity.

292 Clapper Road, Selkirk