HomeAboutServicesSearchListingsMarket ActivityBlogContact
Free Carmel Home Seller Guide

FREE GUIDE FROM SHELDON

Thinking about what your home is worth?

Most people checking their own address are considering a move. Whether you're upsizing, downsizing, or just exploring — my free seller guide walks through pricing strategy, prepping for market, photography that sells, and what to expect at closing.

Get the seller guide
Sheldon Barnes, Carmel Realtor

Is this your home?

Sheldon Barnes can help you list 15340 Mystic Rock Dr

Sheldon Barnes is a Carmel realtor and licensed real estate agent serving Carmel, Indiana and the rest of Hamilton County. Whether you're ready to sell 15340 Mystic Rock Dr in Bridgewater Club or just curious what your home is worth in today's Carmel market, he can put together a no-pressure valuation.

Follow

ABOUT THIS HOME

Live the country club lifestyle at Bridgewater Club without busting your budget! This low maintenance, 2 Bedroom, 2.5 Bath Condo comes with a Social Membership to the acclaimed Bridgewater Club. Amenities include the Pete Dye Executive Golf Course (9-hole), indoor/outdoor pools, a 15,000 sq. ft. fitness center, six tennis courts, six pickleball courts, and multiple dining options. Residents also enjoy access to walking trails, junior sports programs, and year-round community events. You won't find this price point with all of these amenities! Enjoy living on a small pond, copy the neighbors and install an outdoor gathering spot just outside your front door to really enjoy the outdoors! Live like you are on vacation without leaving town!

Listed by Mary Boustani· Keller Williams Indy Metro NE· MLS# 22070696
Pending215 days on market

$315,000

$349,000

2Beds
2.1Baths
1,831Sq Ft

Live the country club lifestyle at Bridgewater Club without busting your budget! This low maintenance, 2 Bedroom, 2.5 Bath Condo comes with a Social Membership to the acclaimed Bridgewater Club. Amenities include the Pete Dye Executive Golf Course (9-hole), indoor/outdoor pools, a 15,000 sq. ft. fi...

Listed by Mary Boustani· Keller Williams Indy Metro NE· MLS# MBR22070696

1,831

Sq Ft

2005

Year Built

0.03

Acres

Off Market

Status

$297,900

Assessed Value

2

Bedrooms

Key things to know

  • Dual primary suites with ensuite bathrooms and walk-in closets
  • Open concept main floor with pond views
  • Included social membership to bridgewater club with golf, pools, fitness center
  • No-carpet home with laminate hardwood throughout
  • Flexible bonus room on lower level

Browse by room

15 rooms · 35 photos

Price history

  1. PendingAccepted offer

    Jun 1, 2026

  2. Price reduced$320,000 → $315,000

    Apr 2, 2026

  3. Listedat $349,000

    Oct 30, 2025

Sold
26
Median price
$785,000
Median DOM
5 days

Comparative value

5 comps in this range

This home is 29% below median for similar nearby sales.

$320K$510KMedian $445K
$315K

Estimated values and comparable-sales ranges shown here are for informational purposes only. They are derived from public records and recent MLS sales, are not an appraisal or formal Comparative Market Analysis (CMA), and should not be used as the sole basis for any pricing, purchase, sale, or financing decision. For an accurate market value of a specific property, contact Sheldon Barnes for a personalized CMA.

AI-curated highlights

INSIDE THIS HOME

FEATURES & AMENITIES

Interior

Cathedral Ceiling(s)Eat-in KitchenEntrance FoyerHi-Speed Internet AvailblPantry

Exterior

Balcony

Climate

Heat: Forced AirHeat: Natural GasCool: Central Air

AI-detected from photos

Vibe:contemporaryupdatedPool

THE FACTS

Pricing trajectory, room-by-room layout, schools, and what's nearby.

Price history

  • $349,000Listed· Oct 30, 2025

  • $315,000Reduced

    $34,000 (9.7% off original)

215 days on market

Layout

Main
5 rooms311 sq ft
Upper
223 rooms1,520 sq ft

Primary bath

Shower Stall Full,Sinks Double

Schools

Westfield-Washington Schools

    Neighborhood

    • Clay Terrace2.8 mi
    • Carmel Arts & Design District2.8 mi
    • Westfield High School2.8 mi
    • Carmel High School3.3 mi
    • IU Health North Hospital3.6 mi
    • Monon Trail (Carmel)4.0 mi

    OFF-MARKET PROPERTY DETAILS

    Living Area

    1,831 sq ft

    Year Built

    2005

    Stories

    Three Or More

    Lot Size

    0.03 acres

    Subdivision

    Bridgewater Club

    Section J

    Bedrooms

    2

    Bathrooms

    2 full, 1 half

    Garage

    2 spaces

    School District

    Westfield-Washington Schools

    TAX ASSESSMENT

    Hamilton County assessed values for current year

    Total Assessed Value

    $297,900

    Land Value

    $30,900

    Land$30,900

    10% of total

    Improvement Value

    $267,000

    Improvements$267,000

    90% of total

    Annual tax · 2024
    $6,002

    PARCEL & LEGAL

    Lot / Section

    Section J

    Powered by Ackee.ai