x
Showing 1 of 0
X
Save

5196 Mesa
Shelby Twp MI 48316 US

$300,000

Active Under Contract Listing ID 50194479
bed icon
2 bed
bath icon
3.00 Bath (3 Full)
home icon
Condominium

$300,000

Active Under Contract Listing ID 50194479
Save

5196 Mesa Welcome to The Cascades of Stoney Creek, 4 FULL BEDROOMS and 3 FULL BATHS! 2-minutes from Stony Creek Metro Park. Located in top-rated Utica Schools. Close to walking trails, restaurants, gourmet markets & abundant retail shopping. Whether you're into craft brews or park strolls, this location delivers. A rare find offering style, space, and the kind of convenience in this RECENTLY UPDATED unit. Spacious and provides the comfort of first-floor living but also includes a finished basement with extra bedrooms/office or playroom space and a full bath.

Collapse all

Property Features

  • Facts
  • Property Type: Residential
  • Property Sub-type: Condominium
  • Features
  • Full Bathrooms: 3
  • Cooling System: Central Air
  • Floor Covering: Carpet, Vinyl, Wood
  • Heating Fuels: Fireplace(s), Forced Air, Humidity Control (Heating)
  • Additional Features
  • Fireplace

Property

  • propertytype: Residential
  • propertysubtype: Condominium
  • listprice: 300000
  • unparsedaddress: 5196 Mesa
  • postalcity: Shelby Twp
  • stateorprovince: MI
  • country: US
  • postalcode: 48316
  • bathroomsfull: 3
  • bathroomshalf: 0
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeunits: Acres
  • livingarea: 1434
  • livingareaunits: Square Feet
  • listagentfullname: Dawn Waldrip Bertani
  • listagentemail: dawn@dawnwaldrip.com
  • listagentkey: 3yd-MIREAL-28546
  • listagentmlsid: 28546
  • listagentpreferredphone: 5862001972
  • listagentofficephone: 5862001972
  • listofficekey: 3yd-MIREAL-1630
  • listagentstatelicense: 6501319325
  • listofficemlsid: 1630
  • disclaimer: Copyright © 2026 Multiple Listing Service MiRealSource. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: MIREAL
  • yearbuilt: 2004
  • listingcontractdate: 2025-11-17
  • listagenturl: http://www.dawnwaldrip.com
  • countyorparish: Macomb
  • parcelnumber: 23-07-05-201-102
  • elementaryschooldistrict: Utica Community Schools
  • middleorjuniorschooldistrict: Utica Community Schools
  • highschooldistrict: Utica Community Schools
  • appliances: Microwave, Range, Refrigerator
  • cooling: Central Air
  • constructionmaterials: Brick
  • flooring: Carpet, Vinyl, Wood
  • heating: Fireplace(s), Forced Air, Humidity Control (Heating)
  • fireplaceyn: True
  • transactiontype: ForSale
  • storiestotal: 1
  • parkingtotal: 0
  • parkingfeatures: Garage, Garage - Attached
  • waterfrontyn: False
  • franchiseaffiliation: Real Estate One
  • interiorfeatures: Ceramic Floors, Hardwood Floors
  • architecturalstyle: Ranch
  • rooms: Basement, Bathroom 1, Bathroom 2, Bathroom 3, Bedroom 1, Bedroom 2, Dining Room, Great Room, Kitchen, Laundry
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"Real Estate One of Michigan", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "Expenses":[{"ExpenseCategory":"Home Owner Assessments Fee", "ExpenseFrequency":"Monthly", "ExpenseValue":275}], "GeocodeOptions":null, "LeadRoutingEmail":"homes@janetandtom.com", "ListBrokerageCity":"Shelby Township", "ListBrokerageCountry":"US", "ListBrokerageEmail":"tbush@realestateone.com", "ListBrokerageLogoUrl":"http://brokerlogos.listhub.net/MIREAL/ff808081171733300117266a2bb94b8b/20140121193124048.png", "ListBrokerageName":"Real Estate One of Michigan", "ListBrokeragePhone":"586-200-1972", "ListBrokeragePostalCode":"48315", "ListBrokerageStateOrProvince":"MI", "ListBrokerageUnitNumber":null, "ListBrokerageUnparsedAddress":"50190 Schoenherr", "ListBrokerageWebsiteUrl":"http://www.JanetandTom.com", "ListOfficeAddress1":"56288 Van Dyke", "ListOfficeAddress2":null, "ListOfficeBrokerMlsId":null, "ListOfficeCity":"Shelby Twp", "ListOfficeCountry":"US", "ListOfficeEmail":"dawn@dawnwaldrip.com", "ListOfficePostalCode":"48316", "ListOfficeStateOrProvince":"MI", "ListPriceCurrencyType":"USD", "ListingTitle":"Condominium, Ranch - Shelby Twp, MI", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/5196-Mesa-Dr_Shelby-Twp_MI_48316_M30098-21951?f=listhub&s=MIREAL&m=50194479&c=rexren", "MLSModificationTimestamp":"2025-12-03T17:48:33Z", "Neighborhoods":[{"Description":null, "Name":"Shelby Twp (50007)"}], "PostalCode":null, "RawPropertySubType":"Condominium", "RawPropertyType":"Condominium", "RoomCount":null, "StateOrProvince":null, "Taxes":[], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 1/1/2026 12:40:43 AM GMT
Source Updated Date: 1/10/2026 12:41:48 PM GMT

Courtesy of: Dawn Waldrip Bertani, Real Estate One Inc-Shelby, dawn@dawnwaldrip.com

Copyright © 2026 Multiple Listing Service MiRealSource. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.