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 Price

5beds

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

Single Family

Home type

220.71

Price / sqft

1956

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

Square Feet
  • 2930

Bedrooms
  • 5

Bathrooms
  • 3

Heating
  • Has Heating:

    Yes

  • Heating Type:

    Hot Water

Cooling
  • Has Cooling:

    Yes

  • Cooling Type:

    Central

Fuel
  • Has Fuel:

    Yes

  • Fuel Type:

    Oil

Basement
  • Has Basement:

    No

  • Basement Type:

    Full

Flooring
  • Has Flooring:

    No

  • Flooring Type:

    N/A

Fireplace
  • Has Fireplace:

    Yes

  • Fireplace Type:

    N/A

Property Details

Lot Size
  • 130680

Water
  • Yes

Sewer
  • Yes

Parking
  • Type:

    Garage, Attached

  • Location:

    N/A

  • Status:

    N/A

  • Number of Spaces:

    4

Deck
  • No

Patio
  • No

Fence
  • No

Pool
  • No

Porch
  • Yes

Stoop
  • No

Breezeway
  • No

Construction Details

Number of Stories
  • 1

Style
  • Cape Cod

Exterior
  • Brick

Foundation
  • N/A

Roof
  • N/A

Roofing Material
  • 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

percent-home-icon

Average Home Price in 12538

Nearby Properties

Zip Code

Price

Bed

Bath

Sqft

Lot

Sold Date

$650,000

5 Beds

3 Baths

2,930 Sqft

130,680 Lot (sqft)

Sold 09/29/2026

$675,807

3 Beds

2.5 Baths

2,627 Sqft

226,512 Lot (sqft)

Sold 10/06/2026

percent-home-icon

Calculators

Mortgage

Mortgage Calculator

Calculate your monthly mortgage payments.
Household Income
70,000
$
Home price
650,000
$
Down payment
130,000
$
Mortgage Rate
6.5
%
Loan Term
Property Tax Rate
1.1
%
Homeowner's Insurance (Annual)
3,900
$
HOA (Monthly)
0
$
PMI
0
$
$4,208
Your Payment
Total Monthly Payment:$4,208
Percent of Income:72%
Affordable:No

Details for 404 GRETNA RD

Property Debt

Foreclosure Contact Details