x
Showing 1 of 0
X
Save

54245 Queensborough
Shelby Twp MI 48315 US

$1,349,900

Active Listing ID 50209172
bed icon
5 bed
bath icon
5.00 Bath (4 Full , 1 Half)
lot icon
Lot: 0.65 Acres
home icon
Single Family Residence

$1,349,900

Active Listing ID 50209172
Save

54245 Queensborough 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.

Collapse all

Property Features

  • Facts
  • Lot Size: 0.65 Acres
  • Property Type: Residential
  • Property Sub-type: Single Family Residence
  • Features
  • Full Bathrooms: 4
  • 1/2 Bathrooms: 1
  • Cooling System: Central Air
  • Exterior Finish: Patio, Porch, Dogs Allowed
  • Floor Covering: Carpet, Tile, Wood
  • Heating Fuels: Fireplace(s), Forced Air
  • Additional Features
  • Fireplace
  • Patio

Property

  • propertytype: Residential
  • propertysubtype: Single Family Residence
  • listprice: 1349900
  • unparsedaddress: 54245 Queensborough
  • postalcity: Shelby Twp
  • stateorprovince: MI
  • country: US
  • postalcode: 48315
  • bathroomsfull: 4
  • bathroomshalf: 1
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 0.65
  • lotsizeunits: Acres
  • lotsizearea: 0.65
  • livingarea: 4980
  • livingareaunits: Square Feet
  • listagentfullname: Kevin Kostka
  • listagentemail: kkostka19@gmail.com
  • listagentkey: 3yd-MIREAL-211491
  • listagentmlsid: 211491
  • listagentpreferredphone: 5866104850
  • listagentofficephone: 2482182604
  • listofficekey: 3yd-MIREAL-110568
  • listagentstatelicense: 6506046875
  • listofficemlsid: 110568
  • disclaimer: 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.
  • sourcesystemid: MIREAL
  • yearbuilt: 2009
  • listingcontractdate: 2026-05-28
  • listagenturl: https://epiquerealty.com
  • countyorparish: Macomb
  • parcelnumber: 23-07-10-278-001
  • elementaryschooldistrict: Utica Community Schools
  • middleorjuniorschooldistrict: Utica Community Schools
  • highschooldistrict: Utica Community Schools
  • appliances: Dishwasher, Dryer, Garbage Disposer, Range, Refrigerator, Refrigerator - Bar, Washer
  • cooling: Central Air
  • constructionmaterials: Brick, Stone
  • flooring: Carpet, Tile, Wood
  • heating: Fireplace(s), Forced Air
  • fireplaceyn: True
  • transactiontype: ForSale
  • storiestotal: 1.5
  • parkingtotal: 0
  • parkingfeatures: Driveway, Garage, Garage - Attached, Paved or Surfaced
  • waterfrontyn: False
  • interiorfeatures: 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)
  • exteriorfeatures: Patio, Porch, Dogs Allowed
  • architecturalstyle: Split Level
  • rooms: Basement, Bathroom 1, Bathroom 2, Bathroom 3, Bathroom 4, Bathroom 5, Bedroom 1, Bedroom 2, Bedroom 3, Bedroom 4, Bedroom 5, Dining Room, Great Room, Kitchen
  • securityfeatures: Security System
  • utilities: Cable Available
  • patioandporchfeatures: Patio, Porch
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"Epique Realty", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "Expenses":[{"ExpenseCategory":"Home Owner Assessments Fee", "ExpenseFrequency":"Annually", "ExpenseValue":600}], "GeocodeOptions":null, "LeadRoutingEmail":"kkostka19@gmail.com", "ListBrokerageCity":"Houston", "ListBrokerageCountry":"US", "ListBrokerageEmail":"mi.realsource.mls@epique.me", "ListBrokerageLogoUrl":null, "ListBrokerageName":"Epique Realty", "ListBrokeragePhone":"(512) 387-0722", "ListBrokeragePostalCode":"77084", "ListBrokerageStateOrProvince":"TX", "ListBrokerageUnitNumber":null, "ListBrokerageUnparsedAddress":"16225 Park Ten Pl", "ListBrokerageWebsiteUrl":"https://epiquerealty.com", "ListOfficeAddress1":"411 S Main Street", "ListOfficeAddress2":null, "ListOfficeBrokerMlsId":null, "ListOfficeCity":"Rochester", "ListOfficeCountry":"US", "ListOfficeEmail":"mibroker@epiquerealty.com", "ListOfficePostalCode":"48307", "ListOfficeStateOrProvince":"MI", "ListPriceCurrencyType":"USD", "ListingTitle":"Split Level, Single Family - Shelby Twp, MI", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/54245-Queensborough-Dr_Shelby-Twp_MI_48315_M30766-77052?f=listhub&s=MIREAL&m=50209172&c=rexren", "MLSModificationTimestamp":"2026-05-28T21:50:03Z", "Neighborhoods":[{"Description":null, "Name":"Shelby Twp (50007)"}], "PostalCode":null, "RawPropertySubType":null, "RawPropertyType":"Single Family", "RoomCount":null, "StateOrProvince":null, "Taxes":[], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 5/30/2026 5:32:01 PM GMT
Source Updated Date: 6/3/2026 6:54:35 PM GMT

Courtesy of: Kevin Kostka, Epique Inc., kkostka19@gmail.com

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.