- 0
- 6
- Overview
- Description
- Property Details
- Location
- HOA Management
- Facts & Features
- Getting Around
- Nearby Homes
Street View
5 Beds
5 Baths4 full baths + 1 half bath
6,340sqft
54182 Queensborough Dr, Shelby Township, MI 48315
Single Family Residence
Built in 1997
$54.17/mo HOA
0.51 acre lot
$174/sq.ft
Description
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. Mechanicals are all under 5 years old. BATVAI
- Houzeo last checked: 7 minutes ago
- Listing updated: August 1, 2026 at 4:28 pm
- Listing Provided by: Mariam Boutros (248) 254-0590 | Community Choice Realty Inc (248) 729-0011
- Source: Realcomp MLS-MI | MLS#: 20261055417
- Originating MLS: Realcomp II Ltd
Property Details
Status
Off Market
Type
Single Family Residence
No. of Stories
-
County
City
Neighborhood
--
Year Built
1997
HOA Fees
$54.17/mo
Finished Area
6,340 sqft
Lot Size
0.51 acre lot
Basement Area
- sqft
MLS Name
Realcomp MLS
MLS Number
20261055417
MLS Status
Active
Cumulative Days on Market
97
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Download App
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
HOA Management
N/A
HOA Fees
$650/ Annually
Amenities
Amenities and services may be covered by one or multiple associations and service providers.
Security Guard
Maintenance
Disclaimer: Amenities are based on third-party information and may vary; buyers must independently verify all amenities, as information is deemed reliable but not guaranteed.
Facts & Features
Rooms
Bedrooms & bathrooms
Bedrooms: 5
Bathrooms: 5
Interior
Cooling
Central Air
Sewer
Septic Tank
Heating
Forced Air, Natural Gas
Appliances
Dishwasher, Disposal, Free Standing Refrigerator
Construction
Year Built
Year Built: 1997
Home type
Single Family Residence
Foundation Details
Basement, Poured
Construction Materials
Brick
Architectural Style
Colonial
Roof
Asphalt
Utilities & Energy
Water Source
Public
Pool Features
In Ground
Parking Features
Threeand Half Car Garage, Attached
Basement
Finished
Other Features
Subdivision Name
Lake In The Woods Sub
Disclosures
Exclusions Do Not Exist, Taxes Homestead Exempt
Price History
| Date | Event | Price |
|---|---|---|
08/23/2026 Source: | Listing Removed | $1,100,000 $174/sqft |
07/20/2026 Source: | Listed for Sale | $1,100,000 $174/sqft |
07/17/2026 Source: | Off Market | $1,100,000 -4.35% $174/sqft |
07/17/2026 Source: | Listing Removed | $1,150,000 -4.17% $181/sqft |
04/27/2026 Source: | Listed for Sale | $1,200,000 +4.35% $189/sqft |
Show more
Nearby Homes
Find Homes by Property Features in Shelby Township, MI
Nearby New Homes For Sale
Based on information from the Board/Association of REALTORS® (alternatively, from the Realcomp II Ltd. MLS) through Sep 19, 2026, 01:15AM. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified. IDX provided courtesy of Realcomp II Ltd. via Andover Real Estate & Houzeo, Copyright 2026 Realcomp II Ltd. Shareholders Any use of search facilities of data on the site, other than by a consumer looking to purchase real estate, is prohibited. IDX information is provided exclusively for consumers' personal, noncommercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified. Listing Information presented by local MLS brokerage: Andover Real Estate, local REALTOR®- Scott Rubin - (248)206-3666 . Any use of search facilities of data on the site, other than by a consumer looking to purchase real estate, is prohibited. © 2024 Realcomp II Ltd. MLS. All Rights Reserved.
Advertising Broker: Andover Real Estate | Andover Real Estate
Houzeo Corp. holds real estate brokerage licenses in Alabama (License No. 000157023 - 0) and Texas (License No. 9013396)
TREC: Info About Brokerage Services, Consumer Protection Notice.
§ 442‑H New York Standard Operating Procedure.
New York State Fair Housing Notice.
