A true masterpiece, this private estate makes an awesome impression & stuns throughout thanks to incredible finishes, features and scale. Set on 21 acres w/creek & pond, this custom home runs 9,000 sqft w/ 6 bedrooms/5.5 bathrooms, grotto-like wine room/bar, mudroom, gym, massive chef's kitchen w/ custom tile/stone counters. Geo-thermal heating system with 3 zones, public water, radiant floors, sprinkler, security systems, 3-car garage, detached 2 car garage with finished room & much more. Superior Condition
Claim this home to receive a free report every month with insights on the changing estimate.
Earn from this home
Refinance
$0
Est. cash available
Get cash now or lower your monthly rate
Market trends in 12009, NY
Last updated October 2026
Buyer's Market
Seller's Market
Seller's market
Sale-to-list price
99.8%
1.3% MoM
Median sale price
$455K
$5K MoM
Avg. days on market
9d
3 days MoM
Recently sold homes
27
3 MoM
Provided by Redfin
Sale history for 2004 W Old State Rd
Date
Event
Price
Global MLS #201912636
Aug 2, 2019
Sold
$1,525,000
$236/sq ft
Apr 23, 2019
Pending
—
Feb 14, 2019
Listed
$2,000,000
$309/sq ft
Year
Property tax
Land + Additions
Assessment*
2026
$41,250 (+2.6%)
$90,000 + $1,410,000
$1,500,000
2025
$40,222 (+2.3%)
$90,000 + $1,410,000
$1,500,000
2024
$39,314 (+3.0%)
$90,000 + $1,410,000
$1,500,000
2023
$38,165 (+1.6%)
$90,000 + $1,410,000
$1,500,000
2022
$37,565 (+4.2%)
$90,000 + $1,410,000
$1,500,000
2021
$36,060 (+81.4%)
$90,000 + $1,410,000
$1,500,000
2020
$19,878 (+2.1%)
$90,000 + $746,000
$836,000
2019
$19,468 (+11.2%)
$90,000 + $746,000
$836,000
2018
$17,514 (−11.2%)
$90,000 + $746,000
$836,000
2017
$19,714 (+3.5%)
$100,000 + $544,700
$644,700
2016
$19,051 (+0.2%)
$100,000 + $544,700
$644,700
2015
$19,022 (+1.7%)
$100,000 + $544,700
$644,700
2014
$18,713
$100,000 + $544,700
$644,700
Tax history for 2004 W Old State Rd
Year
Property tax
Land + Additions
Assessment*
2026
$41,250 (+2.6%)
$90,000 + $1,410,000
$1,500,000
2025
$40,222 (+2.3%)
$90,000 + $1,410,000
$1,500,000
2024
$39,314 (+3.0%)
$90,000 + $1,410,000
$1,500,000
2023
$38,165 (+1.6%)
$90,000 + $1,410,000
$1,500,000
2022
$37,565 (+4.2%)
$90,000 + $1,410,000
$1,500,000
2021
$36,060 (+81.4%)
$90,000 + $1,410,000
$1,500,000
2020
$19,878 (+2.1%)
$90,000 + $746,000
$836,000
2019
$19,468 (+11.2%)
$90,000 + $746,000
$836,000
2018
$17,514 (−11.2%)
$90,000 + $746,000
$836,000
2017
$19,714 (+3.5%)
$100,000 + $544,700
$644,700
2016
$19,051 (+0.2%)
$100,000 + $544,700
$644,700
2015
$19,022 (+1.7%)
$100,000 + $544,700
$644,700
2014
$18,713
$100,000 + $544,700
$644,700
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Beds
6
Baths
5.5
Stories
2
Lot width
701 ft.
Lot depth
—
Lot size
21 Acres
Year renovated
—
Sq. Ft.
8,995
Year built
2011
Style
Vacant Land
County
Albany County
APN
013089A01400000010060110000
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Nov 13, 2026.
Property details
Parking
Parking Information
Has Garage
Attached Garage YN: Yes
# of Garage Spaces: 5
# of Parking Total: 35
Parking Features: Off Street, Attached, Detached
Interior
Bathroom Information
# of Bathrooms (Full): 5
# of Bathrooms (Half): 1
# of Bathrooms (Total Integer): 6
Room 1 Information
Type: Primary Bedroom
Room 2 Information
Type: Full Bathroom
Level: First
Room 3 Information
Type: Bedroom
Level: First
Basement Information
Basement: Finished, Full
Laundry Features
Laundry Features: Laundry Room, Main Level, Upper Level
Fireplace Information
Has Fireplace
# of Fireplaces Total: 1
Interior Features
# of Rooms Total: 3
Interior Features: High Speed Internet, Paddle Fan, Solid Surface Counters, Built-in Features
Appliances: Other, Dishwasher, Disposal, Double Oven, Geothermal Water Heater, Humidifier, Microwave, Oven, Range, Refrigerator, Solar Water Heater, Tankless Water Heater, See Remarks
Flooring: Ceramic Tile
Door Features: Atrium Door, French Doors
Exterior
Exterior Features
Patio And Porch Features: Screened, Patio, Porch
Roof: Asphalt
Exterior Features: Lighting
Property Information
Property Sub Type: Single Family Residence
Living Area: 6,475
Below Grade Finished Area: 2,500
Green Energy Efficient: Exposure/Shade
Construction Materials: Stone
Security Features: Security System
Lot Information
Lot Size Acres: 21
Lot Size Square Feet: 914,760
Lot Size Dimensions: 914,760
Lot Features: Level, Private, Sprinklers In Front, Sprinklers In Rear, Views, Wooded, Landscaped
Financial
Tax Information
Tax Annual Amount: $22,621
Tax Annual Amount: $22,621
Utilities
Heating & Cooling
Has Heating
Heating: Geothermal, Radiant, Zoned
Has Cooling
Cooling: Central Air, Geothermal
Utility Information
Sewer: Septic Tank
Utilities: Cable Available
Water Source: Public
Location
School Information
School District: Guilderland
Location Information
Directions: Hwy 20 W/Western Ave, Turn Right onto NY-158 N, Turn Left onto W Old State Rd
Public facts
Beds: 6
Baths: 5.5
Sq. Ft.: 8,995
Stories: 2.0
Lot Size: 21 acres
Style: Vacant Land
Year Built: 2011
Year Renovated: —
County: Albany County
APN: 013089A01400000010060110000
Home facts updated by county records on Nov 13, 2026
Around this home
Schools
K - 12
Preschool & daycare
Lynnwood Elementary School
Public K-5 • Assigned • 3.4mi
8/10
Farnsworth Middle School
Public 6-8 • Assigned • 6.9mi
7/10
Guilderland High School
Public 9-12 • Assigned • 4.0mi
8/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
3/10 Heat Factor
7 days above 97° expected this year, 15 days in 30 years
3/10 Wind Factor
6% chance of strong winds in next 30 years
1/10 Air Factor
0 unhealthy days expected this year, 0 days in 30 years
Provided by First Street
Historical weather
Altamont, NY • 12009
Average low and high temperatures (°F)
29°
15°
32°
17°
49°
29°
60°
38°
66°
48°
79°
58°
84°
63°
78°
56°
74°
51°
61°
41°
47°
32°
33°
19°
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 8.5 hours in
June and 3.2 hours in December, placing it below the
U.S. average for solar exposure.
8.5 hrs
3.2 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$2.08M – $2.52M
Sell confidently with a local market expert in Altamont. 3 minutes to get started.