Coldwell Banker Home Page
Local Realty Service Provided By: Coldwell Banker Real Estate Group
Property view
Listing view 2
Listing view 3

54245 Queensborough, 
Shelby Twp, MI 48315

$1,349,900


5

Beds


5

Baths


4,980

Sq Ft


Single Family

Active

Listed by

Kevin Kostka

Epique Inc.

248-218-2604

Last updated:

June 2, 2026, 10:14 AM

MLS#

50209172

Source:

MI REALSOURCE

About This Home

54245 Queensborough

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.

Home Facts

Single Family

5 Baths

5 Bedrooms

Built in 2009

Price Summary

1,349,900

$271 per Sq. Ft.

MLS #:

50209172

Last Updated:

June 2, 2026, 10:14 AM

Added:

7 day(s) ago


Rooms & Interior

Bedrooms

Total Bedrooms:

5

Bathrooms

Total Bathrooms:

5

Full Bathrooms:

4

Interior

Living Area:

4,980 Sq. Ft.


Structure

Structure

Architectural Style:

Split Level

Building Area:

8,441 Sq. Ft.

Year Built:

2009


Lot

Lot Size (Sq. Ft):

28,314


Finances & Disclosures

Finances

Price:

$1,349,900

Price per Sq. Ft:

$271 per Sq. Ft.

Source:MI REALSOURCE
The information being provided by Michigan Mls/Mirealsource is for the consumer’s personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The information is deemed reliable but not guaranteed and should therefore be independently verified. © 2026 Michigan Mls/Mirealsource All rights reserved.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.

Contact an Agent

Yes, I would like more information. Please use and/or share my information with a Coldwell Banker ® affiliated agent to contact me about my real estate needs. By clicking Contact, I request to be contacted by phone or text message and consent to being contacted by automated means. I understand that my consent to receive calls or texts is not a condition of purchasing any property, goods, or services. Alternatively, I understand that I can access real estate services by email or I can contact the agent myself.

If a Coldwell Banker affiliated agent is not available in the area where I need assistance, I agree to be contacted by a real estate agent affiliated with another brand owned or licensed by Anywhere Real Estate (BHGRE®, CENTURY 21®, Corcoran®, ERA®, or Sotheby's International Realty®). I acknowledge that I have read and agree to the terms of use and privacy notice.