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
$536,900 Zestimate®
$164/sqft
$3,184 Estimated rent
Home value
$536,900
$510,000 - $564,000
$3,184/mo
Zestimate® history
Owner options
List your home for rent
$3,184/mo
Rent Zestimate®
Find your next renter with Zillow Rental Manager. Plus, with online applications, you can quickly screen prospective tenants – for free.
$3,184/mo
Rent Zestimate®
Refinance and save
$3,581/mo
Est. payment
Refinancing to a lower rate could help reduce your monthly payments and save thousands over the life of the loan.
$3,581/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
Updated ranch homeAdditional living spaceClose to downtown rochesterQuartz countertopsExtensive brickworkWet barHardwood flooring throughout
Zillow last checked:
Listing updated:
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
Bedroom
- Level: Basement
- Area: 126
- Dimensions: 14 x 9
Bedroom
- Level: Entry
- Area: 143
- Dimensions: 13 x 11
Bedroom
- Level: Entry
- Area: 130
- Dimensions: 13 x 10
Bedroom
- Level: Entry
- Area: 110
- Dimensions: 11 x 10
Other
- Level: Basement
- Area: 40
- Dimensions: 8 x 5
Other
- Level: Entry
- Area: 88
- Dimensions: 11 x 8
Other
- Level: Entry
- Area: 42
- Dimensions: 7 x 6
Dining room
- Level: Entry
- Area: 286
- Dimensions: 22 x 13
Family room
- Level: Entry
- Area: 252
- Dimensions: 21 x 12
Kitchen
- Level: Entry
- Area: 198
- Dimensions: 18 x 11
Laundry
- Level: Entry
- Area: 78
- Dimensions: 13 x 6
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
- On waterfront: Yes
- Waterfront features: Waterfront
- Body of water: Celestial Lake
Lot
- Size: 0.3 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 & HOA
Community
- Features: Sidewalks
- Subdivision: TWILIGHT # 04
HOA
- Has HOA: Yes
- HOA fee: $300 annually
Location
- Region: Shelby Township
Financial & listing details
- Price per square foot: $164/sqft
- Tax assessed value: $126,352
- Annual tax amount: $3,800
- Date on market: 2/29/2024
- Cumulative days on market: 3 days
- Listing agreement: Exclusive Right To Sell
- Listing terms: Cash,Conventional
- Exclusions: Exclusion(s) Exist
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 | ||
| 4/6/2017 | Listed for 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% |
| 2022 | $3,590 +0.7% | $147,000 +7.5% |
| 2021 | $3,565 | $136,700 +1.6% |
| 2020 | $3,565 +8.5% | $134,600 +14.4% |
| 2019 | $3,286 +28% | $117,700 +6.9% |
| 2018 | $2,568 +2.2% | $110,100 +3.3% |
| 2017 | $2,513 | $106,550 |
| 2016 | $2,513 | $106,550 +3.8% |
| 2015 | $2,513 -10.9% | $102,600 +18.8% |
| 2013 | $2,822 | $86,350 |
| 2012 | -- | -- |
| 2009 | -- | -- |
| 2001 | $2,031 +3.5% | $73,300 +3.2% |
| 2000 | $1,962 | $71,030 |
Find assessor info on the county website
Neighborhood: 48316
Nearby homes
- $475,1003 bd3 ba2.3k sqft5760 Woodmire Dr, Shelby Township, MI 48316Off Market
- $474,6003 bd3 ba2.3k sqft54099 Mound Rd, Shelby Township, MI 48316Off Market
- $400,0003 bd4 ba2k sqft5726 Woodmire Dr, Shelby Township, MI 48316Sold
- $--7.71 Acres0 Mound Rd, Utica, MI 48316Off Market
- $448,2004 bd2 ba2.7k sqft54077 Mound Rd, Shelby Township, MI 48316Off Market
- $484,9004 bd2 ba2.6k sqft5700 Woodmire Dr, Shelby Township, MI 48316Off Market
- $425,4003 bd2 ba2.2k sqft54055 Mound Rd, Shelby Township, MI 48316Off Market
- $417,0004 bd3 ba2.9k sqft54011 Mound Rd, Shelby Township, MI 48316Sold
Nearby schools
GreatSchools rating
- 9/10Morgan Elementary SchoolGrades: PK-6Distance: 0.2 mi
- 7/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
$536,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
$536,900
- Michigan
- Macomb County
- Shelby Township
- 48316
- 54121 Mound Rd
Nearby cities
Nearby zip codes
Other Shelby Township Topics
