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.
2135 Morrow Ave is a well maintained move in ready five bedroom, two and a half bath two story colonial home in Niskayuna with two thousand four hundred and forty square feet in addition to a large sun room and full size basement. Many rooms have hardwood floors and wall to wall carpeting. The yard has many perennials to discover. Close to bike trails, the high school and local businesses.
Introducing a stunning new construction, to be built home in Niskayuna, situated on a generous private lot exceeding an acre. Boasting a carefully designed floor plan with four bedrooms and 2.5 bathrooms, this property offers the perfect balance of luxury, privacy and convenience. The tiled kitchen with a cozy dinette seamlessly connects to both, a formal living room and an elegant dining room. A spacious family room and a dedicated study can be found on the first floor. The upper level hosts a convenient laundry room and good sized bedrooms. In addition to a comfortable interior, the house features a spacious 2-car garage. Its desirable location next to shopping centers, restaurants, a casino as well as major highways, offers easy access to activities and transportation.
Take advantage of a golden opportunity to have your brand-new home built by Rosewood Home Builders LLC on this beautiful approved lot in the highly desirable Niskayuna School District. This Colonial home sits on a 1.5 acre lot and features 5 bedrooms and 3 bathrooms, boasting a bright and open floor plan in the kitchen and living area. It includes hardwood floors, gas fireplace, granite countertops, built in appliances, walk in closets and much more. With all selections finalized and an expected completion by Mid-April this home embodies modern living and is situated in the heart of the Town of Colonie, close to restaurants, shopping, and I-87. The lot is included in the price. Discover your dream home today!
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.
 |
| © 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 12309has a population of 66,809. Schenectady 12309 is less family-centric than the surrounding county with 23.44% 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 12309 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 12309 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.
