Skip To Content

797 Western Road

Castleton On Hudson, NY 12033
  • $1,270,000
  • STATUS: Active
  • MLS #: 202416481
UPDATED: 62 min ago
$1,270,000
  • 6
    BEDS
  • 64.7
    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

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. Known as ''Enderley Farm,'' the Patroon era Farmhouse has been authentically restored & featured on HGTV. This property has over 64 acres, with spectacular Hudson Valley and seasonal River views. The farmhouse has a bedroom suite with porch & woodstove & 5 additional bedrooms, 3 full baths, 2 dining rooms, & 2 stairways to the 2nd floor.

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-10-08T22:14:42.867.
www.heerrealty.com/homes/150166776
Print Image

797 Western Road Castleton On Hudson, NY 12033

  • Price: $1,270,000
  • Status: Active
  • On Site: Days
  • Updated: 62 min ago
  • MLS #: 202416481
6
Beds
3
Baths
0
½ Baths
64.7
Acres
3,393
SQFT
$374
$/SQFT
1829
Built
County:
Rensselaer
Area:
Rensselaer
High School:
Maple Hill Hs
School District:
Schodack
Property Description
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. Known as ''Enderley Farm,'' the Patroon era Farmhouse has been authentically restored & featured on HGTV. This property has over 64 acres, with spectacular Hudson Valley and seasonal River views. The farmhouse has a bedroom suite with porch & woodstove & 5 additional bedrooms, 3 full baths, 2 dining rooms, & 2 stairways to the 2nd floor.
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 PaddocksPastureTack Room 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 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-10-08T22:14:42.867.
 
https://bt-photos.global.ssl.fastly.net/capital/1280_boomver_5_202416481-2.jpg https://bt-photos.global.ssl.fastly.net/capital/1280_boomver_5_202416481-2.jpg https://bt-photos.global.ssl.fastly.net/capital/1280_boomver_5_202416481-2.jpg
Logo
Heer Realty, Inc.
314 Hoosick Street
Troy NY, 12180