Property Attributes
- MLS#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
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