- Overview
- Description
- Property Details
- Location
- Facts & Features
- Getting Around
- Nearby Homes
$1,990,000
Monthly Est:$9,905
7 Beds
- 3 Baths
3 full baths
5,000sqft
2820 Balltown Rd, Schenectady, NY 12309
$1,990,000
$9,905/moEst:
Get Pre-Approved
Single Family Residence
Built in 2004
$-- HOA
3.1 acres lot
$398/sq.ft
Description
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.
- Houzeo last checked: 12 hours ago
- Listing updated: March 2, 2026 at 7:20 pm
- Listing Provided by: Wayne A Newcomb, Jr. (518) 424-6821 DRE #40NE0858576 | Newcomb Realty Group LLC (518) 250-9827
- Source: Greater Capital Association of Realtors (Global) MLS-NY | MLS#: 202610469

Property Details
Status
Active
Type
Single Family Residence
No. of Stories
-
County
City
Neighborhood
--
Year Built
2004
HOA Fees
-
Finished Area
5,000 sqft
Lot Size
3.1 acres lot
Basement Area
- sqft
MLS Name
Greater Capital Association of Realtors (Global) MLS
MLS Number
202610469
MLS Status
Active
Days on Market
295

Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Location
Facts & Features
Rooms
Bedrooms & bathrooms
Bedrooms: 7
Bathrooms: 3
Interior
Appliances
Cooktop, Dishwasher, Double Oven, Microwave, Refrigerator, Washer/dryer
Exterior Features
Other, Garden, Lighting
Interior Features
Other, High Speed Internet, Walk In Closet(s), Built In Features, Ceramic Tile Bath, Chair Rail, Crown Molding, Eat In Kitchen
Flooring
Wood, Ceramic Tile, Hardwood
Heating
Forced Air
Sewer
Septic Tank
Cooling
Central Air
Construction
Year Built
Year Built: 2004
Home type
Single Family Residence
Roof
Asphalt
Construction Materials
Stone, Stucco
Architectural Style
Mansion
Property Condition
Updated/remodeled
Utilities & Energy
Basement
Finished, Full
Laundry Features
Laundry Room, Main Level
Parking Features
Attached, Detached, Driveway
Fireplace Features
Family Room, Gas
Water Source
Public
Other Features
Patio And Porch Features
Patio
Lot Features
Secluded, Level, Private, Views, Landscaped
Price History
| Date | Event | Price |
|---|---|---|
01/12/2026 Source: | Listed for Sale | $1,990,000 +298.08% $398/sqft |
01/10/2020 Source: | Listing Removed | $499,900 $100/sqft |
Nearby Homes
Find Homes by Property Features in Schenectady, NY
Nearby New Homes For Sale
Based on information from the Global Multiple Listing Service, Inc. through Nov 02, 2026, 02:15PM. Information is provided exclusively for consumers’ personal, non-commercial use. It may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data is deemed reliable but is not guaranteed accurate by the MLS. This website may not include listings or property addresses of sellers who have directed their listing brokers to withhold their listing or their property address from display on the Internet. © 2026 Global Multiple Listing Service, Inc. All Rights Reserved.
Advertising Broker: Derek Greene | The Greene Realty Group















