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 2037 Stanhope St

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

Follow

ABOUT THIS HOME

Nestled in the heart of the esteemed Village of WestClay, this custom William Gordon estate blends timeless design with modern elegance. Boasting five bedrooms, four full and two half baths, this residence offers over $300,000 in premium upgrades, delivering a lifestyle defined by craftsmanship, comfort, and class. A sweeping covered front porch opens to a grand barrel-ceiling foyer, setting the tone for the home's elevated aesthetic. The formal sitting room overlooks a private courtyard oasis, an entertainer's dream, complete with a heated gunite pool, automatic cover, professionally landscaped grounds, and a newly refinished patio ideal for refined outdoor gatherings. Thoughtfully designed for both everyday living and hosting, the main level features an oversized executive office, an updated powder room, and a soaring great room anchored by a dramatic gas fireplace. The chef's kitchen serves as the heart of the home, showcasing granite countertops, premium stainless steel appliances including a 48" Wolf Range, a new dishwasher, statement lighting, and an expansive island. A dual-entry butler's pantry offers ample storage and a discreet laundry station for ultimate convenience. Adjacent to the kitchen, a sunlit breakfast nook offers views of the pool, while a spacious mudroom provides access to a second guest powder room and a pristine three-car garage with new epoxy flooring. The upper level hosts a serene primary suite complete with a private balcony, spa-like bath featuring dual vanities, a whirlpool tub, walk-in shower, and a custom dressing room. Additional accommodations include a Jack-and-Jill suite, private guest suite, and a second laundry room for added functionality. The lower level is tailored for leisure and entertaining, featuring a theater-ready media space, a full wet bar, new luxury vinyl plank flooring, a fifth bedroom and full bath, and two expansive storage rooms easily adaptable as a gym, wine cellar, or playroom.

Listed by Katie Byram· The Agency Indy· MLS# 22039065
SoldSold in 3 days

$1,475,000

5Beds
4.2Baths
5,119Sq Ft

Nestled in the heart of the esteemed Village of WestClay, this custom William Gordon estate blends timeless design with modern elegance. Boasting five bedrooms, four full and two half baths, this residence offers over $300,000 in premium upgrades, delivering a lifestyle defined by craftsmanship, com...

Listed by Katie Byram· The Agency Indy· MLS# MBR22039065

5,431

Sq Ft

2005

Year Built

0.27

Acres

Off Market

Status

$1,053,800

Assessed Value

5

Bedrooms

Key things to know

  • Sold 2.1% below list in 3 days
  • Private pool
  • Spa / hot tub
  • Fireplace
  • Finished basement (1,247 sqft)

Sold

$1,444,000

-$31,000 below list (-2.1%)

Closed
Jun 24, 2025
Listed at
$1,475,000
Sold
11 months ago
Sold in
3 days

Price history

  1. Sold$1,444,000

    Jun 24, 2025

  2. Listedat $1,475,000

    May 16, 2025

Sold
45
Median price
$935,000
Median DOM
8 days

Comparative value

5 comps in this range

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

$547K$2.6MMedian $1.2M
$1.4M

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

High CeilingsKitchen IslandEntrance FoyerPaddle FanHardwood FloorsEat-in KitchenWired for DataPantrySmart ThermostatWalk-In Closet(s)

Exterior

BalconyLightingSmart Light(s)Smart Lock(s)Tennis Community

Climate

Heat: Forced AirHeat: Natural GasCool: Central Air

THE FACTS

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

Price history

  • $1,475,000Listed· May 16, 2025

3 days on market

Layout

Main
5 rooms1,935 sq ft
Upper
434 rooms1,937 sq ft
Basement
112 rooms1,247 sq ft finished

Primary suite

Balcony,Closet Walk in,Deck

Primary bath

Sinks Double,Tub Full with Separate Shower

Schools

Carmel Clay Schools

  • Middle

    Creekside Middle School

Neighborhood

  • Carmel Central Park2.1 mi
  • Zionsville Community HS2.7 mi
  • Clay Terrace3.7 mi
  • Carmel High School4.4 mi
  • Carmel Arts & Design District4.4 mi
  • Monon Trail (Carmel)4.5 mi

OFF-MARKET PROPERTY DETAILS

Living Area

5,431 sq ft

Year Built

2005

Stories

Two

Lot Size

0.27 acres

Subdivision

Village of Westclay

Bedrooms

5

Bathrooms

4 full, 2 half

Garage

3 spaces

School District

Carmel Clay Schools

TAX ASSESSMENT

Hamilton County assessed values for current year

Total Assessed Value

$1,053,800

Land Value

$204,500

Land$204,500

19% of total

Improvement Value

$849,300

Improvements$849,300

81% of total

Annual tax · 2024
$10,096
Exemption
Homestead

PARCEL & LEGAL

Powered by Ackee.ai