Recently Listed Open House 5/30 12pm - 2pm
54245 Queensborough Drive
Shelby Twp, MI, 48315 $ 1,349,900
Bedrooms5 Baths4.1 Sq 4,980 Monthly Estimate*
$ 8,312
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
FeaturesInteriorInterior 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
GeneralHeating 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
ExteriorExterior 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 FeaturesList ByKevin KostkaListing Agent
Affordability Calculator
- 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 NearbySingle family listings in Shelby Twp, MI
Average List Price $574,606
Percent of Sale Price 57%
Trends Information provided by ATTOM Data Solutions.
759666 Elementary School
759828 Middle School
Unknown High School High School
Pricing History| Date | Price | Price Change | Description |
|---|
| 5/28/2026 | $1,349,900 | | Listed Price |