797 Western Road, Castleton, NY 12033
Property image
Property image
FOR SALE
3D VIEW
64.57 ACRES

797 Western Road
Castleton, NY 12033

  • 6 Beds
  • 3 Baths
  • 3,647 sqft (on 64.57 acres)

$1,239,000

Est. Mortgage $8,353/mo*
Get Pre-Qualified

$1,239,000

Est. Mortgage $8,353/mo*
Get Pre-Qualified
6 Beds
3 Baths
3,647 sqft
(on 64.57 acres)

Home Highlights

Parking
2 Car Garage
Outdoor
Porch, Patio, Pool
Climate Control
Radiant, Steam, Wood Stove & Window Unit S
Price/Sqft
$340
Listed
164 days ago

Local Information

  • Map ViewExplore the area around 797 Western Road.
  • Schools1 Elementary School1 Middle School1 High School
  • Shop & Eat
-- mins to
Commute Destination

About this House

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.
Last check for updates: about 3 hours ago
Listing by: Howard Hanna Capital Inc, (518) 584-0743
Aubrey D Guri, (518) 583-1212
Source: Global MLS, MLS#202612988
Also Listed on Global MLS.

Home Details for 797 Western Road

Active Status

MLS Status: Active

Interior Features

Interior Details
Basement: Interior Entry,Sump Pump,UnfinishedNumber of Rooms: 16Types of Rooms: Primary Bedroom, Bedroom, Full Bathroom, Dining Room, Family Room, Game Room, Kitchen, Laundry, Office, OtherWet Bar
Beds & Baths
Number of Bedrooms: 6Number of Bathrooms: 3Number of Bathrooms (full): 3
Dimensions and Layout
Living Area: 3647 Square Feet
Appliances & Utilities
Utilities: Cable ConnectedAppliances: Dishwasher, Dryer, ENERGY STAR Qualified Appliances, Microwave, Oven, Range, Range Hood, Refrigerator, Washer, Wine CoolerDishwasherDryerLaundry: Laundry Room,Main LevelMicrowaveRefrigeratorWasher
Heating & Cooling
Heating: Other,Radiant,Steam,Wood StoveHas CoolingAir Conditioning: Window Unit(s)Has HeatingHeating Fuel: Radiant
Fireplace & Spa
Fireplace: Wood Burning Stove, Bedroom, Family RoomHas a Fireplace
Gas & Electric
Electric: Circuit Breakers
Windows, Doors, Floors & Walls
Window: Screens, Shutters, Storm Window(s), Window Coverings, Window Treatments, Wood Frames, Blinds, Curtain Rods, ENERGY STAR Qualified Windows, Insulated WindowsDoor: ENERGY STAR Qualified Doors, French Doors, Storm Door(s)Flooring: Tile, Wood, Ceramic Tile, Hardwood
Levels, Entrance, & Accessibility
Floors: Tile, Wood, Ceramic Tile, Hardwood
View
Has a ViewView: Meadow, Mountain(s), Orchard, Pasture, Skyline, Trees/Woods, Valley, Hills
Security
Security: Smoke Detector(s), Carbon Monoxide Detector(s)

Exterior Features

Exterior Home Features
Roof: Shingle AsphaltPatio / Porch: Screened, Side Porch, Covered, Enclosed, Front Porch, Patio, PorchFencing: Electric, Fenced, GateOther Structures: Other, Barn(s)Exterior: Garden, LightingFoundation: Combination, StoneGarden
Parking & Garage
Number of Garage Spaces: 2Number of Covered Spaces: 2No CarportHas a GarageHas an Attached GarageHas Open ParkingParking Spaces: 10Parking: Off Street,Storage,Workshop in Garage,Attached,Circular Driveway,Driveway,Garage Door Opener,Heated Garage
Pool
Pool: In GroundPool
Frontage
Waterfront: StreamNot on Waterfront
Water & Sewer
Sewer: Septic Tank
Finished Area
Finished Area (above surface): 3647 Square Feet

Days on Market

Days on Market: 164

Property Information

Year Built
Year Built: 1829
Property Type / Style
Property Type: ResidentialProperty Subtype: Single Family Residence, ResidentialArchitecture: Colonial,Farm,Farmhouse
Building
Construction Materials: Stone, Wood SidingNot a New Construction
Property Information
Condition: Updated/RemodeledParcel Number: 384489 198.13.11

Price & Status

Price
List Price: $1,239,000Price Per Sqft: $340
Status Change & Dates
Possession Timing: Close Of Escrow

