Sold85d on market
54011 Mound Rd
Shelby Township, MI, 48316 • 48316 • Macomb County
$417,000
$141/sqft
4Beds
3Baths
2,956Sqft
0.39 acLot
1969Built
Property DNA
On the Celestial Lake
Waterfront
Colonial Style
Built 1969 · 57 years of history
TWILIGHT # 04
48316
2-Car Garage
Two Car Garage · Attached
This home is getting attention
Listed 85 days ago · 20 views · 1 saves
Market activity
Demand and pricing signals for this listing
20 views
People checking out this listing
1 saves
Buyers have saved this home
85 days on market
Established listing
$141/sqft
Price per square foot
Selling Soon Prediction
HighThis home ranks in the top 20% of listings most likely to go under contract soon, based on market activity and demand signals.
Likelihood score
Want the full market analysis?
Get the detailed selling prediction score, comparable sales data, and price trend forecast for this property.
Free · Delivered to your inbox in minutes
About this home
Single Family · Built 1969
Beautifully renovated home that offers 4 bedrooms and 2 1/2 bathrooms situated on a wonderfully positioned lot on Celestial Lake with fantastic views. Step inside to explore the spacious living areas and incredible natural light throughout! One living area features a cozy brick fireplace and a beautiful view of the lake. Brand new doorwalls off the living and kitchen areas lead out to an expansive deck, perfect for indoor/outdoor entertaining. The brand new luxurious granite kitchen counters and backsplash are a showstopper. All brand new stainless steel appliances and hood vent included. The en-suite includes a walk in closet, and master bathroom featuring a tiled standup shower, and beautiful granite countertops. The guest bedrooms are generously sized, which are perfect for families and guests alike. Step outside to what you can make your own backyard retreat on Celestial Lake with ample green space for endless possibilities! As spectacular as this house is, it also includes brand new windows, furnace upgrades, new hot water heater, new electrical service upgrade with a 100 amp panel, newly refinished hardwood floors, new light fixtures throughout, and upgraded blacktop driveway. This house sets up perfectly for the future and longevity. Come check it out for yourself before it’s too late!
Standout features identified
Our analysis highlights refinished hardwood floors, freshly repainted interiors, and hardwood floors as key attractions of this home.
Estimated monthly payment
Based on current rates
$2,647/month
Principal & Interest$2,059
Property Tax$417
Insurance$139
HOA$32
Down payment20% ($83,400)
3%50%
Est. 6.28% rate · 30yr fixed · $333,600 loan
Full calculator →At a glance
Key facts and listing details
TypeSingle Family Residence
Year Built1969
HeatingForced Air, Natural Gas
CoolingCentral Air
Parking2 Attached Garage spaces
HOA$380 annually
Lot0.39 Acres
Property
Home typeSingle Family
Sub-typeSingle Family Residence
StyleColonial
Year built1969
Stories2
Systems
HeatingForced Air, Natural Gas
CoolingCentral Air
ConstructionAluminum Siding, Brick
Water / SewerPublic / Septic Tank
Parking & Outdoor
ParkingTwo Car Garage, Attached
Garage2 spaces
BasementPartially Finished
Lot0.39 Acres
Location & Tax
Neighborhood48316
Annual tax$3,198
Parcel230708279021
Bathrooms & Fees
Full baths2
HOA$32/mo
Features & details
6 categories of property features
Interior Features
Appliances
Dishwasher
Free Standing Gas Oven
Free Standing Refrigerator
Heating
Forced Air
Natural Gas
Cooling
Central Air
Exterior Features
Parking
Two Car Garage
Attached
Construction
Aluminum Siding
Brick
Pool Features
None
Room details
8 rooms detailed
Primary Bedroom
Second16×10 ft160 sqft
Bedroom
Second10×10 ft100 sqft
Bedroom
Second10×11 ft110 sqft
Bedroom
Second11×10 ft110 sqft
Primary Bathroom
Second7×8 ft56 sqft
Other
Second9×8 ft72 sqft
Listing insights
Market data and value estimates
StatusSold
Days on market85
Est. value$422,100
Est. rent$3,460/mo
Tax rate1.32%
Price/sqft$141
On marketOct 23, 2025
PostedNov 9, 2025
Last sold$417,000
MLS updatedJan 13, 2026
Tour days6
Views20
Favorites1
How are the schools in Shelby Township?
3 schools rated nearby
Location
Shelby Township, MI, 48316
Price history
19 events
DateEventPrice$/sqftSource
Jan 13, 2026Pending Sale$434,000$147Realcomp II
Jan 12, 2026Sold$417,000$141Realcomp II
Nov 18, 2025Price Change$434,000$147Realcomp II
Nov 7, 2025Price Change$439,000$149Realcomp II
Nov 4, 2025Price Change$444,000$150Realcomp II
Oct 30, 2025Price Change$449,000$152Realcomp II
Oct 23, 2025Listed For Sale$459,000$155Realcomp II
Oct 22, 2025Listing Removed$465,000$157Realcomp II
Oct 13, 2025Price Change$465,000$157Realcomp II
Oct 4, 2025Price Change$475,000$161Realcomp II
Sep 29, 2025Listed For Sale$489,900$166Realcomp II
Jun 13, 2025Sold$340,000$115Realcomp II
May 30, 2025Pending Sale$359,000$121Realcomp II
Apr 26, 2025Price Change$359,000$121Realcomp II
Apr 23, 2025Price Change$365,000$123Realcomp II
Apr 10, 2025Pending Sale$285,000$96NextHome
Mar 31, 2025Listed For Sale$285,000$96NextHome
Mar 10, 2025Pending Sale$285,000$96MichRIC
Mar 2, 2025Listed For Sale$285,000$96MichRIC
Pending Sale$434,000
Jan 13, 2026•$147/sqft•Realcomp II
Sold$417,000
Jan 12, 2026•$141/sqft•Realcomp II
Price Change$434,000
Nov 18, 2025•$147/sqft•Realcomp II
Price Change$439,000
Nov 7, 2025•$149/sqft•Realcomp II
Price Change$444,000
Nov 4, 2025•$150/sqft•Realcomp II
Price Change$449,000
Oct 30, 2025•$152/sqft•Realcomp II
Listed For Sale$459,000
Oct 23, 2025•$155/sqft•Realcomp II
Listing Removed$465,000
Oct 22, 2025•$157/sqft•Realcomp II
Price Change$465,000
Oct 13, 2025•$157/sqft•Realcomp II
Price Change$475,000
Oct 4, 2025•$161/sqft•Realcomp II
Listed For Sale$489,900
Sep 29, 2025•$166/sqft•Realcomp II
Sold$340,000
Jun 13, 2025•$115/sqft•Realcomp II
Pending Sale$359,000
May 30, 2025•$121/sqft•Realcomp II
Price Change$359,000
Apr 26, 2025•$121/sqft•Realcomp II
Price Change$365,000
Apr 23, 2025•$123/sqft•Realcomp II
Pending Sale$285,000
Apr 10, 2025•$96/sqft•NextHome
Listed For Sale$285,000
Mar 31, 2025•$96/sqft•NextHome
Pending Sale$285,000
Mar 10, 2025•$96/sqft•MichRIC
Listed For Sale$285,000
Mar 2, 2025•$96/sqft•MichRIC
Tax history
15 years of records
YearTax paidAssessed value
Apr 8, 2025$3,252$164,400
Apr 8, 2024$3,096$156,700
Apr 8, 2023$2,940$143,700
Apr 8, 2022$2,860$127,900
Apr 8, 2021$2,840$130,200
Apr 8, 2020$2,840$128,900
Apr 8, 2019$2,618$125,000
Apr 8, 2018$2,540$119,200
Apr 8, 2017$2,486$109,100
Apr 8, 2016$2,486$109,100
Apr 8, 2015$2,486$99,650
Apr 8, 2012——
Apr 8, 2009——
Apr 8, 2001$2,277$82,150
Apr 8, 2000$2,199$79,610
Nearby homes
Neighborhood details
Local context around this listing
Shelby Township, MI • Macomb County
Nearby cities
ChesterfieldClinton TownshipEastpointeMacombRosevilleSaint Clair ShoresShelby TownshipSterling Heights
Nearby zip codes
48315483164831748318
Similar homes
IDX provided courtesy of Realcomp II Ltd. via Zillow, Inc and MLS Copyright 2026 Realcomp II Ltd. Shareholders IDX information is provided exclusively for consumers' personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified. Any use of search facilities of data on the site, other than by a consumer looking to purchase real estate, is prohibited. The data relating to real estate properties on this website was last updated as recently as 2026-02-06 15:35:30 PST Listing Information presented by local MLS brokerage: Zillow, Inc., REALTOR®- Lauren Buttazzoni - (313) 479-2702
No obligation · Same-day response