From The moment you arrive & pass through the gates of this rare usable 5.75acre, 5900SF above ground estate, ''stunning & exceptional'' are the words to describe what your about to see! This home is a very special place w/picturesque ground, a backyard paradise w/an oversized saltwater pool, surrounded w/custom patio stonework & waterfall. The backyard retreat includes an upper & lower patio, large wood burning fireplace & step down to hot tub area. This 5BR, 4.1BA home has gleaming HW floors, 2 staircases, tiled bathrooms, 2 gas fireplaces, beautifully remodeled open concept 1st floor. Custom moldings & ceilings, a new roof, newer furnaces & central air units are just a few of the upgrades. In addition to the large 3-car attached garage, there's a free standing detached 40X28 3-car garage.
Single-familyProperty Type
1995Year Built
5.76 acresLot Size
$316Est. Price/Sq.Ft.
7 garage spacesParking
Listing by John Longo• Miranda Real Estate Group Inc
•518-813-8915 (agent)
•johnlongo5788@gmail.com (agent)
Bought with Theresa Devine• Coldwell Banker Prime Properties
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Beds
4
Baths
4.5
Stories
2
Lot width
—
Lot depth
—
Lot size
5.76 Acres
Year renovated
—
Sq. Ft.
5,297
Year built
1995
Style
Single Family Residential
County
Albany County
APN
012689A01800000010490020000
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Aug 14, 2026.
SFR
Single Family Residential District
The purpose of the Single Family Residential District (SFR) is to provide areas primarily for single-family residential development in the form of detached dwellings. The purpose is to create neighborhoods where people live and conduct their domestic activities. The Single Family Residential District is characterized by traditional suburban residential development.
Property details
Parking
Parking Information
Has Garage
Attached Garage YN: Yes
# of Garage Spaces: 7
# of Parking Total: 20
Parking Features: Off Street, Workshop in Garage, Paved, Attached, Detached, Driveway, Heated Garage
Appliances: Built-In Electric Oven, Built-In Gas Oven, Dishwasher, Disposal, ENERGY STAR Qualified Appliances, Humidifier, Microwave, Oven, Range, Refrigerator, Tankless Water Heater