Skip main navigation
For sale
  • $1,270,000

    797 Western Rd, Castleton, NY 12033

    6beds
    3,393sqft
    Deeded, Single Family Residence
    Built in 1829
    64.7 Acres Lot
    $-- Zestimate®
    $374/sqft
    $-- HOA

    What's special

    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.
    103 days
    on Zillow
    |
    824
    |
    67
    |

    Zillow last checked: 7 hours ago

    Listing updated: January 13, 2025 at 01:52am

    Listing by:

    Howard Hanna Capital, Inc. 518-286-1000,

    Edward R. Brewer,

    Jolene S. Morris,

    Howard Hanna Capital, Inc.

    Source: Columbia Greene Northern Dutchess MLS,MLS#: 155663MLS LogoOriginating MLS: Columbia County & Northern Dutchess MLS
    Travel times

    Tour with a buyer’s agent

    We’ll find a local expert to take you on a private tour of 797 Western Rd.

    Next available tour time:Tomorrow at 2:30pm

    Facts & features

    Interior

    Bedrooms & bathrooms
    • Bedrooms: 6
    • Bathrooms: 3
    • Full bathrooms: 3
    Heating
    • Steam
    Appliances
    • Included: Clothes Dryer, Clothes Washer, Dishwasher, Microwave, Refrigerator, Stove, Water Treatment, Other, Water Heater (Electric)
    Features
    • Flooring: Hardwood, Wideboard
    • Windows: Double Hung, Low Energy, Storm Window(s)
    • Basement: Full,Unfinished,Exterior Entry,Storage Space,Sump Pump
    • Has fireplace: Yes
    • Fireplace features: Bedroom, Family Room
    Interior area
    • Total structure area: 3,393
    • Total interior livable area: 3,393 sqft

    Property

    Parking
    • Total spaces: 2
    • Parking features: Attached
    • Attached garage spaces: 2
    Features
    • Has view: Yes
    • View description: Farmland, Hills, Panoramic, Park/Greenbelt, Pastoral, River, Seasonal, Valley, Meadow, Rural
    • Has water view: Yes
    • Water view: River
    Lot
    • Size: 64.7 Acres
    • Features: Secluded
    Details
    • Parcel number: 198.-1-3.11
    • Zoning: Ag/Farm
    • Zoning description: Ag/Farm

    Construction

    Type & style
    • Home type: SingleFamily
    • Architectural style: Farm House
    • Property subtype: Deeded, Single Family Residence
    Materials
    • Frame, Plaster, Clapboard
    • Foundation: Poured Concrete, Stone
    • Roof: Asphalt,Shingle,Other
    Condition
    • Excellent
    • Year built: 1829

    Utilities & green energy

    • Electric: 200+ Amp Service, Other
    • Sewer: Septic Tank
    • Water: Private, Well, Cistern

    Community & HOA

    HOA
    • Has HOA: No
    Location
    • Region: Castleton

    Financial & listing details

    • Price per square foot: $374/sqft
    • Tax assessed value: $666,462
    • Annual tax amount: $15,311
    • Price range: $1.3M - $1.3M
    • Date on market: 1/13/2025
    • Electric utility on property: Yes
    • Road surface type: Paved
    • Loading
    • Loading