Last Sold Price
4 beds2,956 sqft$141/sqft
54011 Mound Road, Utica, MI 48316

Description

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...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!
LISTING CLOSED: 01/13/2026 05:01 PM

  1. Listed by Rimi Hirmiz • Brokerage DRE #6505431350 • Luxury Realty
    P: (586)-556-1007 C: (586)-556-1007 hirmizrimi@yahoo.com

Property Details for 54011 Mound Road

Status
MLS #
20251048148
Days on Market
65
Taxes
$3,198 / year
HOA Fees
$380 / year
Condo/Co-op Fees
-
Property Type
MLS Type
Residential / Single Family Residence
Year Built
1969
Lot Size
0.39 AC / 16,988 SF
Subdivision Name
TWILIGHT # 04
Architectural Style
Colonial
Waterfront Features
Waterfront
Waterfront
Yes
Senior Community
No

Location

Listing Courtesy of Luxury Realty

Sold By KW Domain

Add your commute

Building Information for 54011 Mound Road

Stories-Year Built1969Building Size-Lot Size0.39 AC / 16,988 SF

Payment Calculator

$2,418 per month

30 year fixed, 6.55% Interest

Principal and Interest

$2,120

Property Taxes

$267

HOA Dues

$32

The Payment Calculator is for illustrative purposes only.

Know your buying power with a preapproval and custom rate in minutes

Rocket Mortgage1

Property Information for 54011 Mound Road

Summary
Location and General Information
  • Directions: 24 Mile Road and Mound Road
  • Latitude: 42.69165
  • Longitude: -83.05447
  • Township: Macomb Shelby Twp
  • Cross Street: 24 Mile Road and Mound Road
  • MLS Area Major: Shelby Twp (50007)
  • Water Body Name: Celestial Lake
Taxes and HOA
  • Association Fee: $380.00
  • Association Phone: sdmshelby@gmail.com
  • Parcel Number: 0708279021
  • Tax Amount Summer: $1,925.00
  • Tax Amount Winter: $1,273.00
  • Tax Annual Amount: $3,198.00
  • Tax Assessed Value: $105,694.00
  • Tax Legal Description: L 28 TWILIGHT SUBDIVISION NO 4 LOT 197. LIBER 58 PAGES 25-26
  • Association Fee Frequency: Annually
  • Association Contact: Steve Mc Ninch
  • Association: Yes
School Information
  • High School District: Utica
Parking
  • Garage Spaces: 2.0
  • Attached Garage: Yes
  • Garage: Yes
  • Parking Features: Two Car Garage, Attached
Property
Lot Information
  • Frontage Length: 90.0
  • Lot Size Acres: 0.39
  • Lot Size Dimensions: 80.00 x 130.00
  • Water Frontage Feet: 30.0
  • Lot Size Units: Acres
  • Road Frontage Feet: 90
  • Road Frontage Type: Paved
Property and Assessments
  • State Equalized Value: 156700.0
  • Living Area: 2956.0
  • Building Area Total: 3263.0
  • Above Grade Finished Area: 2140.0
  • Below Grade Finished Area: 816.0
  • Above Grade Finished Area Units: Square Feet
  • Below Grade Total Area: 1123.0
  • Class Name: Residential
  • Living Area Source: Estimated
  • New Construction: No
  • Year Built: 1969
Building Features
  • Construction Materials: Aluminum Siding, Brick
  • Entry Location: Ground Level
  • Foundation Details: Basement, Block
  • Levels: Two
  • Year Remodeled: 2025
  • Stories Total: 2
Utilities
  • Sewer: Septic Tank
  • Water Source: Public
Interior and Exterior Features
Interior Features
  • Bathrooms Total Notational: 2.1
  • Appliances: Dishwasher, Free Standing Gas Oven, Free Standing Refrigerator
  • Basement: Partially Finished
  • Has Basement: Yes
  • Bathrooms Full: 2
  • Bathrooms Half: 1
  • Bathrooms Total Integer: 3
  • Bedrooms Total: 4
  • Cooling: Central Air
  • Has Cooling: Yes
  • Fireplace: No
  • Heating: Forced Air, Natural Gas
  • Has Heating: Yes
  • Rooms Total: 5
Exterior Features
  • Pool Private: No
Room Information
Room 1
  • Room Dimensions: 16 X 10
  • Room Length: 16.0
  • Room Width: 10.0
  • Room Level: Second
  • Room Type: Bedroom 1
Room 2
  • Room Dimensions: 10 X 10
  • Room Length: 10.0
  • Room Width: 10.0
  • Room Level: Second
  • Room Type: Bedroom 3
Room 3
  • Room Dimensions: 10 X 11
  • Room Length: 10.0
  • Room Width: 11.0
  • Room Level: Second
  • Room Type: Bedroom 4
Room 4
  • Room Dimensions: 11 X 10
  • Room Length: 11.0
  • Room Width: 10.0
  • Room Level: Second
  • Room Type: Family Room
