
Member Features
Find Real Estate Bargain!
Full foreclosure details
Home value, equity and ownership info
Find homes priced below market
Get full access with a FREE Account
Already a member?
$650,000
Listing Price5beds
3baths
2,930sqft
130,680sqft lot
404 Gretna Rd, Hyde Park, NY 12538
Member Features
Find Real Estate Bargain!
Full foreclosure details
Home value, equity and ownership info
Find homes priced below market
Get full access with a FREE Account
Already a member?
For Sale
Off Market
Home type
Price / sqft
Year built
Home Details
Pass through the pillar lined entrance and down the circular driveway to find this custom 5 bedroom, 3 bathroom cape cod. Attractive stone & brick exterior surrounded by extensive and elaborate landscaping, privately situated on 3 acres. With 3000 sqft of finished space, the floor plan is ideal for entertaining and offers tremendous versatility. Massive kitchen/family room combo with granite counters, dual wall ovens, Subzero refrigerator, breakfast nook, fireplace & indoor bbq flows seamlessly to formal living room w/fireplace & beamed ceiling. Three first floor bedrooms, two first floor full bathrooms, huge laundry room & entry foyer w/radiant heat. Second floor offers two additional bedrooms and full bathroom. Oversized three car garage with unfinished bonus room above, ideal for future media room, fitness area or studio space. New well w/constant pressure system, spray foam insulation in attic & 3 zone a/c. Perfectly manicured grounds w/patios & covered rear deck for abundant outdoor living space. Surrounded by farmland with incredible views & sustainable privacy. Centrally located with easy access to Village of Millbrook, Taconic State Parkway, Poughkeepsie Train Station, dining, shopping & area attractions. Ideal as a primary residence or weekend retreat.
Interior Details
2930
5
3
Has Heating:
Yes
Heating Type:
Hot Water
Has Cooling:
Yes
Cooling Type:
Central
Has Fuel:
Yes
Fuel Type:
Oil
Has Basement:
No
Basement Type:
Full
Has Flooring:
No
Flooring Type:
N/A
Has Fireplace:
Yes
Fireplace Type:
N/A
Property Details
130680
Yes
Yes
Type:
Garage, Attached
Location:
N/A
Status:
N/A
Number of Spaces:
4
No
No
No
No
Yes
No
No
Construction Details
Cape Cod
Brick
N/A
N/A
Asphalt
Tax History
Year
Amount
Land
Improvement
Percent Change
Assessment
2020
$12,965
$160,500
$241,600
--%
$402,100
2018
$12,579
$160,500
$228,100
--%
$388,600
2017
$12,524
$160,500
$228,100
--%
$388,600
2016
$12,320
$160,500
$228,100
--%
$388,600
2015
$12,426
$160,500
$228,100
--%
$388,600
2013
$10,954
$160,500
$228,100
--%
$388,600
2011
$11,273
$175,000
$265,000
--%
$440,000
Average Home Price in 12538
Nearby Properties
Zip Code
Price
Bed
Bath
Sqft
Lot
Sold Date
$650,000
$650,000
5 Beds
3 Baths
2,930 Sqft
130,680 Lot (sqft)
Sold 09/29/2026
$675,807
$675,807
3 Beds
2.5 Baths
2,627 Sqft
226,512 Lot (sqft)
Sold 10/06/2026




