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.
Property Details
Price:
$1,035,000
MLS #:
20261068602
Status:
Active
Beds:
5
Baths:
5
Type:
Single Family
Subtype:
SingleFamilyResidence
Subdivision:
LAKE IN THE WOODS SUB
Neighborhood:
area03071shelbytwp
Listed Date:
Aug 26, 2026
Finished Sq Ft:
6,400
Year Built:
1997
See this Listing
Schools
School District:
Utica
Interior
Above Grade Finished Area
4100
Appliances
BuiltInRefrigerator, Dishwasher, Disposal, DoubleOven, Dryer, FreeStandingGasOven, FreeStandingGasRange, Microwave, RangeHood, SelfCleaningOven, StainlessSteelAppliances, Washer, WineCooler
Bathrooms
3 Full Bathrooms, 2 Half Bathrooms
Below Grade Finished Area
2300
Cooling
Ceiling Fans, Central Air
Heating
Forced Air, Natural Gas
Interior Features
CentralVacuum, EntranceFoyer, ProgrammableThermostat, SoundSystem
Levels
Two
Exterior
Architectural Style
Colonial
Attached Garage YN
1
Construction Materials
Brick, Wood Siding
Fencing
Back Yard, Fencing Requiredwith Pool
Garage Spaces
3.5
Parking Features
ThreeandHalfCarGarage, Attached, DirectAccess, ElectricityinGarage, GarageDoorOpener
Patio And Porch Features
Covered, Deck, Patio
Roof
Asphalt
Security Features
Carbon Monoxide Detectors, Smoke Detectors
Waterfront Features
Lake Privileges
Window Features
Energy Star Qualified Windows
Financial
HOA Fee
$600
HOA Fee Frequency
Annually
HOA Phone
586-718-2509
Taxes
$14,168
Map
Community
- Address54182 Queensborough Drive Shelby MI
- SubdivisionLAKE IN THE WOODS SUB
- CityShelby
- CountyMacomb
- Zip Code48315
Subdivisions in Shelby
- 00
- ABERDEEN SUB
- ABERDEEN VILLAGE
- ACORN HEIGHTS
- AMBASSADOR VILLAGE CONDO
- AMBASSADOR VILLAGE CONDOMINIUMS
- ANNSBURY EAST
- AUBURNDALE SUB
- AURORA PARK
- BABIARZ HIGHLAND SUB
- BANBURY MEADOWS SUB
- BANNISTER LAKES SUB 1
- BARCLAY LAKE VILLAGE CONDO #506
- BELLARINE SUB
- BIRCHFIELD SUB
- BRENTWOOD PARK
- BRIARWOOD POINTE CONDO MCCP NO 1202
- BROOKLAND PARK # 15
- BROOKSIDE ESTATES
- BROOKSIDE ESTATES # 02
- BROOKSIDE ESTATES # 04
- BROOKSIDE ESTATES SUB
- BROOKSIDE MANOR # 03
- BROOKSIDE MANOR # 06
- BUCKINGHAM FOREST SUBDIVISION
- BUCKINGHAM GLEN SUB 2
- CAROLYN OAKES SUB
- CARRINGTON MANOR
- CARRINGTON MANOR SUBDIVISION #4
- CASCADES OF STONEY CREEK #851
- CEDAR LAKES SUB
- CHERRY CREEK
- CHERRY CREEK CONDOS
- COUNTRY LANE ESTATES # 04
- COVENTRY PLACE SUB 1
- CROSS GOODALE
- CRYSTAL PINES CONDO
- CRYSTAL PINES CONDO #996
- CRYSTAL PINES CONDOS
- DALBY HILLSITES
- DALBY HILLSITES SUB
- DIEGEL FARMS SUB
- DIEGEL FARMS SUB 2
- EAGLE CREEK CONDO
- EMERALD CREEK
- ENCORE OF SHELBY MCCP NO. 1261
- ENCORE/SHELBY
- ESTATES/BEACON POINTE
- EYSTERS CLINTON RIVER GARDENS
- EYSTERS VAN DYKE FARMS
- FORCIER’S VALLEY VIEW
- FOREST LAKE
- FOREST LAKE SUB
- FOUR SEASONS
- FRANKLIN WOODS CONDO
- GASKILL ACRES SUB
- GLEN OAKS
- GLEN POINTE DR
- GLENPOINTE SUB
- GOLDEN LAKES
- GOLDEN LAKES SUB
- GOLDEN PARK CONDO #772
- HERITAGE PLACE
- HERITAGE PLACE WEST
- HERITAGE PLACE WEST #254
- HERITAGE PLACE WEST II
- HILLCREST ESTATES SUB
- HILLS OF REGENCY CONDOMINIUMS
- HILLS OF REGENCY SUB
- HUNTERS GROVE SUB
- HUNTINGTON PARK SUB
- KINGSWOOD ESTATES SUB
- LAKE ARROWHEAD SUB
- LAKE IN THE WOODS
- LAKE IN THE WOODS SUB
- LAKE ROYALE
- LANCASTER/CENTRAL PARK CONDO
- LEXINGTON OFFICE PLAZA
- LUANN # 01
- MAEDER SUB
- MANORS OF REGENCY CONDO #706
- METES AND BOUNDS
- MILL CREEK OF SHELBY
- NICK & JOHN SUB
- NORTH POINTE ESTATES CONDO
- NORTHVIEW MEADOWS
- OMEGA PLAZA BUS CONDO #807
- PACKARD VIEW
- PACKARD VIEW # 01
- PARK PLACE SOUTH #583
- PARK PLACE SOUTH CONDO
- PARKLAWN ESTATES
- PINE CREEK CONDO #853
- PRESTON CORNERS ESTATES
- PRESTON CORNERS MANORS
- PRESTON PINES
- PROVIDENCE PARK CONDO #912
- RANIER SUB
- RANIER SUBDIVISION
- REEDS WOODLAND
- REGENCY HILLS SUB 2
- RESIDENCES AT LEGACY
- RHODAS LITTLE FARMS
- RIZZO INDUST SUB 2
- ROBINS NEST
- ROY FISCHER SUB
- ROYAL FOREST SUB 1
- ROYAL FOREST SUB 3
- ROYAL PARK ESTATES
- ROYAL PARK ESTATES CONDOMINIUMS
- S/P # 01 SHELBY TNWP
- S/P # 02 SHELBY TNWP
- S/P BURTON VAN DYKE GARDENS
- S/P BURTON-VAN DYKE FARMS
- S/P CONNORS MAPLE LANE
- S/P CROSS GOODALE SHELBY TOWNSHIP
- S/P EYSTERS VAN DYKE FARMS # 02
- S/P EYSTERS VAN DYKE FARMS 1SHELBY
- S/P RHODAS LITTLE FARMS
- S/P ROSS
- S/P SUNSET FARMS # 01
- S/P WILLIAM FRASER
- SANDY CREEK
- SANDY POINTE
- SEVEN OAKS SUB
- SHEARER SUB
- SHELBY ACRES CONDOMINIUM
- SHELBY CENTRAL PLAZA
- SHELBY FOREST
- SHELBY FOREST MOBILE HOME PARK
- SHELBY HIGHLAND
- SHELBY HIGHLAND # 02
- SHELBY ORCHARDS SUB
- SHELBY TOWN CENTER CONDO #715
- SHELBY VILLAGE
- SHELBY WOODS LAKE SUB
- SHELBY WOODS NORTH
- SHELBY WOODS NORTH CONDO #989
- SHELBY WOODS SUB 3
- SHELBY WOODS SUBDIVISION
- SHELBYSHIRE ESTATES
- SHELDEN COURT ESTATES
- SHERWOOD CONDOS
- SILENT WOODS # 01
- SILVER BIRCH VILLAGE CONDO #820
- SPRING LAKE SUB
- SPRING LAKE SUB 1
- SPRING LAKE SUBDIVISION #4
- SPRING LAKE SUBDIVISION NO 4 CONDO MCCP NO 1182
- STARLITE MEADOWS SUBDIVISION
- THE ESTATES
- THE GARDENS AT CENTRAL PARK CONDO #834
- THE PRESERVES OF BRIARWOOD CONDO #1085
- THE SHELBY WEST MOBILE HOME PARK
- THE WOODLANDS OF SHELBY SUB
- THUNDER BAY
- THUNDER BAY II
- THUNDERBIRD PARK # 04
- TOWERING OAKS
- TWILIGHT SUB
- TWILIGHT SUB 2
- TWILIGHT SUB 5
- UTICA ESTATES
- VILLA CAPRI ESTATES
- VILLAGE/BEACON POINTE
- VILLAS OF LAKESIDE
- VILLAS/SPLENDOR CONDO
- VINEYARD’S TIMBERLINE MEADOWS # 04
- VINEYARD’S TIMBERLINE MEADOWS SUB’N NO 3
- VINEYARDS TIMBERLINE MEADOWS
- VINEYARDS TIMBERLINE MEADOWS # 01
- VINEYARDS TIMBERLINE MEADOWS # 05
- VISTA LAKES
- WAYFORD MANOR SUB
- WELLINGTON ESTATES
- WESTLAKE
- WESTLAKE SUB
- WESTWOOD MANOR SUB
- WHISPERING HILLS #2
- WHITNEY ESTATES
- WHITNEY ESTATES SUB
- WHITTEYS
- WHITTEYS SUB
- WILDWOOD POINTE # 01
- WINDMILL POND CONDO #941
- WOLF ESTATES
- WOODSIDE VILLAGE SUB #2
Market Summary
Current real estate data for Single Family in Shelby as of Nov 06, 2026
223
Single Family Listed
80
Avg DOM
190
Avg $ / SqFt
$555,168
Avg List Price
Property Summary
- Located in the LAKE IN THE WOODS SUB subdivision, 54182 Queensborough Drive Shelby MI is a Single Family for sale in Shelby, MI, 48315. It is listed for $1,035,000 and features 5 beds, 5 baths, and has approximately 6,400 square feet of living space, and was originally constructed in 1997. The current price per square foot is $162. The average price per square foot for Single Family listings in Shelby is $190. The average listing price for Single Family in Shelby is $555,168.
Similar Listings Nearby
54182 Queensborough Drive
Shelby, MI