Room 5
  • Room Dimensions: 20 X 11
  • Room Length: 20.0
  • Room Width: 11.0
  • Room Level: Entry
  • Room Type: Bathroom 1
Room 6
  • Room Dimensions: 7 X 8
  • Room Length: 7.0
  • Room Width: 8.0
  • Room Level: Second
  • Room Type: Bedroom 2
Room 7
  • Room Dimensions: 9 X 8
  • Room Length: 9.0
  • Room Width: 8.0
  • Room Level: Second
  • Room Type: Bath Full
Room 8
  • Room Dimensions: 6 X 7
  • Room Length: 6.0
  • Room Width: 7.0
  • Room Level: Entry
  • Room Type: Bath Lav
Agent
Sale and Listings
  • Public GLR Website: Yes
Rental
Rent Information
  • Existing Lease: No

Property History for 54011 Mound Road

DateEvent & SourcePriceAppreciation
Jan 13, 2026

Sold

MiRealSource #60947549

Jan 13, 2026

Contract Signed

MiRealSource #60947549

Jan 13, 2026

Sold

Realcomp #20251048148

DateEvent & SourcePrice
01/13/2026

Sold

MiRealSource #60947549

01/13/2026

Contract Signed

MiRealSource #60947549

01/13/2026

Sold

Realcomp #20251048148

For completeness, we often displays two records for one sale: the MLS record and the public record.

Public Records for 54011 Mound Road

Taxable ValueLand-Additions-Total-
Tax Record2025$3,405 ($284 / month)
Home Facts
Beds4Baths2.5Total Finished SqFt1,986 SqFtAbove Grade Finished SqFt1,986 SqFtUnfinished Basement SqFt1,123 SqFtStories2Lot Size17,250 SqFtStyleSingle Family ResidenceYear Built1969Year Renovated1969ZoningR-1-BCountyMACOMBAPN23-07-08-279-021

Schools near 54011 Mound Road

This home is within Utica Community Schools.
Rating
School
Type
Grades
Distance
Public - PK to 6
Public - 7 to 9
Public - 10 to 12
Public - 9 to 12
Rating
School
Distance
Morgan Elementary School
PublicPK to 6

Malow Junior High School
Public7 to 9

Eisenhower High School
Public10 to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

New listings in 48316

$247,000 | 51341 Neumaier Drive, Utica, MI 48316
1/23

$247,000

2
Bedrooms
1,066
Square Feet
0.31
Acres
$365,000 | 53261 Tundra Drive, Utica, MI 48316
1/28

$365,000

3
Bedrooms
2,046
Square Feet
0.27
Acres
$350,000 | 53277 Garland Drive, Utica, MI 48316
1/15

$350,000

4
Bedrooms
3,705
Square Feet
0.34
Acres
$875,000 | 56440 Ashbrooke Drive, Utica, MI 48316
1/68
Open: 8/9 12:00PM - 02:00PM

$875,000

4
Bedrooms
5,084
Square Feet
0.41
Acres
$875,000 | 56440 Ashbrooke Drive East, Utica, MI 48316
1/68

$875,000

4
Bedrooms
5,084
Square Feet
0.41
Acres
$335,000 | 3211 24 Mile Road, Utica, MI 48316
1/18

$335,000

1
Bedrooms
1,599
Square Feet
0.39
Acres
$739,900 | 54921 Palomino Drive, Utica, MI 48316
1/23
New Construction

$739,900

3
Bedrooms
2,250
Square Feet
0.31
Acres
$215,000 | 1996 Monarch Drive, Utica, MI 48316
1/34

$215,000

2
Bedrooms
1,214
Square Feet
$149,900 | 8120 24 Mile Road, Utica, MI 48316
1/28

$149,900

2
Bedrooms
938
Square Feet

Nearby home values

AddressSold priceBedsBathsSqftLot (Sqft)
This home: 54011 Mound Road, Utica, MI 48316
$417,000
4
2,956
16,988
4
2.5
2,445
17,206
$173,900
3
1,800
28,600
3
3
2,522
19,776
$210,000
3
2,200
20,037
3
1.5
1,436
29,447

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of any information, descriptions or measurements (including square footage measurements and property condition), such should be independently verified through appropriate means, including, but not limited to, in person inspection and public records, and Compass International Holdings, its subsidiaries, affiliates and independently owned and operated franchisees, and their affiliated agents and associated third parties expressly disclaim any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the seller's discretion. No financial or legal advice provided. Equal Housing Opportunity. Subject to change at any time. Compass, Inc., its subsidiaries, affiliates and their agents and associated third parties make no guarantee, warranty or representation regarding the accuracy of any waterfront feature, water view or waterfront view.

Listing Courtesy of Luxury Realty

IDX provided courtesy of Realcomp II Ltd. via Compass and its related brokerages. 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 on 07/07/2026 03:45 AM PST