Active

54150 Queensborough Drive

Shelby Twp, Michigan 48315
Mark as Favorite
Bed 4

Bed

Bath 4.5

Bath

SqFt4,289

Sqft

Acres0.56

Acre(Lot)

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 retr eat, 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.

Read More Expand

Detail Ic Property Details

Property Type : Residential

Price : $1,165,000

AD Id : 80037183

MLS Id : 20261030783

Beds : 4

Lot Size : 0.56 Acre

Living Area Size : 4,289

Year Built : 2000

Garage : 3 Car

County : Macomb

Subdivision: Lake In The Woods Sub

  • Map Map

Map

Feature Features

  • Bedroom Information

    Total Bedrooms: 4

    Bathroom Information

    Total Baths: 4.5 Full Baths: 4 Half Baths: 1
  • Room Information

    Total Rooms: 18 Porches: Patio,Terrace,Patio - Covered,Covered

    Interior Features

    Cable Available,Entrance Foyer,High Spd Internet Avail,Security Alarm (owned),Wet Bar Roof: Asphalt Basement Description: Finished,Walk-Out Access Fireplace: Yes Appliances: Built-In Refrigerator,Dishwasher,Double Oven,Dryer,ENERGY STAR® qualified dishwasher,Gas Cooktop,Range Hood,Washer,Bar Fridge
  • Heating & Cooling

    Cooling: Ceiling Fan(s),Central Air,ENERGY STAR® Qualified A/C Equipment Heating: ENERGY STAR® Qualified Furnace Equipment,Forced Air Heating Fuel: Natural Gas

    Fireplace

    Basement,Great Room

    Water Heater

    ENERGY STAR® Qualified Water Heater,Natural Gas

  • Building Information

    Year Built: 2000 Building Stories: 2 Story Fireplace: Basement,Great Room Roof: Asphalt Foundation/Basement: Basement Architecture: Colonial
  • Exterior Features

    Construction: Brick
  • Utility Features

    Sewer: Septic Tank (Existing)
  • Water

    Public (Municipal) Water Heat: ENERGY STAR® Qualified Water Heater,Natural Gas

  • Lot Information

    Lot Size: 0.56 Lot Dimensions: 142x170x145x170 Lot Features: Corner Lot,Sprinkler(s) Frontage Feet: 142
  • Property Information

    SQ ft: 4289 Subdivision: Lake In The Woods Sub Financing: Cash,Conventional,VA

  • Listing Price Information

    Original List Price: $1,165,000
  • Listing Information

    Possession: Close Plus 3-5 Days Legal Description: L 59 V LAKE IN THE WOODS SUB LOT 59 LIBER 6616 PAGES 737-767

  • Tax Information

    Annual Tax: $9,164 Parcel Number: 0710277009

    Terms/Deposits/Fees

    Assoc Fee Freq: $Annually
  • Possession

    Close Plus 3-5 Days
  • Legal Information

    Legal Description: Section: L 59 V LAKE IN THE WOODS SUB LOT 59 LIBER 6616 PAGES 737-767

  • Parking Information

    Has Garage: Yes Garage Size: 3 Car Garage Description: Side Entrance,Electricity,Door Opener,Attached
  • Multi-Unit Information

    Road Frontage: Paved

  • School Information

    School District: Utica
  • Fire Place Information

    Fire Place: Yes Fire Place Location: Basement,Great Room
  • Utility Information

    Water: Public (Municipal) Sewer: Septic Tank (Existing)
Sell a home like this and save $69,401 Find out How

How much is this property worth?

Curious about this home's true market value? Use our free Home Evaluation Tool to instantly get a personalized Comparative Market Analysis (CMA) report. Make smarter, data-driven decisions before you buy.

Images
Loading, please wait...

Nearby Home Value

Address Estimate Bed Bath Sq. Ft Lot Size
14871 Crofton Drive , Shelby Twp, MI, 48315 $500,000 3 2.5 2,375 2,375 SqFt
55733 Whitney Court , Shelby Twp, MI, 48315 $859,900 5 5 4,473 4,473 SqFt
13823 Blue Beech Lane , Shelby Twp, MI, 48315 $540,000 3 2.5 2,179 2,179 SqFt
52598 Bordeaux Way , Shelby Twp, MI, 48315 $439,999 3 2.5 1,877 1,877 SqFt
48430 Montelepre Drive , Shelby Twp, MI, 48315 $650,000 5 3.5 3,100 3,100 SqFt
14751 Ashton Lane , Shelby Twp, MI, 48315 $539,900 4 3.5 2,630 2,630 SqFt
14559 Keswick Drive , Shelby Twp, MI, 48315 $35,000 3 2 1,850 1,850 SqFt
53291 Shanelle Lane , Shelby Twp, MI, 48315 $639,900 4 4.5 3,288 3,288 SqFt
14382 Knightsbridge Dri.., Shelby Twp, MI, 48315 $799,900 4 5.5 4,020 4,020 SqFt
50091 Wensleydale Court , Shelby Twp, MI, 48315 $45,000 3 2 1,800 1,800 SqFt
MLS Logo

Disclosure: The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified. Any use of search facilities of data on the site, other than by a consumer looking to purchase real estate, is prohibited. IDX provided courtesy of Realcomp II Ltd., via ByOwner.com and REALCOMP, Copyright 2026 Realcomp II Ltd. Shareholders. REALTOR (R) licensed in the state of Michigan. The listing broker’s offer of compensation is made only to participants of the MLS where the listing is filed and to participants of any data share partner MLS.

ByOwner last updated this listing 06/19/2026 @ 09:27

MLS: 20261030783 LISTED BY: Danielle Christoff , EXP Realty Romeo 586-372-6057 SOURCE: Realcomp II Ltd

Homes around $1,165,000

Selling? Save $69,401 when you sell a home like this

Tour with a ByOwner Agent