HOMESFARMSANDLAND
BuySell
    • Featured Properties
    • Property Showcases
    • Latest Blogs
      • Overview
      • Explore Open Houses
      • Discover Rental Living
      • Escape to Cabin Life
      • Unlock Multi-Family Living
      • Your Perfect Land Awaits
      • Embrace Farm Life
      • Overview
      • Find Rentals
      • Find Cabins
      • Browse Homes
      • Browse Farms
      • Browse Lands
    • Saved Properties
    • Overview
    • Buying Form
    • Buying Process
    • Mortgage Calculator
    • Overview
    • Selling Form
    • Selling Process
    • Free Home Evaluation
      • All of Otsego
      • Cooperstown
      • Oneonta
      • West Oneonta
      • Milford
      • Hartwick
      • Worcester
      • Unadilla
      • Laurens
      • Richfield Springs
      • All of Schoharie
      • Cobleskill
      • Middleburgh
      • Schoharie
      • Sharon Springs
      • Summit
      • Richmondville
      • Esperance
      • All of Chenango
      • Norwich
      • Oxford
      • Greene
      • Bainbridge
      • Sherburne
      • All of Delaware
      • Delhi
      • Stamford
      • Andes
      • Walton
      • Margaretville
      • Roxbury
      • Sidney
      • All of Greene
      • Catskill
      • Windham
      • Hunter
      • Cairo
      • Coxsackie
      • Athens
      • All of Broome
      • Binghamton
      • Vestal
      • Endicott
      • All of Oneida
      • New Hartford
      • Utica
      • Marcy
      • Clinton
      • All of Montgomery
      • Amsterdam
      • Fort Plain
      • Canajoharie
      • Fonda
      • All of Ulster
      • Kingston
      • New Paltz
      • Saugerties
      • Woodstock
      • Marlborough
    • Overview
    • Free Vendor List
    • Practical Guides
    • Need Funding?
    • Property Inspector
    • Down Payment Eligibility
    • Location Sharing?
      • Overview
      • Standard Operating Procedure
      • NYS Buyer-Seller
      • NYS Landlord-Tenant
      • Tenant Rights Notice
      • Fair Housing Notice
      • Privacy Policy
      • Location Services
      • Properties Preferences
      • Map Data Attribution
    • Who We Are
    • Meet the Team
Featured
Featured Properties
Property Showcases
Latest Blogs
Search
Advanced Search
Explore Open Houses
Discover Rental Living
Escape to Cabin Life
Unlock Multi-Family Living
Your Perfect Land Awaits
Embrace Farm Life
Search by Map
Find Rentals
Find Cabins
Browse Homes
Browse Farms
Browse Lands
Saved Properties
Buy
Buying Form
Buying Process
Mortgage Calculator
Sell
Selling Form
Selling Process
Free Home Evaluation
HOMESFARMSANDLAND
  • Otsego
  • Schoharie
  • Chenango
  • Delaware
  • Greene
  • Broome
  • Oneida
  • Montgomery
  • Ulster

Select a county to see cities

Resources
Free Vendor List
Practical Guides
Need Funding?
Property Inspector
Down Payment Eligibility
Location Sharing?
Disclosures
Standard Operating Procedure
NYS Buyer-Seller
NYS Landlord-Tenant
Tenant Rights Notice
Fair Housing Notice
Privacy Policy
Location Services
Properties Preferences
Map Data Attribution
About
Who We Are
Meet the Team

Let's Find Your Next Property.

HOMESFARMSANDLAND.COM

Kevin Lucero

Lic. Real Estate Salesperson

a Charlotteville Realty Team

Independently Owned & Operated

607-282-6242kevin@homesfarmsandland.com

Buying

  • Buying Form
  • Buying Process
  • Mortgage Calculator

Selling

  • Selling Form
  • Selling Process
  • Free Home Evaluation

About Us

  • Who We are
  • Meet the Team

Resources

  • Latest Blogs
  • Free Vendor List
  • PracticalGuides
  • Need Funding?
  • Property Inspector
  • Down Payment Eligibility

Communities

  • Otsego County
  • Schoharie County
  • Chenango County
  • Delaware County
  • Greene County
  • Broome County
  • Oneida County
  • Montgomery County
  • Ulster County

