Coldwell Banker Home Page
Local Realty Service Provided By: Coldwell Banker Prime Properties
Property view
Listing view 2
Listing view 3

797 Western Road, 
Schodack, NY 12033

$1,239,000


6

Beds


3

Baths


3,647

Sq Ft


Single Family


Virtual Tour

Active

Listed by

Aubrey D Guri

Howard Hanna Capital Inc

1 518-584-0743

Last updated:

May 15, 2026, 02:31 PM

MLS#

202612988

Source:

Global MLS

About This Home

797 Western Road

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.

Home Facts

Single Family

3 Baths

6 Bedrooms

Built in 1829

Price Summary

1,239,000

$339 per Sq. Ft.

MLS #:

202612988

Last Updated:

May 15, 2026, 02:31 PM

Added:

2 month(s) ago


Rooms & Interior

Bedrooms

Total Bedrooms:

6

Bathrooms

Total Bathrooms:

3

Full Bathrooms:

3

Interior

Living Area:

3,647 Sq. Ft.


Structure

Structure

Architectural Style:

Colonial, Farm, Farmhouse

Building Area:

3,647 Sq. Ft.

Year Built:

1829


Lot

Lot Size (Sq. Ft):

2,812,669


Finances & Disclosures

Finances

Price:

$1,239,000

Price per Sq. Ft:

$339 per Sq. Ft.

Source:Global MLS
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.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, 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 a Coldwell Banker 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®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, 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 a Coldwell Banker 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®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.