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

797 Western Road, 
Castleton, NY 12033

$1,270,000


6

Beds


3

Baths


3,393

Sq Ft


Single Family

Active

Listed by

Edward Brewer

Jolene Pace

Howard Hanna Capital, Inc.

518-428-6184

Last updated:

May 8, 2025, 04:03 AM

MLS#

155663

Source:

NY CGND

About This Home

797 Western Road

Historically known as Enderley Farm this Patroon era Farmhouse has been authentically restored and featured on HGTV. This hilltop property has over 64 acres with spectacular Hudson Valley views and seasonal Hudson River views. The location is a blend of convenience and serenity just 10 minutes from downtown Albany. The farmhouse has a bedroom suite with porch and woodstove and 5 additional bedrooms on the second floor, 3 full baths, 2 dining rooms, and 2 stairways to the 2nd floor. The barn has an office and 3 horse stalls leading to 7 acres of fenced pasture. There are several fields and riding trails which are great for horses or four wheelers as well as an inground garden pool with hot tub. This property is a true gentlepersons farm and perfect venue for equine endeavors or to immerse yourself in a slower paced world. Adjoining 777 Western Rd. is also available for an interested party for a caretaker or other family members to live on this classic Farm property - see last photo for front of this home.

Home Facts

Single Family

3 Baths

6 Bedrooms

Built in 1829

Price Summary

1,270,000

$374 per Sq. Ft.

MLS #:

155663

Last Updated:

May 8, 2025, 04:03 AM

Added:

3 month(s) ago


Rooms & Interior

Bedrooms

Total Bedrooms:

6

Bathrooms

Total Bathrooms:

3

Full Bathrooms:

3

Interior

Living Area:

3,393 Sq. Ft.


Structure

Structure

Architectural Style:

Farm House

Building Area:

3,393 Sq. Ft.

Year Built:

1829


Lot

Lot Size (Sq. Ft):

2,818,332


Finances & Disclosures

Finances

Price:

$1,270,000

Price per Sq. Ft:

$374 per Sq. Ft.

Source:NY CGND
The information being provided by Columbia Greene Northern Dutchess Multiple Listing Service is for the consumer’s personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The information is deemed reliable but not guaranteed and should therefore be independently verified. © 2025 Columbia Greene Northern Dutchess Multiple Listing Service All rights reserved.

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.