Andover RE
Powered by 
- 1
- Overview
- Description
- Property Details
- Location
- HOA Management
- Facts & Features
- Getting Around
- Nearby Homes
$1,035,000
Monthly Est:$5,152
5 Beds
5 Baths3 full baths + 2 half baths
6,400sqft
54182 Queensborough Dr, Shelby Township, MI 48315
$1,035,000
$5,152/moEst:
Get Pre-Approved
Single Family Residence
Built in 1997
$50/mo HOA
0.51 acre lot
$162/sq.ft
Description
Highly 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.
- Houzeo last checked: 12 hours ago
- Listing updated: October 19, 2026 at 4:14 pm
- Listing Provided by: Michael Petrevski (248) 817-2095 | 21 United Realty (248) 817-2095
- Source: Realcomp MLS-MI | MLS#: 20261068602
- Originating MLS: Realcomp II Ltd
Property Details
Status
Active
Type
Single Family Residence
No. of Stories
-
County
City
Neighborhood
--
Year Built
1997
HOA Fees
$50/mo
Finished Area
6,400 sqft
Lot Size
0.51 acre lot
Basement Area
- sqft
MLS Name
Realcomp MLS
MLS Number
20261068602
MLS Status
Active
Days on Market
68
Cumulative Days on Market
157
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Continue Your Journey in App
Find your dream home, receive real-time updates, and many more!
Location
HOA Management
N/A
HOA Fees
$600/ Annually
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
Window Features
Energy Star Qualified Windows
Heating
Forced Air, Natural Gas
Sewer
Public Sewer
Cooling
Ceiling Fans, Central Air
Interior Features
Central Vacuum, Entrance Foyer, Programmable Thermostat, Sound System
Appliances
Built In Refrigerator, Dishwasher, Disposal, Double Oven, Dryer, Free Standing Gas Oven, Free Standing Gas Range, Microwave, Range Hood, Self Cleaning Oven, Stainless Steel Appliances, Washer, Wine Cooler
Construction
Year Built
Year Built: 1997
Home type
Single Family Residence
Architectural Style
Colonial
Construction Materials
Brick, Wood Siding
Roof
Asphalt
Foundation Details
Basement, Poured
Utilities & Energy
Pool Features
In Ground
Basement
Finished, Full, Walk Out Access
Fireplace Features
Gas, Great Room
Water Source
Public
Parking Features
Threeand Half Car Garage, Attached, Direct Access, Electricityin Garage, Garage Door Opener
Security Features
Carbon Monoxide Detectors, Smoke Detectors
Electric
Circuit Breakers
Other Features
Subdivision Name
Lake In The Woods Sub
Disclosures
No Restrictions, Taxes Not Homestead Exempt
Patio And Porch Features
Covered, Deck, Patio
Price History
| Date | Event | Price |
|---|---|---|
08/26/2026 Source: | Listed for Sale | $1,075,000 +3.86% $168/sqft |
08/26/2026 Source: | Price Decreased | $1,035,000 -3.72% $162/sqft |
08/26/2026 Source: | Price Decreased | $1,075,000 -2.27% $168/sqft |
08/23/2026 Source: | Listing Removed | $1,100,000 $172/sqft |
07/20/2026 Source: | Listed for Sale | $1,100,000 $172/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 Nov 02, 2026, 02:15PM. 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
