2037 Stanhope Street
Carmel, IN 46032
- 5 beds
- 6 baths
- 5,119 sqft
- 11,761 sqft lot
- $283 per sqft
- 2005 build
More homes
Welcome to this remarkable William Gordon custom built 5 bed, 4 full+2 half bath home, centrally located in the desirable Village of WestClay. Beyond the expansive covered front porch and into the foyer that features a barrel ceiling, you'll immediately feel the seamless traditional yet modern design. The front sitting room is a welcome respite to take in views of the beautiful outdoor courtyard that features a heated gunite pool w/auto cover, separate jacuzzi, custom landscaping and a freshly painted/sealed patio. Just past the oversized office and updated powder room is the spacious great room w/gas fireplace, and newly built-in entertainment center. The open space flows into a chef's kitchen finished with SS appliances, new dishwasher, granite counters, new light fixtures, an oversized center island and premium 6 burner 48" Wolf Range. The double entry butler's pantry is filled with ample storage and a new stackable washer/dryer for added convenience. Enjoy a meal while taking in the views of the pool from the bright window filled dining nook. Hardwood floors span both the main and upper levels and have been refinished with a beautiful modern ebony and ivory stain. At the rear of the house you will find the mudroom with lockers, a 2nd powder bath perfect for pool guests and a spacious 3-car garage complete with new epoxy flooring. Upstairs the Primary Suite features a balcony with Pella slider, a spa like bathroom has separate back to back vanities, a whirlpool tub, large separate shower and custom walk in closet. Bedrooms 2 & 3 are connected by a Jack-n-Jill bathroom, Bedroom 4 has an en suite bathroom. Main laundry room is located upstairs for added convenience. The lower level is ideal for entertaining and is equipped with a theater-ready setup, wired for audio, features new LVP flooring, a 5th bedroom, full bathroom, bar area with sink, and 2 large storage rooms or if built out, a flex space. With over $300K+ of upgrades, this home is truly a treasure!
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated May 16, 2025
•
MLS# 21975205 —
The Building
-
Year Built:2005
-
New Construction:false
-
Construction Materials:Brick, Cement Siding
-
Architectural Style:Italianate
-
Levels:Two
-
Basement:true
-
Basement:Ceiling - 9+ feet, Daylight/Lookout Windows, Egress Window(s), Storage Space
-
Foundation Details:Poured Concrete
-
Patio And Porch Features:Covered Porch, Deck UP, Open Patio
-
Exterior Features:Balcony, Lighting, Smart Light(s), Smart Lock(s), Tennis Community
-
Accessibility Features:No
-
Smart Home Features:Thermostat - Programmable
-
Direction Faces:North
-
Green Certification:No
-
Upper SqFt:1937
-
Building Area Total:5431
-
Below Grade Finished Area:1247
Interior
-
Rooms:9
-
Rooms Total:11
-
Rooms Total:9
-
Interior:Bath Jack-n-Jill,Living Room Formal
-
Interior Features:Raised Ceiling(s), Center Island, Entrance Foyer, Paddle Fan, Hardwood Floors, Eat-in Kitchen, Network Ready, Pantry, Programmable Thermostat, Walk-in Closet(s), Window Bay Bow
-
Kitchen Features:Kitchen Some Updates
-
Other Equipment:Radon System, Security Alarm Monitored, Security Alarm Paid, Smoke Alarm, Sump Pump Dual, Sump Pump w/Backup
-
Eating Area:Dining Combo/Kitchen
-
Laundry Features:Main Level, Upper Level
-
Fireplaces Total:1
-
Fireplace Features:Gas Log, Great Room
Room Dimensions
-
SqFt:3872
-
Main Level SqFt:1935
-
Living Area:5119
Financial & Terms
-
Buyer Financing:Conventional
Location
-
Directions:GPS Friendly
-
Latitude:39.970436
-
Longitude:-86.200801
The Property
-
View:true
-
Property Type:Residential
-
Property Subtype:Single Family Residence
-
Property Attached:false
-
Parcel Number:290928020002000018
-
Acres:1/4-1/2 Acre
-
Lot Features:Curbs, Sidewalks, Street Lights
-
Lot Size Acres:0.27
-
Lot Size SqFt:11,761 Sqft
-
Price Per Acre:5370370
-
Property Condition:Updated/Remodeled
-
Additional Parcels:false
-
View:false
-
Waterfront:false
-
Fencing:Fence Complete, Gate, Wrought Iron
-
Horse Amenities:None
-
Fence:Yes
Listing Agent
- Contact info:
- Agent phone:
- (303) 669-4425
- Office phone:
- (303) 669-4425
Taxes
-
Tax Lot:629
-
Tax Year:2023
-
Tax Exemptions:Homestead Tax Exemption
-
Semi Annual Property Tax Amt:4367
Beds
-
Beds:4
-
Bedrooms:4
-
Bedrooms Total:5
-
Primary Bedroom Description:Balcony,Closet Walk in,Deck
-
# of Bedrooms Upper:4
-
# of Bedrooms Basement:1
Baths
-
Baths:6
-
Full Baths:4
-
Full Baths:3
-
Half Baths:2
-
Half Baths:2
-
Half Baths Main:2
-
Full Baths Upper:3
-
Full Baths Basement:1
The Listing
Heating & Cooling
-
Heating:Forced Air, Gas
-
Cooling:Central Electric
Utilities
-
Water Source:Municipal/City
-
Solid Waste:No
Appliances
-
Appliances:Dishwasher, Dryer, Disposal, Gas Water Heater, Humidifier, Microwave, Gas Oven, Refrigerator, Free-Standing Freezer, Washer, Water Heater, Water Softener Owned
Schools
-
Middle Or Junior School:Creekside Middle School
-
High School District:Carmel Clay Schools
The Community
-
Subdivision Name:The Village of Westclay
-
Association Amenities:Basketball Court, Fitness Center, Meeting Room, Park, Party Room, Playground, Pool, Tennis Court(s), Trail(s)
-
Spa:true
-
Spa Features:Above Ground, Heated
-
Pool Features:Heated, In Ground, Outdoor Pool, Pool Cover, Waterfall
-
Pool Private:true
-
Association Fee Frequency:Quarterly
-
Association:true
-
Association Fee:564
-
HOA Disclosures:Covenants & Restrictions
-
Association Fee Includes:Association Home Owners, Clubhouse, ParkPlayground, Tennis Court(s), Walking Trails
-
Management Company Name:The Village of WestClay OA
-
Ownership Interest Types:Mandatory Fee
Parking
-
Parking Features:Alley Access, Attached, Concrete, Garage Door Opener, Rear/Side Entry
-
Garage:true
-
Garage Spaces:3
-
Garage & Parking:Garage Door Opener,Guest Street Parking,Keyless Entry
-
Garage SqFt:840
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.
Sale history
Date | Event | Source | Price | % Change |
---|---|---|---|---|
6/28/24
Jun 28, 2024
|
Sold | MIBOR | $1,450,000 | |
5/29/24
May 29, 2024
|
Pending | MIBOR | $1,450,000 | |
4/25/24
Apr 25, 2024
|
Listed / Active | MIBOR | $1,450,000 | 1511.1% (77.2% / YR) |