Ad #7791085
MLS #50209172
Welcome to an extraordinary luxury estate nestled in one of the
54245 Queensborough Dr, Shelby, Michigan, 48315
$1,349,900
5Beds
5Baths
8,441Sqft
0.650Acres
About this property
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.
Property Features
5 Beds
5 Baths
8,441 Sqft
Built in 2009
0.650 Acres
2 Stories
Driveway, Garage
Has Fireplace
Forced Air
Macomb County
Lake In The Woods Sub Community
Additional Photos
Contact Information
Kevin Kostka
Epique Realty
586-610-4850
Location
Listing Agent: Kevin Kostka 586-610-4850
Broker: Epique Realty 248-218-2604 Listing Site
Copyright © 2026 Multiple Listing Service MiRealSource. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
Broker: Epique Realty 248-218-2604 Listing Site
Copyright © 2026 Multiple Listing Service MiRealSource. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
BeachHouse.com
Printed Jun 4, 2026
Photo Gallery
$1,349,900
5
Beds
5
Baths
8,441
Sqft
54245 Queensborough Dr, Shelby, Michigan, 48315
By contacting this agent you agree to these Terms and Conditions.
MLS# 50209172
Welcome to an extraordinary luxury estate nestled in one of the
$1,349,900
54245 Queensborough Dr, Shelby, Michigan, 48315
5
Beds
5
Baths
8,441
Sqft
0.650
Acres
$1,349,900
54245 Queensborough Dr, Shelby, Michigan, 48315
5 Beds
5 Baths
8,441 Sqft
0.650 Acres
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.
6 days
on BeachHouse.com
20
views
0
saves
Property Details
HOME DETAILS
5 Beds
5 Baths
8,441 Sqft
Built in 2009
0.650 Acres
2 Stories
EXTERIOR
Driveway, Garage
INTERIOR
Has Fireplace
Forced Air
FINANCIAL & COMMUNITY
Macomb County
Lake In The Woods Sub Community
See More Details
Location
Mortgage Calculator
Ad Statistics
Ad Number
7791085
Viewed
20 times
Listing Status
Active
Added
May 28, 2026
Last Refresh
Jun 04, 2026 11:39:05 AM
Listing Information
Data Source
Multiple Listing Service MiRealSource
Source Property ID
50209172
Listing Agent: Kevin Kostka 586-610-4850
Broker: Epique Realty 248-218-2604 Listing Site
Copyright © 2026 Multiple Listing Service MiRealSource. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
Broker: Epique Realty 248-218-2604 Listing Site
Copyright © 2026 Multiple Listing Service MiRealSource. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
Request Information
Start advertising today
Explore options for real estate agents and homeowners advertising on BeachHouse.com
Sell Your Home
Explore Similar Properties
