2037 Stanhope St Carmel, IN 46032
West Carmel Neighborhood
5
Beds
6
Baths
5,119
Sq Ft
0.27
Acres
Highlights
- Heated Spa
- Updated Kitchen
- Vaulted Ceiling
- Creekside Middle School Rated A+
- Deck
- Wood Flooring
About This Home
As of June 2025Nestled 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.
Last Agent to Sell the Property
The Agency Indy Brokerage Email: Katie.Byram@theagencyre.com License #RB18001843 Listed on: 05/16/2025
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $10,096
Year Built
- Built in 2005 | Remodeled
Lot Details
- 0.27 Acre Lot
HOA Fees
- $188 Monthly HOA Fees
Parking
- 3 Car Attached Garage
Home Design
- Brick Exterior Construction
- Poured Concrete
- Cement Siding
Interior Spaces
- 2-Story Property
- Vaulted Ceiling
- Paddle Fans
- Gas Log Fireplace
- Bay Window
- Entrance Foyer
- Great Room with Fireplace
- Combination Kitchen and Dining Room
Kitchen
- Updated Kitchen
- Eat-In Kitchen
- Gas Oven
- Microwave
- Free-Standing Freezer
- Dishwasher
- Kitchen Island
- Disposal
Flooring
- Wood
- Ceramic Tile
- Vinyl Plank
Bedrooms and Bathrooms
- 5 Bedrooms
- Walk-In Closet
Laundry
- Laundry on main level
- Dryer
- Washer
Basement
- 9 Foot Basement Ceiling Height
- Sump Pump with Backup
- Basement Storage
- Basement Window Egress
- Basement Lookout
Home Security
- Monitored
- Smart Lights or Controls
- Smart Locks
- Smart Thermostat
- Radon Detector
- Fire and Smoke Detector
Pool
- Heated Spa
- Heated Pool
- Outdoor Pool
- Above Ground Spa
- Waterfall Pool Feature
- Pool Cover
Outdoor Features
- Balcony
- Deck
- Covered patio or porch
Schools
- Creekside Middle School
Utilities
- Humidifier
- Forced Air Heating System
- Programmable Thermostat
- Gas Water Heater
Listing and Financial Details
- Tax Lot 629
- Assessor Parcel Number 290928020002000018
- Seller Concessions Offered
Community Details
Overview
- Association fees include home owners, clubhouse, parkplayground, tennis court(s), walking trails
- Association Phone (317) 574-1164
- The Village Of Westclay Subdivision
- Property managed by The Village of WestClay OA
- The community has rules related to covenants, conditions, and restrictions
Recreation
- Tennis Courts
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
May 16, 2025
Closed on
Jun 23, 2025
Sold by
Hunt Matthew Brandon
Bought by
Ortiz Adrian and Wei Carolyn Shya
Seller's Agent
Katie Byram
The Agency Indy
Buyer's Agent
Gita Kapur
Berkshire Hathaway Home
List Price
$1,475,000
Sold Price
$1,444,000
Premium/Discount to List
-$31,000
-2.1%
Views
23
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
28.12%
Original Mortgage
$1,227,400
Outstanding Balance
$1,227,400
Interest Rate
6.5%
Mortgage Type
New Conventional
Estimated Equity
$252,824
Purchase Details
Listed on
Apr 25, 2024
Closed on
Jul 2, 2024
Sold by
Atkinson George and Atkinson Natalie
Bought by
Hunt Matthew Brandon
Seller's Agent
Dawn Pollard
eXp Realty, LLC
Buyer's Agent
Katie Byram
The Agency Indy
List Price
$1,450,000
Sold Price
$1,450,000
Views
63
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
-0.42%
Original Mortgage
$1,160,000
Interest Rate
7.13%
Mortgage Type
New Conventional
Purchase Details
Listed on
Jun 2, 2017
Closed on
Nov 3, 2017
Sold by
Hawkins Crrokshanks Cheryl L
Bought by
Atkinson George and Atkinson Natalie
Seller's Agent
Joseph Kempler
eXp Realty, LLC
Buyer's Agent
Joseph Kempler
eXp Realty, LLC
List Price
$669,800
Sold Price
$620,000
Premium/Discount to List
-$49,800
-7.44%
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
13.63%
Original Mortgage
$620,000
Interest Rate
3.83%
Mortgage Type
New Conventional
Purchase Details
Closed on
Mar 11, 2011
Sold by
Crookshanks Daniel K
Bought by
Hawkins Crookshanks Cheryl L
Purchase Details
Closed on
Sep 30, 2004
Sold by
William Gordon Group Llc
Bought by
Crookshanks Daniel K and Hawkins Crookshanks Cheryl L
Purchase Details
Closed on
Sep 2, 2004
Sold by
Brenwick Tnd Communities Llc
Bought by
William Gordon Group Llc
Similar Homes in Carmel, IN
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Values in the Area
Average Home Value in this Area
Purchase History
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Warranty Deed | -- | Centurion Land Title | |
| Warranty Deed | $1,450,000 | Centurion Land Title | |
| Warranty Deed | -- | None Available | |
| Quit Claim Deed | -- | None Available | |
| Warranty Deed | -- | -- | |
| Warranty Deed | -- | -- |
Source: Public Records
Mortgage History
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Open | $1,227,400 | New Conventional | |
| Previous Owner | $1,160,000 | New Conventional | |
| Previous Owner | $591,000 | New Conventional | |
| Previous Owner | $620,000 | New Conventional | |
| Previous Owner | $86,500 | Credit Line Revolving |
Source: Public Records
Property History
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 06/24/2025 06/24/25 | Sold | $1,444,000 | -2.1% | $282 / Sq Ft |
| 05/18/2025 05/18/25 | Pending | -- | -- | -- |
| 05/16/2025 05/16/25 | For Sale | $1,475,000 | +1.7% | $288 / Sq Ft |
| 06/28/2024 06/28/24 | Sold | $1,450,000 | 0.0% | $283 / Sq Ft |
| 05/24/2024 05/24/24 | Pending | -- | -- | -- |
| 04/25/2024 04/25/24 | For Sale | $1,450,000 | +133.9% | $283 / Sq Ft |
| 11/03/2017 11/03/17 | Sold | $620,000 | -5.9% | $114 / Sq Ft |
| 10/30/2017 10/30/17 | Pending | -- | -- | -- |
| 08/18/2017 08/18/17 | Price Changed | $658,700 | +17.9% | $121 / Sq Ft |
| 08/18/2017 08/18/17 | Price Changed | $558,700 | -16.6% | $103 / Sq Ft |
| 06/02/2017 06/02/17 | For Sale | $669,800 | -- | $123 / Sq Ft |
Source: MIBOR Broker Listing Cooperative®
Tax History Compared to Growth
Tax History
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2024 | $10,062 | $940,700 | $204,500 | $736,200 |
| 2023 | $10,097 | $857,900 | $204,500 | $653,400 |
| 2022 | $8,735 | $735,000 | $204,500 | $530,500 |
| 2021 | $7,740 | $658,100 | $204,500 | $453,600 |
| 2020 | $7,203 | $631,700 | $204,500 | $427,200 |
| 2019 | $7,794 | $682,500 | $136,300 | $546,200 |
| 2018 | $6,957 | $621,600 | $136,300 | $485,300 |
| 2017 | $6,948 | $620,800 | $136,300 | $484,500 |
| 2016 | $6,961 | $631,600 | $136,300 | $495,300 |
| 2014 | $6,879 | $627,300 | $129,500 | $497,800 |
| 2013 | $6,879 | $621,000 | $129,500 | $491,500 |
Source: Public Records
Agents Affiliated with this Home
-
K
Seller's Agent in 2025
Katie Byram
The Agency Indy
(812) 699-0459
4 in this area
43 Total Sales
-
Buyer's Agent in 2025
Gita Kapur
Berkshire Hathaway Home
(908) 391-9961
41 in this area
145 Total Sales
-
Seller's Agent in 2024
Dawn Pollard
eXp Realty, LLC
(303) 669-4425
39 in this area
51 Total Sales
-
Seller's Agent in 2017
Joseph Kempler
eXp Realty, LLC
(317) 523-6405
60 in this area
109 Total Sales
Map
Source: MIBOR Broker Listing Cooperative®
MLS Number: 22039065
APN: 29-09-28-020-002.000-018
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
Based on information submitted to the MLS GRID. All data is obtained from various sources and may not have been verified by broker or MLS GRID. Supplied Open House Information is subject to change without notice. All information should be independently reviewed and verified for accuracy. Properties may or may not be listed by the office/agent presenting the information. Some IDX listings have been excluded from this website.
Nearby Homes
- 2263 Glebe St
- 2436 Gwinnett St
- 12833 Tradd St Unit 3A
- 12460 Horesham St
- 12853 Tradd St Unit 2B
- 12505 Branford St
- 1902 Rhettsbury St
- 1894 Rhettsbury St
- 12874 Tradd St
- 12938 University Crescent Unit 2B
- 12999 Deerstyne Green St
- 12838 Bird Cage Walk
- 2570 Congress St
- 12910 Ives Way
- 12823 Bird Cage Walk
- 12839 Bird Cage Walk
- 2627 Congress St
- 2223 Shaftesbury Rd
- 12895 Grenville St
- 2578 Filson St