Set on a generously sized lot in Schalmont School District, this property offers a wonderful opportunity to create something special. With strong value in the land and ample space for future expansion , this property is ideal for buyers looking to customize and add long-term value.
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.
Stunning new construction home to be built, offering over 2,900 sq ft of thoughtfully designed living space. This one-of-a-kind residence features a first-floor master suite and a truly unique custom floor plan—no duplicates, no repeats, and unmatched architectural character. Located in the highly regarded Guilderland School District, this home provides exceptional convenience just minutes from Crossgates Mall, Costco, restaurants, shopping, and major highways for an easy commute. A rare opportunity to own a custom-built home in a prime Capital Region location.
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'
Welcome home. . The contemporary eat-in kitchen offers stone countertops, energy star SS appliances and a breakfast bar. Relax in the cozy LR complete with charming gas fireplace. Enjoy the convenience of turn-key living and unwind on your private & covered, patio. All first-floor units are ADA compliant. But that's not all! The Crossings at Helederberg Meadows offers a beautiful community room perfect for entertaining a larger group, a community gym, outdoor pickle ball courts, and even a dog park! . Open houses begin 1/12/2025 - 12pm-2pm.
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.
Excellent opportunity to own a single family home in a the growing city of Schenectady! Conveniently located just off of State Street, this 2 bedroom, 1 bath home offers great potential for investors., homeowners, or anyone looking to customize a space to their taste. Some of the updates have already been started-bring your tools and finishing touches to make it your own. Enjoy a spacious backyard perfect for future expansion, entertaining, or relaxation. Low taxes and central location close to shopping, restaurants, schools, and public transportation.
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.
Price Reduced!!! Welcome to this modern contemporary 4 bedroom 2.5 bath home on a secluded 56 acre lot. Serene and private although only 5 minutes to 890 and the thruway. 10 minutes to downtown Schenectady. 4000+ sq feet, a 3 car garage, finished space in the basement 2 ponds. Custom kitchen with stainless steel appliances and pot filler. To die for master suite with sitting room walk in closet, jetted tub, glass showier. Cozy house with 7 zone radiant heat and 3 fire places with blowers. Rooftop deck fireplace, with spectacular views of the mohawk valley and downtown Albany on clear days. Wrap around deck with hot tub, Large shed, chicken coop, 2 ponds complete this breath taking property!!
A spacious 4-bedroom, 2-bath single-family home offering comfort, character, and convenience in the heart of Schenectady. Conveniently located near downtown Schenectady, Mohawk Harbor, restaurants, and shops. Bring your vision and unlock the potential of 11 River Street!
Welcome home. . The contemporary eat-in kitchen offers stone countertops, energy star SS appliances and a breakfast bar. Relax in the cozy LR complete with charming gas fireplace. Enjoy the convenience of turn-key living and unwind on your private & covered, patio. All first-floor units are ADA compliant. But that's not all! The Crossings at Helederberg Meadows offers a beautiful community room perfect for entertaining a larger group, a community gym, outdoor pickle ball courts, and even a dog park! . Open houses begin Sunday 12pm-2pm.
Welcome home. . The contemporary eat-in kitchen offers stone countertops, energy star SS appliances and a breakfast bar. Relax in the cozy LR complete with charming gas fireplace. Enjoy the convenience of turn-key living and unwind on your private & covered, patio. All first-floor units are ADA compliant. But that's not all! The Crossings at Helederberg Meadows offers a beautiful community room perfect for entertaining a larger group, a community gym, outdoor pickle ball courts, and even a dog park! . Open houses begin Sunday 12pm-2pm.
Looking for a fixer in Niskayuna Schools that has all the potential? Check out this 2-3+ Bedroom Bungalow with 2 decent-sized bedrooms on 1st floor. The 2nd floor has a large finished heated Bonus Room (no closet, although there is a closet across the hall) and unfinished attic area. Full basement with interior and exterior entrance. Radiator (natural gas) heat. Seller said there is some mildew in the home. Under kitchen sink and bathroom sink has some leaks. Toilet needs repair/replaced. Shower needs repair.
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.
Owning a home for less than your rent: YES, it's still possible! This Schenectady townhome has 3 bedrooms, 1.5 bathrooms, and almost 1200sf. There's also a spacious full basement to provide extra storage and potential. Have comfort in an only 30 year old home with all modern electrical, plumbing, windows, and more. Move right in without lifting a finger! Nice eat-in kitchen, Hardwood floors, tiled shower, newer hot water tank, and more. The END-UNIT townhome brings in much more natural light. Enjoy Jerry Burrell Park across the street or lounging on your trex deck in the fully fenced back yard. There is even off street parking in the driveway on the rear side. If you've been waiting for something affordable AND good, now is your chance.
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.
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.
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.
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.
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.
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.
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.
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.
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.
![]() |
| © 2026 Greater Capital Association of REALTORS (CRMLSNY). All rights reserved. The data relating to real estate for sale on this website have been downloaded from CRMLS. The IDX logo indicates listings of other real estate firms that are identified in the detailed listing information. Information herein is deemed reliable but not guaranteed, representations are approximate, individual verification's recommended. Per New York legal requirement, click here for the Standard Operating Procedures. |

Schenectady is located in New York. Schenectady, New York has a population of 66,809. Schenectady is less family-centric than the surrounding county with 21.04% of the households containing married families with children. The county average for households married with children is 27.91%.
The median household income in Schenectady, New York is $50,237. The median household income for the surrounding county is $69,891 compared to the national median of $69,021. The median age of people living in Schenectady is 36.8 years.
The average high temperature in July is 83.1 degrees, with an average low temperature in January of 13.8 degrees. The average rainfall is approximately 40.5 inches per year, with 59.9 inches of snow per year.