797 Western Road, Castleton On Hudson, NY 12033
What's special
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 ...
- 36 days |
- 2,024 |
- 122 |
Travel times
Living Room
Kitchen
Dining Room
Zillow last checked: 7 hours ago
Listing updated: April 06, 2026 at 01:59pm
Howard Hanna Capital Inc 518-584-0743,
Aubrey D Guri 518-583-1212
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: $666,462
- 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 |
|---|---|---|
| 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 market value
$1,179,000
$1.12M - $1.24M
$4,039/mo
Climate risks
Explore flood, wildfire, and other predictive climate risk information for this property on First Street®️.
Neighborhood: 12033
Nearby schools
GreatSchools rating
- 7/10Castleton Elementary SchoolGrades: K-6Distance: 0.9 mi
- 6/10Maple Hill High SchoolGrades: 7-12Distance: 2 mi
Schools provided by the listing agent
- High: Maple Hill HS
Source: Global MLS. This data may not be complete. We recommend contacting the local school district to confirm school assignments for this home.
- 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