Mountain Homes Realty
Enter City, Zip or MLS

797 western road

Schodack, NY 12033

$1,239,000

6 BEDS 3 BATHS
3,647 SQFT64.56 AC LOT
Residential - Single Family
Image 1: Summer
Image 2: IMG_7261_Flowers in Bloom
Image 3: Exterior_Winter Scene
Image 4: Front
Bedrooms 6
Total Baths 3
Full Baths 3
Square Feet 3647
Acreage 64.57
Status Active
MLS # 202612988
County Rensselaer
More Info
Category Residential - Single Family
Status Active
Square Feet 3647
Acreage 64.57
MLS # 202612988
County Rensselaer
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.
Location not available

Exterior Features

  • Style Colonial, Farm, Farmhouse
  • Siding Shingle, Asphalt
  • Exterior Barn, Garden, Lighting, Storm Door(s)
  • Roof Shingle, Asphalt
  • Garage Yes
  • Garage Description 2
  • Water Cistern
  • Sewer Septic Tank
  • Lot Description Secluded, Level, Meadow, Mountain(s), Private, Road Frontage, Views, Wooded, Bluff, Cleared, Garden, Landscaped

Interior Features

  • Appliances Ice Maker, Dishwasher, Dryer, ENERGY STAR Qualified Appliances, Microwave, Oven, Range, Range Hood, Refrigerator, Washer, Wine Cooler
  • Heating Other, Radiant, Steam, Wood Stove
  • Cooling Window Unit(s)
  • Basement Interior Entry, Sump Pump, Unfinished
  • Living Area 3,647 SQFT
  • Year Built 1829

Financial Information

  • Parcel ID 384489 198.-1-3.11

Additional Services

Internet Service Providers

Listing Information

Listing Provided Courtesy of Howard Hanna Capital Inc
©2026 Global Multiple Listing Service, Inc. The data relating to real estate on this website comes in part from the Internet Data Exchange program of the GMLS. All information is deemed reliable but not guaranteed and should be independently verified. All properties subject to prior sale, change, or withdrawal. Neither listing broker(s), GMLS shall be responsible for any typographical errors, misinformation, or misprints, and shall be held totally harmless from any damages arising from reliance upon these data. Data last updated 04/21/2026.
Listing data is current as of 04/21/2026.

Contact Our Agent

By clicking “Submit”, you agree that Mountain Homes Realty, its affiliates, and real estate professionals may contact you by phone, text, or email to any phone number and email address you provided, including by automated means, even if your number is on a federal, state, or our internal Do Not Call list. You also agree to our Terms of Use and Privacy Policy.