Coldwell Banker Home Page
Local Realty Service Provided By: Coldwell Banker Phillips
Property view
Listing view 2
Listing view 3

404 Gretna Road, 
Hyde Park, NY 12538

$650,000


5

Beds


3

Baths


3,000

Sq Ft


Single Family

Active

Listed by

Daniel Axtmann

Bhhs Hudson Valley Properties

Last updated:

September 20, 2025, 11:51 AM

MLS#

914663

Source:

OneKey MLS

About This Home

404 Gretna Road

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.

Home Facts

Single Family

3 Baths

5 Bedrooms

Built in 1956

Price Summary

650,000

$216 per Sq. Ft.

MLS #:

914663

Last Updated:

September 20, 2025, 11:51 AM

Added:

1 day(s) ago


Rooms & Interior

Bedrooms

Total Bedrooms:

5

Bathrooms

Total Bathrooms:

3

Full Bathrooms:

3

Interior

Living Area:

3,000 Sq. Ft.


Structure

Structure

Architectural Style:

Cape Cod

Building Area:

3,000 Sq. Ft.

Year Built:

1956


Lot

Lot Size (Sq. Ft):

130,680


Finances & Disclosures

Finances

Price:

$650,000

Price per Sq. Ft:

$216 per Sq. Ft.

Source:OneKey MLS
Copyright 2025 OneKey MLS. All rights reserved. Listings courtesy of OneKey MLS as distributed by MLS GRID. OneKey MLS provides content displayed here (“provided content”) on an “as is” basis and makes no representations or warranties regarding the provided content, including, but not limited to those of non-infringement, timeliness, accuracy, or completeness. Individuals and companies using information presented are responsible for verification and validation of information they utilize and present to their customers and clients. OneKey MLS will not be liable for any damage or loss resulting from use of the provided content or the products available through Portals, IDX, VOW, and/or Syndication. Recipients of this information shall not resell, redistribute, reproduce, modify, or otherwise copy any portion thereof without the expressed written consent of OneKey MLS.

Contact an Agent

Yes, I would like more information from Coldwell Banker. Please use and/or share my information with a Coldwell Banker agent to contact me about my real estate needs.

By clicking Contact I agree a Coldwell Banker Agent may contact me by phone or text message including by automated means and prerecorded messages about real estate services, and that I can access real estate services without providing my phone number. I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.

 

Contact an Agent

Yes, I would like more information from Coldwell Banker. Please use and/or share my information with a Coldwell Banker agent to contact me about my real estate needs.

By clicking Contact I agree a Coldwell Banker Agent may contact me by phone or text message including by automated means and prerecorded messages about real estate services, and that I can access real estate services without providing my phone number. I acknowledge that I have read and agree to the Terms of Use and Privacy Notice.