Waterfront
Address
247 Sarah Wells Trail, Campbell Hall, NY
Price
$ 3,250,000
Property Attributes
- ID#952530
- TypeSingle Family
- Listing Status Active
- CountyORANGE
- CityCampbell Hall
- Zip10916
- StyleColonial
- Year Built1863
- Taxes$ 20737
- Price$ 3,250,000
- Bedrooms6
- Full Bathrooms3
- Half Bathrooms1
- Sqr Footage3618
- Lot Size186 Acres
Data Source:
Listings courtesy of OneKey® MLS as distributed by MLS GRID
Property Description
Extraordinary 186-Acre Colonial Estate with Views, Water Features & Endless Potential! Hamptonburgh, NY, a rare Hudson Valley legacy property! This historic 4-bed, 3-bath Center-Hall Colonial sits on 186 stunning acres across 3 parcels, offering sweeping panoramic views reaching as far as High Point, NJ and Sugar Loaf Mountain. Located just 0.9 miles from the Campbell Hall Metro-North Station, the property combines unmatched privacy with commuter convenience and proximity to local attractions. The main home blends timeless charm and modern upgrades with exposed hand-hewn beams, refinished wide plank floors, crown molding, and a gourmet kitchen with granite counters, stainless appliances, and custom cabinetry. Formal living and dining rooms feature pocket doors and intricate period detailing, while the upstairs offers 4 spacious bedrooms including a cozy bunk room and luxurious baths with a soaking tub and stall shower. Enjoy dual-fuel heating options with both an oil-fired system and an outdoor wood-burning furnace. The setting is low-maintenance, with the option to renew an existing farm lease—leaving you responsible only for lawn care around the home. This property is a true outdoor retreat, featuring a private bass pond, creek frontage, hunting, and gently rolling fields framed by woodlands. Additional features include: Original hand-hewn barns, A 48-stall dairy barn, Oversized 3+ car garage with workshop, Multiple storage buildings, A fully approved and private kennel, A separate caretaker’s studio with full kitchen and bath! Whether you envision a private residence, equestrian estate, working farm, or unique venue, the possibilities are endless. With spectacular views, natural beauty, and over 200 years of history, this is a once-in-a-lifetime chance to own a signature Hudson Valley estate. Only 1 hour to NYC and 35 minutes to Northern NJ—private yet close to everything.
| Elementary School | Middle School | High School |
|---|---|---|
| Little Britain Elementary School | Washingtonville Middle School | Washingtonville Senior High School |
| Price History | |
|---|---|
| 1/21/2026 | Listed $3,370,000 |
| 3/18/2026 | 4$3,250,000 |
General Features
| Sewer | Septic Tank |
|---|---|
| Heating | Forced Air,Oil |
| Cooling | Central Air |
| Utilities | Trash Collection Public |
| Appliances | Stainless Steel Appliance(s),Oil Water Heater |
| Garage Spaces | 3 |
| Patio/Porch Features | Deck,Patio,Porch |
| Architectural Style | Colonial |
| Construction Materials | HardiPlank Type |
| Year Built | 1863 |
| Property Subtype | Single Family Residence |
| Tax Year | 2024 |
| Parcel Number | 333489-010-000-0001-005.200-0000 |
| Waterfront Features | Pond,Stream |
| County | Orange County |
| Property Type | Residential |
| HOA | No |
| Garage Y/N | Yes |
| Other Structures | Barn(s),Garage(s),Guest House,Kennel/Dog Run,Outbuilding,Stable(s) |
| Total Rooms | 12 |
| Full Baths | 3 |
| Directions | NY Routes 207 or 208 to Sarah Wells Trail |
| High School | Washingtonville Senior High School |
| City | Hamptonburgh |
| Disclosures | Lead Paint,Seller Property Disclosure |
| Senior Community Y/N | No |
| High School District | Washingtonville |
| Carport Spaces | 1 |
| Carport Y/N | Yes |
| Elementary School | Little Britain Elementary School |
| Property Attached Y/N | No |
| Tax Annual Amount | 20737.1 |
| Middle/Junior High School | Washingtonville Middle School |
| Property Condition | Estimated,Updated/Remodeled |
| Additional Parcels Y/N | Yes |
| Building Area Units | Square Feet |
| Standard Status | Active |
| Middle/Junior School District | Washingtonville |
| Elementary School District | Washingtonville |
| Tax Assessed Value | 761600 |
| Tax Lot | 6 |
| Virtual Tour | https://my-property-photography.aryeo.com/sites/247-sarah-wells-trail-campbell-hall-ny-10916-4661517/branded |
| PostalCity | Campbell Hall |
| Listing Appliances | Stainless Steel Appliance(s), Oil Water Heater |
Interior Features
| Interior Amenities | Formal Dining,Granite Counters,High Ceilings,Kitchen Island,Open Kitchen,Original Details,Walk Through Kitchen,Walk-In Closet(s),Wet Bar |
|---|---|
| Basement | Unfinished |
| Flooring | Hardwood |
| Formal Dining | Yes |
| Basement Features | Unfinished |
| Basement (Y/N) | Yes |
| Fireplace Y/N | No |
| Half Baths | 1 |
| Total Bedrooms | 6 |
| Total Baths | 4 |
| General Features | Formal Dining,Granite Counters,High Ceilings,Kitchen Island,Open Kitchen,Original Details,Walk Through Kitchen,Walk-In Closet(s),Wet Bar |
| Walk-In Closet | Yes |
Exterior Features
| Exterior Amenities | Dog Run,Rain Gutters |
|---|---|
| Parking Features | Carport,Detached,Other |
| Water Source | Private |
| Total Parking | 3 |
| Parking Spaces | 3 |
| Parking Features | Carport, Detached, Other |
| Foundation Details | Pillar/Post/Pier |
| Waterfront Y/N | Yes |
| General Features Ext. | Dog Run,Rain Gutters |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
Property vs Single Family Average in 10916
Price
Taxes
Year Built
Visits
Based on information from California Regional Multiple Listing Service, Inc. as of September 19, 2026 8:50 PM UTC This information is for your personal, non-commercial use and may not be used for any purpose other than to identify prospective properties you may be interested in purchasing. Display of MLS data is usually deemed reliable but is NOT guaranteed accurate by the MLS. Buyers are responsible for verifying the accuracy of all information and should investigate the data themselves or retain appropriate professionals. Information from sources other than the Listing Agent may have been included in the MLS data. Unless otherwise specified in writing, Broker/Agent has not and will not verify any information obtained from other sources. The Broker/Agent providing the information contained herein may or may not have been the Listing and/or Selling Agent.
The data relating to real estate for sale on this web site comes in part from the INTERNET DATA EXCHANGE Program of the Greater Las Vegas Association of REALTORS® MLS. Real estate listings held by brokerage firms other than this site-owner are marked with the IDX logo. The information being provided is for the consumers' personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
Based on information from California Desert Association of Realtors as of September 19, 2026 8:25 PM UTC The information being provided by California Desert Association of Realtors, SoCalMLS, CRISNet MLS, and CARETS is for the consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumer may be interested in purchasing. Any information relating to real estate for sale referenced on this web site comes from the Internet Data Exchange
Copyright 2026 by the REALTORS® Association of Edmonton. All rights reserved.
Data is deemed reliable but is not guaranteed accurate by the REALTORS® Association of Edmonton.
The trademarks REALTOR®, REALTORS® and the REALTOR® logo are controlled by The Canadian Real Estate Association (CREA) and identify real estate professionals who are members of CREA. The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by CREA and identify the quality of services provided by real estate professionals who are members of CREA. Used under license.
Information last updated on September 19, 2026 8:50 PM UTC
Data is supplied by Pillar 9™ MLS® System. Pillar 9™ is the owner of the copyright in its MLS® System. Data is deemed reliable but is not guaranteed accurate by Pillar 9™. The trademarks MLS®, Multiple Listing Service® and the associated logos are owned by The Canadian Real Estate Association (CREA) and identify the quality of services provided by real estate professionals who are members of CREA. Used under license.
The data relating to real estate for sale on this web site comes in part from the Broker Reciprocity program of the Northern Nevada Regional Multiple Listing Service®. Real estate listings held by brokerage firms other than the owner of this site are marked with the Broker Reciprocity logo and detailed information about those listings includes the name of the listing brokerage. Copyright 2026 of the Northern Nevada Regional Multiple Listing Service MLS. All rights reserved.
The data relating to real estate for sale on this web site comes in whole or in part from the SISKIYOU Internet Data Exchange program of the Siskiyou Multiple Listing Service. Information being provided is for consumer's person, ie, non-commercial use and may NOT be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The information provided in these real estate listings has been assembled from various sources of varying degrees of reliability.
Wyoming Multiple Listing Service - Casper Board of REALTORS® All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties
Copyright ©2026 Lowcountry Regional Multiple Listing Service. Information is deemed reliable but not guaranteed. Information is provided exclusively for the consumer's personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Last Updated: September 19, 2026 8:47 PM UTC
REALTOR® Association of Southern Kentucky All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may
Listing data provided by: Central Panhandle Association of Realtors (CPAR)
Information deemed reliable but not guaranteed. The information is provided exclusively for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.
The data relating to real estate for sale on this web site comes in part from the Internet Data Exchange (IDX) program of the Mid GA MLS. Real estate listings held by brokerage firms other than Development are marked with the listing brokers name and detailed information about such listings includes the name of the listing broker. Data provided is deemed reliable but is not guaranteed.
© BRIGHT, All Rights Reserved
The information being provided is for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Listing data being provided is updated in real-time. Sources for listing data may include the local government offices such as Tax Assessor, Tax Commissioner and school authorities, as well as appraisers and other sources. This site may not include all listings available through the MLS.
INFORMATION
Greater Erie Board of Realtors® Inc. All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be
All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data relating
The data relating to real estate for sale on this site comes from the Broker Reciprocity/IDX of Columbus REALTORS ®. No warranties, expressed or implied, are provided for the data herein, or for their use or interpretation by the user. Columbus REALTORS ® does not create, control or review the property data displayed herein and take no responsibility for the content of such records. Federal law prohibits discrimination on the basis of race, color, religion, sex, handicap, familial status or national origin in the sale, rental or financing of housing. IDX information is provided exclusively for consumers personal, non-commercial use, that it may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing, and that the data is deemed reliable but is not guaranteed accurate by the MLS. Information deemed reliable but not guaranteed. Copyright © 2026 Columbus REALTORS ® All rights reserved. Last Updated: September 19, 2026 8:49 PM UTC
Huntington Board of REALTORS® All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data relating to real estate for sale on this website comes in part from the Internet Data Exchange program of the Multiple Listing Service. Real estate listings held by brokerage firms other than Development may be marked with the Internet Data Exchange logo and detailed information about those properties will include the name of the listing broker(s) when required by the MLS. Copyright ©2026 All rights reserved.
Last Updated: September 19, 2026 8:26 PM UTC
Grand Island Board of Realtors® All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested
All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data relating
All information deemed reliable but not guaranteed. All properties are subject to prior sale, change or withdrawal. Neither listing broker(s) or information provider(s) shall be responsible for any typographical errors, misinformation, misprints and shall be held totally harmless. Listing(s) information is provided for consumer's personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The data relating
OneKey® MLS required Copyright, Source of Data and Disclaimer for IDX display
Information Copyright 2026, OneKey® MLS. All Rights Reserved.
The source of the displayed data is either the property owner or public record provided by non-governmental third parties. It is believed to be reliable but not guaranteed. This information is provided exclusively for consumers' personal, non-commercial use.
The data relating to real estate for sale on this website comes in part from the
