- 0
- 10
- Overview
- Description
- Property Details
- Location
- Facts & Features
- Getting Around
- Nearby Homes
5 days ago
Street View
$5,750,000
Monthly Est:$28,620
6 Beds
8 Baths7 full baths + 1 half bath
9,247sqft
24 Trails End, New Castle, NY 10514
$5,750,000
$28,620/moEst:
Get Pre-Approved
Single Family Residence
Built in 1991
$-- HOA
9.08 acres lot
$622/sq.ft
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 b...
Continue Reading- Houzeo last checked: 6 minutes ago
- Listing updated: September 17, 2026 at 4:09 pm
- Listing Provided by: Brian Milton (914) 469-9889 | Compass Greater NY, LLC (914) 228-2656
- Source: OneKey MLS-NY | MLS#: 1017994
Property Details
Status
Active
Type
Single Family Residence
No. of Stories
-
County
City
Neighborhood
--
Year Built
1991
HOA Fees
-
Finished Area
9,247 sqft
Lot Size
9.08 acres lot
Basement Area
- sqft
MLS Name
OneKey MLS
MLS Number
1017994
MLS Status
Active
Days on Market
5
Cumulative Days on Market
3
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Download App
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Facts & Features
Rooms
Bedrooms & bathrooms
Bedrooms: 6
Bathrooms: 8
Interior
Interior Features
Cathedral Ceiling(s), Eat In Kitchen, Entrance Foyer, Formal Dining, First Floor Bedroom, Primary Bathroom, Pantry, Walk In Closet(s)
Exterior Features
Balcony
Window Features
Skylight(s)
Cooling
Central Air
Sewer
Septic Tank
Heating
Baseboard, Forced Air, Oil, Radiant
Appliances
Cooktop, Dishwasher, Dryer, Exhaust Fan, Freezer, Microwave, Oven, Refrigerator, Washer
Construction
Year Built
Year Built: 1991
Home type
Single Family Residence
Construction Materials
Brick, Frame
Architectural Style
Colonial, Estate
Property Condition
Actual
Utilities & Energy
Utilities
Trash Collection Public
Parking Features
Attached
Basement
Finished, Full
Water Source
Public
Pool Features
In Ground, Pool/spa Combo
Security Features
Security System
Other Features
Lot Features
Landscaped, Part Wooded, Stone/brick Wall, Views
Patio And Porch Features
Deck, Patio, Porch
Price History
| Date | Event | Price |
|---|---|---|
09/14/2026 Source: | Listed for Sale | $5,750,000 $622/sqft |
Nearby Homes
Find Homes by Property Features in New Castle, NY
Based on information from OneKey MLS, through Sep 20, 2026, 06:01AM. IDX information is provided exclusively for personal, non-commercial use, and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. Information is deemed reliable but not guaranteed. © 2026 OneKey® MLS. All rights reserved.
Advertising Broker: Mark Karten | Karten Real Estate Services
Love this home?
Here's 4 things you can do
Your local real estate expert. Speak directly with agent about the home & pricing.
Book your private tour
as early as Today at 09:00 AM
Rates starting from 6.3%. Secure financing early to move quickly when you're ready.
Fastest way to get your offer in. Speak directly with agent to negotiate the offer.
Houzeo Corp. holds real estate brokerage licenses in Alabama (License No. 000157023 - 0) and Texas (License No. 9013396)
TREC: Info About Brokerage Services, Consumer Protection Notice.
§ 442‑H New York Standard Operating Procedure.
New York State Fair Housing Notice.
