Highly sought-after MAIN FLOOR 3-BR/2-BA Condo in Carmel. Situated on a rolling common area w/ a wooded tree line providing a scenic wildlife view & lots of privacy. Condo backs up to the Monon Trail, & access to the trail is nearby. Condo is in excellent condition & has neutral colors. It has an open floorplan b/w the Kitchen & Great Rm (w/ a gas fireplace), which is great for entertaining guests or lounging at home. Kitchen features tiled flooring, solid surface counters & cherry cabinets. Large Master BR suite w/ a sizeable walk-in closet. All Kitchen appliances, W/D & water softener included. Oversized (extra long) 2-car garage. Beautifully maintained community w/ great amenities, incl a pool, clubhouse, fitness ctr & tennis/PB courts.
CondoProperty Type
2002Year Built
$196Est. Price/Sq.Ft.
2 car garageParking
Listed by Curt Mikulla• Hot House Realty, LLC
Contact: homes@curtmikulla.com
Bought with DEBORAH NEWMAN• Berkshire Hathaway Home
*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
2
Stories
1
Lot width
—
Lot depth
—
Lot size
—
Year renovated
2002
Sq. Ft.
1,640
Year built
2002
Style
Condo/Co-op
County
Hamilton County
APN
291312405063000018
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Jul 20, 2026.
R-4
Residence District
The purpose of this district is to provide for high-density single-, two- and multiple-family development on small lots in distinctly urbanized areas. The intent of this district is to protect and conserve existing residential development, particularly in locations featuring marginally standard housing and facing potential change from original uses, and to preserve natural features, and encourage open space residential land-use patterns in this district is intended to corresponds to Urban Residential in the Comprehensive Plan's Land Classification Plan.
Permitted uses
Include but are not limited to:
Agriculture
Housing-Single unit
Housing-Multiple units
Public service
Park & open space
Property details
Parking
Parking Information
Parking Features: Attached, Electric Vehicle Service Equipment (EVSE), Garage Door Opener, Guest Parking
Garage Spaces: 2
Has Garage
Interior
Virtual Tour
Interior Sq. Ft. Information
Building Area Total: 1640
Living Area: 1640
Main Level Sq. Ft.: 1640
Upper Level Sq. Ft.: 0
Bedroom Information
Primary Bedroom Description: Closet Walk in,Tub Full with Shower,Tub Garden
# of Bedrooms Main: 3
Beds MU: 3
Bedrooms MU: 3
Bathroom Information
# of Full Baths (Total): 2
# of Full Baths (Main): 2
Full Baths MU: 3
Full Bathrooms MU: 2
Room 1 Information
Room Features: Carpet
Room Dimensions: 16x12
Room Level: Main
Room 2 Information
Room Type: Bedroom 2
Room Features: Carpet
Room Dimensions: 12x11
Room Level: Main
Room 3 Information
Room Type: Bedroom 3
Room Features: Carpet
Room Dimensions: 11x09
Room Level: Main
Room 4 Information
Room Type: Great Room
Room Features: Carpet
Room Dimensions: 20x16
Room Level: Main
Room 5 Information
Room Type: Kitchen
Room Dimensions: 14x09
Room Level: Main
Room 6 Information
Room Type: Dining Room
Room Features: Carpet
Room Dimensions: 09x08
Room Level: Main
Other Rooms Information
Rooms Upper: 0
Rooms Main: 7
Rooms Basement: 0
# of Rooms: 7
Laundry Room Information
Laundry Features: Main Level
Fireplace Information
# of Fireplaces: 1
Fireplace Features: Gas Log, Gas Starter, Great Room
Heating & Cooling
Heating Information: Forced Air, Gas
Cooling Information: Central Electric
Interior Features
Interior Features: Walk-in Closet(s), Window Bay Bow, Windows Vinyl, Wood Work Painted, Breakfast Bar, Pantry
Appliances: Dishwasher, Dryer, Disposal, Microwave, Electric Oven, Refrigerator, Washer, Gas Water Heater, Water Softener Owned
Floor Number: 1
Exterior
Exterior Features
Patio And Porch Features: Covered Porch
Exterior Features: Tennis Community
Pool Information
Pool Features: Community, Association
Property Information
Ownership Interest Types: Mandatory Fee
Other Equipment: Smoke Alarm
Property Type: Residential
Attached Property
Property Sub Type: Condominium
Land Information
Acres: CndHPRCoop
Lot Information
Lot Size Acres: 0
Lot Features: On Trail, Mature Trees
Utilities
Utility Information
Utility Prim Sewage Disp: Municipal Sewer Connected
Water Source: Municipal/City
Utilities: Cable Available, Cable Connected, Gas
Solid Waste Information: No
Location
Multi-Unit Information
Unit Entry Level: 1
HOA Information
Has HOA
HOA Disclosures: Covenants & Restrictions
Association Fee: $254
Association Fee Frequency: Monthly
Association Fee Includes: Association Home Owners, Clubhouse, Exercise Room, Lawncare, Maintenance Grounds, Management, Snow Removal, Tennis Court(s), Trash
School Information
High School District: Carmel Clay Schools
Location Information
Directions: From 106th St, South on Westfield Blvd, then Right into The Retreat. At 3-way stop, go Right on Sierra Springs. At fork, veer right on Shadow Ridge Rd. Condo is on the Right, as the road bends to the left.
Tax Legal Description: THE RETREAT CONDO HPR
Condo Information
Condo Type: Horizontal
Condo Description Location: Ground Level
Public facts
Beds: 4
Baths: 2.0
Sq. Ft.: 1,640
Stories: 1.0
Lot Size: —
Style: Condo/Co-op
Year Built: 2002
Year Renovated: 2002
County: Hamilton County
APN: 291312405063000018
Home facts updated by county records on Jul 20, 2026
Other
Listing Information
Attribution Contact: homes@curtmikulla.com
Green Information
Green Certification YN: No
Home Information
Foundation Details: Slab
Construction Materials: Brick, Cement Siding
Levels: One
Security Features: Carbon Monoxide Detector(s)
Around this home
Schools
Places
Transit
Forest Dale Elementary School
Public PreK-5 • Assigned • 1.7mi
9/10
Carmel Middle School
Public 6-8 • Assigned • 3.2mi
8/10
Carmel High School
Public 9-12 • Assigned • 3.5mi
10/10
Provided by GreatSchools
Lifestyle
Provided by Walk Score and Local Logic
Climate risks
1/10 Flood Factor
Minimal risk 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
0% chance of strong winds in next 30 years
4/10 Air Factor
4 unhealthy days expected this year, 6 days in 30 years
Provided by First Street
Historical weather
Carmel, IN • 46280
Average low and high temperatures (°F)
32
17
41
25
60
39
68
47
71
53
82
65
87
70
84
64
81
59
70
48
53
38
41
27
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Sun exposure
In this area, properties receive around 9.8 hours in
June and 3.3 hours in December, placing it below the
U.S. average for solar exposure.
9.8 hrs
3.3 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$306,000 – $371,000
Reach more buyers when you sell with Redfin. Save up to $3,219 in fees.3 minutes to get started.