Skip to Main Content

For Sale
3D Tour3D Tour
Single family home for sale at 797 Western Rd, Castleton On Hudson, NY 12033 | MLS# 202612988 | Listing updated on 2026-10-28
Photo 1 of Single family home for sale at 797 Western Rd, Castleton On Hudson, NY 12033 | MLS# 202612988 | Listing updated on 2026-10-28
Photo 2 of Single family home for sale at 797 Western Rd, Castleton On Hudson, NY 12033 | MLS# 202612988 | Listing updated on 2026-10-28
Photo 3 of Single family home for sale at 797 Western Rd, Castleton On Hudson, NY 12033 | MLS# 202612988 | Listing updated on 2026-10-28
Photo 4 of Single family home for sale at 797 Western Rd, Castleton On Hudson, NY 12033 | MLS# 202612988 | Listing updated on 2026-10-28
63+
Beds Icon

Virtual Tour

Beds Icon

Street View

$1,195,000

Monthly Est:$5,948

  • Beds Icon6 Beds
  • Beds Icon
    3 Baths
  • Beds Icon3,647sqft

797 Western Rd, Castleton On Hudson, NY 12033

$5,948/moEst:

Get Pre-Approved

  • Single Family Residence

  • Built in 1829

  • $-- HOA

  • 64.57 acres lot

  • $328/sq.ft

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.

  • Houzeo last checked: 14 minutes ago
  • Listing updated: October 28, 2026 at 9:07 pm
  • Listing Provided by: Aubrey D Guri (518) 583-1212 DRE #10301218169 | Howard Hanna Capital Inc (518) 584-0743
  • Source: Greater Capital Association of Realtors (Global) MLS-NY | MLS#: 202612988 Greater Capital Association of Realtors (Global) MLS-NY

Property Details

  • Status

    Active

  • Type

    Single Family Residence

  • No. of Stories

    -

  • County

    Rensselaer County

  • City

    Castleton On Hudson

  • Neighborhood

    --

  • Year Built

    1829

  • HOA Fees

    -

  • Finished Area

    3,647 sqft

  • Lot Size

    64.57 acres lot

  • Basement Area

    - sqft

  • MLS Name

    Greater Capital Association of Realtors (Global) MLS

  • MLS Number

    202612988

  • MLS Status

    Active

  • Days on Market

    253

Continue Your Journey in App

Find your dream home, receive real-time updates, and many more!

Location

Facts & Features

Rooms

  • Bedrooms & bathrooms

    Bedrooms: 6

    Bathrooms: 3

Interior

  • Heating

    Other, Radiant, Steam, Wood Stove

  • Sewer

    Septic Tank

  • Exterior Features

    Barn, Garden, Lighting, Storm Door(s)

  • Window Features

    Screens, Shutters, Storm Window(s), Window Coverings, Window Treatments, Wood Frames, Blinds, Curtain Rods, Energy Star Qualified Windows, Insulated Windows

  • Appliances

    Ice Maker, Dishwasher, Dryer, Energy Star Qualified Appliances, Microwave, Oven, Range, Range Hood, Refrigerator, Washer, Wine Cooler

  • Interior Features

    High Speed Internet, Solid Surface Counters, Wall Paneling, Wet Bar, Built In Features, Ceramic Tile Bath, Crown Molding, Eat In Kitchen, Kitchen Island

  • Cooling

    Window Unit(s)

  • Flooring

    Tile, Wood, Ceramic Tile, Hardwood

Construction

  • Year Built

    Year Built: 1829

  • Home type

    Single Family Residence

  • Architectural Style

    Colonial, Farm, Farmhouse

  • Construction Materials

    Stone, Wood Siding

  • Roof

    Shingle, Asphalt

  • Foundation Details

    Combination, Stone

  • Property Condition

    Updated/remodeled

Utilities & Energy

  • Fireplace Features

    Wood Burning Stove, Bedroom, Family Room

  • Electric

    200+ Amp Service, Circuit Breakers

  • Laundry Features

    Laundry Room, Main Level

  • Parking Features

    Off Street, Storage, Workshop In Garage, Attached, Circular Driveway, Driveway, Garage Door Opener, Heated Garage

  • Water Source

    Cistern

  • Pool Features

    In Ground

  • Basement

    Interior Entry, Sump Pump, Unfinished

  • Security Features

    Smoke Detector(s), Carbon Monoxide Detector(s)

  • Utilities

    Cable Connected

Other Features

  • Lot Features

    Secluded, Level, Meadow, Mountain(s), Private, Road Frontage, Views, Wooded, Bluff, Cleared, Garden, Landscaped

  • Patio And Porch Features

    Screened, Side Porch, Covered, Enclosed, Front Porch, Patio, Porch

Price History

DateEventPrice

10/02/2026

Source: mls_logoGreater Capital Association of Realtors (Global) MLS-NY #202612988

Price Decreased

$1,195,000 -3.55%

$0/sqft

03/09/2026

Source: mls_logoGreater Capital Association of Realtors (Global) MLS-NY #202612988

Price Decreased

$1,239,000 -1.59%

$0/sqft

01/06/2026

Source: mls_logoGreater Capital Association of Realtors (Global) MLS-NY #202519616

Listed for Sale

$1,259,000

$0/sqft

06/16/2025

Source: mls_logoGreater Capital Association of Realtors (Global) MLS-NY #202519616

Off Market

$1,259,000 -0.87%

$0/sqft

05/16/2025

Source: mls_logoGreater Capital Association of Realtors (Global) MLS-NY #202510557

Listing Removed

$1,270,000

$0/sqft

Show more

Nearby Homes

Based on information from the Global Multiple Listing Service, Inc. through Nov 18, 2026, 03:45AM. Information is provided exclusively for consumers’ personal, non-commercial use. It may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data is deemed reliable but is not guaranteed accurate by the MLS. This website may not include listings or property addresses of sellers who have directed their listing brokers to withhold their listing or their property address from display on the Internet. © 2026 Global Multiple Listing Service, Inc. All Rights Reserved.

Advertising Broker: Derek Greene | The Greene Realty Group