Listing Agent is Licensed Real Estate Broker in the state of Michigan. Desired Lake In The Woods Sub with lake access 6340 square foot brick colonial with 5 bedrooms, 4.5 bathrooms, fully finished walk out lower level or possible in-law or au pair suite with full kitchen, bathroom, bedroom and living area. Two gas fireplaces, one in entry level great room and one in finished walk out lower level. Large upper deck and large lower brick paver patio that leads out to a beautifully landscaped yard with inground pool, stamped concrete pool deck, gas fire pit, exterior timer lighting and sprinkling system.
Property Details
Price:
$1,075,000
MLS #:
58050217851
Status:
Active
Beds:
5
Baths:
5
Type:
Single Family
Subtype:
SingleFamilyResidence
Subdivision:
LAKE IN THE WOODS
Neighborhood:
area03071shelbytwp
Listed Date:
Aug 7, 2026
Finished Sq Ft:
6,340
Year Built:
1997
See this Listing
Schools
School District:
Utica
Interior
Above Grade Finished Area
4060
Appliances
Dishwasher, Disposal, Dryer, Microwave, Oven, Refrigerator, Range, Washer
Bathrooms
4 Full Bathrooms, 1 Half Bathroom
Below Grade Finished Area
2280
Cooling
Central Air
Heating
Forced Air, Natural Gas
Interior Features
EatInKitchen, Pantry
Levels
Two
Exterior
Architectural Style
Colonial
Attached Garage YN
1
Construction Materials
Brick, Wood Siding
Garage Spaces
3.5
Parking Features
Assigned2Spaces, ThreeandHalfCarGarage, Attached, Garage, Paved
Patio And Porch Features
Patio, Porch
Waterfront Features
Lake Privileges
Financial
HOA Fee
$600
HOA Fee Frequency
Annually
Taxes
$14,168
Map
Community
- Address54182 Queensbourough Shelby MI
- SubdivisionLAKE IN THE WOODS
- CityShelby
- CountyMacomb
- Zip Code48315
Subdivisions in Shelby
Market Summary
Current real estate data for Single Family in Shelby as of Aug 08, 2026
248
Single Family Listed
85
Avg DOM
185
Avg $ / SqFt
$571,137
Avg List Price
Property Summary
- Located in the LAKE IN THE WOODS subdivision, 54182 Queensbourough Shelby MI is a Single Family for sale in Shelby, MI, 48315. It is listed for $1,075,000 and features 5 beds, 5 baths, and has approximately 6,340 square feet of living space, and was originally constructed in 1997. The current price per square foot is $170. The average price per square foot for Single Family listings in Shelby is $185. The average listing price for Single Family in Shelby is $571,137. To schedule a showing of MLS#58050217851 at 54182 Queensbourough in Shelby, MI, contact your LoChirco Realty, LLC agent at 586-321-9997.
Similar Listings Nearby

54182 Queensbourough
Shelby, MI
