797 Western Road, Schodack, NY 12033
797 Western Road, Schodack, NY 12033
797 Western Road, Schodack, NY 12033
REQUEST A TOUR If you would like to see this home without being there in person, select the "Virtual Tour" option and your agent will contact you to discuss available opportunities.
In-PersonVirtual Tour
Listed by Aubrey D Guri • Howard Hanna Capital Inc
$1,239,000
Est. payment /mo
6 Beds
3 Baths
3,647 SqFt

UPDATED:

Key Details

Property Type Single Family Home

Sub Type Single Family Residence

Listing Status Active

Purchase Type For Sale

Square Footage 3,647 sqft

Price per Sqft $339

MLS Listing ID 202612988

Bedrooms 6

Full Baths 3

HOA Y/N No

Year Built 1829

Annual Tax Amount $16,583

Lot Size 64.570 Acres

Acres 64.57

Property Sub-Type Single Family Residence

Source Global MLS

Property Description

A remarkable hilltop colonial manor home overlooking magnificent Hudson Valley views, where sunsets melt gently into the horizon, and the sky feels endlessly expansive. Established in 1829, Enderley Farm has been thoughtfully and lovingly restored to impeccable, move-in condition, and was featured on HGTV. This six-bedroom, three-full-bath residence honors its historic roots while embracing modern comfort. Preserved craftsmanship tells the story of its past, while every major system, plumbing, electrical, heating, foundation, and roof, has been fully upgraded to ensure peace of mind for years to come.

Let this lifestyle unfold while pursuing your dreams and passions in an idealistic and serene setting. This 64-acre spread of land offers the best of mountain views, peaceful seclusion, and has perfect southern exposures for growing. Trails weave through the acreage, perfect for riding, walking, or winter sports. Walking the fields and forested trails, the majesty of this historic property comes to life as you feel like you are in your own state park. The open fields are perfectly suited for small-scale farming or for horses or other animals that can graze under the endless skies.

The barn is complete with three stalls, a hay loft with drops, a separate office, and a large interior space with a new stamped concrete floor, perfect for equestrian pursuits, hobbies, or social gatherings. A pool framed by grapevines and a charming cabana creates a peaceful retreat for gathering with friends or unwinding beneath the open sky. Each season unveils its own quiet, picturesque beauty.

Location

State NY

County Rensselaer

Direction From NYS Thruway Interstate 90/Berkshire Connector), take Exit B1 toward US-9 (Albany/Hudson). Right on US-9 North. Left on Rt 6 (Maple Hill Rd). Right on Simon's Rd. Left on Brookview Station Rd. Right on Brookview Rd. Left on Western Rd. #797 is on your right just past a red barn.

Interior

Interior Features High Speed Internet, Solid Surface Counters, Wall Paneling, Wet Bar, Built-in Features, Ceramic Tile Bath, Crown Molding, Eat-in Kitchen, Kitchen Island

Heating Other, Radiant, Steam, Wood Stove

Flooring Tile, Wood, Ceramic Tile, Hardwood

Fireplaces Type Wood Burning Stove, Bedroom, Family Room

Fireplace No

Window Features Screens,Shutters,Storm Window(s),Window Coverings,Window Treatments,Wood Frames,Blinds,Curtain Rods,ENERGY STAR Qualified Windows,Insulated Windows

Exterior

Exterior Feature Barn, Garden, Lighting, Storm Door(s)

Parking Features Off Street, Storage, Workshop in Garage, Attached, Circular Driveway, Driveway, Garage Door Opener, Heated Garage

Garage Spaces 2.0

Pool In Ground

Utilities Available Cable Connected

Waterfront Description Stream

Roof Type Shingle,Asphalt

Porch Screened, Side Porch, Covered, Enclosed, Front Porch, Patio, Porch

Garage Yes

Building

Lot Description Secluded, Level, Meadow, Mountain(s), Private, Road Frontage, Views, Wooded, Bluff, Cleared, Garden, Landscaped

Sewer Septic Tank

Water Cistern

Architectural Style Colonial, Farm, Farmhouse

New Construction No

Schools

School District Schodack

Others

Tax ID 384489 198.-1-3.11

Special Listing Condition Standard

Virtual Tour https://app.doaudiotours.com/unbranded?id=17573&lang=en-US


Read Less Info

Nearby School & Business

Get More Information

Erin Steinbach

Erin Steinbach

+1(518) 222-6031

Lic. Associate R. E. Broker | License ID: 10301217507

Lic. Associate R. E. Broker License ID: 10301217507

Name

Name

Phone*

Phone

Message