HomeAboutServicesSearchListingsMarket ActivityBlogContact
$1,750,00015015 Ascot Hills Drive S
For Sale106 days on market

15015 Ascot Hills Drive S

Carmel, Indiana 46032

Village Farms

$1,750,000

$1,999,900

Schedule a Showing

5

Beds

7

Baths

4,793

Sq Ft

1978

Year Built

3.34

Acres

Sheldon Barnes, Carmel Realtor

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.

Follow

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.

Listed by Marianne Piazzi· Encore Sotheby's International· MLS# 22074414

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

  1. Price reduced$1,999,900 → $1,750,000

    Apr 6, 2026

  2. Listedat $1,999,900

    Dec 1, 2025

Sold
16
Median price
$601,000
Median DOM
6 days

Comparative value

5 comps in this range

This home is 92% above median for similar nearby sales.

$675K$1.2MMedian $910K
$1.8M

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

Entrance FoyerHardwood FloorsEat-in KitchenWalk-In Closet(s)Wet Bar

Exterior

Sprinkler System

Climate

Heat: ElectricHeat: Forced AirHeat: Heat PumpCool: Central Air

AI-detected from photos

Vibe:traditionalupdated

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

Main
8 rooms2,338 sq ft
Upper
546 rooms1,512 sq ft
Basement
14 rooms943 sq ft finished

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

  • High

    Westfield High School

    2.6 mi

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

Powered by Ackee.ai