Active
$1,239,000
6beds
3,647sqft
797 Western Road, Castleton On Hudson, NY 12033
6beds
3,647sqft
Single family residence, residential
Built in 1829
64.57 Acres
2 Garage spaces
$340 price/sqft
What's special
Hay loft with dropsSeparate officePreserved craftsmanshipHilltop colonial manor homeSix-bedroom three-full-bath residenceBest of mountain viewsPool framed by grapevines
A remarkable hilltop colonial manor home overlooking magnificent Hudson Valley views, where sunsets melt gently into the horizon, and the sky feels endlessly expansive. Established in 1829, Enderley Farm has been thoughtfully and lovingly restored to impeccable, move-in condition, and was featured on HGTV. This six-bedroom, three-full-bath residence honors its historic ...
- 95 days |
- 1,156 |
- 75 |
Source: Global MLS,MLS#: 202612988
Travel times
Living Room
Kitchen
Dining Room
Zillow last checked:
Listing updated:
Listed by:
Howard Hanna Capital Inc 518-584-0743,
Aubrey D Guri 518-583-1212
Source: Global MLS,MLS#: 202612988
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 6
- Bathrooms: 3
- Full bathrooms: 3
Primary bedroom
- Description: Sitting area with wood stove & 2nd story porch
- Level: Second
Bedroom
- Description: Door to 2nd story porch
- Level: Second
Bedroom
- Description: Window seat
- Level: Second
Bedroom
- Description: Transom window
- Level: Second
Bedroom
- Description: Hobby room
- Level: Second
Bedroom
- Level: Second
Full bathroom
- Level: First
Full bathroom
- Description: Original clawfoot tub
- Level: Second
Full bathroom
- Description: Clawfoot tub
- Level: Second
Dining room
- Description: Formal Dining Rm
- Level: First
Family room
- Description: Wood Stove
- Level: First
Game room
- Description: Billiards Rm w/ Wet Bar
- Level: First
Kitchen
- Level: First
Laundry
- Level: First
Office
- Description: Access to screened porch
- Level: First
Other
- Description: Breakfast Rm/Informal Dining Rm
- Level: First
Heating
- Other, Radiant, Steam, Wood Stove
Cooling
- Window Unit(s)
Appliances
- Included: Dishwasher, Dryer, ENERGY STAR Qualified Appliances, Microwave, Oven, Range, Range Hood, Refrigerator, Washer, Wine Cooler
- Laundry: Laundry Room, Main Level
Features
- High Speed Internet, Solid Surface Counters, Wall Paneling, Wet Bar, Built-in Features, Ceramic Tile Bath, Crown Molding, Eat-in Kitchen, Kitchen Island
- Flooring: Tile, Wood, Ceramic Tile, Hardwood
- Doors: ENERGY STAR Qualified Doors, French Doors, Storm Door(s)
- Windows: Screens, Shutters, Storm Window(s), Window Coverings, Window Treatments, Wood Frames, Blinds, Curtain Rods, ENERGY STAR Qualified Windows, Insulated Windows
- Basement: Interior Entry,Sump Pump,Unfinished
- Has fireplace: Yes
- Fireplace features: Wood Burning Stove, Bedroom, Family Room
Interior area
- Total structure area: 3,647
- Total interior livable area: 3,647 sqft
- Finished area above ground: 3,647
- Finished area below ground: 0
Video & virtual tour
Property
Parking
- Total spaces: 10
- Parking features: Off Street, Storage, Workshop in Garage, Attached, Circular Driveway, Driveway, Garage Door Opener, Heated Garage
- Garage spaces: 2
- Has uncovered spaces: Yes
Features
- Patio & porch: Screened, Side Porch, Covered, Enclosed, Front Porch, Patio, Porch
- Exterior features: Garden, Lighting
- Pool features: In Ground
- Fencing: Electric,Fenced,Gate
- Has view: Yes
- View description: Meadow, Mountain(s), Orchard, Pasture, Skyline, Trees/Woods, Valley, Hills
- Waterfront features: Stream
Lot
- Size: 64.57 Acres
- Features: Secluded, Level, Meadow, Mountain(s), Private, Road Frontage, Views, Wooded, Bluff, Cleared, Garden, Landscaped
Details
- Additional structures: Other, Barn(s)
- Parcel number: 384489 198.13.11
- Special conditions: Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial,Farm,Farmhouse
- Property subtype: Single Family Residence, Residential
Materials
- Stone, Wood Siding
- Foundation: Combination, Stone
- Roof: Shingle,Asphalt
Condition
- Updated/Remodeled
- New construction: No
- Year built: 1829
Utilities & green energy
- Electric: Circuit Breakers
- Sewer: Septic Tank
- Water: Cistern
- Utilities for property: Cable Connected
Community & HOA
Community
- Security: Smoke Detector(s), Carbon Monoxide Detector(s)
HOA
- Has HOA: No
Location
- Region: Castleton
Financial & listing details
- Price per square foot: $340/sqft
- Tax assessed value: $705,423
- Annual tax amount: $16,583
- Date on market: 3/9/2026
Price history
| Date | Event | Price |
|---|---|---|
| 3/9/2026 | Price change | $1,239,000-1.6%$340/sqft |
Source: | ||
| 6/16/2025 | Price change | $1,259,000-0.9%$345/sqft |
Source: | ||
| 1/13/2025 | Listed for sale | $1,270,000$348/sqft |
Source: | ||
| 9/25/2024 | Listing removed | $1,270,000$348/sqft |
Source: | ||
| 9/11/2024 | Price change | $1,270,000-1.6%$348/sqft |
Source: | ||
| 5/3/2024 | Listed for sale | $1,290,000$354/sqft |
Source: | ||
| 4/25/2024 | Listing removed | -- |
Source: | ||
| 4/9/2024 | Listed for sale | $1,290,000+1128.6%$354/sqft |
Source: | ||
| 1/12/2021 | Listing removed | -- |
Source: Global MLS Report a problem | ||
| 8/17/2020 | Listed for rent | $1,600 |
Source: Howard Hanna #202025598 Report a problem | ||
| 9/14/2018 | Sold | $105,000-47.5%$29/sqft |
Source: Public Record Report a problem | ||
| 1/21/2000 | Sold | $200,000$55/sqft |
Source: | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | -- | $433,200 |
| 2024 | -- | $433,200 |
| 2023 | -- | $433,200 |
| 2022 | -- | $433,200 |
| 2021 | -- | $433,200 |
| 2020 | -- | $433,200 |
| 2019 | -- | $433,200 |
| 2018 | -- | $433,200 |
| 2017 | $11,048 | $433,200 |
| 2016 | -- | $433,200 |
| 2015 | -- | $433,200 |
| 2014 | -- | $433,200 -2% |
| 2013 | -- | $442,000 |
| 2012 | -- | $442,000 |
| 2011 | -- | $442,000 |
| 2010 | -- | $442,000 |
| 2009 | -- | $442,000 |
| 2008 | -- | $442,000 +383.1% |
| 2007 | -- | $91,500 |
| 2006 | -- | $91,500 |
| 2005 | -- | $91,500 |
| 2004 | -- | $91,500 |
| 2003 | -- | $91,500 +14.5% |
| 2002 | -- | $79,900 |
| 2001 | -- | $79,900 |
| 2000 | -- | $79,900 |
Find assessor info on the county website
Monthly payment
Estimated monthly payment$1,822
All calculations are estimates and provided by Zillow, Inc. for informational purposes only. Actual amounts may vary.
HOA fees may include property taxes on listings classified as Co-Ops. Contact the listing agent and/or owner for fee details.
Mortgage interest rates are dependent on a number of factors, including credit score, down payment, and repayment length. Interest rate data provided by Zillow Group Marketplace, Inc. as of 1/1/1970 from various mortgage lenders with which we have lead or other similar arrangements; the Estimated Payment is an average of those rates.
See how much you could borrow to make a competitive offer.
Estimated market value
$1,174,600
$1.12M - $1.23M
$4,003/mo
Climate risks
Explore flood, wildfire, and other predictive climate risk information for this property on First Street®️.
Neighborhood: 12033
Nearby schools
Castleton Elementary School
Grades K-6 • 0.9 miles7/10
GreatSchools® Rating
Test Score Rating
7/10Academic Progress Rating
7/10Maple Hill High School
Grades 7-12 • 2 miles6/10
GreatSchools® Rating
Test Score Rating
7/10Academic Progress Rating
6/10College Readiness Rating
6/10- New York
- Rensselaer County
- Castleton-on-Hudson
- 12033
- 797 Western Road
Nearby cities
Nearby zip codes
Other Castleton-on-Hudson Topics
- Apartments for Rent in 12033
- Houses for Sale in 12033
- Houses for Rent in 12033
- 12033 Real Estate
- Castleton-on-Hudson Condos
- Houses for Sale in Castleton-on-Hudson
- Newest Listings in Castleton-on-Hudson
- Castleton-on-Hudson Home Values
- Castleton-on-Hudson Real Estate Agents
- Castleton-on-Hudson Refinance
- Castleton-on-Hudson Mortgage Rates