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

$495,000
6 Beds 5 Baths 202530407 MLS
This property is a five-unit multifamily, located in the highly convenient and historic Union Street corridor. With approximately 2,932 square feet of living space and three stories, this building offers strong investment potential in one of Schenectady's most active rental areas. Built in 1984, the property sits on a 28-by-150-foot lot with municipal water and sewer, public utilities, and off-street parking via the shared driveway. The location provides exceptional accessibility. Union College, Ellis Hospital, Schenectady High School, Downtown Schenectady, and Mohawk Harbor are all within easy reach, along with nearby shops, restaurants, and entertainment venues on Union Street itself. School proximities include Yates Elementary, Oneida Middle School, and Schenectady High School, all within 2 miles or less. This property is zoned for multi-family use and offers a reliable opportunity for investors seeking stable occupancy and long-term value in a well-connected neighborhood.

714 Union Street

$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

©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