Skip To Content

797 Western Road

Castleton On Hudson, NY 12033
  • $1,270,000
  • STATUS: Active
  • MLS #: 202510557
$1,270,000
  • 7
    BEDS
  • 64.57
    ACRES
  • 3
    BATHS
  • 0
    1/2 BATHS
  • 3,393
    SQFT
  • $374
    $/SQFT
Type:
Farm
Built:
1829
County:
Area:

School Information

High School:
School District:

Description

Historically known as ''Enderley Farm'' this Patroon era Farmhouse has been authentically restored and featured on HGTV. This hilltop property has over 64 acres with spectacular Hudson Valley views. The location is a blend of convenience and serenity just 10 minutes from downtown Albany. The farmhouse has a bedroom suite with porch and woodstove and 5 additional bedrooms, 3 full baths, 2 dining rooms, and 2 stairways to the 2nd floor. The barn has an office and 3 horse stalls leading to 7 acres of fenced pasture. There are several fields & riding trails as well as an inground garden pool. This property is a true ''gentlepersons farm'' and perfect venue for equine endeavors or to immerse yourself in a slower paced world. Adjoining 777 Western Rd. is also available for an interested party.

Monthly Payment Calculator



© 2025 Global Multiple Listing Service, Inc. The data relating to real estate on this website comes in part from the Internet Data Exchange program of the 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. Data last updated 2025-02-07T00:12:00.317.
www.alysharizzicone.com/homes/159390043
Print Image

797 Western Road Castleton On Hudson, NY 12033

  • Price: $1,270,000
  • Status: Active
  • On Site: Days
  • MLS #: 202510557
7
Beds
3
Baths
0
½ Baths
64.57
Acres
3,393
SQFT
$374
$/SQFT
1829
Built
County:
Rensselaer
Area:
Rensselaer
High School:
Maple Hill Hs
School District:
Schodack
Property Description
Historically known as ''Enderley Farm'' this Patroon era Farmhouse has been authentically restored and featured on HGTV. This hilltop property has over 64 acres with spectacular Hudson Valley views. The location is a blend of convenience and serenity just 10 minutes from downtown Albany. The farmhouse has a bedroom suite with porch and woodstove and 5 additional bedrooms, 3 full baths, 2 dining rooms, and 2 stairways to the 2nd floor. The barn has an office and 3 horse stalls leading to 7 acres of fenced pasture. There are several fields & riding trails as well as an inground garden pool. This property is a true ''gentlepersons farm'' and perfect venue for equine endeavors or to immerse yourself in a slower paced world. Adjoining 777 Western Rd. is also available for an interested party.
Exterior Features

Architectural Style FarmFarmhouse Attached Garage YN Yes Construction Materials OtherClapboard Door Features French Doors Exterior Features BarnLighting Fencing WireOther Foundation Details SlabStone Garage YN Yes Lot Features SecludedMeadowPrivateRoad FrontageViewsBluffClearedIrregular LotLandscaped Other Structures Guest HouseSecond ResidenceShed(s)WorkshopBarn(s)CabanaGarage(s) Parking Features Off StreetWorkshop in GarageAttachedCircular DrivewayDrivewayGarage Door OpenerHeated Garage Parking Total 25 Patio And Porch Features ScreenedSide PorchPatioPorch Pool Features In GroundOutdoor Pool Roof ShingleAsphaltCopper Spa YN Yes View MeadowMountain(s)PastureRiverValleyHills Waterfront Features [] Waterfront YN No Window Features ShuttersStorm Window(s)Curtain RodsDouble Pane Windows

Interior Features

Appliances DehumidifierDishwasherElectric Water HeaterIcemakerMicrowaveRangeRefrigeratorWasher/DryerWater PurifierWater SoftenerWine Cooler Basement Exterior EntryFullPillar/Post/PierSump Pump Cooling Window Unit(s) Cooling YN Yes Fireplace Features Wood Burning Stove Fireplace YN No Fireplaces Total 0 Flooring Ceramic TileHardwood Formal Dining Room Yes Heating OilSteamZoned Heating YN Yes Interior Features High Speed InternetWalk-In Closet(s)OtherCeramic Tile BathCrown MoldingKitchen IslandBuilt-in Features Laundry Features Laundry ClosetMain Level Rooms Dining Room (First Level) Kitchen (First Level) Living Room (First Level) Dining Room (First Level) Family Room (First Level) Full Bathroom (First Level) Game Room (First Level) Other (First Level) Primary Bedroom (Second Level) Full Bathroom (Second Level) Primary Bedroom (Second Level) Bedroom (Second Level) Bedroom (Second Level) Bedroom (Second Level) Bedroom (Second Level) Bedroom (Second Level) Full Bathroom (Second Level)

Property Features

Accessibility Features [] Association Amenities [] Association Fee Includes [] Association YN No Current Use [] Electric 200+ Amp ServiceGenerator Green Energy Efficient [] Green Energy Generation [] Green Indoor Air Quality [] Horse Amenities [] Land Lease YN No Listing Terms [] New Construction YN No Other Equipment Fuel Tank(s) Property Condition Updated/Remodeled Property Sub Type Farm Security Features Carbon Monoxide Detector(s) Sewer Septic Tank Special Listing Conditions Standard Utilities Cable Connected Water Source Supplemental WellDrilled Well Zoning Farm

Listing information © 2025 Global MLS.
Listing provided courtesy of Edward Brewer of Howard Hanna: 518-286-1000.



© 2025 Global Multiple Listing Service, Inc. The data relating to real estate on this website comes in part from the Internet Data Exchange program of the 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. Data last updated 2025-02-07T00:12:00.317.
 
https://bt-photos.global.ssl.fastly.net/capital/1280_boomver_1_202510557-2.jpg https://bt-photos.global.ssl.fastly.net/capital/1280_boomver_1_202510557-2.jpg https://bt-photos.global.ssl.fastly.net/capital/1280_boomver_1_202510557-2.jpg
Logo
Realty One Group Key
1541 Union Street
Schenectady NY, 12309