Refine Search
Sort by
$1,990,000
7 Beds 3 Baths 202610469 MLS
Welcome to The Mansion at Rebecca's Fountain, where you'll be welcomed by a working fountain with a statue of Rebecca which sets the tone for this beautiful estate. Perched atop more than three secluded acres in Niskayuna, overlooking the Mohawk River, the Estate offers mountain views, refined architecture, and a rare sense of privacy minutes from the finest destinations. Reminiscent of ''Gone with the Wind,'' a grand foyer welcomes you with sweeping dual staircase & a striking 6-foot motorized crystal chandelier that showcases the elegance found throughout the home. Fully furnished by a designer, the approx. 5,000 sqft residence features 7 bedrooms, 3 full baths, sun-filled spaces, soaring ceilings, hardwood floors & oversized windows framing the surrounding landscape. The 1st floor primary suite serves as a serene retreat, featuring a spa-inspired bath w dual sinks, walk-in shower, jetted tub, and an expansive walk-in closet. The gourmet kitchen is ideal for daily living & entertaining, offering a large island, custom cabinetry & seamless flow to a formal dining room with classic millwork. Additional highlights include a sunken Great Room with vaulted ceiling and a floor-to-ceiling LP gas fireplace, first-floor laundry/ Butler's pantry, central air, a two-car side-load garage, and a partially finished lower level that is suitable as 7th bedroom or theater room. An additional 1,720 sqft of unfinished lower-level space (formerly wine storage) offers potential for a gym, game room or other uses. The estate unfolds into a serene oasis with a tranquil pond, custom concrete patio & deck, firepit, and a 7-person spa overlooking apple trees and wildlife. Completing the property is a detached aux building with an existing, legally permitted use for wine tasting & wine sales, offering a rare and distinctive feature that further sets the estate apart. A rare opportunity to own a landmark estate offering timeless elegance, exceptional flexibility, unmatched tranquility.

2820 Balltown Road

$229,900
2 Beds 1 Baths 202531155 MLS
This lovely 2 bedroom, 1 bathroom home is situated on a spacious corner lot in Rotterdam. A bedroom upstairs has a fireplace, as well as the living room, which is highlighted by a beautiful brick, wood burning fireplace, creating a warm and inviting atmosphere. The formal dining room seamlessly flows into an eat-in kitchen, setting the stage for delightful dinners. The home also includes a dedicated office space- an asset for today's work-from-home-professionals. The outdoors will charm you with a partially fenced backyard, offering a peaceful space to unwind on a back patio. With restaurants and shopping located a short distance away, convenience is close at hand. Don't miss this opportunity to own a home filled with character and modern comforts. This is an Estate and is being sold 'As-is'

2953 Clyde Avenue

$165,500
3 Beds 1 Baths 202530931 MLS
Investors,Whether you are looking to expand your portfolio with a high-demand rental property or searching for a private, efficient, and nature-connected retreat to call your own, this special home is completely ready for its next chapter. A large deck creates the perfect space for outdoor dining, entertaining, or simply taking in the peaceful surroundings and sounds of nature. Inside, the home provides easy one-level living with a functional layout and a full basement offering excellent storage or future finishing potential for additional living space, recreation, workshop, or hobby areas.Turn-Key & Fully Updated: Enjoy total peace of mind with a brand-new furnace and water tank (installed October 2025), an updated kitchen complete with modern cabinetry and appliances, and a new Bilco door leading to the basement. Title bathroom , fresh paint, new floors,& barn door If you have been searching for privacy, efficiency, and a connection to the outdoors, this special property is ready to welcome you home.

4711 Pattersonville-Rynex Corners Road

$499,895
2 Beds 2 Baths 202529637 MLS
Join Rotterdam's Newest 55+ Community Today & Enjoy The Carefree Lifestyle You've Been Yearning For. One Floor Living In One Of Our 1500 Sq Ft Cottages Featuring Covered Front Porch, Den, Primary Bedroom w/ Walk-In Closet & Pvt Bath, Guest Bedroom w/ Walk-In Closet, Main Bath, Eat-In Kitchen w/ Granite Counters & SS Appl Pkg, Combined Great Rm/ Dining Rm w/ Sliding Doors to Covered Patio, Finished Walk-Up 500 Sq Ft Bonus Room & Storage, 2 Car Att Garage w/ Opener, Off St Pkg, Nat Gas Hot Air Heat, Elec HW, Full Basement, Gas Fireplace. Interior Selections Available, HOA, Front/Side IG Sprinklers, 200 Amp CB Elec; Fire Suppression, Security & Emergency Call Systems, Ctrl A/C, Clubhouse, Golf Course, Public Water & Sewer, Mohonasen CSD. SPEC HOME READY IN < 30 DAYS.

125 Whispering Pines Way

$575,000
6 Beds 3 Baths 202529611 MLS
A one of a kind gentleman property build in 1950(continuously renovated ), uniquely situated on 1.17 acres along high-visibility Rt 7, next to Rotterdam & I-88/I-90 Exit. This inviting +/- 3700 sq. ft. 3 Bedroom, 2 bath home sits beside a mixed use commercial building- perfect for those seeking live - work convenience, additional rental income and provides compelling alternative to traditional commuting & leasing arrangement. Next door, the +/-2400 sq. ft. commercial structure has been thoughtfully designed for professional use and features multiple rooms that can adapt to a variety of business or studio needs. Whether you're looking for a home with workspace, an investment property or room to expand, this unique setup delivers endless options.

2241-2275 Duanesburg Road

$845,000
5 Beds 5 Baths 202529377 MLS
Experience the Perfect blend of luxury, comfort, & privacy in this stunning contemporary estate set on 28.17 acres. This spacious 4,333 sq. ft home features 5 BR, 4 1/2 baths, including a main-level primary suite w/generous closets, & beautifully appointed bathroom. The open Kitchen is ideal for entertaining. The great room with an entertainment center, wet bar, & pool table- perfect for gatherings and relaxation. Step outside through French doors to enjoy the inviting inground saltwater pool. Car Enthusiasts and hobbyist will appreciate both the attached 3 car garage, & 3 car detached garage that holds 6 cars, while the greenhouse offers exciting potential for gardening. Energy efficiency is a highlight, with OWNED Solar panels and a propane tank providing independence and savings. (Attached garage solar is, rented) Recent updates include a blue stone front retaining wall, newer sidewalks, foundational work, fresh exterior paint (2023), a newer awning, 2 new garage doors (attached) and an accessible ramp to the front entrance. This Property is a rare opportunity for those seeking unique amenities, expansive grounds, private retreat. A New Furnace installed in February 2026, and all new LBT flooring was installed in the basement in April 2026.

3041 Mariaville Road

$1,699,000
4 Beds 4 Baths 202528482 MLS
The approach to The Grey Arrow feels almost cinematic. An 800-foot tree-lined drive leads to a Civil War-era farmhouse, its presence both commanding and welcoming. For five generations, this homestead has been a place of memory and stewardship. Under its current owners, it has been thoughtfully reborn--its history preserved, its comforts elevated, its spirit transformed into a modern sanctuary. Inside, the foyer introduces the home's character with Helderberg bluestone etched in arrowhead motifs. Beyond it, light-filled rooms open where wide-plank pine floors run beneath tall windows and two Rumford fireplaces anchor the living spaces with warmth and intention. The kitchen blends rustic authenticity with contemporary luxury: original 1850s beams, reclaimed-wood cabinetry, quartz countertops, and GE Café appliances that make daily rituals feel indulgent. A gas stove with indoor grill, hands-free faucet, and instant-hot sink at the coffee and tea bar elevate everyday living. Behind a hidden door, an expansive butler's pantry offers quiet order. The home unfolds in wings. The primary suite is a restorative retreat with a soaking tub, tiled shower, fog-free LED mirrors, and WiFi-enabled NuTone speakers. The guest wing, connected discreetly, offers comfort and privacy. Every bathroom has been fully renovated with intention. Beyond the main house, a 500-square-foot guest studio with cathedral ceilings, exposed beams, and a renovated bath offers endless possibility--an artist's loft, recording space, office, or serene guest quarters. Four hand-hewn barns from 1850-1910 stand ready for reinvention or preservation. The land itself is a defining character. 113 acres of meadows, gardens, forest, and trails invite exploration. A spring-fed pond mirrors the sky. Riverstone hardscaping and heirloom gardens frame moments of stillness. Mornings begin slowly on the bluestone patio; evenings stretch long with painted sunsets and firelight under the stars.

