MLS # 20240055491 (Realcomp)

*** OPEN HOUSE CANCELLED due to agent sickness*** Discover your dream home in this beautiful two bedroom, three and a half bathroom home in Shelby Twp! The heart of the home is the inviting living room, highlighted by a stunning stone fireplace, vaulted ceilings and floor-to-ceiling windows that fill the space with natural light. The dining room opens to a private back deck, perfect for relaxing or entertaining. Gourmet kitchen with real wood custom cabinets boasts an additional eat-in dining area, while the first-floor laundry room adds convenience to your daily routine. The beautiful, open staircase leads upstairs to a charming sitting area on the second floor - a great spot to read and enjoy your morning coffee. Retreat to the primary suite, which offers a walk-in closet and en-suite bathroom a relaxing soaking tub. The finished basement expands your living space and is perfect for an entertainer: featuring a Pub atmosphere bar/kitchen, home theatre room, full bathroom and garden windows! New water heater (2024), Wine Cooler (2019), Google Nest (2021), Kitchen Fridge (2022), complete Ring alarm system and myQ garage opener included. Schedule your showing of this show-stopping home today!
Source: SparkMLS
Located in Shelby Township in Shelby Twp, this property offers 2-bedroom, 4-bath, 3,025 sq ft, with original construction dating to 2004.
Final sale price: $375,000 (about $124/sq ft).
Annual property taxes run approximately $4,238 ($353/month). Tax figure is from the MLS listing record; verify with the county treasurer for the most current amount.
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 98 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 Lygia Galizia
Keller Williams Advantage
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
5164 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.