797 Western Road
Schodack, NY 12033
- 7 beds
- 3 baths
- 3,393 sqft
- ~65 acre lot
- $374 per sqft
- 1829 build
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.
Listing courtesy of GLOBAL_MLS / Edward Brewer, 518-428-6184 / Howard Hanna
Last checked:
Checking…
•
Last updated Jan 13, 2025
•
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
MLS# 202510557 —
The Building
-
Year Built:1829
-
New Construction:false
-
Construction Materials:Other, Clapboard
-
Architectural Style:Farm, Farmhouse
-
Direction Faces:None
-
Roof:Shingle, Asphalt, Copper
-
Foundation Details:Slab, Stone
-
Entry Level:None
-
Exterior Features:Barn, Lighting
-
Door Features:French Doors
-
Window Features:Shutters, Storm Window(s), Curtain Rods, Double Pane Windows
-
Patio And Porch Features:Screened, Side Porch, Patio, Porch
-
Security Features:Carbon Monoxide Detector(s)
-
Basement:Exterior Entry, Full, Pillar/Post/Pier, Sump Pump
-
Basement Full:true
-
Above Grade Finished Area:3393.0
Interior
-
Interior Features:High Speed Internet, Walk-In Closet(s), Other, Ceramic Tile Bath, Crown Molding, Kitchen Island, Built-in Features
-
Kitchen:true
-
Kitchen Level:First
-
Dining Room:true
-
Living Room:true
-
Living Room Level:First
-
Family Room:true
-
Family Room Level:First
-
Rooms Total:17
-
Flooring:Ceramic Tile, Hardwood
-
Stories:None
-
Main Level Laundry:true
-
Laundry Features:Laundry Closet, Main Level
-
Fireplace:false
-
Fireplace Features:Wood Burning Stove
Room Dimensions
-
Living Area:3393.0
Financial & Terms
-
Possession:At Closing
-
Rent Includes:None
Location
-
Directions:Rt. 9J to Western Rd. approx. 1 mile to the top of the hill on left.
-
Directions:Rt. 9J to Western Rd. approx. 1 mile to the top of the hill on left.
-
Latitude:42.54096
-
Longitude:-73.740727
The Property
-
Property Type:Residential
-
Property Condition:Updated/Remodeled
-
Property Subtype:Farm
-
Lot Features:Secluded, Meadow, Private, Road Frontage, Views, Bluff, Cleared, Irregular Lot, Landscaped
-
Lot Size Area:64.57
-
Lot Size Acres:64.57
-
Lot Size Units:Acres
-
Lot Size SqFt:2812669.2
-
Possible Use:None
-
Zoning:Farm
-
Parcel Number:384489 198.-1-3.11
-
Topography:None
-
Views:true
-
View:Meadow, Mountain(s), Pasture, River, Valley, Hills
-
Waterfront:No
-
Fencing:Wire, Other
-
Other Equipment:Fuel Tank(s)
-
Other Structures:Guest House, Second Residence, Shed(s), Workshop, Barn(s), Cabana, Garage(s)
-
Main Road Frontage:3005.0
-
Land Lease:false
-
Land Lease:No
Listing Agent
- Contact info:
- Agent phone:
- (518) 428-6184
- Office phone:
- (518) 286-1000
Taxes
-
Tax Lot:3.011
-
Tax Block:1
-
Tax Tract:198.00
-
Tax Annual Amount:15236.0
Beds
-
Bedrooms Total:7
-
Bedroom:true
-
Bedroom Level:Second
-
Primary Bedroom Level:Second
-
Primary Bedroom:true
Baths
-
Total Baths:3
-
Total Baths:3.0
-
Full Baths:true
-
Full Baths:3
-
Full Bath Level:First
-
Full Bath Level:1st
-
Three Quarter Baths:None
-
Quarter Baths:None
Heating & Cooling
-
Cooling:Window Unit(s)
-
Cooling:true
-
Heating:Oil, Steam, Zoned
-
Heating:true
Utilities
-
Utilities:Cable Connected
-
Electric:200+ Amp Service, Generator
-
Sewer:Septic Tank
-
Sewer/Septic Tank:true
-
Water Source:Supplemental Well, Drilled Well
Appliances
-
Appliances:Dehumidifier, Dishwasher, Electric Water Heater, Icemaker, Microwave, Range, Refrigerator, Washer/Dryer, Water Purifier, Water Softener, Wine Cooler
-
Range:true
-
Refrigerator:true
-
Icemaker:true
-
Microwave:true
-
Dishwasher:true
-
Dehumidifier:true
-
Water Softener:true
-
Washer and Dryer:true
-
Wine Cooler:true
Schools
-
Elementary School District:None
-
Middle Or Junior School District:None
-
Middle Or Junior School:None
-
High School:Maple Hill HS
-
High School District:Schodack
The Community
-
Pool Features:In Ground, Outdoor Pool
-
Pool Private:No
-
Spa:true
-
Spa:Yes
-
Spa Features:None
-
Waterfront:false
-
Pets Allowed:None
-
Association:false
Parking
-
Parking:Yes
-
Garage:true
-
Parking Total:25.0
-
Parking Features:Off Street, Workshop in Garage, Attached, Circular Driveway, Driveway, Garage Door Opener, Heated Garage
-
Parking Total:25.0
-
Garage:true
-
Garage Spaces:2.0
-
Attached Garage:true
-
Garage Workshop:true
-
Carport Spaces:None
-
Open Parking:No
Extra Units
-
Barn:true
-
Workshop:true
Monthly cost estimate
Asking price
$1,270,000
Expense | Monthly cost |
---|---|
Mortgage
This calculator is intended for planning and education purposes only. It relies on assumptions and information provided by you regarding your goals, expectations and financial situation, and should not be used as your sole source of information. The output of the tool is not a loan offer or solicitation, nor is it financial or legal advice. |
$6,800
|
Taxes | $1,269 |
Insurance | $349 |
Utilities | $303 See report |
Total | $8,721/mo.* |
*This is an estimate |
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.
Max Internet Speed
Provided by BroadbandNow®
This is the maximum advertised internet speed available for this home. Under 10 Mbps is in the slower range, and anything above 30 Mbps is considered fast. For heavier internet users, some plans allow for more than 100 Mbps.
Sale history
Date | Event | Source | Price | % Change |
---|---|---|---|---|
1/13/25
Jan 13, 2025
|
Listed / Active | GLOBAL_MLS | $1,270,000 |