13388 Duanesburg Road

$449,900
2 Beds 2 Baths 202520119 MLS
Join Rotterdam's Newest 55+ Community Today & Enjoy The Carefree Lifestyle You've Been Yearning For. New Construction Contracts (TO BE BUILT) Now Being Accepted. One Floor Living In One Of Our 1500 Sq Ft Cottages Featuring Covered Front Porch, Den, Primary Bedroom w/ Walk-In Closet & Pvt Bath, Guest Bedroom w/ Walk-In Closet, Main Bath, Eat-In Kitchen w/ Granite Counters & SS Appl Pkg, Combined Great Rm/ Dining Rm w/ Sliding Doors to Covered Patio, Walk-Up 500 Sq Ft Attic Storage w/ Option To Finish, 2 Car Att Garage w/ Opener, Off St Pkg, Nat Gas Hot Air Heat, Elec HW, Slab On Grade, Optional Natural Gas Fireplace. Interior Selections Available, HOA, Front/Side IG Sprinklers, 200 Amp CB Elec; Fire Suppression, Security & Emergency Call Systems, Ctrl A/C, Clubhouse, Golf Course, Public Water & Sewer, Mohonasen Central Schools.

108 Whispering Pines Way

$459,900
2 Beds 2 Baths 202511698 MLS
Join Rotterdam's Newest 55+ Community Today & Enjoy The Carefree Lifestyle You've Been Yearning For. New Construction Contracts (TO BE BUILT) Now Being Accepted. One Floor Living In One Of Our 1500 Sq Ft Cottages Featuring Covered Front Porch, Den, Primary Bedroom w/ Walk-In Closet & Pvt Bath, Guest Bedroom w/ Walk-In Closet, Main Bath, Eat-In Kitchen w/ Granite Counters & SS Appl Pkg, Combined Great Rm/ Dining Rm w/ Sliding Doors to Covered Patio, Walk-Up 500 Sq Ft Attic Storage w/ Option To FInish, 2 Car Att Garage w/ Opener, Off St Pkg, Nat Gas Hot Air Heat, Elec HW, Full Basement & Natural Gas Fireplace Options. Interior Selections Available, HOA, Front/Side IG Sprinklers, 200 Amp CB Elec; Fire Suppression, Security & Emergency Call Systems, Ctrl A/C, Clubhouse, Golf Course, Public Water & Sewer, Mohonasen Central Schools.

103 Whispering Pines Way

$459,900
2 Beds 2 Baths 202511697 MLS
Join Rotterdam's Newest 55+ Community Today & Enjoy The Carefree Lifestyle You've Been Yearning For. New Construction Contracts (TO BE BUILT) Now Being Accepted. One Floor Living In One Of Our 1500 Sq Ft Cottages Featuring Covered Front Porch, Den, Primary Bedroom w/ Walk-In Closet & Pvt Bath, Guest Bedroom w/ Walk-In Closet, Main Bath, Eat-In Kitchen w/ Granite Counters & SS Appl Pkg, Combined Great Rm/ Dining Rm w/ Sliding Doors to Covered Patio, Walk-Up 500 Sq Ft Attic Storage w/ Option To Finish, 2 Car Att Garage w/ Opener, Off St Pkg, Nat Gas Hot Air Heat, Elec HW, Full Basement, Optional Natural Gas Fireplace. Interior Selections Available, HOA, Front/Side IG Sprinklers, 200 Amp CB Elec; Fire Suppression, Security & Emergency Call Systems, Ctrl A/C, Clubhouse, Golf Course, Public Water & Sewer, Mohonasen Central Schools.

