Welcome to this exceptional luxury estate nestled within the prestigious Lake in the Woods community of Shelby Township. Situated on a premium corner lot, this impressive brick colonial offers over 6,400 square feet of finished living space, including a beautifully finished walk-out lower level designed for both entertaining and everyday enjoyment. A grand two-story foyer welcomes you into a thoughtfully designed floor plan featuring 4 spacious bedrooms, 4.1 baths, a private library, formal dining room, and an expansive great room highlighted by a natural fireplace and soaring ceilings. The gourmet kitchen is appointed with premium appliances, including a built-in refrigerator, gas cooktop, double ovens, and a convenient butler’s pantry. The luxurious primary suite serves as a private retreat, complete with a spa-inspired bath and generous closet space. The finished walk-out lower level provides exceptional additional living space with a fireplace, wet bar, and versatile recreation areas perfect for entertaining guests. Step outside to enjoy multiple patios, covered outdoor living spaces, professional landscaping, and a full sprinkler system. Residents enjoy annual HOA services include snow removal for added convenience. Meticulously maintained by its original owners, this home showcases true pride of ownership throughout. Recent improvements include updated ENERGY STAR forced air and central air systems (2023/2024), exterior repainting completed in 2025, and a Macomb County septic inspection passed in May 2026, providing peace of mind for the next owner. Completing the package is a side-entry 3-car garage and an ideal location within the award-winning Utica Community Schools district, just minutes from shopping, dining, and major commuter routes. This extraordinary residence offers the perfect blend of timeless elegance, modern efficiency, and luxury living. Please note – ALL potential buyers must provide proof of pre-approval or bank certified proof of funds provided to their agent prior to showing approval.
Property Details
Price:
$1,165,000
MLS #:
20261030783
Status:
Active
Beds:
4
Baths:
5
Type:
Single Family
Subtype:
SingleFamilyResidence
Subdivision:
LAKE IN THE WOODS SUB
Neighborhood:
area03071shelbytwp
Listed Date:
Jun 4, 2026
Finished Sq Ft:
6,410
Year Built:
2000
See this Listing
Schools
School District:
Utica
Interior
Above Grade Finished Area
4289
Appliances
BuiltInRefrigerator, BarFridge, Dishwasher, DoubleOven, Dryer, EnergyStarQualifiedDishwasher, GasCooktop, RangeHood, Washer
Bathrooms
4 Full Bathrooms, 1 Half Bathroom
Below Grade Finished Area
2121
Cooling
Ceiling Fans, Central Air, ENERGYSTAR Qualified AC Equipment
Heating
ENERGYSTAR Qualified Furnace Equipment, Forced Air, Natural Gas
Interior Features
EntranceFoyer, HighSpeedInternet, WetBar
Laundry Features
Laundry Room
Levels
Two
Exterior
Accessibility Features
Accessible Hallways, Common Area
Architectural Style
Colonial
Construction Materials
Brick
Fencing
Fencing Requiredwith Pool
Garage Spaces
3
Lot Features
CornerLot, Sprinklers
Parking Features
ThreeCarGarage, Attached, ElectricityinGarage, GarageDoorOpener, SideEntrance
Patio And Porch Features
Covered, Patio, Terrace
Roof
Asphalt
Security Features
Security System Owned
Financial
HOA Fee
$650
HOA Fee Frequency
Annually
HOA Includes
SnowRemoval
HOA Phone
AGAZZI21@YAHOO.COM 586-718-2509
Taxes
$9,164
Map
Community
- Address54150 Queensborough Drive Shelby MI
- SubdivisionLAKE IN THE WOODS SUB
- CityShelby
- CountyMacomb
- Zip Code48315
Subdivisions in Shelby
Market Summary
Current real estate data for Single Family in Shelby as of Jun 10, 2026
204
Single Family Listed
97
Avg DOM
194
Avg $ / SqFt
$603,957
Avg List Price
Property Summary
- Located in the LAKE IN THE WOODS SUB subdivision, 54150 Queensborough Drive Shelby MI is a Single Family for sale in Shelby, MI, 48315. It is listed for $1,165,000 and features 4 beds, 5 baths, and has approximately 6,410 square feet of living space, and was originally constructed in 2000. The current price per square foot is $182. The average price per square foot for Single Family listings in Shelby is $194. The average listing price for Single Family in Shelby is $603,957. To schedule a showing of MLS#20261030783 at 54150 Queensborough Drive in Shelby, MI, contact your Keller Williams Paint Creek agent at 586-663-0473.
Similar Listings Nearby

54150 Queensborough Drive
Shelby, MI
