Save
Ask
Tour
Hide
Share
$1,075,000
New Listing

54182 Queensbourough Drive
Shelby Charter Township, MI 48315

For Sale|Single Family Residence|Active
5
Beds
5
Total Baths
4
Full Baths
1
Partial Bath
6,340
SqFt
$170
/SqFt
1997
Built
Subdivision:
LAKE IN THE WOODS
County:
Macomb
Call Now: 888-825-1420
Is this the listing for you? We can help make it yours.
888-825-1420
54182 Queensbourough Drive54182 Queensbourough Drive54182 Queensbourough Drive54182 Queensbourough Drive
Save
Ask
Tour
Hide
Share

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.

Save
Ask
Tour
Hide
Share
Listing Snapshot
Price 
$1,075,000
Days On Site 
0 Days
Bedrooms 
5
Inside Area (SqFt) 
6,340 sqft
Total Baths 
5
Full Baths 
4
Partial Baths 
1
Lot Size 
0.51 Acres
Year Built 
1997
MLS® Number 
58050217851
Status 
Active
Property Tax 
$14,168.29
HOA/Condo/Coop Fees 
$50 monthly
Sq Ft Source 
Assessor
Friends & Family
Recent Activity
2 hours agoListing first seen on site
3 hours agoListing updated with changes from the MLS®
General Features
Acres 
0.51
Attached Garage 
Yes
Cross Street 
Jewell Road / 24 Mile Road
Disclosures 
Flood Ins Not Reqd, No Encroachment, Flood Plain None, Taxes Homestead Exempt
Garage 
Yes
Garage Spaces 
3.5
Levels 
Two
Parking 
AttachedGaragePavedAssigned
Property Sub Type 
Single Family Residence
Sewer 
Septic Tank
Special Circumstances 
Standard
SqFt Above 
4060
SqFt Below 
2280
Style 
Colonial
Utilities 
Water Available
Zoning 
Residential
Interior Features
Appliances 
Gas Water HeaterDishwasherDisposalDryerMicrowaveOvenRefrigeratorRangeWasher
Basement 
ConcreteFinishedFullSump PumpWalk-Out Access
Cooling 
Central Air
Fireplace 
Yes
Fireplace Features 
BasementGasGreat Room
Heating 
Forced AirNatural Gas
Interior 
Eat-in KitchenPantry
BathFull 
Level - Second
BathLav 
Bedroom 2 
Dimensions - 13.0 x 12.0Level - Second
Bedroom 3 
Dimensions - 12.0 x 12.0Level - Second
Bedroom 4 
Dimensions - 14.0 x 12.0Level - Second
Bedroom 5 
Dimensions - 18.0 x 16.0Level - Lower
BreakfastNookRoom 
Dimensions - 12.0 x 10.0
Dining Room 
Dimensions - 14.0 x 13.0
Great Room 
Dimensions - 22.0 x 18.0
InLawQuarters 
Kitchen 
Dimensions - 28.0 x 15.0
Laundry 
Dimensions - 8.0 x 7.0
Library 
Dimensions - 18.0 x 15.0
Living Room 
Dimensions - 16.0 x 14.0
Loft 
Master Bathroom 
Level - Second
Master Bedroom 
Dimensions - 18.0 x 17.0Level - Second
Save
Ask
Tour
Hide
Share
Exterior Features
Construction Details 
BrickWood Siding
Patio And Porch 
PatioPorch
Pool Features 
In Ground
Waterfront Features 
Lake Privileges
Community Features
Association Dues 
600
Financing Terms Available 
CashConventional
HOA Fee Frequency 
Annually
MLS Area 
Area03071ShelbyTwp
Roads 
Paved
School District 
Utica
Schools
School District
Utica
Elementary School
Unknown
Middle School
Unknown
High School
Unknown
Listing courtesy of Lakeside Properties LLC: (586) 873-6644



IDX provided courtesy of Realcomp II Ltd. via MiRealSource. Copyright © 2026 Realcomp II Ltd. Shareholders.

IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing and that the data is deemed reliable but not guaranteed accurate by the MLS.

Neighborhood & Commute
Source: Walkscore
Save
Ask
Tour
Hide
Share