$1,075,000 $5,771 est/mo Sourced by Back At You
54182 Queensborough Drive,Shelby Twp, MI 48315
Shelby Twp, MI 48315
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.
Details
| MLS # | 20261068602 |
|---|---|
| Listing Type | For Sale |
| Style | House |
| HOA Dues | $600 |
| Sub-Type | Resale |
| Status | Active |
| Year | 1997 |
| Days On Site | 46 |
| Listing Provided By | 21 United Realty | Michael Petrevski |
Features
| Bed(s) | 5 |
|---|---|
| Bath(s) | 5 Total |
| SQ Feet | 6,400 |
| Garage | 3 |
| Basement | Y |
| Story(s) | 2 |
| Acreage | 0.51 |
| Water Front | Yes |
Interior
| Rooms Total | 5 |
|---|---|
| Cooling Yes / No | Yes |
| Cooling | Ceiling Fans, Central Air |
| Heating Yes / No | Yes |
| Heating | Forced Air, Natural Gas |
| Interior Features | Central Vacuum, Entrance Foyer, Programmable Thermostat, Sound System |
| Window Features | Energy Star Qualified Windows |
| 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 |
Exterior
| Roof | Asphalt |
|---|---|
| Security Features | Carbon Monoxide Detectors, Smoke Detectors |
| Construction Materials | Brick, Wood Siding |
| Foundation Details | Basement, Poured |
Parking
| Garage Yes / No | Yes |
|---|---|
| Attached Garage Yes / No | Yes |
| Parking Features | Threeand Half Car Garage, Attached, Direct Access, Electricityin Garage, Garage Door Opener |
Taxes
| Tax Annual Amount | 14168 |
|---|
Area Information
| State | MI |
|---|---|
| County | Macomb |
| City | Shelby Twp |
| Zip Code | 48315 |
| Area | Shelby Twp |
| Community Name | LAKE IN THE WOODS SUB |
| School District | Utica |
| High School | Utica |
| Listing VS Median (in LAKE IN THE WOODS SUB) | |
Price: $1,075,000 low | high Med: $1,062,500 sqft: 6,400 low | high Med: 6,405 $ / sqft: $168 low | high Med: $166 On site: 46 low | high Med: 103.5 | |
Request a showing
Request a showing
Contact
Learn More About This Property
| State | MI |
|---|---|
| County | Macomb |
| City | Shelby Twp |
| Zip Code | 48315 |
| Area | Shelby Twp |
| Community Name | LAKE IN THE WOODS SUB |
| School District | Utica |
| High School | Utica |
| Listing VS Median (in LAKE IN THE WOODS SUB) | |
Price: $1,075,000 low | high Med: $1,062,500 sqft: 6,400 low | high Med: 6,405 $ / sqft: $168 low | high Med: $166 On site: 46 low | high Med: 103.5 | |
Nearby Listings (Within 1/10 mile)
Price: $806K - $1.343M
sqft: 4,500 - 8,000
Listing Updated: September 28, 2026 at 6:54:33 PM PDT