Media

Location

Direction & Address
City: Castleton On Hudson
School Information
High School: Maple Hill HSHigh School District: Schodack

Agent Information

Listing Agent
Listing ID: 202612988

Building

Building Area
Building Area: 3647 Square Feet

HOA

No HOA

Lot Information

Lot Area: 64.57 Acres

Listing Info

Special Conditions: Standard

Mobile R/V

Mobile Home Park
Mobile Home Units: Feet

Miscellaneous

BasementMls Number: 202612988Above Grade Unfinished Area: 3647Showing Requirements: No Sign, Occupied, 24 Hour Notice, Agent to Accompany

Around this home

What Locals Say about Castleton-on-Hudson

At least 35 Trulia users voted on each feature.

  • 96 % Say car is needed

  • 95 % Say parking is easy

  • 91 % Say yards are well-kept

  • 90 % Say it's dog friendly

  • 88 % Say there's wildlife

  • 87 % Say kids play outside

  • 85 % Say there's holiday spirit

  • 82 % Say people would walk alone at night

  • 71 % Say neighbors are friendly

  • 67 % Say it's quiet

  • 66 % Say they plan to stay for at least 5 years

  • 55 % Say there are sidewalks

  • 45 % Say there are community events

  • 32 % Say streets are well-lit

  • 31 % Say it's walkable to restaurants

Sourced by Trulia users. Learn more about our methodology.
  • Bradleystp
    "Great place to walk your dog. Always neighbors walking their dog around the block. There are also some dog parks in the area."
    0
    Flag
  • Rachel S.
    "I think it’s important for parents to know that the school district is a great school with supportive staff and parents. "
    0
    Flag
  • Tyarah D.
    "I’ve been familiar with the area for a little over a year now and i’m truly interested in thinking about staying awhile longer! "
    0
    Flag
  • Mike O.
    "Dogs welcome, they can woof all they want. Great people, great schools and great place to raise kids!"
    0
    Flag
  • Denise D.
    "Best community ever. I love living here. The village takes great care of the roads in the winter. Great schools. Friendly neighbors. Most people care about their properties. Up and coming Main Street"
    0
    Flag
  • Denise D.
    "Neighbors are friends! People bring their kids in from surrounding areas to trick or treat. Community is amazing and so are the schools."
    0
    Flag
  • April S.
    "You see dogs being walked all over. The only downfall is if your dog does not do well with kids, other walkers, or other dogs. Always someone passing you. "
    0
    Flag
  • Denise D.
    "There are a lot of dogs in the neighborhood. It’s a walkable neighborhood with great hills. Friendly neighbors help catch my dog when she escapes."
    0
    Flag
  • Geeweed39
    "Safe area for kids. Decent schools, I’m a and good library. Could have town swimming pool and more camps in the summer. "
    0
    Flag

Market trends in Castleton-on-Hudson

Last updated July 2026
Buyer'sMarketSeller'sMarket
Avg. sale price
—
Sale-to-List Price
—
Price per sq ft
—
Available listings
24
3MoM

Home Value

Trulia Estimate
$1.17M
Since last month
Increased$14K (+1.2%)
Since last year
Decreased$31K (-2.6%)
Since last sale
Increased$1M (+1,018%)
Learn more about this home's value by checking out its Trulia Estimate, the value of nearby homes, and how much similar homes have sold for.

Trulia Estimate

The of this home's value increased by +208% in the last 10 years
MonthEstimated value
2026
August 2026$1.17M
July 2026$1.16M
June 2026$1.16M
May 2026$1.16M
April 2026$1.17M
March 2026$1.19M
February 2026$1.16M
January 2026$1.17M
2025
2024
2023
2022
2021
2020
2019
2018
2017
2016

Comparable sales

