Skip To Content

797 Western Road

Castleton On Hudson, NY 12033
  • $1,290,000
  • STATUS: Active
  • MLS #: 202416481
UPDATED: 179 min ago
$1,290,000
  • 6
    BEDS
  • 64.7
    ACRES
  • 3
    BATHS
  • 0
    1/2 BATHS
  • 3,393
    SQFT
  • $380
    $/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 & featured on HGTV. This hill top property has over 64 acres, with spectacular Hudson Valley views. The location is a blend of convenience and serenity, ten minutes from downtown Albany. The farmhouse features a bedroom suite with porch, 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 or just to immerse yourself in a slower paced world. There is a 3 bedroom caretaker home for sale separately.

Monthly Payment Calculator



© 2024 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 2024-07-16T00:14:58.117.
www.heerrealty.com/homes/150166776
Print Image

797 Western Road Castleton On Hudson, NY 12033

  • Price: $1,290,000
  • Status: Active
  • On Site: Days
  • Updated: 179 min ago
  • MLS #: 202416481
6
Beds
3
Baths
0
½ Baths
64.7
Acres
3,393
SQFT
$380
$/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 & featured on HGTV. This hill top property has over 64 acres, with spectacular Hudson Valley views. The location is a blend of convenience and serenity, ten minutes from downtown Albany. The farmhouse features a bedroom suite with porch, 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 or just to immerse yourself in a slower paced world. There is a 3 bedroom caretaker home for sale separately.
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 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

Association YN No Electric 200+ Amp ServiceGenerator Horse Amenities PaddocksPastureTack Room Land Lease YN No 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 WellCisternDrilled Well Zoning Farm

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



© 2024 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 2024-07-16T00:14:58.117.
 
https://bt-photos.global.ssl.fastly.net/capital/1280_boomver_4_202416481-2.jpg https://bt-photos.global.ssl.fastly.net/capital/1280_boomver_4_202416481-2.jpg https://bt-photos.global.ssl.fastly.net/capital/1280_boomver_4_202416481-2.jpg
Logo
Heer Realty, Inc.
314 Hoosick Street
Troy NY, 12180