
Sheldon Barnes
For Sale — 15015 Ascot Hills Drive S, Carmel, IN 460325
Beds
7
Baths
4,793
Sq Ft
1978
Year Built
3.34
Acres
Schedule a tour or ask a question
Sheldon Barnes can help you tour 15015 Ascot Hills Drive S
Sheldon Barnes is a Carmel realtor and licensed real estate agent serving Carmel, Indiana and the rest of Hamilton County. Book a private tour of 15015 Ascot Hills Drive S in Village Farms, ask any question about this home, or talk through what you should know about buying in Carmel.
ABOUT THIS HOME
An iconic all-brick American Classic, this stately Colonial estate is thoughtfully set on approximately 3.4 acres in a desirable Westfield estate setting bordering Carmel. Beautifully traditional in its construction, the home is tucked at the end of a cul-de-sac with direct Monon Trail access and no HOA. Grand in scale yet warmly livable, the home has been cared for by the original owners with exceptional attention. Its timeless architecture, traditional craftsmanship, and enduring materials offer a compelling opportunity for thoughtful modernization, allowing the next owner to tailor the home while preserving its classic character. A gracious foyer with a sweeping staircase and traditional millwork sets the tone, leading to generously proportioned living and entertaining spaces. A private main-level office offers a quiet, dedicated work-from-home space, while the kitchen features a center island and opens to a breakfast room and adjoining sunroom, creating a natural flow for everyday living. A refined entertaining wing includes a family room with fireplace, bar, wine storage, beverage refrigeration, and a butler's pantry ideal for both intimate and large gatherings. All bedrooms are located on the upper level, including a spacious primary suite with sitting area, walk-in closet, and generous bath, along with two additional en suite bedrooms and a large, versatile bonus room. The finished basement provides additional living space and abundant storage. Exceptionally cared for and beautifully livable as it stands, the home also presents a rare blend of privacy, character, and long-term possibility.
Key things to know
- 3.4-acre lot in cul-de-sac with direct monon trail access
- Gracious foyer with sweeping staircase and traditional millwork
- Primary suite with sitting area and walk-in closet
- Entertaining wing with bar, wine storage, and butler's pantry
- Finished basement with abundant storage
Browse by room
18 rooms · 66 photos
Monthly payment
Estimate · $1,750,000
$9,818/mo
≈ $9,314 principal & interest · $504 tax
Estimate only. Actual payment depends on lender, taxes, insurance, and HOA. Down payment $350,000 on a loan of $1,400,000.
Price history
- Price reduced$1,999,900 → $1,750,000
Apr 6, 2026
- Listedat $1,999,900
Dec 1, 2025
Village Farms · activity
past 6 months
- Sold
- 16
- Median price
- $601,000
- Median DOM
- 6 days
Recent comparable sales

$1,176,000
13338 Berwick Lane
5bd · 5ba · 4,449 sqft
Sold Jun 2026

$910,000
1534 Jensen Drive
6bd · 5ba · 5,228 sqft
Sold Jun 2026

$725,000
13777 Smokey Hollow Court
4bd · 3ba · 3,977 sqft
Sold Jun 2026

$915,500
1644 Caspian Drive
5bd · 4ba · 4,892 sqft
Sold Jun 2026

$675,000
3627 Patriot Court
4bd · 3ba · 4,319 sqft
Sold Jun 2026
Comparative value
5 comps in this range
This home is 92% above median for similar nearby sales.
Estimated values and comparable-sales ranges shown here are for informational purposes only. They are derived from public records and recent MLS sales, are not an appraisal or formal Comparative Market Analysis (CMA), and should not be used as the sole basis for any pricing, purchase, sale, or financing decision. For an accurate market value of a specific property, contact Sheldon Barnes for a personalized CMA.
AI-curated highlights
INSIDE THIS HOME
FEATURES & AMENITIES
Interior
Exterior
Climate
AI-detected from photos
THE FACTS
Pricing trajectory, room-by-room layout, schools, and what's nearby.
Price history
$1,999,900Listed· Dec 1, 2025
$1,750,000Reduced
↓ $249,900 (12.5% off original)
106 days on market
Layout
Primary suite
Closet Walk in,Sitting Room
Primary bath
Sinks Double,Suite,Tub Full with Separate Shower
Schools
Westfield-Washington Schools
Middle
Westfield Middle School
- 2.6 mi
High
Westfield High School
Neighborhood
- Clay Terrace1.1 mi
- Carmel Arts & Design District2.2 mi
- Westfield High School2.6 mi
- Carmel High School2.8 mi
- Carmel Central Park3.1 mi
- Monon Trail (Carmel)3.4 mi
PROPERTY DETAILS
Combined data from the listing and Hamilton County records
Living Area
4,793 sq ft
Year Built
1978
Stories
Two
Subdivision
Village Farms
Bedrooms
5
Bathrooms
5 full, 2 half
Garage
3 spaces
School District
Westfield-Washington Schools