These are recently sold homes that have a similar location or other similar features to this home, like bedrooms, bathrooms, and square footage. Get a sense of the expected prices in the area by viewing these homes.
Address
Distance
Property Type
Sold Price
Sold Date
Bed
Bath
Sqft
944 Stony Point Road, Castleton, NY
0.74
Single-Family Home
$556,000
07/31/26
4
4
2,907
847 Maple Hill Road, Castleton, NY
0.82
Single-Family Home
$410,000
07/07/26
3
3
2,700
55 Seaman Avenue, Castleton, NY
0.70
Single-Family Home
$255,000
04/02/26
4
1.5
1,482
69 S Main Street, Castleton, NY
1.27
Single-Family Home
$98,000
06/26/26
5
2
2,416
1826 Brookview Road, Castleton, NY
0.71
Single-Family Home
$215,000
09/24/25
3
2
1,152
56 Scott Avenue, Castleton, NY
0.90
Single-Family Home
$266,250
10/21/25
4
2
1,770
110 Green Avenue, Castleton, NY
0.98
Single-Family Home
$650,000
03/17/26
5
5
3,968
9 Boltwood Avenue, Castleton, NY
0.68
Single-Family Home
$264,000
12/12/25
4
1
1,460
30 Boltwood Avenue, Castleton, NY
0.53
Single-Family Home
$225,000
06/29/26
2
1
1,256

Nearby home prices

Get a sense of expected prices in the area by checking the value of nearby homes.
Address
Distance
Price
Bed
Bath
Sqft
Status
870 Western Road, Castleton, NY 12033
0.20
$498,900
3
1
2,200
Off Market
30 Boltwood Avenue, Castleton, NY 12033
0.53
$225,000
2
1
1,256
Recently Sold
10 Mann Drive, Castleton, NY 12033
0.57
$305,000
3
1
1,344
Recently Sold
0 Campbell Avenue, Castleton On Hudson, NY 12033
0.59
-
-
-
-
Off Market
885 Stony Point Road, Castleton, NY 12033
0.64
$205,200
2
1
801
Off Market
5 Brashear Place, Castleton, NY 12033
0.63
$509,200
3
2
1,780
Off Market
16 BRASHEAR Place, Castleton, NY 12033
0.64
$403,100
3
2.5
1,800
Off Market
91 Seaman Avenue, Castleton, NY 12033
0.65
$227,100
2
1
1,396
Off Market
9 Boltwood Avenue, Castleton, NY 12033
0.68
$264,000
4
1
1,460
Recently Sold
4 Boltwood Ave Avenue, Castleton, NY 12033
0.68
$397,000
4
4
1,984
Off Market
55 Seaman Avenue, Castleton, NY 12033
0.70
$255,000
4
1.5
1,482
Recently Sold

Price and Tax history

DateEventPrice
Mar 9, 2026
Source: Global MLS #202612988
PriceChange
$1,239,000
Price decreased by 2%
Jun 16, 2025
Source: Global MLS #202519616
PriceChange
$1,259,000
Price decreased by 1%
Jan 13, 2025
Source: Global MLS #202510557
Listed For Sale
$1,270,000
Sep 25, 2024
Source: Global MLS #202416481
ListingRemoved
$1,270,000
Sep 11, 2024
Source: Global MLS #202416481
PriceChange
$1,270,000
Price decreased by 2%

LGBTQ Local Legal Protections

Aubrey D Guri, Howard Hanna Capital Inc, (518) 584-0743
Agent Phone: (518) 583-1212
IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed.
Judy Moriarty, Zillow, Inc., Corp. Broker

Similar Homes You May Like

Skip to last item
Skip to first item

New Listings near 797 Western Road

Skip to last item
Skip to first item

Frequently asked questions about 797 Western Road

  • What is the estimated monthly payment for 797 Western Road?
    Based on a $1,239,000 list price with 20% down at today's rates, the estimated monthly payment for 797 Western Road in Castleton, NY is approximately $8,418 (about $6,330 principal & interest, $2,013 property taxes, and $75 homeowner's insurance). This is an estimate. Actual payment depends on your loan terms.
  • What do residents say about Castleton?
    Residents describe Castleton, NY as easy to park in, well-kept, and dog-friendly. Most residents say you need a car. See homes for sale in Castleton, NY.
  • What are the closest schools to 797 Western Road?
    The closest schools to 797 Western Road in Castleton, NY are Castleton Elementary School (rated 7/10), Maple Hill High School (Middle, rated 6/10).
  • What is 797 Western Road estimated to be worth?
    Trulia's estimated value for 797 Western Road in Castleton, NY is $1,173,900.
  • Does 797 Western Road have air conditioning?
    Yes, 797 Western Road in Castleton, NY has air conditioning.
  • Does 797 Western Road have a pool?
    Yes, 797 Western Road in Castleton, NY has a pool.
797 Western Road, Castleton, NY 12033 is a 6 bedroom, 3 bathroom, 3,647 sqft single-family home built in 1829. This property is currently available for sale and was listed by Global MLS on Mar 9, 2026. The MLS # for this home is MLS# 202612988.