MLS # 20240043791 (Realcomp)

***Open House CANCELED for 06/30/24*** You can live next door to the beach! Beautiful condo right next door to Stony Creek Metropark! This condo is super clean and waiting for its next owner. New carpet, kitchen appliances, and water heater installed in summer of 2022. The whole place was freshly painted in 2023. The roof was just replaced in April 2024. There is nothing to do but move in and ride your bike next door to the beach!
Source: SparkMLS
This 2-bedroom, 2-bath, 1,520 sq ft home built in 2004 sits in Shelby Township in Shelby Twp.
Closed at $310,000 (about $204/sq ft).
Estimated annual property tax: $4,208, or about $351 monthly. Estimate is based on county assessor records and current millage rates; actual tax may vary with PRE status and recent assessment changes.
Electric service is provided by DTE Electric Company; natural gas by Consumers Energy Company. Broadband is available with download speeds up to 1,200 Mbps from 9 providers.
Location
Construction & Systems
Sale & Financing
HOA
Source: SparkMLS
Source: Public Records
Legal Description
4/27/04 FOR 2005 SPLIT FROM 07-05-200-017CASCADES OF STONEY CREEK MCCSP # 851 UNIT 92 LIBER 15114 PAGES 110-172 PURSUANT TO THE 6TH AMENDMENT REPLAT NUMBER 5 LIBER 19951 PAGES 667 TO 676.
FEMA Flood Zone: Zone X — Minimal flood risk
Source: FEMA NFHLUSDA Rural Development: Not Eligible
Verify eligibility at USDAListed by William Quinn
Berkshire Hathaway HomeServices Kee Realty SCS
Municipality: SHELBY TOWNSHIP
School district: UTICA COMMUNITY SCHOOLS
County: Macomb
Estimate based on SEV for a new buyer (taxable value resets to SEV on transfer). Actual taxes may vary. MI Treasury PT Estimator
Estimate only. Does not include PMI or other fees. Consult a lender for exact rates.
Download
1.2 Gbps
Upload
50 Mbps
FCC Broadband Data Collection (Dec 2025). Max advertised speeds.
DTE Electric Company
Investor-Owned
Consumers Energy Company
Investor-Owned
MI Public Service Commission service territory boundaries.
Property
5112 Mesa Drive, Shelby Twp, MI 48316
View full property history →
Municipality
Shelby Township
View all listings →
County
Macomb County
View county overview →
We'll notify you when something hits the market in Shelby Township or nearby.
Munro Real Estate · MI Broker #6502405404 · No spam, one-click unsubscribe.