Discover unparalleled luxury in this brand-new, custom-built home by Sigma Builders, located in the prestigious Bridgewater Country Club. Spanning three floors, this 4-bed, 3.5-bath masterpiece blends high-end craftsmanship with functional living. Thoughtfully designed for effortless entertaining, every detail showcases the finest finishes and custom touches. Enjoy a completely maintenance-free lifestyle, giving you more time to focus on what matters most. Nestled just minutes from Downtown Carmel and Westfield, this home is situated in the highly acclaimed Westfield school district. With your purchase, you'll receive a Sport Social Membership to Bridgewater Country Club, granting access to indoor and outdoor pools, sport courts, a state-of-the-art gym, fine dining, golf, and more. The best part? While this home is move-in ready, the builder offers customization options to suit your lifestyle. Don't miss the chance to own a luxury home in one of Indiana's most sought-after communities!
Single-familyProperty Type
2025Year Built
2,178 sq ftLot Size
$239Price/Sq.Ft.
$137/moHOA Dues
2 car garageParking
Listed by Kyle Ingle• eXp Realty, LLC
Bought with Arlene Janicki-Raby• Keller Williams Indpls Metro N
Est. $3,645 per month, based on comparable rentals
Sale and tax history for 15407 Mystic Rock Dr
Sale History
Tax History
Date
Event
Price
MIBOR as Distributed by MLS Grid #22079818
Jun 1, 2026
Sold
$581,607
$239/sq ft
May 4, 2026
Pending
—
Mar 3, 2026
Price Changed
$585,000
$241/sq ft
Jan 9, 2026
Listed
$600,000
$247/sq ft
MIBOR as Distributed by MLS Grid #22022673
Jan 13, 2026
Listing Removed
—
Aug 21, 2025
Price Changed
$600,000
$247/sq ft
Feb 20, 2025
Listed
$615,000
$253/sq ft
Year
Property tax
Land + Additions
Assessment*
2025
$7,536 (+53,959.3%)
$44,100 + $297,800
$341,900
2024
$14 (−0.3%)
$44,100 + $297,800
$341,900
2023
$14 (+2.3%)
$600
2022
$14 (−8.4%)
$600
2021
$15 (−50.9%)
$600
2020
$30 (+87.8%)
$600
2019
$16
$600
Public record
Public record
Zoning
Beds
3
Baths
3.5
Stories
3
Lot width
—
Lot depth
—
Lot size
—
Year renovated
2024
Sq. Ft.
2,482
Year built
2024
Style
Condo/Co-op
County
Hamilton County
APN
291017026023000015
Parking Spaces
—
Basement
—
Accessible
—
HOA Dues
—
Garage
—
Features
—
Last updated by owner on Oct 6, 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.
Middle Or Junior High School: Westfield Middle School
Intermediate School: Westfield Intermediate School
High School: Westfield High School
High School District: Westfield-Washington Schools
Location Information
Directions: GPS Friendly
Tax Legal Description: Acreage .05, Section 17, Township 18, Range 4, Bridgewater Club, Replat Information: Blocks H, J, K, L, M, N, Pt R In Bridgew
Public facts
Beds: 3
Baths: 3.5
Sq. Ft.: 2,482
Stories: 3.0
Lot Size: —
Style: Condo/Co-op
Year Built: 2024
Year Renovated: 2024
County: Hamilton County
APN: 291017026023000015
Home facts updated by county records on Oct 6, 2026
Other
Home Information
Foundation Details: Slab
Construction Materials: Brick, Cement Siding
New Construction
Builder Name: Sigma Builders
Levels: Three Or More
Around this home
Schools
Carey Ridge Elementary School
Public PreK-4 • Assigned • 1.2mi
8/10
Westfield Middle School
Public 7-8 • Assigned • 3.4mi
8/10
Westfield High School
Public 9-12 • Assigned • 3.5mi
10/10
Provided by GreatSchools
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
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
96/ 100
Exceptional sunlight
Sunscore
This home ranks in the top 11% for direct sun exposure in Carmel. There appears to be minimal shading by surrounding buildings, terrain, and vegetation.
10.5 hrs
6.3 hrs
JuneDecember
Provided by Shadowmap
Estimated sale price
$503,000 – $608,000
Reach more buyers when you sell with Redfin. Plus, you'll save $5,285 in fees.