HomeAboutServicesSearchAI ToursListingsMarket ActivityBlogContact
Free Carmel Home Seller Guide

FREE GUIDE FROM SHELDON

Thinking about what your home is worth?

Most people checking their own address are considering a move. Whether you're upsizing, downsizing, or just exploring — my free seller guide walks through pricing strategy, prepping for market, photography that sells, and what to expect at closing.

Get the seller guide
Sheldon Barnes, Carmel Realtor

Is this your home?

Sheldon Barnes can help you list 2171 Mildred Rd

Sheldon Barnes is a Carmel realtor and licensed real estate agent serving Westfield, Indiana and the rest of Hamilton County. Whether you're ready to sell 2171 Mildred Rd in Westgate or just curious what your home is worth in today's Westfield market, he can put together a no-pressure valuation.

Follow

ABOUT THIS HOME

This former Endeavor model home in Westgate is the perfect blend of modern style, smart design, and everyday convenience-crafted for how you really live. With three bedrooms, two-and-a-half baths, and a versatile loft, every space is packed with designer details and thoughtful upgrades. Step inside to an open-concept layout where the Great Room makes a statement with a custom wood accent wall and built-in TV cabinets. The kitchen and dining area flow effortlessly, designed for both laid-back nights in and entertaining friends or guests. A stylish main-floor bath with a stunning tile accent wall adds a touch of personality and sophistication. Upstairs, the loft is the ultimate flex space-whether you need a cozy reading nook, home office, or play area, the built-in floating shelves and accent wall paint make it extra inviting. The spacious Owner's Suite is a retreat of its own, complete with a decorative chandelier and walk-in closet, while the secondary bedrooms feature designer lighting and built-ins that add both charm and function. This home is designed for low-maintenance living, with premium landscaping, an irrigation system, and a security system already in place. Plus, living in Westgate means access to resort-style amenities, including a clubhouse, three pools, sports courts, and recreation fields. With Grand Park Sports Complex, Midland Trace Trail, and Grand Junction Plaza just minutes away-not to mention quick access to SR-32 and US-31-you get the best of Westfield with an easy commute to Indy. Style, convenience, and an unbeatable location-this stunning former model home is ready for you!

Listed by Erin Hundley· Compass Indiana, LLC· MLS# 22026283
SoldSold in 32 days

$320,000

3Beds
2.1Baths
1,736Sq Ft

This former Endeavor model home in Westgate is the perfect blend of modern style, smart design, and everyday convenience-crafted for how you really live. With three bedrooms, two-and-a-half baths, and a versatile loft, every space is packed with designer details and thoughtful upgrades. Step inside ...

Listed by Erin Hundley· Compass Indiana, LLC· MLS# MBR22026283

1,816

Sq Ft

2021

Year Built

0.07

Acres

Off Market

Status

$266,200

Assessed Value

3

Bedrooms

Key things to know

  • Sold 1.7% below list in 32 days
  • Westgate subdivision

Sold

$314,500

-$5,500 below list (-1.7%)

Closed
Jun 2, 2025
Listed at
$320,000
Sold
11 months ago
Sold in
32 days

Price history

  1. Sold$314,500

    Jun 2, 2025

  2. Listedat $320,000

    Apr 2, 2025

Sold
14
Median price
$490,000
Median DOM
36 days

Comparative value

5 comps in this range

This home is 21% below median for similar nearby sales.

$265K$561KMedian $400K
$315K

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.

Sheldon Barnes

Sheldon Barnes

Real Estate Agent · Carmel Realty LLC

License No. RB21000235

FEATURES & AMENITIES

Interior

Attic AccessWalk-In Closet(s)Wood Work PaintedBreakfast BarKitchen IslandPantrySmart Thermostat

Exterior

Smart Lock(s)

Climate

Heat: High Efficiency (90%+ AFUE )Heat: Natural GasCool: Central Air

THE FACTS

Pricing trajectory, room-by-room layout, schools, and what's nearby.

Price history

  • $320,000Listed· Apr 2, 2025

32 days on market

Layout

Main
3 rooms667 sq ft
Upper
325 rooms1,069 sq ft

Primary suite

Closet Walk in

Primary bath

Shower Stall Full,Sinks Double

Schools

Westfield-Washington Schools

  • Elementary

    Shamrock Springs Elementary School

  • Middle

    Westfield Middle School

  • High

    Westfield High School

    3.9 mi

Neighborhood

  • Westfield High School3.9 mi
  • Clay Terrace4.4 mi
  • Carmel Central Park5.0 mi
  • Zionsville Community HS5.6 mi
  • Carmel Arts & Design District5.7 mi
  • Carmel High School6.2 mi

OFF-MARKET PROPERTY DETAILS

Living Area

1,816 sq ft

Year Built

2021

Stories

Two

Lot Size

0.07 acres

Subdivision

Westgate

Section 1

Bedrooms

3

Bathrooms

2 full, 1 half

Garage

2 spaces

School District

Westfield-Washington Schools

TAX ASSESSMENT

Hamilton County assessed values for current year

Total Assessed Value

$266,200

Land Value

$75,000

Land$75,000

28% of total

Improvement Value

$191,200

Improvements$191,200

72% of total

Annual tax · 2024
$2,882

PARCEL & LEGAL

Lot / Section

Section 1

Powered by Ackee.ai