Skip To Content

797 Western Road

Castleton, NY 12033
  • $1,270,000
  • STATUS: Active
  • MLS #: 155663
UPDATED: 198 min ago
$1,270,000
  • 6
    BEDS
  • 64.7
    ACRES
  • 3
    BATHS
  • 0
    1/2 BATHS
  • 3,393
    SQFT
  • $374
    $/SQFT
Neighborhood:
Type:
Single-Family Home
Built:
1829
County:
Area:

School Ratings & Info

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 and seasonal Hudson River 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 on the second floor, 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 and riding trails which are great for horses or four wheelers as well as an inground garden pool with hot tub. 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 for a caretaker or other family members to live on this classic Farm property - see last photo for front of this home.

Monthly Payment Calculator



© 2025 Columbia Greene and Northern Dutchess MLS. All rights reserved. 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 consumers may be interested in purchasing. Information is deemed reliable but is not guaranteed accurate by the MLS or This Old Hudson Team at Houlihan Lawrence. Data last updated: 2025-05-12T13:46:40.893.
www.thisoldhudsonrealestate.com/homes/159389465
Print Image

797 Western Road Castleton, NY 12033

  • Price: $1,270,000
  • Status: Active
  • On Site: Days
  • Updated: 198 min ago
  • MLS #: 155663
6
Beds
3
Baths
0
½ Baths
64.7
Acres
3,393
SQFT
$374
$/SQFT
1829
Built
Neighborhood:
Schodack
County:
Rensselaer
Area:
Schodack
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 and seasonal Hudson River 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 on the second floor, 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 and riding trails which are great for horses or four wheelers as well as an inground garden pool with hot tub. 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 for a caretaker or other family members to live on this classic Farm property - see last photo for front of this home.
Exterior Features

Color Yellow with Blue Shutters Construction Frame Garage Attached Paved Street Yes Roof AsphaltShingleOther Siding Clapboard Views FarmlandHilltopPanoramicParklikePastoralRiverSeasonalValley ViewMeadowRural

Interior Features

1st Floor 1971 2nd Floor 1422 3rd Floor 0 Appliances Included Clothes DryerClothes WasherDishwasherMicrowaveRefrigeratorStoveWater TreatmentOther Basement FullUnfinishedExterior EntryStorage SpaceSump Pump Basement Sqft 0 Central Air No Fireplace Location BedroomFamily Room First Floor BathFamily RoomLiving RoomDining RoomKitchenGreat RoomOther Room Floors HardwoodWideboard Heat Type Steam Heating Stv Location BedroomFamily Room Insulation Type Fiberglass Number Of Fireplaces 0 Second Floor Bedroom 1Bedroom 2Bedroom 3Bedroom 4Bath Security System No Walls Plaster Water Heater Electric Windows Double HungLow EnergyStorm

Property Features

Condition Excellent Deed Restrictions No Electric 200 AmpsOther Flood Zone No Foundation Poured ConcreteStone Hoa Fee 0 Home Owners Assoc No Lot Measurement Acres Lot Square Footage 2818332.00 Other Tax 0.00 Property Subtype Deeded School Tax 11209.00 Secluded Yes Sewer Septic Tank Style Farm House Tax Exemptions Yes Total Tax 15300 Town Tax 4102.00 Village Tax 0.00 Water PrivateWellCistern Waterfront No Wetlands No Zoning Ag/Farm

Listing provided courtesy of Edward Brewer of Howard Hanna Capital, Inc.: 518-286-1000.


© 2025 Columbia Greene and Northern Dutchess MLS. All rights reserved. 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 consumers may be interested in purchasing. Information is deemed reliable but is not guaranteed accurate by the MLS or This Old Hudson Team at Houlihan Lawrence. Data last updated: 2025-05-12T13:46:40.893.
 
https://bt-photos.global.ssl.fastly.net/ndutchess/1280_boomver_1_282984-2.jpg https://bt-photos.global.ssl.fastly.net/ndutchess/1280_boomver_1_282984-2.jpg https://bt-photos.global.ssl.fastly.net/ndutchess/1280_boomver_1_282984-2.jpg
Logo
This Old Hudson Team at Houlihan Lawrence
Hudson NY, 12534