Price Reduction
Address
54182 Queensbourough Drive, Shelby Twp, MI
Price
$ 1,035,000
Property Attributes
- ID#58050217851
- TypeSingle Family
- Listing Status Active
- CountyMACOMB
- CityShelby Twp
- AreaShelby Twp
- NeighborhoodLAKE IN THE WOODS
- Zip48315
- StyleColonial
- Year Built1997
- Taxes$ 14168
- Price$ 1,035,000
- Bedrooms5
- Full Bathrooms4
- Half Bathrooms1
- Sqr Footage6340
- Lot Size0.51 Acres
Data Source:
RealComp
Property Description
Seller is Listing Agent and 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.
| Price History | |
|---|---|
| 8/8/2026 | Listed $1,075,000 |
| 9/8/2026 | 4$1,035,000 |
General Features
| Sewer | SepticTank |
|---|---|
| Heating | ForcedAir, NaturalGas |
| Cooling | CentralAir |
| Possession | ClosePlus31to60Days |
| Appliances | Dishwasher, Disposal, Dryer, Microwave, Oven, Refrigerator, Range, Washer |
| HOA Fee | 600.0 |
| Garage Spaces | 3.5 |
| Patio/Porch Features | Patio, Porch |
| Architectural Style | Colonial |
| Pool Features | InGround |
| Construction Materials | Brick, WoodSiding |
| Year Built | 1997 |
| 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 |
| Garage Y/N | Yes |
| Total Rooms | 10 |
| Full Baths | 4 |
| Status | Active |
| City | ShelbyCharterTownship_Macomb |
| Body of Water | Jewell Lake |
| Disclosures | FloodInsNotReqd, NoEncroachment, FloodPlainNone, TaxesHomesteadExempt |
| Association Name | Lake In Th |
| Senior Community Y/N | No |
| High School District | Utica |
| Zoning Description | Residential |
| MLS Area | Area03071ShelbyTwp |
| Carport Y/N | No |
| Land Lease Y/N | No |
| Tax Annual Amount | 14168.29 |
| 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 |
| Standard Status | Active |
| MobileHomeRemainsYN | No |
| PostalCity | Utica_Macomb |
| Legal Description | L 58 V LAKE IN THE WOODS SUB LOT 58 LIBER 6616 PAGES 737-767 |
Interior Features
| Interior Amenities | EatInKitchen, Pantry |
|---|---|
| Basement | Concrete, Finished, Full, SumpPump, WalkOutAccess |
| Fireplace Features | Basement, Gas, GreatRoom |
| Basement (Y/N) | Yes |
| Air Conditioning Y/N | Yes |
| Heating Y/N | Yes |
| Fireplace Y/N | Yes |
| Above Grade Finished Area | 4060.0 |
| Half Baths | 1 |
| Total Bedrooms | 5 |
| Below Grade Finished Area | 2280.0 |
| WaterHeaterFuel | NaturalGas |
| Above Grade Finished Area Source | Assessor |
| Above Grade Finished Area Unit Type | SquareFeet |
| Total Baths | 5 |
Exterior Features
| Parking Features | Assigned2Spaces, ThreeandHalfCarGarage, Attached, Garage, Paved |
|---|---|
| Water Source | WateratStreet |
| Foundation Details | Basement |
| Spa | No |
| Lot Dimensions | 130 x 170 |
| Lot Size Acres | 0.51 |
| Road Surface Type | Paved |
| Waterfront Y/N | No |
| 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 Dearborn 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 14, 2026 4:07 AM 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
