Property Attributes
- ID#1017994
- TypeSingle Family
- Listing Status Active
- CountyWESTCHESTER
- CityChappaqua
- Zip10514
- StyleColonial,Estate
- Year Built1991
- Taxes$ 96392
- Price$ 5,750,000
- Bedrooms6
- Full Bathrooms7
- Half Bathrooms1
- Sqr Footage9247
- Lot Size9.078 Acres
Data Source:
Listings courtesy of OneKey® MLS as distributed by MLS GRID
Property Description
Welcome to 24 Trails End, an unparalleled private resort estate redefining luxury living on over 9 pristine, park-like acres. This majestic brick Colonial, quietly positioned at the end of a prestigious cul-de-sac, overlooks its scenic, spring-fed pond. Inside, classic architectural sophistication meets modern design, highlighted by a soaring double-height great room, dual home offices, and a rich mahogany billiard room with a wet bar and fireplace. The heart of the home is an expansive chef's kitchen, with an oversized marble island, and a sunny breakfast area. The lower level is an extraordinary recreation destination, boasting a 2600 sqft indoor sports court lined for basketball and pickleball, alongside a full home gym. Step outside to your private backyard paradise with an inviting heated Gunite pool, integrated spa, and a pool house/cabana surrounded by sprawling bluestone terraces and meandering walking trails. Two firepits located around the property and a serene pond with an island, an additional firepit and two docks for unmotorized boat usage complete this spectacular picture. An ultra-private lifestyle compound in the award winning Chappaqua schools, just under an hour from Manhattan.
| Elementary School | Middle School | High School |
|---|---|---|
| Roaring Brook Elementary School | Seven Bridges Middle School | Horace Greeley High School |
| Price History | |
|---|---|
| 9/14/2026 | Listed $5,750,000 |
General Features
| Sewer | Septic Tank |
|---|---|
| Heating | Baseboard,Forced Air,Oil,Radiant |
| Cooling | Central Air |
| Utilities | Trash Collection Public |
| Appliances | Cooktop,Dishwasher,Dryer,Exhaust Fan,Freezer,Microwave,Oven,Refrigerator,Washer |
| Garage Spaces | 3 |
| Patio/Porch Features | Deck,Patio,Porch |
| Architectural Style | Colonial,Estate |
| Pool Features | In Ground,Pool/Spa Combo |
| Security Features | Security System |
| Construction Materials | Brick,Frame |
| Year Built | 1991 |
| View | Water |
| Property Subtype | Single Family Residence |
| Tax Year | 2026 |
| Parcel Number | 3600-081-020-00003-000-0010 |
| Waterfront Features | Water Access |
| County | Westchester County |
| Property Type | Residential |
| HOA | No |
| Garage Y/N | Yes |
| Other Structures | Pool House |
| Total Rooms | 16 |
| Full Baths | 7 |
| Directions | Roaring Brook Rd to Kerry Lane to Paula Place to Trails End to #24. |
| High School | Horace Greeley High School |
| City | New Castle |
| Senior Community Y/N | No |
| High School District | Chappaqua |
| Carport Y/N | No |
| Elementary School | Roaring Brook |
| Property Attached Y/N | No |
| Tax Annual Amount | 96392 |
| Middle/Junior High School | Seven Bridges Middle School |
| Property Condition | Actual |
| Additional Parcels Y/N | No |
| Building Area Units | Square Feet |
| Standard Status | Active |
| Middle/Junior School District | Chappaqua |
| Elementary School District | Chappaqua |
| Tax Assessed Value | 572600 |
| PostalCity | Chappaqua |
| AttributionContact | 914-228-2656 |
| Balcony Y/N | Yes |
| Listing Appliances | Cooktop, Dishwasher, Dryer, Exhaust Fan, Freezer, Microwave, Oven, Refrigerator, Washer |
Interior Features
| Interior Amenities | Cathedral Ceiling(s),Eat-in Kitchen,Entrance Foyer,Formal Dining,First Floor Bedroom,Primary Bathroom,Pantry,Walk-In Closet(s) |
|---|---|
| Basement | Finished,Full |
| Total Fireplaces | 4 |
| Formal Dining | Yes |
| Basement Features | Finished, Full |
| Basement (Y/N) | Yes |
| Window Features | Skylight(s) |
| Fireplace Y/N | Yes |
| Half Baths | 1 |
| Total Bedrooms | 6 |
| Eat-in Kitchen | Yes |
| Total Baths | 8 |
| General Features | Cathedral Ceiling(s),Eat-in Kitchen,Entrance Foyer,Formal Dining,First Floor Bedroom,Primary Bathroom,Pantry,Walk-In Closet(s) |
| Walk-In Closet | Yes |
| Entrance Foyer | Yes |
Exterior Features
| Exterior Amenities | Balcony |
|---|---|
| Parking Features | Attached |
| Water Source | Public |
| Parking Features | Attached |
| Spa | Yes |
| Waterfront Y/N | Yes |
| Other Equipment | Generator |
| Road Responsibility | Public Maintained Road |
| General Features Ext. | Balcony |
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
Based on information from California Regional Multiple Listing Service, Inc. as of September 16, 2026 8:16 AM 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 16, 2026 8:21 AM 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 16, 2026 8:16 AM 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 16, 2026 6:40 AM 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 16, 2026 8:19 AM 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 16, 2026 8:13 AM 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