Active

54245 Queensborough Drive

Shelby Twp, Michigan 48315
Mark as Favorite
Bed 5

Bed

Bath 4.5

Bath

SqFt4,980

Sqft

Acres0.65

Acre(Lot)

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 f or 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

Read More Expand

Detail Ic Property Details

Property Type : Residential

Price : $1,349,900

AD Id : 79429445

MLS Id : 58050209172

Beds : 5

Lot Size : 0.65 Acre

Living Area Size : 4,980

Year Built : 2009

Garage : 3 Car

County : Macomb

Subdivision: Lake In The Woods Sub

  • Map Map

Map

Map What's Nearby

Map Nearby Areas

Feature Features

  • Bedroom Information

    Total Bedrooms: 5

    Bathroom Information

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

    Total Rooms: 20 Porches: Balcony,Patio,Porch

    Interior Features

    Other,High Spd Internet Avail,Humidifier,Jetted Tub,Security Alarm Basement Description: Finished,Walk-Out Access Fireplace: Yes Appliances: Dishwasher,Disposal,Dryer,Oven,Range/Stove,Refrigerator,Washer,Bar Fridge
  • Heating & Cooling

    Cooling: Central Air Heating: Forced Air Heating Fuel: Natural Gas

    Fireplace

    Dining Room,Great Room

    Water Heater

    Natural Gas

  • Building Information

    Year Built: 2009 Building Stories: 1 1/2 Story Fireplace: Dining Room,Great Room Foundation/Basement: Basement Architecture: Split Level
  • Exterior Features

    Construction: Brick,Stone
  • Utility Features

    Sewer: Sewer (Sewer-Sanitary)
  • Water

    Public (Municipal) Water Heat: Natural Gas

  • Lot Information

    Lot Size: 0.65 Lot Dimensions: 180x164x235x88 Lot Features: Corner Lot,Irregular Frontage Feet: 323
  • Property Information

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

  • Listing Price Information

    Original List Price: $1,349,900
  • Listing Information

    Possession: At Close Legal Description: L 42 V LAKE IN THE WOODS SUB LOT 42 LIBER 6616 PAGES 737-767

  • Tax Information

    Annual Tax: $17,538 Parcel Number: 230710278001

    Terms/Deposits/Fees

    Assoc Fee Freq: $Annually
  • Possession

    At Close
  • Legal Information

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

  • Parking Information

    Has Garage: Yes Garage Size: 3 Car Garage: 29X42 Garage Description: 2+ Assigned Spaces,Electricity,Door Opener,Attached

  • School Information

    School District: Utica
  • Fire Place Information

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

    Water: Public (Municipal) Sewer: Sewer (Sewer-Sanitary)
Sell a home like this and save $80,495 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
54150 Queensborough Dri.., Shelby Twp, MI, 48315 $1,165,000 4 4.5 4,289 4,289 SqFt
13823 Blue Beech Lane , Shelby Twp, MI, 48315 $520,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
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
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
47351 Bobwhite Lane , Shelby Twp, MI, 48315 $629,900 3 3.5 2,273 2,273 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/20/2026 @ 03:33

MLS: 58050209172 LISTED BY: Kevin Kostka , Epique Inc. 248-218-2604 SOURCE: Realcomp II Ltd

Homes around $1,349,900

Selling? Save $80,495 when you sell a home like this

Tour with a ByOwner Agent