54245 Queensborough Drive Shelby Twp, MI $ 1,349,900
54245 Queensborough Drive
$ 1,349,900
Recently Listed
Open House 5/30 12pm - 2pm
Share Save

54245 Queensborough Drive

Shelby Twp, MI, 48315
$ 1,349,900
Bedrooms5 Baths4.1 Sq 4,980

Monthly Estimate*

$ 8,312

54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 1
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 2
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 3
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 4
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 5
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 6
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 7
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 8
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 9
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 10
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 11
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 12
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 13
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 14
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 15
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 16
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 17
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 18
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 19
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 20
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 21
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 22
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 23
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 24
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 25
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 26
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 27
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 28
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 29
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 30
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 31
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 32
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 33
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 34
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 35
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 36
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 37
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 38
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 39
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 40
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 41
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 42
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 43
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 44
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 45
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 46
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 47
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 48
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 49
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 50
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 51
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 52
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 53
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 54
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 55
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 56
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 57
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 58
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 59
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 60
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 61
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 62
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 63
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 64
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 65
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 66
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 67
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 68
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 69
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 70
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 71
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 72
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 73
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 74
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 75
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 76
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 77
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 78
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 79
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 80
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 81
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 82
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 83
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 84
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 85
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 86
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 87
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 88
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 89
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 90
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 91
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 92
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 93
54245 Queensborough Drive, Shelby Twp, MI 48315 - Image 94

Single Family Home for sale in Shelby Twp, MI

for $1,349,900 with 5 bedrooms and 4 full baths, 1 half bath. This 4,980 square foot home was built in 2009 on a lot size of 0.65.

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.

See more

Open House

5/30/2026 12:00 PM - 2:00 PM
54245 Queensborough Drive Shelby Twp, MI
* Some states or local ordinances may prohibit Open Houses at this time, please confirm with your Weichert agent or local rep to confirm

Single Family Active

Price

$ 1,349,900

Bedrooms

5

Full Bath

4

Half Bath

1

Property Type

Single Family

Taxes

$ 17,538

Style

Split Level

Lot Size

0.65

Year Built

2009

Town/City

Shelby Twp

County/Region

Macomb

MLS | Web ID

50209172

Features
Interior
Interior Amenities 9 ft + Ceilings Interior Balcony Bay Window Cable/Internet Avail. Cathedral/Vaulted Ceiling Ceramic Floors Hardwood Floors Spa/Jetted Tub Security System Walk-In Closet Window Treatment(s)
Great Room Level Entry
Dining Room Level Entry
Basement Finished Walk Out Poured
Bedroom 3 Level Second
Bedroom 1 Level Entry
Bedroom 2 Level Entry
Beds 5
Fireplace? Yes
See more
General
Heating Forced Air
Kitchen Level Entry
Cooling Central A/C
Possession At Close
Fireplaces DinRoom Fireplace Grt Rm Fireplace
Garage Attached Garage Electric in Garage Gar Door Opener
Water Public Water
Appliances Bar-Refrigerator Dishwasher Disposal Dryer Humidifier Range/Oven Refrigerator Washer
Status Active Active
Full Baths 4
Half Baths 1
Bathrooms 5
Year Built 2009
Parking 3 or More Spaces Garage Paved Driveway
Pets Allowed Yes
Subdivision Lake In The Woods Sub MI
Water Heater Gas
Style Split Level
County Macomb
Class RESIDENTIAL
Type Single Family
Ownership Private
Municipality Shelby Twp
New Construction Y/N No
Zoning Residential
Sale/Rent For Sale
Status Detail 0
HOA Fee Includes Snow Removal
Structure Style 1 1/2 Story
Area Shelby Twp (50007)
Primary City Shelby Twp
City Shelby Twp
School District Utica Community Schools
Financial Terms Cash Conventional FHA VA
Legal Description L 42 V LAKE IN THE WOODS SUB LOT 42 LIBER 6616 PAGES 737-767
DOM 0
Postal Code 48315
Price Per Sq Ft Total AG 271.06
Public Remarks Welcome to an extraordinary luxury estate nestled in one of the most exclusive enclaves of Shelby Township; Lake in The Woods. Offering nearly 5
See more
Exterior
Exterior Brick Stone
Exterior Amenities Patio Porch
Frontage 323
Lot Size Area 0.65
Pool (Y/N) No
Lot Dimensions 180x164x235x88
Roads City/County
Waterfront Y/N No
Frontage Type Road
See more
* Excluded Features
List By
Kevin Kostka

Listing Agent

Epique Inc.

Broker

kkostka19@gmail.com

Email

Affordability Calculator

$9,773
Per Month
85%
15%
0%
Monthly Principal & Interest
$8,312
Monthly Property Taxes
$1,462
Monthly Home Insurance
--
Default based on a 30-year fixed rate of 6.25% with 20% down. The estimated payment is offered for convenience and is not an offer of credit. Due to market fluctuations, interest rates are subject to change at any time and without notice. Your individual rate may vary. Rates may differ for FHA, VA or jumbo loans.
Learn more about how to save

Discover how much house you can afford

Your dream home may be within reach.

Learn More about how to save

The time to sell is now
THE TIME TO SELL IS NOW! What's my home worth?
Nearby
759666 Elementary School
759828 Middle School
Unknown High School High School
Pricing History
DatePricePrice ChangeDescription
5/28/2026$1,349,900 Listed Price

Map


See all

54245 Queensborough Drive, Shelby Twp, MI, 48315 is a Single Family Home for sale at $1,349,900 with 4,980 sqft and a lot size of 0.65. 54245 Queensborough Drive has 5 bedrooms, 4.1 baths, and was built in 2009. The property's zip code is 48315 which is in Shelby Twp, MI