54011 Mound Road
Shelby Twp, MI 48316
- 5 beds
- 3 baths
- 2,140 sqft
- ~1/2 acre lot
- $143 per sqft
- 1969 build
- – on site
More homes
UPDATE: ALL OFFERS DUE BY 7PM, 3-8-25, DECISION AND RESPONSE BY 3PM 3-9-25. THANK YOU FOR THE INTEREST!! UPDATE: INTERIOR 1ST & 2ND FLRS. FRESHLY REPAINTED TWO WKS AGO ($8,000). HOT WATER HEATER REPLACED 3-3-25, AS WELL AS OTHER FURNACE WORK COMPLETED ($4,200) Charming Lakefront Home in Shelby Township - Great Potential! Solidly-built, older home offers a terrific opportunity to live on Celestial Lake, a private, well-maintained, spring-fed lake. Some updating and personal touches are needed but the sturdy foundation and unbeatable location make this a true gem with endless potential. You'll appreciate the natural fireplace in the oak-floored family room and you'll find oak flooring under carpeting throughout the home. Come see the possibilities!
Last checked:
As a licensed real estate brokerage, Estately has access to the same database professional Realtors use: the Multiple Listing Service (or MLS). That means we can display all the properties listed by other member brokerages of the local Association of Realtors—unless the seller has requested that the listing not be published or marketed online.
The MLS is widely considered to be the most authoritative, up-to-date, accurate, and complete source of real estate for-sale in the USA.
Estately updates this data as quickly as possible and shares as much information with our users as allowed by local rules. Estately can also email you updates when new homes come on the market that match your search, change price, or go under contract.
Checking…
•
Last updated Apr 23, 2025
•
MLS# 25007448 —
The Building
-
Year Built:1969
-
New Construction:false
-
Construction Materials:Aluminum Siding, Brick
-
Architectural Style:Colonial
-
Foundation Details:None
-
Building Features:None
-
Window Features:Storms, Screens, Replacement
-
Patio And Porch Features:Deck
-
Accessibility Features:No
-
Direction Faces:None
-
Roof:Asphalt, Shingle
-
Stories:2
-
Basement:No
-
Basement:Full
-
Basement:Yes
-
Basement Finished SqFt:816.0
-
Common Walls:None
-
Building Area Total:2140.3
-
Exterior -Brick:true
-
Exterior Material -Aluminum Siding:true
-
Roofing -Shingle:true
-
Roofing -Asphalt:true
-
Below Grade Finished Area:816.0
Interior
-
Rooms Total:13
-
Interior Features:Garage Door Opener
-
Flooring:Tile
-
Total Fireplaces:1.0
-
Fireplaces Total:1
-
Fireplace:true
-
Fireplace Features:Family Room, Wood Burning
-
Fireplace -Wood Burning:true
-
Furnished:None
Room Dimensions
-
Living Area:2956.3
-
Main Level SqFt:1426.0
-
Upper Level SqFt:714.3
-
Basement SqFt:1118.0
Financial & Terms
-
Ownership:Private Owned
Location
-
Directions:From the East - 24 Mile West to Mound Road North From the West- 696 East to I-75 North, to Big Beaver Road East, to Ryan North to 23 Mile East, to Mound North From the South - I-75 North to Big Beaver Road East, to Ryan North to 23 Mile East to Mound North
-
Cross Street:24 Mile Road and Mound Road
-
Latitude:42.691063
-
Longitude:-83.05498
The Property
-
Parcel Number:23-07-08-279-021
-
Property Type:Residential
-
Property Subtype:Single Family Residence
-
Property Attached:No
-
Lot Features:Sidewalk
-
Lot Size SqFt:17424.0
-
Lot Size Acres:0.4
-
Lot Size Area:0.4
-
Lot Size Units:Acres
-
Topography:None
-
Waterfront:false
-
View:None
-
View:No
-
Inclusions:None
-
Zoning:None
-
Current Use:None
-
Possible Use:None
-
Frontage Type:None
-
Water Access:Yes
-
Waterfront:No
-
Waterfront Features:Lake
-
Road Surface Type:Paved
-
Road Frontage:90.0
Listing Agent
- Contact info:
- Agent phone:
- (248) 912-7014
- Office phone:
- (248) 810-8441
Taxes
-
Tax Year:2024
-
Tax Year:2024.0
-
Tax Legal Description:LOT 197 TWILIGHT SUBDIVISION NO. 4, according to the plat thereof as recorded in Liber 58, Page 25 AND 26 of Plats, MACOMB COUNTY RECORDS
-
Tax Annual Amount:3251.62
-
Tax Assessed Value:105694
-
Taxable Value:105694.0
-
Annual Property Taxes:3251.62
Beds
-
Bedrooms Total:5
-
Basement Bedrooms:1
Baths
-
Total Baths:3
-
Total Baths:2.5
-
Partial Baths:None
-
Full Baths:2
-
Full Baths:2
-
Half Baths:1
-
Three Quarter Baths:None
-
Half Baths:1
-
Quarter Baths:None
The Listing
-
Terms Available -VA Loan:true
Heating & Cooling
-
Cooling:Central Air
-
Cooling:true
-
Heating:true
-
Heating:Forced Air
-
Heat Type -Forced Air:true
-
Heat Source -Natural Gas:true
Utilities
-
Utilities:Natural Gas Connected, Cable Connected
-
Natural Gas:true
-
Central Air:true
-
Sewer:Septic Tank
-
Sewer/Septic System:true
-
Water Source:Public
-
Water Public:true
Appliances
-
Appliances:Cooktop, Disposal, Microwave, Range, Refrigerator
-
Refrigerator:true
-
Disposal:true
-
Range:true
-
Cook Top:true
-
Microwave:true
-
Laundry Features:Electric Dryer Hookup, Laundry Room, Main Level, Sink, Washer Hookup
Schools
-
Elementary School District:None
-
Middle Or Junior School District:None
-
High School District:Utica
The Community
-
Subdivision:Twilight Subdivision
-
Senior Community:No
-
Pool Private:No
-
Association:true%
-
Association Fee:300.0
-
Association Fee Frequency:Annually
Parking
-
Garage:true
-
Attached Garage:true
-
Garage Spaces:2.0
-
Carport Spaces:None
-
Parking Total:None
-
Parking Features:Attached
Walk Score®
Provided by WalkScore® Inc.
Walk Score is the most well-known measure of walkability for any address. It is based on the distance to a variety of nearby services and pedestrian friendliness. Walk Scores range from 0 (Car-Dependent) to 100 (Walker’s Paradise).
Bike Score®
Provided by WalkScore® Inc.
Bike Score evaluates a location's bikeability. It is calculated by measuring bike infrastructure, hills, destinations and road connectivity, and the number of bike commuters. Bike Scores range from 0 (Somewhat Bikeable) to 100 (Biker’s Paradise).
Soundscore™
Provided by HowLoud
Soundscore is an overall score that accounts for traffic, airport activity, and local sources. A Soundscore rating is a number between 50 (very loud) and 100 (very quiet).
Air Pollution Index
Provided by ClearlyEnergy
The air pollution index is calculated by county or urban area using the past three years data. The index ranks the county or urban area on a scale of 0 (best) - 100 (worst) across the United Sates.