Janet "Jan" C. Alber
Licensed Associate Broker
REALTOR®
West Sand Lake, NY
Cell: (518) 366-5337 Office: (518) 674-3238 Fax: (518) 477-2156
social icon 

797 Western Road, Castleton on Hudson, NY 12033

New
V-Tour
Virtual Tour View Full Photo Gallery

Property 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.

797 Western Road | MLS# 202612988

This single family home located at 797 Western Road, Castleton on Hudson, NY 12033 is currently listed for sale with an asking price of $1,239,000. This property was built in 1829 and has 6 bedrooms and 3 full baths with 3647 sq. ft. Western Road is located within the Schodack school district. Search Castleton On Hudson real estate on jan-alber.coldwellbankerprime.com today.

Gallery

Property Features

Property Type: Residential - Single Family
Basement: Yes
Basement: Interior Entry, Sump Pump, Unfinished
Cooling: Window Unit(s)
Fenced: Yes
Garage: 2 car attached
Heating: Other, Radiant, Steam, Wood Stove
Home Style: Colonial, Farm, Farmhouse
Lot Size: 64.57 Acres
Roof Type: Shingle, Asphalt
Taxes: $16,583
Year Built: 1829

Feature Descriptions

Appliances: Ice Maker, Dishwasher, Dryer, ENERGY STAR Qualified Appliances, Microwave, Oven, Range, Range Hood, Refrigerator, Washer, Wine Cooler
Days on Site: 2
Doors: ENERGY STAR Qualified Doors, French Doors, Storm Door(s)
Exterior: Barn, Garden, Lighting, Storm Door(s)
Exterior: Stone, Wood Siding
Fencing: Electric, Fenced, Gate
Fireplace: Wood Burning Stove, Bedroom, Family Room
Flooring: Tile, Wood, Ceramic Tile, Hardwood
Foundation: Combination, Stone
Interior: High Speed Internet, Solid Surface Counters, Wall Paneling, Wet Bar, Built-in Features, Ceramic Tile Bath, Crown Molding, Eat-in Kitchen, Kitchen Island
Laundry: Laundry Room, Main Level
Lot: Secluded, Level, Meadow, Mountain(s), Private, Road Frontage, Views, Wooded, Bluff, Cleared, Garden, Landscaped
Parcel #: 384489 198.-1-3.11
Parking: Off Street, Storage, Workshop in Garage, Attached, Circular Driveway, Driveway, Garage Door Opener, Heated Garage
Parking Total: 10
Parking Total: 10
Patio/Porch: Screened, Side Porch, Covered, Enclosed, Front Porch, Patio, Porch
Pool: In Ground
Rooms Total: 16
Security: Smoke Detector(s), Carbon Monoxide Detector(s)
Sewer: Septic Tank
Special View Info: Meadow, Mountain(s), Orchard, Pasture, Skyline, Trees/W
SQFT Above Grade Finished: 3647
Structures: Other, Barn(s)
Swimming Pool: Yes
Utilities: Cable Connected
Water: Cistern
Waterfront: Stream
Windows: Screens, Shutters, Storm Window(s), Window Coverings, Window Treatments, Wood Frames, Blinds, Curtain Rods, ENERGY STAR Qualified Windows, Insulated Windows
Wooded: Yes

Room Sizes

Kitchen: Level - First
Other: Level - First
Family Room: Level - First
Dining Room: Level - First
Game Room: Level - First
Office: Level - First
Full Bathroom: Level - Second
Laundry: Level - First
Primary Bedroom: Level - Second
Bedroom: Level - Second

Local Schools

High School: Maple Hill HS
School District: Schodack

Estimate Your Payment

Estimated Payment

$ 4,500.77 per month $2,757.48 Principal & Interest $1,381.92 Property Tax $361.38 Homeowner's Insurance

Change Payment Information

%
years/fixed
yearly
yearly (est.)
(Payments are an estimate and may vary by lender)

Demographics

Listed By / Shown By

Listing By

Agency Name: Howard Hanna Capital Inc
Agency Phone: 1 518-584-0743

Shown By

Agent Name: Janet "Jan" C. Alber
Agent Phone: (518) 366-5337 Cell
Agency Title: Coldwell Banker Prime Properties

IDX logo

Disclaimer: All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers 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 on this site was last updated 03/12/2026. The listing information on this page last changed on 03/12/2026. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of Delta Media Group MLS (last updated Thu 03/12/2026 12:34:36 AM EST) or Global MLS (last updated Thu 03/12/2026 12:22:04 AM EST) or New York State Alliance MLS (last updated Thu 03/12/2026 12:30:33 AM EST) or Hudson Valley Catskill Region MLS (last updated Thu 03/12/2026 12:11:16 AM EST) or OneKey MLS (last updated Thu 03/12/2026 12:28:12 AM EST). Real estate listings held by brokerage firms other than Coldwell Banker Prime Properties may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. All rights reserved.

C.B. Prime Properties, Inc. fully supports the principles of the Fair Housing Act and the Equal Opportunity Act. Each franchise is independently owned and operated.

Homestead Funding Corp. Company NMLS# 3232. Equal Housing Lender. State Licensing Information

Coldwell BankerĀ®. All rights reserved. The Coldwell Banker System is comprised of company owned offices which are owned by a subsidiary of Anywhere Advisors LLC and franchised offices. Coldwell Banker Real Estate LLC, fully supports the principles of the Fair Housing Act and the Equal Opportunity Act. Any services or products provided by independently owned and operated franchisees are not provided by, affiliated with, or related to Coldwell Banker Real Estate LLC nor any of its affiliated companies.


Privacy Policy / DMCA Notice / ADA Accessibility

Login to My Homefinder

Pixel