- 0
- 4
- Overview
- Description
- Property Details
- Location
- Facts & Features
- Getting Around
- Nearby Homes
$1,990,000
Monthly Est:$9,905
7 Beds
3 Baths3 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-f...
- Houzeo last checked: 8 minutes 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
250
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Download App
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Facts & Features
Rooms
Bedrooms & bathrooms
Bedrooms: 7
Bathrooms: 3
Interior
Exterior Features
Other, Garden, Lighting
Appliances
Cooktop, Dishwasher, Double Oven, Microwave, Refrigerator, Washer/dryer
Sewer
Septic Tank
Cooling
Central Air
Flooring
Wood, Ceramic Tile, Hardwood
Interior Features
Other, High Speed Internet, Walk In Closet(s), Built In Features, Ceramic Tile Bath, Chair Rail, Crown Molding, Eat In Kitchen
Heating
Forced Air
Construction
Year Built
Year Built: 2004
Home type
Single Family Residence
Roof
Asphalt
Property Condition
Updated/remodeled
Architectural Style
Mansion
Construction Materials
Stone, Stucco
Utilities & Energy
Laundry Features
Laundry Room, Main Level
Parking Features
Attached, Detached, Driveway
Basement
Finished, Full
Water Source
Public
Fireplace Features
Family Room, Gas
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 Sep 19, 2026, 04: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
Love this home?
Here's 4 things you can do
Your local real estate expert. Speak directly with agent about the home & pricing.
Book your private tour
as early as Today at 02:30 PM
Rates starting from 6.3%. Secure financing early to move quickly when you're ready.
Fastest way to get your offer in. Speak directly with agent to negotiate the offer.
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.
