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

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

Layout spacer

    Layout spacer

      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 / 71

      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 Market72 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
      72 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
        43 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
        • Lighting
        • 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
        72 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 →
      • 262 Old Post Road, Ballston Spa, NY 12020ACTIVE$1,125,000

        262 Old Post Road, Ballston Spa, NY 12020

        4 Beds3 Baths3,509 SqFt3.86 Acres

        LISTING BY KW PLATFORM

      • 5135 Peck Hill Road, DeWitt, NY 13078ACTIVE$1,125,000

        5135 Peck Hill Road, DeWitt, NY 13078

        5 Beds5 Baths5,322 SqFt1.87 Acres

        LISTING BY THE O'HARA GROUP

      • 44515 Saint Lawrence Park Place, Alexandria, NY 13607ACTIVE$1,129,000

        44515 Saint Lawrence Park Place, Alexandria, NY 13607

        4 Beds2 Baths1,430 SqFt0.584 Acres

        LISTING BY STAIE ON THE SEAWAY REAL ESTATE SERVICES RES, 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

      • 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

      • 2769 W Lake Road, Cazenovia, NY 13035ACTIVE$1,149,900OPEN 5/20

        2769 W Lake Road, Cazenovia, NY 13035

        3 Beds3.5 Baths3,610 SqFt4.67 Acres

        LISTING BY HUNT REAL ESTATE ERA

      • 5287 N Kashong Point, Geneva Town, NY 14456ACTIVE$1,150,000

        5287 N Kashong Point, Geneva Town, NY 14456

        4 Beds2 Baths2,366 SqFt0.44 Acres

        LISTING BY WARREN REAL ESTATE OF ITHACA INC.

      • 4184 Silver Beach Road, Malta, NY 12020ACTIVE$1,150,000

        4184 Silver Beach Road, Malta, NY 12020

        3 Beds2.5 Baths2,363 SqFt0.21 Acres

        LISTING BY KW PLATFORM