RateMyAgentGo to search
Back 54245 Queensborough Drive
Off Market

54245 Queensborough Drive

Utica MI 48315

5
5
3
8441 sq. ft.
0.65 ac.
Single-Family
Last sold for $1,250,000
Kevin KostkaKevin Kostka, last sold this property on 24 July 2026 after 57 days on market.

Overview

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.

Features

5 bedrooms
5 bathrooms
3 carspaces
3 garage spaces
8441 sq. ft. floor area
0.65 ac. lot size
Single-Family

Estimated Value

Based on this property and similar 5 bedroom single-family properties sold in Utica over the last 12 months, the estimated median property value of 54245 Queensborough Drive is $780k.

Median value
$780k
Estimated value range
$539.9k - $1.25m
Median days on market
21
Estimated value trend
29%
increase over the last 12 months
Average days on market is based on recent, comparable sales in Utica. It is only an indication of the time a property is actively listed and should not be relied upon as an accurate representation of how soon a property will be sold.

Property history for 54245 Queensborough Drive

2026
Sold
$1,250,000
24 Jul 2026 by Kevin Kostka, of Epique Inc.
2022
Sold
$1,150,000
12 May 2022 by Anthony Djon, of Anthony Djon Luxury Real Estate

Happy sellers in Utica

~%

We have insufficient information to provide an overview of customer satisfaction for Utica. Viewing the agent profiles, reviews and sales for Utica can provide insights for this location.

Local market activity for 5 bedroom single-family properties in Utica

In the last 12 months, 12 five-bedroom single-family properties similar to 54245 Queensborough Drive, have been sold.

This represents a 160% decrease in five-bedroom single-family properties sales when compared to the previous 12 months.

Nearby agents

Compare and contact these top performing agents who’ve delivered exception customer service for their clients in Utica

placeholder
Rami Yasi

Rami Yasi is a recommended agent for Utica.  They have 2 local sales and collected 2 local reviews across the last 12 months.

  •   5   (117 reviews)
  •  2 Reviews in Utica
  •  2 Sales in Utica
View profile
placeholder
Bridget Robidoux

Sellers who recommend Bridget Robidoux have praised them for being local expert, clear communication, supportive, well-prepared, responsive, reliable, and dedicated

  •   5   (28 reviews)
  •  2 Reviews in Utica
  •  1 Sale in Utica
View profile
placeholder
Tiffany Bruno

Sellers who recommend Tiffany Bruno have praised them for being local expert, clear communication, responsive, supportive, friendly, enthusiastic, and dedicated

  •   5   (39 reviews)
  •  1 Review in Utica
  •  1 Sale in Utica
View profile
placeholder
Ereny Gaied

Sellers who recommend Ereny Gaied have praised them for being local expert, responsive, clear communication, honest, dedicated, patient, and supportive

  •   5   (113 reviews)
  •  1 Review in Utica
  •  1 Sale in Utica
View profile
or
Skip the list and find your ideal agent to sell your propertyFind My Agent
RateMyAgent
Sales:
(619) 566-0008
Quick Links
© 2026 RateMyAgent
Privacy PolicyTerms & ConditionsLicensingSitemap