Skip to main content
For Sale

54245 Queensborough Drive, Shelby Twp, MI 48315

$1,349,900
5 beds4 bathsBuilt 20090.65 acres3 MLS listings
54245 Queensborough Drive, Shelby Twp, MI 48315 — front exterior
1 / 94

Description

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.

Price & Status History

May 28, 2026MLS #50209172
Listed for sale
$1,349,900
May 12, 2022MLS #2220014378
Sold
$1,150,000
Mar 4, 2022MLS #2220014378
Listed for sale
$1,299,000
Jun 8, 2020MLS #2200041626
Listed for sale
$1,100,000

MLS Listing History3 listings

StatusList PriceSale PriceListedSoldBoard
For Sale$1,349,900May 28, 2026MiRealView →
Sold$1,299,000$1,150,000Mar 4, 2022May 12, 2022RealcompView →
Canceled$1,100,000Jun 8, 2020RealcompView →

Property Details

Property TypeResidentialBedrooms5Bathrooms4Lot Size0.65 acresYear Built2009CityShelby TwpMunicipalityShelby TwpZip Code48315School DistrictUticaTerms AcceptedCash, Conventional, FHA, VA Loan

Listed by Kevin Kostka

Epique Inc.

Browse All Neighborhoods
Browse All Condos
Ann Arbor
Ypsilanti
Allen Park
Belleville
Birmingham
Bloomfield Hills
Brighton
Canton
Chelsea
Clawson
Commerce
Dearborn
Detroit
Dexter
Farmington Hills
Ferndale
Flat Rock
Franklin
Howell
Livonia
Luna Pier
Manchester
Melvindale
Milan
Milford
Monroe
New Boston
New Hudson
Northville
Novi
Plymouth
Rochester Hills
Romulus
Royal Oak
Saline
South Lyon
South Rockwood
Southfield
Sterling Heights
Taylor
Temperance
Trenton
Troy
Utica
Walled Lake
Warren
Waterford
Wayne
Westland
Wixom
Zip_48165
Zip_48315
Browse All Towns & Cities
Ada TwpAddison TwpAdrian TwpAhmeekAkronAlaiedon TwpAlamo TwpAlansonAlbee TwpAlbion TwpAlgoma TwpAlgonacAllegan TwpAllenAllendale TwpAlmaAlmont TwpAlpenaAlpine TwpAnn Arbor TwpApplegateArcadia TwpArgentine TwpArmada TwpAsh TwpAshleyAthens TwpAtlas TwpAttica TwpAu GresAuburnAuburn HillsAugusta TwpAurelius TwpBad AxeBainbridge TwpBaldwinBancroftBangorBaroda TwpBarrytonBattle CreekBay CityBear LakeBeavertonBedford TwpBeldingBellaireBellevueBenton HarborBenton TwpBenzoniaBerkleyBerlin TwpBerrien SpringsBerrien TwpBertrand TwpBessemerBeulahBeverly HillsBig RapidsBingham FarmsBirch Run TwpBlackman TwpBlendon TwpBlissfield TwpBloomfield TwpBloomingdaleBlue Lake TwpBlumfield TwpBowne TwpBoyne CityBoyne FallsBrady TwpBrandon TwpBrant TwpBreckenridgeBreedsvilleBridgeport TwpBridgewater TwpBridgmanBrighton TwpBrittonBrockway TwpBronsonBrooklynBrown CityBrownstown TwpBruce TwpBuchanan TwpBuckleyBuena Vista TwpBunker Hill TwpBurlington TwpBurnside TwpBurr OakBurtchville TwpBurtonByron TwpCadillacCaledonia TwpCalumetCambridge TwpCamdenCannon TwpCanton TwpCapacCarletonCaroCarrollton TwpCarson CityCarsonvilleCascade TwpCasco TwpCasevilleCasnovia TwpCaspianCass CityCassopolisCedar Creek TwpCedar SpringsCement CityCenter LineCentral LakeCentrevilleChapin TwpCharleston TwpCharlevoixCharlotteCheboyganChesaning TwpCheshire TwpChester TwpChesterfield TwpChikaming TwpChina TwpClareClarence TwpClarendon TwpClarksvilleClay TwpClayton TwpClimax TwpClinton TwpClioClyde TwpCohoctah TwpColdwaterColemanColoma TwpColonColumbia TwpColumbiavilleColumbus TwpCommerce TwpComstock TwpConcord TwpConstantineConvis TwpConway TwpCooper TwpCoopersvilleCopemishCorunnaCottrellville TwpCourtland TwpCrockery TwpCroswellCusterDalton TwpDavison TwpDe Tour VillageDearborn HeightsDecaturDeckervilleDeerfield TwpDelhi TwpDewittDexter TwpDimondaleDorr TwpDouglasDover TwpDowagiacDryden TwpDundee TwpDurandEast China TwpEast Grand RapidsEast JordanEast LansingEast TawasEastlakeEastpointeEaton RapidsEau ClaireEckford TwpEcorseEdmoreEdwardsburgEgelston TwpElba TwpElbertaElk RapidsElktonEllsworthElsieEmmett TwpEmpireErie TwpEscanabaEssexvilleEstral BeachEvartExeter TwpFairfield TwpFairgroveFarmingtonFarwellFennvilleFenton TwpFerrysburgFife LakeFillmore TwpFlint TwpFlushing TwpForest TwpForestvilleFort Gratiot TwpFountainFowlerFowlervilleFrankenmuth TwpFrankfortFranklin TwpFraserFredonia TwpFree SoilFreedom TwpFreeportFremont TwpFrenchtown TwpFruitland TwpFruitport TwpGagetownGaines TwpGalesburgGalien TwpGanges TwpGarden CityGaylordGenesee TwpGenoa TwpGeorgetown TwpGibraltarGladwinGoblesGoodland TwpGoodrichGrand BeachGrand Blanc TwpGrand Haven TwpGrand LedgeGrand Rapids TwpGrandvilleGrant TwpGrass Lake TwpGrattan TwpGraylingGreen Oak TwpGreenvilleGreenwood TwpGrosse Ile TwpGrosse PointeGrosse Pointe FarmsGrosse Pointe ParkGrosse Pointe WoodsGroveland TwpGun Plain TwpHadley TwpHagar TwpHamburg TwpHamtramckHandy TwpHanover TwpHarbor BeachHarper WoodsHarriettaHarrison TwpHarrisvilleHartHartfordHartland TwpHastingsHazel ParkHeath TwpHenrietta TwpHerseyHesperiaHighland ParkHighland TwpHillmanHillsdaleHolland TwpHolly TwpHolton TwpHomer TwpHonorHopkins TwpHoughtonHoward CityHowell TwpHubbardstonHudson TwpHudsonvilleHuron TwpIda TwpImlay CityIndependence TwpIngham TwpInksterIoniaIosco TwpIra TwpIron MountainIron RiverIronwoodIshpemingIthacaJacksonJames TwpJamestown TwpJonesfield TwpJonesvilleKalamazoo TwpKalevaKalkaskaKeego HarborKenockee TwpKent CityKentwoodKimball TwpKingsleyKingstonKochville TwpL AnseLa Salle TwpLaingsburgLake AngelusLake AnnLake CityLake IsabellaLake OdessaLake OrionLakefield TwpLaketon TwpLaketown TwpLakeviewLakewood ClubLansing TwpLapeer TwpLathrupLauriumLawrenceLawtonLe RoyLee TwpLeighton TwpLennonLenox TwpLeonardLeoni TwpLeroy TwpLeslie TwpLexingtonLiberty TwpLima TwpLincoln ParkLincoln TwpLindenLitchfieldLocke TwpLodi TwpLondon TwpLowell TwpLudingtonLutherLyndon TwpLynn TwpLyon TwpLyonsMackinac IslandMackinaw CityMacomb TwpMacon TwpMadison HeightsMadison TwpMancelonaManchester TwpManisteeManistiqueManlius TwpMantonMaple Grove TwpMaple RapidsMarathon TwpMarcellusMarengo TwpMarine CityMarion TwpMarletteMarquetteMarshall TwpMartin TwpMarysvilleMasonMattawanMaybeeMayfield TwpMayvilleMcbainMcbrideMecostaMedina TwpMelvinMemphisMendonMeridian TwpMerrillMesickMetamora TwpMichianaMiddlevilleMidlandMilan TwpMilford TwpMillersburgMillingtonMinden CityMonroe TwpMontague TwpMonterey TwpMontgomeryMontrose TwpMoorland TwpMorenciMorleyMorriceMount ClemensMount Morris TwpMount PleasantMuirMullikenMundy TwpMunisingMuskegon HeightsMuskegon TwpMussey TwpNapoleon TwpNashvilleNelson TwpNew BaltimoreNew Buffalo TwpNew EraNew HavenNew LothropNewaygoNewberryNewton TwpNiles TwpNorth AdamsNorth Branch TwpNorth MuskegonNorthfield TwpNorthportNorthville TwpNorton ShoresNorvell TwpNorwayNovi TwpOakfield TwpOakland TwpOakleyOceola TwpOgden TwpOlive TwpOlivetOmerOnawayOnekamaOnondaga TwpOnstedOrchard LakeOregon TwpOrion TwpOronoko TwpOrtonvilleOshtemo TwpOtisvilleOtsego TwpOtter LakeOverisel TwpOvidOwossoOxford TwpPalmyra TwpParchmentPark TwpParma TwpPavilion TwpPaw PawPeckPellstonPennfield TwpPentwaterPerrintonPerryPetersburgPetoskeyPewamoPiersonPigeonPinconningPipestone TwpPlainfield TwpPlainwellPleasant RidgePlymouth TwpPolkton TwpPontiacPort AustinPort HopePort Huron TwpPort SanilacPort Sheldon TwpPortagePortlandPosenPottervillePrairie Ronde TwpPrescottPulaski TwpPutnam TwpQuincyRaisin TwpRaisinville TwpRavenna TwpRay TwpReadingRedford TwpReed CityReeseRich TwpRichfield TwpRichland TwpRichmond TwpRidgeway TwpRiga TwpRiley TwpRiver RougeRiverviewRives TwpRobinson TwpRochesterRockfordRockwoodRogers CityRollin TwpRome TwpRomeoRoosevelt ParkRoscommonRose CityRosebushRosevilleRoss TwpRothburyRoyal Oak TwpRoyalton TwpSaginaw TwpSalem TwpSaline TwpSand LakeSandstone TwpSanduskySanfordSaranacSaugatuck TwpSault Ste MarieSchoolcraft TwpScottvilleSebewaingSeneca TwpSharon TwpShelby TwpShepherdSheridan TwpSherwoodShorehamSodus TwpSolon TwpSouth HavenSouthfield TwpSouthgateSparta TwpSpaulding TwpSpencer TwpSpring Arbor TwpSpring Lake TwpSpringfield TwpSpringport TwpSt Charles TwpSt Clair ShoresSt Clair TwpSt IgnaceSt JohnsSt Joseph TwpSt LouisStandishStantonStanwoodStephensonSterlingStevensvilleStockbridge TwpSturgisSullivan TwpSummerfield TwpSummit TwpSumpter TwpSunfieldSuttons BaySwan Creek TwpSwartz CreekSylvan LakeSylvan TwpTallmadge TwpTawas CityTaymouth TwpTecumseh TwpTekonsha TwpTexas TwpThetford TwpThomas TwpThompsonvilleThree Oaks TwpThree RiversTittabawassee TwpTompkins TwpTraverse CityTrowbridge TwpTurnerTustinTwiningTyrone TwpUblyUnadilla TwpUnion CityUnionvilleValley TwpVan Buren TwpVandaliaVanderbiltVassarVergennes TwpVermontvilleVernonVevay TwpVicksburgVienna TwpVillage Of ClarkstonVillage Of Grosse Pointe ShoresWakefieldWakeshma TwpWaldronWales TwpWalkerWalkervilleWashington TwpWaterford TwpWaterloo TwpWatervliet TwpWatson TwpWayland TwpWebbervilleWebster TwpWeesaw TwpWest Bloomfield TwpWest BranchWestphaliaWheatfield TwpWhite CloudWhite Lake TwpWhite Oak TwpWhite PigeonWhite River TwpWhiteford TwpWhitehall TwpWhitmore LakeWhittemoreWilliamstonWilliamstown TwpWolverineWolverine LakeWoodhavenWoodlandWoodstock TwpWright TwpWyandotteWyomingYaleYork TwpYpsilanti TwpZeeland TwpZilwaukee Twp