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 a 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
Massachusetts MLS Property Info Network (MLSPIN) - The property listing data and information set forth herein were provided to MLS Property Information Network, Inc. from third party sources, including sellers, lessors and public records, and were compiled by MLS Property Information Network, Inc. The property listing data and information are for the personal, non commercial use of consumers having a good faith interest in purchasing or leasing listed properties of the type displayed to them and
Copyright© 2026 REIN Inc. Information Deemed Reliable But Not Guaranteed. The listings data displayed on this medium comes in part from the Real Estate Information Network Inc.(REIN) and has been authorized by participating listing Broker Members of REIN for display. REIN's listings are based upon Data submitted by its Broker Members, and REIN therefore makes no representation or warranty regarding the accuracy of the Data. All users of REIN's listings database should confirm the accuracy of
© 2011 HiCentral MLS, Ltd. Information is deemed reliable but not guaranteed. Based on information from the Multiple Listing Service of Hicentral MLS, Ltd. Listings last updated on September 25, 2026 9:58 AM UTC Some of the active listings appearing on this site may be listed by other REALTORS®. We are only showing FEE SIMPLE, ACTIVE listings on this website.
Copyright 2026 PrimeMLS. All rights reserved. This information is deemed reliable, but not guaranteed. The data relating to real estate displayed on
this Site comes in part from the IDX Program of PrimeMLS. 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. Data last updated September 25, 2026 9:51 AM UTC
©2026 Georgia Multiple Listing Service 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
MIBOR REALTOR® Association 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 Mobile Officez 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 25, 2026 9:47 AM UTC
© MLS Now, INC - Northern Ohio Regional Multiple Listing Service 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
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.
Washington County 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
Iron County MLS® (ICBOR) 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
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