Address
54182 Queensborough Drive, Shelby Charter Township, MI
Price
$ 1,075,000
Property Attributes
- ID#20261068602
- TypeSingle Family
- Listing Status Active
- CountyMACOMB
- CityShelby Charter Township
- AreaShelby Twp
- NeighborhoodLAKE IN THE WOODS SUB
- Zip48315
- StyleColonial
- Year Built1997
- Taxes$ 14168
- Price$ 1,075,000
- Bedrooms5
- Full Bathrooms3
- Half Bathrooms2
- Sqr Footage6400
- Lot Size0.51 Acres
Data Source:
RealComp
Property 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.
| Price History | |
|---|---|
| 8/26/2026 | Listed $1,075,000 |
General Features
| Sewer | PublicSewer |
|---|---|
| Heating | ForcedAir, NaturalGas |
| Cooling | CeilingFans, CentralAir |
| Possession | AtClose |
| Roof | Asphalt |
| Appliances | BuiltInRefrigerator, Dishwasher, Disposal, DoubleOven, Dryer, FreeStandingGasOven, FreeStandingGasRange, Microwave, RangeHood, SelfCleaningOven, StainlessSteelAppliances, Washer, WineCooler |
| HOA Fee | 600.0 |
| Garage Spaces | 3.5 |
| Patio/Porch Features | Covered, Deck, Patio |
| Architectural Style | Colonial |
| Pool Features | InGround |
| Security Features | CarbonMonoxideDetectors, SmokeDetectors |
| Construction Materials | Brick, WoodSiding |
| Year Built | 1997 |
| Electric | CircuitBreakers |
| Levels | Two |
| Property Subtype | SingleFamilyResidence |
| Waterfront Features | LakePrivileges |
| Assoc Fee Paid Per | Annually |
| County | Macomb |
| New Construction | No |
| Property Type | Residential |
| HOA | Yes |
| Attached Garage | Yes |
| Subdivision Name | LAKE IN THE WOODS SUB |
| Garage Y/N | Yes |
| Total Rooms | 5 |
| Full Baths | 3 |
| Status | Active |
| Directions | Off Jewell Road between 24 and 25 Mile Road |
| City | ShelbyCharterTownship_Macomb |
| Body of Water | Jewell Lake |
| Disclosures | NoRestrictions, TaxesNotHomesteadExempt |
| Entry Location | GroundLevel |
| Senior Community Y/N | No |
| High School District | Utica |
| MLS Area | Area03071ShelbyTwp |
| Lot Size Units | Acres |
| Carport Y/N | No |
| Land Lease Y/N | No |
| Tax Annual Amount | 14168.0 |
| Home Warranty Y/N | No |
| Lease Renewal Y/N | No |
| Additional Parcels Y/N | No |
| Lease Considered Y/N | No |
| Rent Control Y/N | No |
| Virtual Tour | https://www.propertypanorama.com/instaview/nocbor/20261068602 |
| Standard Status | Active |
| Occupancy Type | Owner |
| Tax Assessed Value | 423800 |
| Expected Active Date | 2026-08-26 |
| MobileHomeRemainsYN | No |
| PostalCity | ShelbyTwp_Macomb |
| Legal Description | L 58 V LAKE IN THE WOODS SUB LOT 58 LIBER 6616 PAGES 737-767 |
Interior Features
| Interior Amenities | CentralVacuum, EntranceFoyer, ProgrammableThermostat, SoundSystem |
|---|---|
| Basement | Finished, Full, WalkOutAccess |
| Furnished Y/N | Negotiable |
| Fireplace Features | Gas, GreatRoom |
| Basement (Y/N) | Yes |
| Air Conditioning Y/N | Yes |
| Heating Y/N | Yes |
| Window Features | EnergyStarQualifiedWindows |
| Fireplace Y/N | Yes |
| Above Grade Finished Area | 4100.0 |
| Half Baths | 2 |
| Total Bedrooms | 5 |
| Below Grade Finished Area | 2300.0 |
| WaterHeaterFuel | NaturalGas |
| LivingAreaSource | Estimated |
| Above Grade Finished Area Unit Type | SquareFeet |
| Total Baths | 5 |
Exterior Features
| Fencing | BackYard, FencingRequiredwithPool |
|---|---|
| Parking Features | ThreeandHalfCarGarage, Attached, DirectAccess, ElectricityinGarage, GarageDoorOpener |
| Water Source | Public |
| Foundation Details | Basement, Poured |
| Spa | No |
| Lot Dimensions | 130X170 |
| Lot Size Acres | 0.51 |
| Waterfront Y/N | No |
| Road Frontage Type | Paved |
| Crops Included Y/N | No |
| Horse Y/N | No |
| Irrigation Water Rights Y/N | No |
Amenities
- Foreclosure
- Views
- Short Sale
- New Construction
- Adult 55+
- Lease To Own
- No HOA Fees
- Furnished
- Primary On Main
- Air Conditioning
- Seller Finance
- Green
- Fixer Upper
- Horse
- Golf
- Fireplace
- Deck
- Garage
- Basement
- Pool
IDX provided courtesy of Realcomp II Ltd., via Taylor Office and The Originating MLS(found above), © 2026 Realcomp II Ltd. Shareholders. Shareholders. The information being provided is 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.
Data is updated as of September 13, 2026 11:12 PM UTC Information deemed reliable but not guaranteed.
The data relating to real estate on this web site comes in part from the Internet Data Exchange (IDX) Program of Realcomp Ltd
Property vs Single Family Average in 48315
Price
Taxes
Year Built
Visits
In The Neighborhood
Reduced
Shelby Charter Township
$ 1,100,000
- Type
- Single Family
- Size
- 6,410 SqFt
- Rooms
- 4 Beds + 4.5 Baths