104 Whispering Pines Way

$459,900
2 Beds 2 Baths 202511696 MLS
Join Rotterdam's Newest 55+ Community Today & Enjoy The Carefree Lifestyle You've Been Yearning For. New Construction Contracts (TO BE BUILT) Now Being Accepted. One Floor Living In One Of Our 1500 Sq Ft Cottages Featuring Covered Front Porch, Den, Primary Bedroom w/ Walk-In Closet & Pvt Bath, Guest Bedroom w/ Walk-In Closet, Main Bath, Eat-In Kitchen w/ Granite Counters & SS Appl Pkg, Combined Great Rm/ Dining Rm w/ Sliding Doors to Covered Patio, Walk-Up 500 Sq Ft Attic Storage w/ Option To Finish, 2 Car Att Garage w/ Opener, Off St Pkg, Nat Gas Hot Air Heat, Elec HW, Full Basement, Optional Natural Gas Fireplace. Interior Selections Available, HOA, Front/Side IG Sprinklers, 200 Amp CB Elec; Fire Suppression, Security & Emergency Call Systems, Ctrl A/C, Clubhouse, Golf Course, Public Water & Sewer, Mohonasen Central Schools.

105 Whispering Pines Way

$449,900
2 Beds 2 Baths 202511695 MLS
Join Rotterdam's Newest 55+ Community Today & Enjoy The Carefree Lifestyle You've Been Yearning For. New Construction Contracts (TO BE BUILT) Now Being Accepted. One Floor Living In One Of Our 1500 Sq Ft Cottages Featuring Covered Front Porch, Den, Primary Bedroom w/ Walk-In Closet & Pvt Bath, Guest Bedroom w/ Walk-In Closet, Main Bath, Eat-In Kitchen w/ Granite Counters & SS Appl Pkg, Combined Great Rm/ Dining Rm w/ Sliding Doors to Covered Patio, Walk-Up 500 Sq Ft Attic Storage w/ Option To Finish, 2 Car Att Garage w/ Opener, Off St Pkg, Nat Gas Hot Air Heat, Elec HW, Slab On Grade, Optional Natural Gas Fireplace. Interior Selections Available, HOA, Front/Side IG Sprinklers, 200 Amp CB Elec; Fire Suppression, Security & Emergency Call Systems, Ctrl A/C, Clubhouse, Golf Course, Public Water & Sewer, Mohonasen Central Schools.

106 Whispering Pines Way

$449,900
2 Beds 2 Baths 202511694 MLS
Join Rotterdam's Newest 55+ Community Today & Enjoy The Carefree Lifestyle You've Been Yearning For. New Construction Contracts (TO BE BUILT) Now Being Accepted. One Floor Living In One Of Our 1500 Sq Ft Cottages Featuring Covered Front Porch, Den, Primary Bedroom w/ Walk-In Closet & Pvt Bath, Guest Bedroom w/ Walk-In Closet, Main Bath, Eat-In Kitchen w/ Granite Counters & SS Appl Pkg, Combined Great Rm/ Dining Rm w/ Sliding Doors to Covered Patio, Walk-Up 500 Sq Ft Attic Storage w/ Option To Finish, 2 Car Att Garage w/ Opener, Off St Pkg, Nat Gas Hot Air Heat, Elec HW, Slab On Grade, Optional Natural Gas Fireplace. Interior Selections Available, HOA, Front/Side IG Sprinklers, 200 Amp CB Elec; Fire Suppression, Security & Emergency Call Systems, Ctrl A/C, Clubhouse, Golf Course, Public Water & Sewer, Mohonasen Central Schools.

