- Overview
- Description
- Property Details
- Location
- Getting Around
$1,990,000
7 Beds
3 Baths3 full baths
5,000sqft
2820 Balltown Rd, Schenectady, NY 12309
$1,990,000
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-f...
- Houzeo last checked: 4 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
224
Love this home?
Here's 4 things you can do
Houzeo Corp. holds real estate brokerage licenses in Alabama (License No. 000157023 - 0) and Texas (License No. 9013396)
TREC: Info About Brokerage Services, Consumer Protection Notice.
§ 442‑H New York Standard Operating Procedure.
New York State Fair Housing Notice.
