This stunning colonial in the highly sought-after Lake in the Woods subdivision of Shelby Township. Featuring 5 bedrooms, 4 bathrooms, and LAKE ACCESS. This home provides over 4,000 square feet of above-grade living space with a well-designed layout ideal for both everyday living and entertaining.
The home is further enhanced with a finished walkout basement with an additional 2,280 square feet of living space including a second kitchen, living room, bedroom, and full bathroom!
Step outside to your private backyard retreat complete with an in-ground pool, perfect for summer entertaining and relaxing in a serene setting.
BATVAI
The home is further enhanced with a finished walkout basement with an additional 2,280 square feet of living space including a second kitchen, living room, bedroom, and full bathroom!
Step outside to your private backyard retreat complete with an in-ground pool, perfect for summer entertaining and relaxing in a serene setting.
BATVAI
Property Details
Price:
$1,200,000
MLS #:
20261024326
Status:
Active
Beds:
5
Baths:
5
Type:
Single Family
Subtype:
SingleFamilyResidence
Subdivision:
LAKE IN THE WOODS SUB
Neighborhood:
area03071shelbytwp
Listed Date:
Apr 26, 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, FreeStandingRefrigerator
Bathrooms
4 Full Bathrooms, 1 Half Bathroom
Below Grade Finished Area
2280
Cooling
Central Air
Heating
Forced Air, Natural Gas
Levels
Two
Exterior
Architectural Style
Colonial
Attached Garage YN
1
Construction Materials
Brick
Garage Spaces
3.5
Parking Features
ThreeandHalfCarGarage, Attached
Roof
Asphalt
Waterfront Features
Lake Privileges, No Motor Lake
Financial
HOA Fee
$650
HOA Fee Frequency
Annually
HOA Includes
MaintenanceGrounds, Security
HOA Phone
586-718-2509 / AGAZZI21@YAHOO.COM
Taxes
$14,168
Map
Community
- Address54182 Queensborough Drive Shelby MI
- SubdivisionLAKE IN THE WOODS SUB
- CityShelby
- CountyMacomb
- Zip Code48315
Subdivisions in Shelby
Market Summary
Current real estate data for Single Family in Shelby as of May 24, 2026
207
Single Family Listed
100
Avg DOM
199
Avg $ / SqFt
$591,802
Avg List Price
Property Summary
- Located in the LAKE IN THE WOODS SUB subdivision, 54182 Queensborough Drive Shelby MI is a Single Family for sale in Shelby, MI, 48315. It is listed for $1,200,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 $189. The average price per square foot for Single Family listings in Shelby is $199. The average listing price for Single Family in Shelby is $591,802.
Similar Listings Nearby
54182 Queensborough Drive
Shelby, MI