#879075, Listing office: William Pitt Sothebys Int Rlty
$1,259,000 List price
797 Western Rd Schodack, NY 12033
6 beds
3 full
3,647 sqft
64.6 acres
$345 / sqft
House
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
Home typeSingle Family Residence
HeatingOther, Oil, Radiant, Steam, Wood Stove
StatusActive
CoolingWindow Unit(s)
Size3,647 sqft
BasementYes
Lot size64.57 Acres
Year built1829
ParkingOff Street, Storage, Workshop in Garage, Attached, Driveway, Garage Door Opener
MLS #202519616
Attached garage2 spaces
WaterfrontStream
FireplaceWood Burning Stove, Bedroom, Living Room
ViewMeadow, Mountain(s), Orchard, Pasture, Trees/Woods, Valley, Forest, Hills
Private poolYes
Summary
- Full Bathrooms: 3
- Appliances: Ice Maker, Dishwasher, Dryer, Electric Oven, ENERGY STAR Qualified Appliances, Microwave, Range, Range Hood, Refrigerator, Washer, Wine Cooler
- Basement: Yes
- Flooring Type: Tile, Wood, Ceramic Tile, Hardwood
- Interior: High Speed Internet, Solid Surface Counters, Wall Paneling, Wet Bar, Built-in Features, Ceramic Tile Bath, Crown Molding, Kitchen Island
- Fireplace: Wood Burning Stove, Bedroom, Living Room
- Total Bedroom Count: 6
- Garage Space: 2 spaces
- Attached Garage: Yes
- Private Pool: Yes
- Parking: Off Street, Storage, Workshop in Garage, Attached, Driveway, Garage Door Opener
- Waterfront: Stream
- View: Meadow, Mountain(s), Orchard, Pasture, Trees/Woods, Valley, Forest, Hills
- Exterior: Fence, Gate, Screened Porch, Porch Side, Porch/Covered, Enclosed Porch, Porch Front, Patio, Porch, Barn, Storm Doors
- Architectural Style: Colonial, Farm, Farmhouse, Traditional
- Heating: Other, Oil, Radiant, Steam, Wood Stove
- Cooling: Window Unit(s)
- List Price: $1,259,000
- Price/SqFt: $345
- Lot: Rolling/Hilly, Secluded, Level, Meadow, Private, Views, Wooded, Bluff, Cleared, Landscaped
- 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 Simon's 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: 202519616
- MLS Name: Global MLS
- Office Name: William Pitt Sotheby's
- Office Phone: (518) 392-0244
- Office Email: pbreunich@williampitt.com
- Listing Agent: Joseph Briggs
The data relating to real estate on this website comes in part from the Internet Data Exchange program of the Global MLS (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. IDX information is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties they may be interested in purchasing.
Copyright © 2025 Global Multiple Listing Service, Inc. 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/30/2025, 9:40:33 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. Most Schodack, NY residents have annual incomes between $100k-200k. Residents typically live in single, no kids family. Residents of this area typically have post secondary degree education.
How much money do the neighbors make?
17%
<35k
30%
35k-100k
48%
100k-200k
5%
200k+
What level of education do the neighbors have?
High School Diploma
Post Secondary Degree
Masters Degree
Doctorate
What types of families live nearby?
38%
Single, No Kids
8%
Single, with Kids
31%
Married, No Kids
23%
Married, with Kids
Are the neighbors home owners or renters?
Home Owners
Renters
How old are people in this area?
14%
<11 yrs old
9%
12-17 yrs old
16%
18-34 yrs old
48%
35-64 yrs old
13%
65+ yrs old
What do the neighbors do for fun?
Hunting
NASCAR
Figure Skating
Where do the neighbors shop?
Dick's Sporting Goods
Dillards
Wal-Mart
Where do the neighbors go to eat?
Texas Roadhouse
Cracker Barrel
Hardee's
What do the neighbors drive?
Subaru
Cadillac
Ram
What do the neighbors listen to?
New Country
News/Talk/Information
Classic Country
All data provided by Home Junction and Claritas
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 Schodack, 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 Schodack, 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 16, 2025 and is currently priced at $1,259,000.
In June 2025 more than 9 listings in Schodack, 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. In June 2025 in Schodack, NY there were 3.3% less homes for sale than in May. While the average time on the market in June 2025 was 29 days, the median list price was $347,000.
From Rocket Homes Real Estate and based on county public records data.