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

54150 Queensborough Drive, 
Shelbytwp, MI 48315

$1,165,000


4

Beds


5

Baths


6,410

Sq Ft


Single Family

Active

Listed by

Danielle Christoff

, 

Kenneth J Hirschmann

eXp Realty Romeo

, 

eXp Realty

586-372-6057

Last updated:

June 6, 2026, 10:00 AM

MLS#

20261030783

Source:

MI REALCOMP

About This Home

54150 Queensborough Drive

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.

Home Facts

Single Family

5 Baths

4 Bedrooms

Built in 2000

Price Summary

1,165,000

$181 per Sq. Ft.

MLS #:

20261030783

Last Updated:

June 6, 2026, 10:00 AM

Added:

2 day(s) ago


Rooms & Interior

Bedrooms

Total Bedrooms:

4

Bathrooms

Total Bathrooms:

5

Full Bathrooms:

4

Interior

Living Area:

6,410 Sq. Ft.


Structure

Structure

Architectural Style:

Colonial

Year Built:

2000


Lot

Lot Size (Sq. Ft):

24,393


Finances & Disclosures

Finances

Price:

$1,165,000

Price per Sq. Ft:

$181 per Sq. Ft.

MLS Logo
The information being provided by Realcomp Ii Ltd. 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 Realcomp Ii Ltd. 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.