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.
For sale
$1,270,000
797 Western Rd, Castleton, NY 12033
6beds
3,393sqft
Deeded, Single Family Residence
Built in 1829
64.7 Acres Lot
$-- Zestimate®
$374/sqft
$-- HOA
What's special
- 103 days
- on Zillow |
- 824 |
- 67 |
Zillow last checked: 7 hours ago
Listing updated: January 13, 2025 at 01:52am
Listing by:
Howard Hanna Capital, Inc. 518-286-1000,
Edward R. Brewer,
Jolene S. Morris,
Howard Hanna Capital, Inc.
Source: Columbia Greene Northern Dutchess MLS,MLS#: 155663
Originating MLS: Columbia County & Northern Dutchess MLS

Travel times
Tour with a buyer’s agent
Tour with a buyer’s agent
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 6
- Bathrooms: 3
- Full bathrooms: 3
Heating
- Steam
Appliances
- Included: Clothes Dryer, Clothes Washer, Dishwasher, Microwave, Refrigerator, Stove, Water Treatment, Other, Water Heater (Electric)
Features
- Flooring: Hardwood, Wideboard
- Windows: Double Hung, Low Energy, Storm Window(s)
- Basement: Full,Unfinished,Exterior Entry,Storage Space,Sump Pump
- Has fireplace: Yes
- Fireplace features: Bedroom, Family Room
Interior area
- Total structure area: 3,393
- Total interior livable area: 3,393 sqft
Property
Parking
- Total spaces: 2
- Parking features: Attached
- Attached garage spaces: 2
Features
- Has view: Yes
- View description: Farmland, Hills, Panoramic, Park/Greenbelt, Pastoral, River, Seasonal, Valley, Meadow, Rural
- Has water view: Yes
- Water view: River
Lot
- Size: 64.7 Acres
- Features: Secluded
Details
- Parcel number: 198.-1-3.11
- Zoning: Ag/Farm
- Zoning description: Ag/Farm
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Farm House
- Property subtype: Deeded, Single Family Residence
Materials
- Frame, Plaster, Clapboard
- Foundation: Poured Concrete, Stone
- Roof: Asphalt,Shingle,Other
Condition
- Excellent
- Year built: 1829
Utilities & green energy
- Electric: 200+ Amp Service, Other
- Sewer: Septic Tank
- Water: Private, Well, Cistern
Community & HOA
HOA
- Has HOA: No
Location
- Region: Castleton
Financial & listing details
- Price per square foot: $374/sqft
- Tax assessed value: $666,462
- Annual tax amount: $15,311
- Price range: $1.3M - $1.3M
- Date on market: 1/13/2025
- Electric utility on property: Yes
- Road surface type: Paved
- Loading
- Loading