797 Western Road Castleton, NY $ 1,239,000
797 Western Road
$ 1,239,000
Recently Listed
Share Save

797 Western Road

Castleton, NY, 12033
$ 1,239,000
Bedrooms6 Baths3.0 Sq 3,647

Monthly Estimate*

$ 7,629

797 Western Road, Castleton, NY 12033 - Image 1
797 Western Road, Castleton, NY 12033 - Image 2
797 Western Road, Castleton, NY 12033 - Image 3
797 Western Road, Castleton, NY 12033 - Image 4
797 Western Road, Castleton, NY 12033 - Image 5
797 Western Road, Castleton, NY 12033 - Image 6
797 Western Road, Castleton, NY 12033 - Image 7
797 Western Road, Castleton, NY 12033 - Image 8
797 Western Road, Castleton, NY 12033 - Image 9
797 Western Road, Castleton, NY 12033 - Image 10
797 Western Road, Castleton, NY 12033 - Image 11
797 Western Road, Castleton, NY 12033 - Image 12
797 Western Road, Castleton, NY 12033 - Image 13
797 Western Road, Castleton, NY 12033 - Image 14
797 Western Road, Castleton, NY 12033 - Image 15
797 Western Road, Castleton, NY 12033 - Image 16
797 Western Road, Castleton, NY 12033 - Image 17
797 Western Road, Castleton, NY 12033 - Image 18
797 Western Road, Castleton, NY 12033 - Image 19
797 Western Road, Castleton, NY 12033 - Image 20
797 Western Road, Castleton, NY 12033 - Image 21
797 Western Road, Castleton, NY 12033 - Image 22
797 Western Road, Castleton, NY 12033 - Image 23
797 Western Road, Castleton, NY 12033 - Image 24
797 Western Road, Castleton, NY 12033 - Image 25
797 Western Road, Castleton, NY 12033 - Image 26
797 Western Road, Castleton, NY 12033 - Image 27
797 Western Road, Castleton, NY 12033 - Image 28
797 Western Road, Castleton, NY 12033 - Image 29
797 Western Road, Castleton, NY 12033 - Image 30
797 Western Road, Castleton, NY 12033 - Image 31
797 Western Road, Castleton, NY 12033 - Image 32
797 Western Road, Castleton, NY 12033 - Image 33
797 Western Road, Castleton, NY 12033 - Image 34
797 Western Road, Castleton, NY 12033 - Image 35
797 Western Road, Castleton, NY 12033 - Image 36
797 Western Road, Castleton, NY 12033 - Image 37
797 Western Road, Castleton, NY 12033 - Image 38
797 Western Road, Castleton, NY 12033 - Image 39
797 Western Road, Castleton, NY 12033 - Image 40
797 Western Road, Castleton, NY 12033 - Image 41
797 Western Road, Castleton, NY 12033 - Image 42
797 Western Road, Castleton, NY 12033 - Image 43
797 Western Road, Castleton, NY 12033 - Image 44
797 Western Road, Castleton, NY 12033 - Image 45
797 Western Road, Castleton, NY 12033 - Image 46
797 Western Road, Castleton, NY 12033 - Image 47
797 Western Road, Castleton, NY 12033 - Image 48
797 Western Road, Castleton, NY 12033 - Image 49
797 Western Road, Castleton, NY 12033 - Image 50
797 Western Road, Castleton, NY 12033 - Image 51
797 Western Road, Castleton, NY 12033 - Image 52
797 Western Road, Castleton, NY 12033 - Image 53
797 Western Road, Castleton, NY 12033 - Image 54
797 Western Road, Castleton, NY 12033 - Image 55
797 Western Road, Castleton, NY 12033 - Image 56
797 Western Road, Castleton, NY 12033 - Image 57
797 Western Road, Castleton, NY 12033 - Image 58
797 Western Road, Castleton, NY 12033 - Image 59
797 Western Road, Castleton, NY 12033 - Image 60
797 Western Road, Castleton, NY 12033 - Image 61
797 Western Road, Castleton, NY 12033 - Image 62
797 Western Road, Castleton, NY 12033 - Image 63
797 Western Road, Castleton, NY 12033 - Image 64
797 Western Road, Castleton, NY 12033 - Image 65
797 Western Road, Castleton, NY 12033 - Image 66
797 Western Road, Castleton, NY 12033 - Image 67
View a Virtual Tour

Single Family Home for sale in Castleton, NY

for $1,239,000 with 6 bedrooms and 3 full baths. This 3,647 square foot home was built in 1829 on a lot size of 64.57.

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.

See more

Single Family Active

Price

$ 1,239,000

Bedrooms

6

Full Bath

3

Property Type

Single Family

Taxes

$ 16,583

Style

Colonial,Farm,Farmhouse

Lot Size

64.57

Year Built

1829

Town/City

Castleton

County/Region

Rensselaer

MLS | Web ID

202612988

