797 Western Road
Castleton, NY 12033
6 Beds
3 Baths
3,647 sqft (on 64.57 acres)
6 Beds
3 Baths
3,647 sqft
(on 64.57 acres)
Local Information
© Google
-- mins to
Description
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 roots while embracing modern comfort. Preserved craftsmanship tells the story of its past, while every major system, plumbing, electrical, heating, foundation, and roof, has been fully upgraded to ensure peace of mind for years to come.
Let this lifestyle unfold while pursuing your dreams and passions in an idealistic and serene setting. This 64-acre spread of land offers the best of mountain views, peaceful seclusion, and has perfect southern exposures for growing. Trails weave through the acreage, perfect for riding, walking, or winter sports. Walking the fields and forested trails, the majesty of this historic property comes to life as you feel like you are in your own state park. The open fields are perfectly suited for small-scale farming or for horses or other animals that can graze under the endless skies.
The barn is complete with three stalls, a hay loft with drops, a separate office, and a large interior space with a new stamped concrete floor, perfect for equestrian pursuits, hobbies, or social gatherings. A pool framed by grapevines and a charming cabana creates a peaceful retreat for gathering with friends or unwinding beneath the open sky. Each season unveils its own quiet, picturesque beauty.
Let this lifestyle unfold while pursuing your dreams and passions in an idealistic and serene setting. This 64-acre spread of land offers the best of mountain views, peaceful seclusion, and has perfect southern exposures for growing. Trails weave through the acreage, perfect for riding, walking, or winter sports. Walking the fields and forested trails, the majesty of this historic property comes to life as you feel like you are in your own state park. The open fields are perfectly suited for small-scale farming or for horses or other animals that can graze under the endless skies.
The barn is complete with three stalls, a hay loft with drops, a separate office, and a large interior space with a new stamped concrete floor, perfect for equestrian pursuits, hobbies, or social gatherings. A pool framed by grapevines and a charming cabana creates a peaceful retreat for gathering with friends or unwinding beneath the open sky. Each season unveils its own quiet, picturesque beauty.
Home Highlights
Parking
Garage
Outdoor
Porch, Patio, Pool
A/C
Heating & Cooling
HOA
None
Price/Sqft
$340
Listed
73 days ago
Last check for updates: about 2 hours ago
Listing by: Howard Hanna Capital Inc, (518) 584-0743
Aubrey D Guri, (518) 583-1212
Source: Global MLS, MLS#202612988
Also Listed on Global MLS.
Home Details for 797 Western Road
|
|---|
MLS Status: Active |
|
|---|
Interior Details Basement: Interior Entry,Sump Pump,UnfinishedNumber of Rooms: 16Types of Rooms: Primary Bedroom, Bedroom, Full Bathroom, Dining Room, Family Room, Game Room, Kitchen, Laundry, Office, OtherWet Bar |
Beds & Baths Number of Bedrooms: 6Number of Bathrooms: 3Number of Bathrooms (full): 3 |
Dimensions and Layout Living Area: 3647 Square Feet |
Appliances & Utilities Utilities: Cable ConnectedAppliances: Dishwasher, Dryer, ENERGY STAR Qualified Appliances, Microwave, Oven, Range, Range Hood, Refrigerator, Washer, Wine CoolerDishwasherDryerLaundry: Laundry Room,Main LevelMicrowaveRefrigeratorWasher |
Heating & Cooling Heating: Other,Radiant,Steam,Wood StoveHas CoolingAir Conditioning: Window Unit(s)Has HeatingHeating Fuel: Other |
Fireplace & Spa Fireplace: Wood Burning Stove, Bedroom, Family RoomHas a Fireplace |
Gas & Electric Electric: Circuit Breakers |
Windows, Doors, Floors & Walls Window: Screens, Shutters, Storm Window(s), Window Coverings, Window Treatments, Wood Frames, Blinds, Curtain Rods, ENERGY STAR Qualified Windows, Insulated WindowsDoor: ENERGY STAR Qualified Doors, French Doors, Storm Door(s)Flooring: Tile, Wood, Ceramic Tile, Hardwood |
Levels, Entrance, & Accessibility Floors: Tile, Wood, Ceramic Tile, Hardwood |
View Has a ViewView: Meadow, Mountain(s), Orchard, Pasture, Skyline, Trees/Woods, Valley, Hills |
Security Security: Smoke Detector(s), Carbon Monoxide Detector(s) |
|
|---|
Exterior Home Features Roof: Shingle AsphaltPatio / Porch: Screened, Side Porch, Covered, Enclosed, Front Porch, Patio, PorchFencing: Electric, Fenced, GateOther Structures: Other, Barn(s)Exterior: Garden, LightingFoundation: Combination, StoneGarden |
Parking & Garage Number of Garage Spaces: 2Number of Covered Spaces: 2No CarportHas a GarageHas Open ParkingParking Spaces: 10Parking: Off Street,Storage,Workshop in Garage,Attached,Circular Driveway,Driveway,Garage Door Opener,Heated Garage |
Pool Pool: In GroundPool |
Frontage Waterfront: StreamNot on Waterfront |
Water & Sewer Sewer: Septic Tank |
Finished Area Finished Area (above surface): 3647 Square Feet |
|
|---|
Days on Market: 73 |
|
|---|
Year Built Year Built: 1829 |
Property Type / Style Property Type: ResidentialProperty Subtype: Single Family Residence, ResidentialArchitecture: Colonial,Farm,Farmhouse |
Building Construction Materials: Stone, Wood SidingNot a New Construction |
Property Information Condition: Updated/RemodeledParcel Number: 384489 198.13.11 |
|
|---|
Price List Price: $1,239,000Price Per Sqft: $340 |
Status Change & Dates Possession Timing: Close Of Escrow |
|
|---|
Direction & Address City: Castleton On Hudson |
School Information High School: Maple Hill HSHigh School District: Schodack |
|
|---|
Listing Agent Listing ID: 202612988 |
|
|---|
Building Area Building Area: 3647 Square Feet |
|
|---|
No HOA |
|
|---|
Lot Area: 64.57 Acres |
|
|---|
Special Conditions: Standard |
|
|---|
Mobile Home Park Mobile Home Units: Feet |
|
|---|
BasementMls Number: 202612988Above Grade Unfinished Area: 3647Showing Requirements: No Sign, Occupied, 24 Hour Notice, Agent to Accompany |
Price History for 797 Western Road
| Date | Price | Event | Source |
|---|---|---|---|
| 03/09/2026 | $1,239,000 | PriceChange | Global MLS #202612988 |
| 06/16/2025 | $1,259,000 | PriceChange | Global MLS #202519616 |
| 01/13/2025 | $1,270,000 | Listed For Sale | Global MLS #202510557 |
| 09/25/2024 | $1,270,000 | ListingRemoved | Global MLS #202416481 |
| 09/11/2024 | $1,270,000 | PriceChange | Global MLS #202416481 |
| 05/03/2024 | $1,290,000 | Listed For Sale | Global MLS #202416481 |
| 04/25/2024 | ListingRemoved | Global MLS #202414869 | |
| 04/09/2024 | $1,290,000 | Listed For Sale | Global MLS #202414869 |
| 01/12/2021 | ListingRemoved | Global MLS | |
| 08/17/2020 | $1,600 | Listed For Rent | Agent Provided |
| 09/14/2018 | $105,000 | Sold | N/A |
| 01/21/2000 | $200,000 | Sold | Global MLS #9932681 |
Similar Homes You May Like
NEW - 2 DAYS AGONEW CONSTRUCTION1.49 ACRESListing by: KW Platform, Active
NEW - 2 DAYS AGONEW CONSTRUCTION1.97 ACRESListing by: KW Platform, Active- NEW CONSTRUCTION1.5 ACRESListing by: KW Platform, Active
NEW CONSTRUCTION1.5 ACRESListing by: KW Platform, Active
NEWOPEN SAT, 12-2PM0.67 ACRESListing by: Sinkoff Realty Group, Active
54.4 ACRESListing by: Carrow Real Estate Services LLC, Active
3.17 ACRESListing by: Berkshire Hathaway HomeService, Active
24.93 ACRESListing by: Miranda Real Estate Group Inc, Active
NEW CONSTRUCTIONListing by: Amedore Homes
NEW CONSTRUCTIONListing by: Amedore Homes
NEW CONSTRUCTION0.71 ACRESListing by: Amedore Homes, Active
NEW CONSTRUCTIONListing by: Amedore Homes
NEW CONSTRUCTION0.64 ACRESListing by: Amedore Homes, Active
NEW - 20 HRS AGO0.67 ACRESListing by: Coldwell Banker Prime Properties, Active
NEW CONSTRUCTION0.53 ACRESListing by: Amedore Homes, Active
1.93 ACRESListing by: Coldwell Banker Prime Properties, Active
1.51 ACRESListing by: Four Seasons Sotheby's Int., Active
4.3 ACRESListing by: Berkshire Hathaway HomeService, Active
NEW CONSTRUCTION0.61 ACRESListing by: Amedore Homes, Active
3.04 ACRESListing by: A 1 R E O Services LLC, Active
NEW CONSTRUCTION0.34 ACRESListing by: Amedore Homes, Active
2.91 ACRESListing by: Mahar Real Estate, LLC, Active
NEW CONSTRUCTION0.3 ACRESListing by: Amedore Homes, Active
18.63 ACRESListing by: KW Platform, Active
NEW CONSTRUCTION0.27 ACRESListing by: Amedore Homes, Active
NEW CONSTRUCTIONListing by: Amedore Homes
NEW CONSTRUCTIONListing by: Amedore Homes
NEW CONSTRUCTIONListing by: Amedore Homes
NEW CONSTRUCTIONListing by: Amedore Homes
NEW CONSTRUCTIONListing by: Amedore Homes
Listing by: McDonald Real Estate Comp LLC, Active
0.92 ACRESListing by: Beach & Bartolo Realtors, Active
NEW - 17 HRS AGO10.07 ACRESListing by: Trevett Group LLC, Active
Listing by: Miranda Real Estate Group Inc, Active
1.4 ACRESListing by: Houlihan Lawrence Inc., Active
1.7 ACRESListing by: Four Seasons Sotheby's Int., Active
Listing by: McDonald Real Estate Comp LLC, Active
See more homes for sale inCastleton
New Listings near 797 Western Road
23.24 ACRESListing by: Sierra North Real Estate LLC, Active- 24.93 ACRESListing by: Miranda Real Estate Group Inc, Active
- NEW - 2 DAYS AGONEW CONSTRUCTION1.49 ACRESListing by: KW Platform, Active
- NEW - 2 DAYS AGONEW CONSTRUCTION1.97 ACRESListing by: KW Platform, Active
- NEW CONSTRUCTION1.5 ACRESListing by: KW Platform, Active
- NEW CONSTRUCTION1.5 ACRESListing by: KW Platform, Active
- 54.4 ACRESListing by: Carrow Real Estate Services LLC, Active
NEW CONSTRUCTION1.5 ACRESListing by: KW Platform, Active
NEW CONSTRUCTION1.5 ACRESListing by: KW Platform, Active
1.02 ACRESListing by: Berkshire Hathaway HomeService, Active- 3.17 ACRESListing by: Berkshire Hathaway HomeService, Active
35.94 ACRESListing by: COLDWELL BANKER COMMERCIAL PRIME PROPERTIES- NEWOPEN SAT, 12-2PM0.67 ACRESListing by: Sinkoff Realty Group, Active
- See more homes for sale inCastleton
Property Tax and Assessment
| Year | 2025 |
|---|---|
| Tax | |
| Assessment | $705,423 |
Home facts updated by county records
Comparable Sales for 797 Western Road
Address | Distance | Property Type | Sold Price | Sold Date | Bed | Bath | Sqft |
|---|---|---|---|---|---|---|---|
0.70 | Single-Family Home | $255,000 | 04/02/26 | 4 | 1.5 | 1,482 | |
0.82 | Single-Family Home | $100,000 | 06/11/25 | 3 | 1.5 | 1,320 | |
0.63 | Single-Family Home | $485,000 | 08/13/25 | 3 | 2 | 1,780 | |
0.71 | Single-Family Home | $215,000 | 09/24/25 | 3 | 2 | 1,152 | |
0.90 | Single-Family Home | $266,250 | 10/21/25 | 4 | 2 | 1,770 | |
0.98 | Single-Family Home | $650,000 | 03/17/26 | 5 | 5 | 3,968 | |
0.68 | Single-Family Home | $264,000 | 12/12/25 | 4 | 1 | 1,460 | |
0.77 | Single-Family Home | $402,000 | 07/10/25 | 3 | 2 | 1,750 | |
0.57 | Single-Family Home | $305,000 | 04/03/26 | 3 | 1 | 1,344 |
Assigned Schools
These are the assigned schools for 797 Western Road.
- Castleton Elementary School
- K-6
- Public
- 443 Students
7/10GreatSchools RatingParent Rating AverageNothing was EVER done about the racism no matter how many times I reported it.Other Review4y ago - Maple Hill High School
- 7-12
- Public
- 399 Students
6/10GreatSchools RatingParent Rating AverageThe safety is low lots of discrimination and racism inside the grade lots of racial slurs heard the student are horrible and the help for people with ADD and ADHD is lowStudent Review1y ago 
Check out schools near 797 Western Road.
What Locals Say about Castleton-on-Hudson
At least 35 Trulia users voted on each feature.
96 % Say car is needed
95 % Say parking is easy
91 % Say yards are well-kept
90 % Say it's dog friendly
88 % Say there's wildlife
87 % Say kids play outside
85 % Say there's holiday spirit
82 % Say people would walk alone at night
71 % Say neighbors are friendly
67 % Say it's quiet
66 % Say they plan to stay for at least 5 years
55 % Say there are sidewalks
45 % Say there are community events
32 % Say streets are well-lit
31 % Say it's walkable to restaurants
Sourced by Trulia users. Learn more about our methodology.
LGBTQ Local Legal Protections
LGBTQ Local Legal Protections
Aubrey D Guri, Howard Hanna Capital Inc, (518) 584-0743
Agent Phone: (518) 583-1212
IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Information is deemed reliable but not guaranteed.
Judy Moriarty, Zillow, Inc., Corp. Broker
Judy Moriarty, Zillow, Inc., Corp. Broker
797 Western Road, Castleton, NY 12033 is a 6 bedroom, 3 bathroom, 3,647 sqft single-family home built in 1829. This property is currently available for sale and was listed by Global MLS on Mar 9, 2026. The MLS # for this home is MLS# 202612988.