#202519616, Joseph Briggs, Listing office: William Pitt Sotheby's
797 Western Rd Call Listing Agent, NY 12033
Property details
About 797 Western Rd
Enderley Farm, historic Patroon-era farmhouse authentically restored, featured on HGTV. Over 64 serene acres, sweeping Hudson Valley views. Ideal for horses, goats, sheep, alpacas, canines, or small-scale agriculture—think CSA, vineyard, berries, or Christmas trees—also weddings or B&B. 6 BR home includes private suite with porch, wood stove, 3 full baths, dual staircases. Wonderful walking and riding trails throughout. Convenient to Chatham, Kinderhook, Hudson, easy access to Saratoga, Albany International, Amtrak to NYC. Enjoy nearby skiing, hiking, local markets, wineries, Whole Foods, arts, dining. A rare blend of country charm and regional access.
Highlights
Virtual tour
Summary
- Full Bathrooms: 3
- Appliances: Dishwasher, Dryer, Electric Oven, ENERGY STAR Qualified Appliances, Microwave, Range, Refrigerator, Washer
- Basement: Yes
- Flooring Type: Ceramic Tile, Hardwood, Tile, Wood
- Interior: Built-in Features, Crown Molding, High Ceilings, High Speed Internet, Stone Counters, Wet Bar
- Total Bedroom Count: 6
- Garage Space: 2 spaces
- Private Pool: Yes
- Waterfront: Stream
- View: Mountain(s), Trees/Woods
- Exterior: Fence
- Architectural Style: Colonial, Farmhouse, Traditional
- Heating: Oil, Radiant, Steam, Wood
- Cooling: Wall/Window Unit(s)
- List Price: $1,259,000
- Price/SqFt: $345
- Lot: Cleared, Wooded, Secluded, Views
- Directions: From NY State Thruway Interstate 90 / Berkshire Connector, take Exit B1 Route 9 Albany / Hudson, Right on Rt 9 North, Left on Rt 6 Maple Hill Rd, Right on Simons Rd, Left on Brookview Station Rd, quick Right on Brookview Rd, quick Left on Western Rd, house #797 is on right just past Red Barn on Left.
- Year Built: 1829
- Living Area: 3,647 SqFt
- Lot Size: 64.57 Acres
- MLS Number: 879075
- MLS Name: ONEKEY2
- Office Name: William Pitt Sothebys Int Rlty
- Office Phone: (518) 392-0244
Listings courtesy of OneKey MLS as distributed by MLS GRID.
All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Properties displayed may be listed or sold by various participants in the MLS.
DMCA NoticeThe data relating to real estate for sale on this web site comes in part from the Broker Reciprocity Program of the OneKey™ MLS. Real Estate listings held by brokerage firms other than this broker are marked with the Broker Reciprocity logo and detailed information about them includes the name of the listing brokers. This information is provided exclusively for consumers’ personal, non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
The source of the displayed data is either the property owner or public record provided by non-governmental third parties. It is believed to be reliable but not guaranteed.
Information Copyright 2025, OneKey™ MLS. All Rights Reserved.
Data displayed may be a portion of, and not a complete set of all listings published in the MLS.
This advertisement does not suggest that the broker has a listing in this property or properties or that any property is currently available.
Last updated on: 7/10/2025, 11:41:27 PM Eastern. If you have any questions regarding the accuracy of this data, please contact us at help@rockethomes.com.
Price information
Property sales
We're sorry, we currently don't have property sales data for this listing.
Tax history
We're sorry, we currently don't have tax history data for this listing.
Nearby schools
6
Castleton Elementary School
Public District KG-6
0.8 mi
•80 Scott Ave
7
Green Meadow School
Public District KG-5
3.2 mi
•234 Schuurman Rd
4
Albertus W Becker School
Public District PK-5
3.5 mi
•1146 Route # 9W
School ratings are a score out of 10, where 10 is the highest and 1 is the lowest.
Neighborhood
The neighbors living near this home have an average income of $105,780. Residents of Call Listing Agent, NY typically earn between $100k-200k each year. Typical family type is single, no kids. The majority of residents in this area have post secondary degree education.
Similar homes for sale
Frequently asked questions
About 797 Western Rd
The listing price of 797 Western Rd property is $1,259,000.
The property 797 Western Rd is a house located in Call Listing Agent, New York, 12033.
Active Listing: 797 Western Rd is For Sale (Active/New) which means the seller is accepting offers.
The nearby schools for 797 Western Rd are: Castleton Elementary School (GreatSchools Rating 6/10), Green Meadow School (GreatSchools Rating 7/10), Albertus W Becker School (GreatSchools Rating 4/10), Howard L Goff School (GreatSchools Rating 8/10), Ravena-Coeymans-Selkirk Middle School (GreatSchools Rating 3/10), Albany Community Charter School (GreatSchools Rating 2/10), Maple Hill Junior/Senior High School (GreatSchools Rating 6/10), Ravena-Coeymans-Selkirk Senior High School (GreatSchools Rating 4/10), Columbia High School (GreatSchools Rating 8/10).
The property at 797 Western Rd has 6 bedrooms and 3 bathrooms.
The property 797 Western Rd is 3,647 SqFt (source: MLS/tax record).
The year of construction for 797 Western Rd is 1829.
This home is located at 797 Western Rd in Call Listing Agent, NY and zip code 12033. This 3,647 square foot home, which was built in 1829, sits on a 64.57 acre lot. Features: 6 bedrooms, 3 bathrooms. It has been listed on Rocket Homes since June 18, 2025 and is currently priced at $1,259,000.
In June 2025 more than 9 listings in Call Listing Agent, NY were sold above the asking price. During the same period more than 2 listings were sold at asking price, while more than 2 were sold below. Between May and June 2025, Call Listing Agent, NY real estate market has seen decrease in the number of listings by 3.3%. While the average time on the market in June 2025 was 29 days, the median list price was $347,000.