107 Whispering Pines Way

$459,900
2 Beds 2 Baths 202511682 MLS
Join Rotterdam's Newest 55+ Community Today & Enjoy The Carefree Lifestyle You've Been Yearning For. New Construction Contracts (TO BE BUILT) Now Being Accepted. One Floor Living In One Of Our 1500 Sq Ft Cottages Featuring Covered Front Porch, Den, Primary Bedroom w/ Walk-In Closet & Pvt Bath, Guest Bedroom w/ Walk-In Closet, Main Bath, Eat-In Kitchen w/ Granite Counters & SS Appl Pkg, Combined Great Rm/ Dining Rm w/ Sliding Doors to Covered Patio, Walk-Up 500 Sq Ft Attic Storage w/ Option To FInish, 2 Car Att Garage w/ Opener, Off St Pkg, Nat Gas Hot Air Heat, Elec HW, Full Basement & Natural Gas Fireplace Options. Interior Selections Available, HOA, Front/Side IG Sprinklers, 200 Amp CB Elec; Fire Suppression, Security & Emergency Call Systems, Ctrl A/C, Clubhouse, Golf Course, Public Water & Sewer, Mohonasen Central Schools.

55 Whispering Pines Way

$459,900
2 Beds 2 Baths 202511679 MLS
Join Rotterdam's Newest 55+ Community Today & Enjoy The Carefree Lifestyle You've Been Yearning For. New Construction Contracts (TO BE BUILT) Now Being Accepted. One Floor Living In One Of Our 1500 Sq Ft Cottages Featuring Covered Front Porch, Den, Primary Bedroom w/ Walk-In Closet & Pvt Bath, Guest Bedroom w/ Walk-In Closet, Main Bath, Eat-In Kitchen w/ Granite Counters & SS Appl Pkg, Combined Great Rm/ Dining Rm w/ Sliding Doors to Covered Patio, Walk-Up 500 Sq Ft Attic Storage w/ Option To Finish, 2 Car Att Garage w/ Opener, Off St Pkg, Nat Gas Hot Air Heat, Elec HW, Full Basement, Optional Natural Gas Fireplace. Interior Selections Available, HOA, Front/Side IG Sprinklers, 200 Amp CB Elec; Fire Suppression, Security & Emergency Call Systems, Ctrl A/C, Clubhouse, Golf Course, Public Water & Sewer, Mohonasen Central Schools.

56 Whispering Pines Way

$459,900
2 Beds 2 Baths 202511677 MLS
Join Rotterdam's Newest 55+ Community Today & Enjoy The Carefree Lifestyle You've Been Yearning For. New Construction Contracts (TO BE BUILT) Now Being Accepted. One Floor Living In One Of Our 1500 Sq Ft Cottages Featuring Covered Front Porch, Den, Primary Bedroom w/ Walk-In Closet & Pvt Bath, Guest Bedroom w/ Walk-In Closet, Main Bath, Eat-In Kitchen w/ Granite Counters & SS Appl Pkg, Combined Great Rm/ Dining Rm w/ Sliding Doors to Covered Patio, Walk-Up 500 Sq Ft Attic Storage w/ Option To Finish, 2 Car Att Garage w/ Opener, Off St Pkg, Nat Gas Hot Air Heat, Elec HW, Full Basement, Optional Natural Gas Fireplace. Interior Selections Available, HOA, Front/Side IG Sprinklers, 200 Amp CB Elec; Fire Suppression, Security & Emergency Call Systems, Ctrl A/C, Clubhouse, Golf Course, Public Water & Sewer, Mohonasen Central Schools.

57 Whispering Pines Way