Features
Interior
Interior Amenities High Speed Internet Solid Surface Counters Wall Paneling Wet Bar Built-in Features Ceramic Tile Bath Crown Molding Eat-in Kitchen Kitchen Island
Basement Interior Entry Sump Pump Unfinished
Flooring Tile Wood Ceramic Tile Hardwood
Total Fireplaces 0
Fireplace Features Wood Burning Stove Bedroom Family Room
Basement (Y/N) N
Air Conditioning Y/N Y
Heating Y/N Y
Window Features Screens Shutters Storm Window(s) Window Coverings Window Treatments Wood Frames Blinds Curtain Rods ENERGY STAR Qualified Windows Insulated Windows
Fireplace Y/N N
Above Grade Finished Area 3647.0
Half Baths 0
Laundry Features Laundry Room Main Level
Total Bedrooms 6
Below Grade Finished Area 0.0
Below Grade Finished Area Source Plans
Above Grade Finished Area Source Plans
Total Baths 3
Kitchen Island True
See more
General
Sewer Septic Tank
Heating Other Radiant Steam Wood Stove
Cooling Window Unit(s)
Utilities Cable Connected
Possession At Closing
Roof Shingle Asphalt
Appliances Ice Maker Dishwasher Dryer ENERGY STAR Qualified Appliances Microwave Oven Range Range Hood Refrigerator Washer Wine Cooler
Garage Spaces 2.0
Patio/Porch Features Screened Side Porch Covered Enclosed Front Porch Patio Porch
Architectural Style Colonial Farm Farmhouse
Pool Features In Ground
Security Features Smoke Detector(s) Carbon Monoxide Detector(s)
Construction Materials Stone Wood Siding
Year Built 1829
Electric 200+ Amp Service Circuit Breakers
View Meadow Mountain(s) Orchard Pasture Skyline Trees/Woods Valley Hills
Property Subtype Single Family Residence
Waterfront Features Stream
County Rensselaer
New Construction N
Property Type Residential
HOA N
Attached Garage Y
Garage Y/N Y
Other Structures Other Barn(s)
Total Rooms 16
Full Baths 3
Status Active
Directions From NYS Thruway Interstate 90/Berkshire Connector) take Exit B1 toward US-9 (Albany/Hudson). Right on US-9 North. Left on Rt 6 (Maple Hill Rd). Right on Simon's Rd. Left on Brookview Station Rd.
High School Maple Hill HS
City Schodack
High School District Schodack
Lot Size Units Acres
Lot Size Square Feet 2812669.2
Carport Y/N N
Land Lease Y/N N
Tax Annual Amount 16583.0
Home Warranty Y/N N
Property Condition Updated/Remodeled
Lease Renewal Y/N N
Additional Parcels Y/N N
Lease Considered Y/N N
Rent Control Y/N N
Virtual Tour https://app.doaudiotours.com/unbranded?id=17573&lang=en-US https://app.doaudiotours.com/branded?id=17573&lang=en-US
Standard Status Active
Tax Assessed Value 0
Tax Lot 3.011
See more
Exterior
Exterior Amenities Barn Garden Lighting Storm Door(s)
Fencing Electric Fenced Gate
Parking Features Off Street Storage Workshop in Garage Attached Circular Driveway Driveway Garage Door Opener Heated Garage
Lot Features Secluded Level Meadow Mountain(s) Private Road Frontage Views Wooded Bluff Cleared Garden Landscaped
Water Source Cistern
Total Parking 10.0
Lot Size Area 64.57
Foundation Details Combination Stone
Spa N
Lot Size Acres 64.57
Waterfront Y/N N
Door Features ENERGY STAR Qualified Doors French Doors Storm Door(s)
Crops Included Y/N N
Horse Y/N N
Irrigation Water Rights Y/N N
See more
Internal Only
Street Number 1 797
See more
* Excluded Features
List By
Aubrey Guri

Listing Agent

Howard Hanna Capital Inc

Broker

(518) 583-1212

Phone

aubrey@geraldine.com

Email

Affordability Calculator

$9,011
Per Month
85%
15%
0%
Monthly Principal & Interest
$7,629
Monthly Property Taxes
$1,382
Monthly Home Insurance
--
Default based on a 30-year fixed rate of 6.25% with 20% down. The estimated payment is offered for convenience and is not an offer of credit. Due to market fluctuations, interest rates are subject to change at any time and without notice. Your individual rate may vary. Rates may differ for FHA, VA or jumbo loans.
Learn more about how to save

Discover how much house you can afford

Your dream home may be within reach.

Learn More about how to save

The time to sell is now
THE TIME TO SELL IS NOW! What's my home worth?
Nearby
853208 Elementary School
853394 Middle School
Maple Hill HS High School
Pricing History
DatePricePrice ChangeDescription
3/9/2026$1,239,000 Listed Price

Map


See all

797 Western Road, Castleton, NY, 12033 is a Single Family Home for sale at $1,239,000 with 3,647 sqft and a lot size of 64.57. 797 Western Road has 6 bedrooms, 3.0 baths, and was built in 1829. The property's zip code is 12033 which is in Castleton, NY