Redfin is joining Rocket

Discover how we're simplifying your journey home.

$1,259,000

797 Western Rd Call Listing Agent, 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
HeatingOil, Radiant, Steam, Wood
StatusActive
CoolingWall/Window Unit(s)
Size3,647 sqft
BasementYes
Lot size64.57 Acres
Year built1829
MLS #879075
Garage2 spaces
WaterfrontStream
ViewMountain(s), Trees/Woods
Private poolYes

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

IDX 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 Notice

IDXThe 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.

All data from GreatSchools

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.

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?

  • HuntingHunting
  • NASCARNASCAR
  • Figure SkatingFigure Skating

Where do the neighbors shop?

  • Dick's Sporting GoodsDick's Sporting Goods
  • DillardsDillards
  • Wal-MartWal-Mart

Where do the neighbors go to eat?

  • Texas RoadhouseTexas Roadhouse
  • Cracker BarrelCracker Barrel
  • Hardee'sHardee's

What do the neighbors drive?

  • SubaruSubaru
  • CadillacCadillac
  • RamRam

What do the neighbors listen to?

  • New CountryNew Country
  • News/Talk/InformationNews/Talk/Information
  • Classic CountryClassic 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 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.

From Rocket Homes Real Estate and based on county public records data.

More resources