54245 Queensborough Drive Shelby Twp, MI $ 1,349,900
54245 Queensborough Drive
$ 1,349,900
Recently Listed
Share Save

54245 Queensborough Drive

Shelby Twp, MI, 48315
$ 1,349,900
Bedrooms5 Baths4.1 Sq 8,441

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 8,441 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

See more

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

58050209172

Features
Interior
Interior Amenities Balcony CathedralCeilings EatInKitchen EntranceFoyer HighCeilings HighSpeedInternet JettedTub WalkInClosets
Basement Concrete Finished WalkOutAccess
Flooring CeramicTile Hardwood
Fireplace Features DiningRoom GreatRoom
Basement (Y/N) Y
Air Conditioning Y/N Y
Heating Y/N Y
Window Features BayWindows WindowTreatments
Fireplace Y/N Y
Above Grade Finished Area 4980.0
Half Baths 1
Total Bedrooms 5
Below Grade Finished Area 3461.0
Above Grade Finished Area Source PublicRecords
Above Grade Finished Area Unit Type SquareFeet
Total Baths 5
See more
General
Sewer PublicSewer
Heating ForcedAir NaturalGas
Cooling CentralAir
Possession AtClose
Appliances BarFridge Dishwasher Disposal Dryer Humidifier Oven Refrigerator Range Washer
HOA Fee 600.0
Garage Spaces 3.0
Association Fee Includes SnowRemoval
Patio/Porch Features Patio Porch
Architectural Style SplitLevel
Pool Features None
Security Features SecuritySystem
Construction Materials Brick Stone
Pets Allowed DogsOk Yes
Year Built 2009
Levels OneAndOneHalf
Property Subtype SingleFamilyResidence
Tax Year 2025
Assoc Fee Paid Per Annually
County Macomb
New Construction N
Property Type Residential
HOA Y
Attached Garage Y
Subdivision Name LAKE IN THE WOODS SUB
Garage Y/N Y
Total Rooms 15
Full Baths 4
Status Active
City ShelbyCharterTownship_Macomb
Disclosures TaxesHomesteadExempt
Association Name 5867097779
Senior Community Y/N N
High School District Utica
Zoning Description Residential
MLS Area Area03071ShelbyTwp
Carport Y/N N
Land Lease Y/N N
Tax Annual Amount 17538.0
Home Warranty Y/N N
Lease Renewal Y/N N
Additional Parcels Y/N N
Lease Considered Y/N N
Rent Control Y/N N
Standard Status Active
Legal Description L 42 V LAKE IN THE WOODS SUB LOT 42 LIBER 6616 PAGES 737-767
See more
Exterior
Parking Features Assigned2Spaces ThreeCarGarage Attached ElectricityinGarage Garage GarageDoorOpener Paved
Lot Features CornerLot IrregularLot ManyTrees
Water Source Public
Foundation Details Basement
Spa N
Lot Dimensions 180x164x235x88
Lot Size Acres 0.65
Waterfront Y/N N
Crops Included Y/N N
Road Responsibility PublicMaintainedRoad
Horse Y/N N
Irrigation Water Rights Y/N N
See more
Internal Only
Street Number 1 54245
See more
* Excluded Features
List By
Kevin Kostka

Listing Agent

Epique Inc.

Broker

(586) 610-4850

Phone

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
848440 Elementary School
848594 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 8,441 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