Property photo 1
Property photo 2
Property photo 3
Property photo 4
Property photo 5
5 Beds
5 Baths
4,980 sqft

$1,250,000

54245 Queensborough Drive, Shelby Twp MI, 48315

Price per sqft$251.00
Built in2009
Property size4,980 sqft
Property typeResidential

Overview

Sold

Closed

Listed May 28, 2026

Updated Jul 25

Welcome to an extraordinary luxury estate nestled in one of the most exclusive enclaves of Shelby Township; Lake in The Woods. Offering nearly 5,000 square feet of impeccably maintained above-grade living space, plus an additional 3,000 square feet of beautifully finished walkout lower level living, this exceptional residence delivers the perfect blend of elegance, comfort, and functionality. Designed with both everyday living and entertaining in mind, the home features a dramatic two-story great room filled with natural light, creating a stunning focal point and an incredible sense of openness throughout the main living area. The spacious kitchen is complemented by a dedicated dining area large enough to comfortably accommodate even the largest of families, making it the perfect setting for gatherings and entertaining alike. A convenient first-floor laundry room further enhances the home’s thoughtful and functional layout. Two spacious first-floor primary suites each offer privacy and refined finishes, while two additional guest bedrooms are thoughtfully situated on the second level. With 4 full bathrooms and an additional half bath, the layout provides exceptional flexibility for family and guests alike. The walkout lower level is truly an entertainer’s dream, complete with an expansive custom bar featuring three brand-new wine fridges, a dedicated theatre room with $10,000 in new premium theatre seating, a barely broken in pool table and a private bedroom with its own en suite bath — ideal for extended stays or multi-generational living. Positioned on a large corner lot, the home offers exceptional curb appeal with a grand circular driveway and an oversized rear-entry 3-car garage featuring durable epoxy flooring. Every inch of this residence reflects pride of ownership and meticulous care. Significant recent mechanical updates provide peace of mind, including two tankless water heaters (May 2023), a whole-house water filtration system (September 2023), and three new high-efficiency furnaces & A/C's installed in July 2025. A professionally installed 9-camera security system further enhances the home’s modern convenience and security. Located within the highly acclaimed Utica Community Schools, this turnkey luxury property presents a rare opportunity to own a meticulously maintained estate in a premier location that truly needs nothing but new owners.

Additional information

MLS® ID
50209172

Interior Features

Bedrooms
5
Bathrooms
5
Fireplace
Yes
Cooling
Yes
Heating
Yes
Basement
Yes

Exterior Features

Lot Size
0.65 Acres

Other Property Details

Taxes
$17,538
Tax Frequency
Annually
Association Fee Frequency
Yearly
Garage
Yes
Pets Allowed
Yes
MLS provider logo

Listed by Kevin Kostka with Epique Inc.
Listing Contact: 586-610-4850 

Based on information originating from the MiRealSource as of 7/25/2026. This information is for your personal, non-commercial use and may not be used for any purpose other than to identify prospective properties you may be interested in purchasing. Display of MLS data is usually deemed reliable but is NOT guaranteed accurate by the MLS. Buyers are responsible for verifying the accuracy of all information and should investigate the data themselves or retain appropriate professionals. Information from sources other than the Listing Agent may have been included in the MLS data. Unless otherwise specified in writing, the Broker/Agent has not and will not verify any information obtained from other sources. The Broker/Agent providing the information contained herein may or may not have been the Listing and/or Selling Agent. Property locations as displayed on any map are best approximations only and exact locations should be independently verified. Any offer of compensation is made only to participants of the MLS where the listing is filed.

©2026 MiRealSource all rights reserved.

Data last updated on 7/25/2026 at 3:08 AM UTC

Powered by Luxury Presence