797 Western Road, Castleton On Hudson, NY 12033

Castleton On Hudson
Local realty services provided by:HUNT Real Estate ERA
797 Western Road,Schodack, NY 12033
$1,239,000
Virtual Tour
  • 6 Beds
  • 3 Baths
  • 3,647 sq. ft.
  • Single family
  • Active
Listed by: aubrey d guri
Office: howard hanna capital inc
MLS#:202612988
Source:Global MLS

Price summary

  • Price:$1,239,000
  • Price per sq. ft.:$339.73

About this home

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

Contact an agent

contact an agent

Yes, I would like more information. Please use and/or share my information with an ERA®  affiliated agent to contact me about my real estate needs. By clicking Send message, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If an ERA®  affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE® , CENTURY 21® , Coldwell Banker® , Corcoran® , Sotheby's International Realty® ). I acknowledge that I have read and agree to theTerms of useandPrivacy notice

Home facts

  • Year built:1829
  • Listing ID #:202612988
  • Added:1 day(s) ago
  • Updated:March 09, 2026 at 06:45 PM

Rooms and interior

  • Bedrooms:6
  • Total bathrooms:3
  • Full bathrooms:3
  • Rooms Total:16
  • Flooring:Hardwood, Tile, Wood
  • Dining Description:Eat-in Kitchen, Kitchen Island
  • Bathrooms Description:Ceramic Tile Bath
  • Kitchen Description:Dishwasher, Ice Maker, Microwave, Oven, Range, Range Hood, Refrigerator, Wine Cooler
  • Basement Description:Interior Entry, Sump Pump, Unfinished
  • Living area:3,647 sq. ft.

Heating and cooling

  • Cooling:Window Unit(s)
  • Heating:Radiant, Steam, Wood Stove

Structure and exterior

  • Roof:Asphalt, Shingle
  • Year built:1829
  • Building area:3,647 sq. ft.
  • Lot area:64.57 Acres
  • Lot Features:Bluff, Cleared, Garden, Landscaped, Level, Meadow, Mountain(s), Private, Road Frontage, Secluded, Views, Wooded
  • Architectural Style:Colonial, Farm, Farmhouse
  • Construction Materials:Stone, Wood Siding
  • Exterior Features:Covered, Enclosed, Front Porch, Garden, Lighting, Patio, Porch, Screened, Side Porch, Storm Door(s)
  • Foundation Description:Combination, Stone

Schools

  • High school:Maple Hill HS

Utilities

  • Water:Cistern
  • Sewer:Septic Tank

Finances and disclosures

  • Price:$1,239,000
  • Price per sq. ft.:$339.73
  • Tax amount:$16,583

Features and amenities

  • Laundry features:Dryer, Laundry Room, Main Level, Washer
  • Amenities:Blinds, Built-in Features, Crown Molding, Curtain Rods, ENERGY STAR Qualified Windows, Eat-in Kitchen, High Speed Internet, Insulated Windows, Kitchen Island, Screens, Shutters, Solid Surface Counters, Storm Door(s), Storm Window(s), Wall Paneling, Wet Bar, Window Coverings, Window Treatments, Wood Frames
  • Pool features:In Ground
The information being provided by Global MLS is for the consumer’s personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The information is deemed reliable but not guaranteed and should therefore be independently verified.  © 2026 Global MLS All rights reserved.

New listings near 797 Western Road