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!
Sold for $417,000
Zestimate®
$417,000
54011 Mound Rd, Shelby Township, MI 48316
4beds
2,956sqft
Single Family Residence
Built in 1969
0.39 Acres Lot
$417,000 Zestimate®
$141/sqft
$3,045 Estimated rent
Home value
$417,000
$396,000 - $438,000
$3,045/mo
Zestimate® history
Loading...
Owner options
Explore your selling options
What's special
Zillow last checked: 8 hours ago
Listing updated: January 13, 2026 at 08:54am
Listed by:
Rimi Hirmiz 586-556-1007,
Platinum Home Realty
Bought with:
Leandro Dedndrejaj, 6501398038
KW Domain
Source: Realcomp II,MLS#: 20251048148
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 4
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Primary bedroom
- Level: Second
- Area: 160
- Dimensions: 16 X 10
Bedroom
- Level: Second
- Area: 100
- Dimensions: 10 X 10
Bedroom
- Level: Second
- Area: 110
- Dimensions: 10 X 11
Bedroom
- Level: Second
- Area: 110
- Dimensions: 11 X 10
Primary bathroom
- Level: Second
- Area: 56
- Dimensions: 7 X 8
Other
- Level: Second
- Area: 72
- Dimensions: 9 X 8
Other
- Level: Entry
- Area: 42
- Dimensions: 6 X 7
Family room
- Level: Entry
- Area: 220
- Dimensions: 20 X 11
Heating
- Forced Air, Natural Gas
Cooling
- Central Air
Appliances
- Included: Dishwasher, Free Standing Gas Oven, Free Standing Refrigerator
Features
- Basement: Partially Finished
- Has fireplace: No
Interior area
- Total interior livable area: 2,956 sqft
- Finished area above ground: 2,140
- Finished area below ground: 816
Property
Parking
- Total spaces: 2
- Parking features: Two Car Garage, Attached
- Attached garage spaces: 2
Features
- Levels: Two
- Stories: 2
- Entry location: GroundLevel
- Pool features: None
- Waterfront features: Waterfront
- Body of water: Celestial Lake
Lot
- Size: 0.39 Acres
- Dimensions: 80.00 x 130.00
Details
- Parcel number: 0708279021
- Special conditions: Short Sale No,Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Colonial
- Property subtype: Single Family Residence
Materials
- Aluminum Siding, Brick
- Foundation: Basement, Block
Condition
- New construction: No
- Year built: 1969
- Major remodel year: 2025
Utilities & green energy
- Sewer: Septic Tank
- Water: Public
Community & neighborhood
Location
- Region: Shelby Township
- Subdivision: TWILIGHT # 04
HOA & financial
HOA
- Has HOA: Yes
- HOA fee: $380 annually
Other
Other facts
- Listing agreement: Exclusive Right To Sell
- Listing terms: Cash,Conventional,FHA
Price history
| Date | Event | Price |
|---|---|---|
| 1/13/2026 | Pending sale | $434,000+4.1%$147/sqft |
Source:  Realcomp II #20251048148 Report a problem | ||
| 1/12/2026 | Sold | $417,000-3.9%$141/sqft |
Source: Realcomp II #20251048148 Report a problem | ||
| 11/18/2025 | Price change | $434,000-1.1%$147/sqft |
Source: Realcomp II #20251048148 Report a problem | ||
| 11/7/2025 | Price change | $439,000-1.1%$149/sqft |
Source: Realcomp II #20251048148 Report a problem | ||
| 11/4/2025 | Price change | $444,000-1.1%$150/sqft |
Source: Realcomp II #20251048148 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $3,252 +5% | $164,400 +4.9% |
| 2024 | $3,096 +5.3% | $156,700 +9% |
| 2023 | $2,940 +2.8% | $143,700 +12.4% |
Find assessor info on the county website
Neighborhood: 48316
Nearby schools
GreatSchools rating
- 7/10Morgan Elementary SchoolGrades: PK-6Distance: 0.2 mi
- 6/10Malow Junior High SchoolGrades: 7-9Distance: 0.3 mi
- 9/10Eisenhower High SchoolGrades: 10-12Distance: 0.5 mi
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value$417,000
Get a cash offer in 3 minutes
Find out how much your home could sell for in as little as 3 minutes with a no-obligation cash offer.
Estimated market value
$417,000