Disclosures

  • Standard Operating Procedure
  • NYS Buyer-Seller
  • NYS Landlord-Tenant
  • Tenant Rights Notice
  • Fair Housing Notice
  • Privacy Policy
  • Location Services
  • Properties Preferences
  • Map Data Attribution

© 2026 Homes, Farms & Land. All rights reserved.

Property at 797 Western Road, Schodack, NY 12033
ACTIVE
0
$1,239,000

797 Western RoadSchodack, NY, 12033

6 Beds3 Baths3,647 SqFt64.57 Acres
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.
1 / 57

Est. Monthly

$5,873/MO

$1,239,000

797 Western Road, Schodack, NY

6 Beds3 Baths3,647 SqFt64.57 Acres

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.

StatusActive
Property TypeResidential
Property SubtypeSingle Family Residence
Year Built1829
Total Rooms16 rooms
Days on Market94 days

Est. Monthly Payment

$5,872.83

%
%
yr

Private Mortgage Insurance

Not required

Affordability Checkoptional
$

Enter your annual income to check affordability

Property Details

Property Information

797 Western Road

Schodack, NY 12033 • Rensselaer
6
Beds
3
Baths
3,647
SqFt
64.57
Acres
Status
Active
Property Type
Residential
Property Subtype
Single Family Residence
Year Built
1829197 years ago
Total Rooms
16 rooms
Days on Market
94 days
Tax History
Estimated values, may not reflect current amounts.
  • Annual Tax Amount
    $16,583
Property History
  • Listed for sale
    Mar 9, 2026 • GLOBAL MLS • 202612988
    $1,239,000
Mortgage Calculator
Estimated monthly payment for this property
$5,872.83
Down Payment
Interest Rate
Loan Term
%
%
yearsyrs.
Affordability Checkoptional
$

Enter your annual income to see if this home fits your budget

Private Mortgage Insurance

Not required — down payment above 20%
MLS Information
  • Source
    Global MLS
  • MLS#
    202612988
  • Listing Office
    Howard Hanna Capital Inc
  • Last Updated
    8 days ago

Kitchen & Laundry

  • Kitchen
    • Breakfast Room
    • Eat-in Kitchen
    • Kitchen Island
    • Modern Kitchen
    • Built-in Features

Appliances

  • Appliances
    • Range
    • Refrigerator
    • Washer
    • Dishwasher
    • Dryer
    • Microwave
    • Range Hood
    • Ice Maker
    • Wine Cooler
    • Oven
    • ENERGY STAR Qualified Appliances

Climate & Systems

  • Heating
    • Wood Stove
    • Radiant
    • Steam
    • Other
  • Fireplace
    • Wood Burning Stove
    • Family Room
    • Bedroom

Interior Features

  • Flooring
    • Ceramic Tile
    • Wood
    • Hardwood
    • Tile
  • Doors
    • French Doors
    • ENERGY STAR Qualified Doors
    • Storm Door(s)
  • Basement
    • Unfinished
    • Interior Entry
    • Sump Pump
  • Windows
    • Insulated Windows
    • Storm Window(s)
    • Blinds
    • Curtain Rods
    • ENERGY STAR Qualified Windows
    • Screens
    • Shutters
    • Window Coverings
    • Window Treatments
    • Wood Frames
  • Interior Features
    • Ceramic Tile Bath
    • High Speed Internet
    • Wall Paneling
    • Built-in Features
    • Wet Bar
    • Crown Molding
    • Solid Surface Counters
    • Eat-in Kitchen
    • Kitchen Island

Parking

  • Parking Features
    • Attached
    • Storage
    • Heated Garage
    • Garage Door Opener
    • Workshop in Garage
    • Off Street
    • Circular Driveway
    • Driveway
    • Garage
  • Parking Spaces
    10
  • Garage Spaces
    2

