Close IconHouzeo

Do Real Estate on the Go!

For Sale
Deal AlertDeal Alert?
3D Tour3D Tour
Homes for sale in Niskayuna, NY | 2820 Balltown Rd, Niskayuna, NY 12309 | MLS# 202610469
Homes for sale in Niskayuna, NY | 2820 Balltown Rd, Niskayuna, NY 12309 | MLS# 202610469
Homes for sale in Niskayuna, NY | 2820 Balltown Rd, Niskayuna, NY 12309 | MLS# 202610469
Homes for sale in Niskayuna, NY | 2820 Balltown Rd, Niskayuna, NY 12309 | MLS# 202610469
Homes for sale in Niskayuna, NY | 2820 Balltown Rd, Niskayuna, NY 12309 | MLS# 202610469
72+
Beds Icon

Virtual Tour

Beds Icon

Street View

$1,990,000

  • Beds Icon7 Beds
  • Beds Icon
    3 Baths

    3 full baths

  • Beds Icon5,000sqft

2820 Balltown Rd, Niskayuna, NY 12309

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...

Continue Reading
  • Houzeo last checked: 55 Minutes ago
  • Listing updated: January 20, 2026 at 4:15 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 Greater Capital Association of Realtors (Global) MLS-NY

Property Details

  • Status

    Active

  • Type

    Single Family Residence

  • No. of Stories

    -

  • County

    Schenectady County

  • City

    Niskayuna

  • 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

    24

AMERICA’S BEST HOME BUYING WEBSITE

Homes For Sale Near Me

We couldn’t find any listings matching your search

Search Tips

mapBlueIcon

Widen the search area

Expand your search to a larger area (eg: neighborhood to ZIP) or simply click and zoom out on the interactive map.

filterBlueIcon

Refine your search

Reduce the number of applied filters to make your search less restrictive.

searchBlueIcon

Try adjusting your filters or search by

  • Address: 16308 Mount Holly Dr, Bradenton, FL 34211
  • Neighborhood - Reseda
  • ZIP - 33143
  • City - Miami

Click to see all homes
static map image
Satellite
Close IconHouzeo

Do Real Estate on the Go!

For Sale
Price

Price Range

Minimum Price
$
Maximum Price
$
Beds & Baths
Home Type
Filters
Save Search Share