The UPDATED RANCH HOME you have been waiting for in Shelby Twp!!! You will enjoy fishing, swimming and ice skating on CELESTIAL LAKE. The kitchen has QUARTZ countertops and stainless appliances. The spacious first-floor laundry/mudroom is right off the garage making laundry a breeze. Hardwood flooring throughout. The FINISHED BASEMENT has a wet bar, additional living space, bedroom and an updated full bath. Outside you will LOVE watching sunsets on your 30x12 covered patio. Extensive brickwork in the driveway and paths around home surrounded by LUSH professional landscaping. Sidewalks lead to the Macomb Orchard Trail with an overall location close to downtown Rochester, Highways, Parks, shops, schools and anything else you might need. It's not just a house, this home offers you a lifestyle you cannot refuse. Seller is offering one year home warranty. Exclusions. B&BATVAI
Sold for $501,000
$501,000
54121 Mound Rd, Shelby Township, MI 48316
3beds
3,062sqft
Single Family Residence
Built in 1971
0.3 Acres Lot
$526,900 Zestimate®
$164/sqft
$2,829 Estimated rent
Home value
$526,900
$501,000 - $553,000
$2,829/mo
Zestimate® history
Loading...
Owner options
List your home for rent
$2,829/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
Learn more$2,829/mo
Rent Zestimate®
Refinance and save
$3,535/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
See today's rates$3,535/mo
Est. payment
Explore your selling options
Work with a Zillow partner agent
Leverage their expertise and Zillow's premium Showcase listings to get your home seen by more buyers.
Get startedList with your own agent
Get your home in front of millions of buyers by listing it on Zillow.
Learn how to do itSell it yourself
Take full control of how buyers see your home on Zillow by listing For Sale by Owner (FSBO).
List your homeWhat's special
Zillow last checked: 7 hours ago
Listing updated: August 06, 2025 at 04:30pm
Listed by:
Christina Hogan 248-770-2686,
Real Estate One-Rochester
Bought with:
Unidentified Agent
Unidentified Office
Source: Realcomp II,MLS#: 20240009071
Facts & features
Interior
Bedrooms & bathrooms
- Bedrooms: 3
- Bathrooms: 3
- Full bathrooms: 2
- 1/2 bathrooms: 1
Kitchen
- Level: Entry
- Dimensions: 18 x 11
Heating
- Forced Air, Natural Gas
Cooling
- Ceiling Fans, Central Air
Appliances
- Included: Dishwasher, Disposal, Dryer, Free Standing Gas Oven, Free Standing Refrigerator, Stainless Steel Appliances, Washer
- Laundry: Laundry Room
Features
- Basement: Finished,Full
- Has fireplace: Yes
- Fireplace features: Dining Room, Wood Burning
Interior area
- Total interior livable area: 3,062 sqft
- Finished area above ground: 1,705
- Finished area below ground: 1,357
Property
Parking
- Total spaces: 2
- Parking features: Two Car Garage, Attached, Direct Access
- Attached garage spaces: 2
Features
- Levels: One
- Stories: 1
- Entry location: GroundLevelwSteps
- Patio & porch: Covered, Patio, Porch
- Pool features: None
- Waterfront features: Waterfront
- Body of water: Celestial Lake
Lot
- Size: 0.30 Acres
- Dimensions: 133 x 194 x 236
Details
- Parcel number: 0708279016
- Special conditions: Short Sale No,Standard
Construction
Type & style
- Home type: SingleFamily
- Architectural style: Ranch
- Property subtype: Single Family Residence
Materials
- Brick
- Foundation: Basement, Block, Sump Pump
- Roof: Asphalt
Condition
- New construction: No
- Year built: 1971
- Major remodel year: 2017
Details
- Warranty included: Yes
Utilities & green energy
- Sewer: Septic Tank
- Water: Waterat Street
Community & neighborhood
Community
- Community features: Sidewalks
Location
- Region: Shelby Township
- Subdivision: TWILIGHT # 04
HOA & financial
HOA
- Has HOA: Yes
- HOA fee: $300 annually
Other
Other facts
- Listing agreement: Exclusive Right To Sell
- Listing terms: Cash,Conventional
Price history
| Date | Event | Price |
|---|---|---|
| 4/5/2024 | Sold | $501,000+0.2%$164/sqft |
Source:  Realcomp II #20240009071 Report a problem | ||
| 3/4/2024 | Pending sale | $499,900$163/sqft |
Source: Realcomp II #20240009071 Report a problem | ||
| 2/29/2024 | Listed for sale | $499,900+86.9%$163/sqft |
Source: Realcomp II #20240009071 Report a problem | ||
| 6/5/2017 | Sold | $267,500-2.7%$87/sqft |
Source:  MiRealSource #31316499 Report a problem | ||
| 6/3/2017 | Pending sale | $275,000$90/sqft |
Source: Hasse-L-Free Realty #31316499 Report a problem | ||
Public tax history
| Year | Property taxes | Tax assessment |
|---|---|---|
| 2025 | $4,131 -9% | $178,400 +7.5% |
| 2024 | $4,540 +23% | $165,900 +7.2% |
| 2023 | $3,691 +2.8% | $154,800 +5.3% |
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.4 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
$526,900
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
$526,900
- Michigan
- Macomb County
- Shelby Township
- 48316
- 54121 Mound Rd