Lot & Grounds

  • Lot Size
    64.57 acres
  • Lot Features
    • Cleared
    • Meadow
    • Landscaped
    • Level
    • Mountain(s)
    • Private
    • Road Frontage
    • Secluded
    • Wooded
    • Views
    • Bluff
    • Garden
  • View
    • Hills
    • Meadow
    • Mountain(s)
    • Orchard
    • Pasture
    • Skyline
    • Trees or Woods
    • Valley
  • Fencing
    • Fenced
    • Electric
    • Gate
  • Patio & Porch
    • Patio
    • Porch
    • Enclosed
    • Screened
    • Front Porch
    • Covered
    • Side Porch
  • Exterior Features
    • Barn
    • Garden
    • Storm Door(s)

Type

  • Property Type
    Residential
  • Property Subtype
    Single Family Residence
  • Architectural Style
    • Colonial
    • Farm
    • Farmhouse

Structure

  • Construction
    • Wood Siding
    • Stone
  • Roof
    • Asphalt
    • Shingle
  • Foundation
    • Combination
    • Stone

Condition

  • Year Built
    1829
  • Condition
    Updated or Remodeled
  • Days on Market
    94 days
  • Water
    Cistern
  • Sewer
    Septic Tank
  • Electric
    • 200+ Amp Service
    • Circuit Breakers
  • Utilities
    Cable Connected

607-282-6242, (607) 282-6242, or +1 607 282 6242

Kevin Lucero

Kevin Lucero

Lic. Real Estate Salesperson

CallEmail
Picked for you

Similar Properties

Handpicked listings that match what you're looking at

View all →
  • 9 Harvest Glen, Pittsford, NY 14534ACTIVE$1,129,000

    9 Harvest Glen, Pittsford, NY 14534

    6 Beds4.5 Baths4,114 SqFt0.52 Acres

    LISTING BY BRIX & MAVEN REALTY GROUP LLC

  • 11 Goldfoot Road, Round Lake, NY 12151ACTIVE$1,130,000OPEN 6/14

    11 Goldfoot Road, Round Lake, NY 12151

    4 Beds4.5 Baths4,000 SqFt25.01 Acres

    LISTING BY REALTY ONE GROUP KEY

  • 6 Sterling Ridge, Colonie, NY 12211ACTIVE$1,134,800

    6 Sterling Ridge, Colonie, NY 12211

    3 Beds2.5 Baths2,328 SqFt0.41 Acres

    LISTING BY GUCCIARDO REAL ESTATE LLC

  • 1110 River Road, Schodack, NY 12156ACTIVE$1,139,050

    1110 River Road, Schodack, NY 12156

    7 Beds3 Baths5,672 SqFt23.24 Acres

    LISTING BY SIERRA NORTH REAL ESTATE LLC

  • 49 Cannon Royal Drive, Wilton, NY 12866ACTIVE$1,139,800

    49 Cannon Royal Drive, Wilton, NY 12866

    4 Beds2.5 Baths2,620 SqFt0.93 Acres

    LISTING BY STERLING REAL ESTATE GROUP

  • Lot 47 Longbow Way, Lysander, NY 13027ACTIVE$1,140,000

    Lot 47 Longbow Way, Lysander, NY 13027

    4 Beds2.5 Baths3,100 SqFt

    LISTING BY KIRNAN REAL ESTATE

  • 3043 E Shore South Road, Galway, NY 12086ACTIVE$1,147,000

    3043 E Shore South Road, Galway, NY 12086

    4 Beds4 Baths3,340 SqFt0.29 Acres

    LISTING BY HOWARD HANNA CAPITAL INC

  • 5 Mystic Lane, Saratoga Springs, NY 12866ACTIVE$1,149,000

    5 Mystic Lane, Saratoga Springs, NY 12866

    4 Beds3.5 Baths3,116 SqFt0.63 Acres

    LISTING BY HUNT ERA

  • 9 Rolling Brook Drive, Saratoga Springs, NY 12866ACTIVE$1,149,000OPEN 6/14

    9 Rolling Brook Drive, Saratoga Springs, NY 12866

    4 Beds3.5 Baths2,640 SqFt2.08 Acres

    LISTING BY ROOHAN REALTY

  • 5010 East River Road, Grand Island, NY 14072ACTIVE$1,149,000

    5010 East River Road, Grand Island, NY 14072

    5 Beds5.5 Baths5,708 SqFt0.4706 Acres

    LISTING BY CENTURY 21 NORTH EAST