797 Western Road, Castleton, NY 12033

$1,270,000 Asking Price

6 beds
3 baths
3,393  sqft
Built in 1829

Improved price for this impeccably maintained Gentle Person Hobby farm overlooking the Hudson Valley and conveniently located to downtown Albany and the Rensselaer train station. This serene setting is ideal for horses, llamas, goats, canines or any other animals for the hobbyist. Possible commercial uses include a Christmas Tree farm, B&B, Country Weddings or growing cash crops such as grapes or berries for a person looking for a manageable sized site.Historically known as ''Enderley Farm,'' this Patroon era Farmhouse has been authentically restored & featured on HGTV. This hill top property has over 64 acres, with spectacular Hudson Valley and seasonal Hudson River views. The location is a perfect blend of convenience and serenity located on a quiet country lane and just ten minutes from downtown Albany and 25 minutes to Chatham and Hudson. The farmhouse features a bedroom suite with porch and woodstove and 5 additional bedrooms, 3 full baths, 2 dining rooms, & 2 stairways to the 2nd floor. The barn has an office & 3 horse stalls leading to 7 acres of fenced pasture. There are several other fields & riding trails, as well as an inground garden pool. This property is a true ''gentlepersons farm'' and perfect venue for equine endeavors, gatherings or just to immerse yourself in a peaceful, slower paced world.


Features & Amenities

Interior

Appliances:
Clothes Dryer,Clothes Washer,Dishwasher,Microwave,Refrigerator,Stove,Water Treatment,Other
Basement:
Full,Unfinished
Flooring:
Hardwood,Wideboard
A/C:
None
Heating:
Steam
Fireplace:
Bedroom,Family Room, Fireplaces: 0

Exterior

General:
Clapboard
Style:
Farm House

Construction

Roofing:
Asphalt,Shingle,Other
Windows:
Double Hung,Low Energy,Storm
General:
Frame, Farm House, Poured Concrete,Stone

Location

Originating MLS:
Columbia Greene Northern Dutchess MLS
School District:
Schodack
County:
Rensselaer

Lot

Zoning:
Ag/Farm, 198.-1-3.11
View:
Farmland,Hilltop,Panoramic,Parklike,River,Seasonal,Valley View
Restrictions:
None

Utilities

Utilities:
200 Amps,Other
Water:
Private,Well
Sewer:
Septic Tank

Financial

Source:
Columbia Greene Northern Dutchess MLS

This listing courtesy of:
Howard Hanna Capital, Inc., Edward Brewer

About Castleton on Hudson, NY

Housing

Number of Units
3,177
Median Home Value
$225,511
Median Rent
$1,063

24.06% of housing units are renter occupied.

6.18% are vacant.

Commute

Car
71.94%
Public Transportation
1.44%
Walk to Work
0.14%
Work from Home
26.09%
Other
0.39%

The median travel time to work is 19 minutes.

People

Population
7,286
Median Age
44.20
Median Household Size
2.51

Education

High School
22.85%
Associate’s Degree
14.51%
Bachelor’s Degree
23.33%
Graduate Degree
14.24%

Disclaimer: Community and Demographic information uses data from the U.S. Census Bureau but is not endorsed or certified by the Census Bureau.

Message

Interested in this home?

Request more information: