MOTIVATED SELLER,PRICE REDUCED BY OVER $500,000!! Grand Georgian-style Colonial. Incredible views of the golf course plus the privacy & security of a gated cul-de-sac. Elevator serves all floors, caregiver's quarters/in-law quarters, 6beds w/ 6 1/2 baths, Master Ste is over 1,000 SF w/ bar/kitchenette. Granite everywhere, Viking appliances, hardwood floors, 3 fireplaces, sports bar/poker/theatre in walkout lower level, heated 4 car garage with basketball court.
*Taxable value of land and structures on it ("additions") is determined regularly by local assessors and does not affect market price.
Public record
Public record
Zoning
Beds
4
Baths
6.5
Stories
2
Lot width
—
Lot depth
—
Lot size
0.6 Acres
Year renovated
2006
Sq. Ft.
8,401
Year built
2006
Style
Single Family Residential
County
Hamilton County
APN
291008006006000015
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Sep 16, 2026.
PUD
Planned Unit Development Overlay District
The PUD District is intended to: Encourage flexibility and innovation in the development of land in order to promote its most appropriate Use.; Improve the design, character and quality of new developments.; Encourage a harmonious and appropriate mix of Uses.; Facilitate the adequate and economic provision of streets, utilities and municipal services.; Preserve the natural environmental and scenic features of the site; Encourage and provide a mechanism for arranging improvements on sites so as to preserve desirable features.; Mitigate problems which may be presented by specific site conditions.
Property details
Public facts
Beds: 4
Baths: 6.5
Sq. Ft.: 8,401
Stories: 2.0
Lot Size: 0.6 acres
Style: Single Family Residential
Year Built: 2006
Year Renovated: 2006
County: Hamilton County
APN: 291008006006000015
Home facts updated by county records on Sep 16, 2026
Around this home
Schools
Carey Ridge Elementary School
Public PreK-4 • Assigned • 0.5mi
8/10
Westfield Middle School
Public 7-8 • Assigned • 2.7mi
8/10
Westfield High School
Public 9-12 • Assigned • 2.8mi
10/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
3/10 Flood Factor
Estimated 10-14% chance of a flood reaching the building in the next 30 years
1/10 Fire Factor
Unlikely to be in a wildfire in next 30 years
3/10 Heat Factor
7 days above 102° expected this year, 18 days in 30 years
2/10 Wind Factor
1% chance of strong winds in next 30 years
4/10 Air Factor
3 unhealthy days expected this year, 5 days in 30 years
Provided by First Street
Historical weather
Carmel, IN • 46033
Average low and high temperatures (°F)
32
17
42
25
60
38
68
46
72
52
84
64
88
69
81
62
81
56
70
46
53
38
40
27
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 9.9 hours in
June and 3.3 hours in December, placing it below the
U.S. average for solar exposure.
9.9 hrs
3.3 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$2.07M – $2.50M
Reach more buyers when you sell with Redfin. Save up to $21,729 in fees.3 minutes to get started.