$449,900
2 Beds 2 Baths 202511668 MLS
Join Rotterdam's Newest 55+ Community Today & Enjoy The Carefree Lifestyle You've Been Yearning For. New Construction Contracts (TO BE BUILT) Now Being Accepted. One Floor Living In One Of Our 1500 Sq Ft Cottages Featuring Covered Front Porch, Den, Primary Bedroom w/ Walk-In Closet & Pvt Bath, Guest Bedroom w/ Walk-In Closet, Main Bath, Eat-In Kitchen w/ Granite Counters & SS Appl Pkg, Combined Great Rm/ Dining Rm w/ Sliding Doors to Covered Patio, Walk-Up 500 Sq Ft Attic Storage w/ Option To Finish, 2 Car Att Garage w/ Opener, Off St Pkg, Nat Gas Hot Air Heat, Elec HW, Slab On Grade, Optional Natural Gas Fireplace. Interior Selections Available, HOA, Front/Side IG Sprinklers, 200 Amp CB Elec; Fire Suppression, Security & Emergency Call Systems, Ctrl A/C, Clubhouse, Golf Course, Public Water & Sewer, Mohonasen Central Schools.

58 Whispering Pines Way

$449,900
2 Beds 2 Baths 202511658 MLS
Join Rotterdam's Newest 55+ Community Today & Enjoy The Carefree Lifestyle You've Been Yearning For. New Construction Contracts (TO BE BUILT) Now Being Accepted. One Floor Living In One Of Our 1500 Sq Ft Cottages Featuring Covered Front Porch, Den, Primary Bedroom w/ Walk-In Closet & Pvt Bath, Guest Bedroom w/ Walk-In Closet, Main Bath, Eat-In Kitchen w/ Granite Counters & SS Appl Pkg, Combined Great Rm/ Dining Rm w/ Sliding Doors to Covered Patio, Walk-Up 500 Sq Ft Attic Storage w/ Option To Finish, 2 Car Att Garage w/ Opener, Off St Pkg, Nat Gas Hot Air Heat, Elec HW, Slab On Grade, Optional Natural Gas Fireplace. Interior Selections Available, HOA, Front/Side IG Sprinklers, 200 Amp CB Elec; Fire Suppression, Security & Emergency Call Systems, Ctrl A/C, Clubhouse, Golf Course, Public Water & Sewer, Mohonasen Central Schools.

60 Whispering Pines Way

$449,900
2 Beds 2 Baths 202511660 MLS
Join Rotterdam's Newest 55+ Community Today & Enjoy The Carefree Lifestyle You've Been Yearning For. New Construction Contracts (TO BE BUILT) Now Being Accepted. One Floor Living In One Of Our 1500 Sq Ft Cottages Featuring Covered Front Porch, Den, Primary Bedroom w/ Walk-In Closet & Pvt Bath, Guest Bedroom w/ Walk-In Closet, Main Bath, Eat-In Kitchen w/ Granite Counters & SS Appl Pkg, Combined Great Rm/ Dining Rm w/ Sliding Doors to Covered Patio, Walk-Up 500 Sq Ft Attic Storage w/ Option To Finish, 2 Car Att Garage w/ Opener, Off St Pkg, Nat Gas Hot Air Heat, Elec HW, Slab On Grade, Optional Natural Gas Fireplace. Interior Selections Available, HOA, Front/Side IG Sprinklers, 200 Amp CB Elec; Fire Suppression, Security & Emergency Call Systems, Ctrl A/C, Clubhouse, Golf Course, Public Water & Sewer, Mohonasen Central Schools.

59 Whispering Pines Way

©2019 Global Multiple Listing Service, Inc. The data relating to real estate on this website comes in part from the Internet Data Exchange program of the GMLS. All information is deemed reliable but not guaranteed and should be independently verified. All properties subject to prior sale, change, or withdrawal. Neither listing broker(s), GMLS shall be responsible for any typographical errors, misinformation, or misprints, and shall be held totally harmless from any damages arising from reliance upon these data. IDX information is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties they may be interested in purchasing. Data last updated