Sign In

Close

x
Showing 1 of 0
X
Save
54182 Queensborough Drive Shelby Twp MI 48315US5 Bed, 5.00 Bath (4 Full Bath , 1 Half Bath), 20261055417
54182 Queensborough Drive Shelby TwpMI48315
1100000.0000 1/1/1900 12:00:00 AM
Realty Executives Showcase Commercial
49433 Hayes RdShelby TownshipMI48315
586-726-4600
1 /

Courtesy of: Mariam Boutros, Community Choice Realty Inc, mariam@summitunionre.com

54182 Queensborough Drive
Shelby Twp MI 48315 US

Save
1 /

Courtesy of: Mariam Boutros, Community Choice Realty Inc, mariam@summitunionre.com

Realty Executives Showcase Commercial
49433 Hayes Rd
Shelby Township, MI, US 48315
586-726-4600

Get more info about this property

54182 Queensborough Drive
Shelby Twp MI 48315 US

$1,100,000

Active Listing ID 20261055417
bed icon
5 bed
bath icon
5.00 Bath (4 Full , 1 Half)
lot icon
Lot: 0.51 Acres
home icon
Other

$1,100,000

Active Listing ID 20261055417
Save
3d icon
Maps

54182 Queensborough Drive This stunning colonial in the highly sought-after Lake in the Woods subdivision of Shelby Township. Featuring 5 bedrooms, 4 bathrooms, and LAKE ACCESS. This home provides over 4, 000 square feet of above-grade living space with a well-designed layout ideal for both everyday living and entertaining. The home is further enhanced with a finished walkout basement with an additional 2, 280 square feet of living space including a second kitchen, living room, bedroom, and full bathroom! Step outside to your private backyard retreat complete with an in-ground pool, perfect for summer entertaining and relaxing in a serene setting. Mechanicals are all under 5 years old. BATVAI

Collapse all

Property Features

  • Facts
  • Lot Size: 0.51 Acres
  • Property Type: Residential
  • Property Sub-type: Other
  • Features
  • Full Bathrooms: 4
  • 1/2 Bathrooms: 1
  • Cooling System: Central Air
  • Exterior Finish: Pool - Inground
  • Roof Type: Asphalt
  • Heating Fuels: Forced Air

Property

  • propertytype: Residential
  • propertysubtype: Other
  • listprice: 1100000
  • unparsedaddress: 54182 Queensborough Drive
  • postalcity: Shelby Twp
  • stateorprovince: MI
  • country: US
  • postalcode: 48315
  • bathroomsfull: 4
  • bathroomshalf: 1
  • bathroomsonequarter: 0
  • bathroomsthreequarter: 0
  • lotsizeacres: 0.51
  • lotsizeunits: Acres
  • lotsizearea: 0.51
  • livingarea: 4060
  • livingareaunits: Square Feet
  • latitude: 42.693275
  • longitude: -83.017158
  • listagentfullname: Mariam Boutros
  • listagentemail: mariam@summitunionre.com
  • listagentkey: 3yd-REALCOMPMI-445528
  • listagentmlsid: 445528
  • listagentpreferredphone: (248) 729-0011
  • listagentofficephone: 2487290011
  • listofficekey: 3yd-REALCOMPMI-338645
  • listofficemlsid: 338645
  • disclaimer: Copyright © 2026 Realcomp Limited II. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.
  • sourcesystemid: REALCOMPMI
  • yearbuilt: 1997
  • listingcontractdate: 2026-04-26
  • listagenturl: http://www.cmchoice.com
  • countyorparish: Macomb
  • parcelnumber: 0710277008
  • elementaryschooldistrict: Utica
  • middleorjuniorschooldistrict: Utica
  • highschooldistrict: Utica
  • appliances: Dishwasher, Disposal, Free-Standing Refrigerator
  • cooling: Central Air
  • constructionmaterials: Brick
  • heating: Forced Air
  • fireplaceyn: False
  • transactiontype: ForSale
  • storiestotal: 2
  • parkingtotal: 0
  • roof: Asphalt
  • waterfrontyn: False
  • franchiseaffiliation: None
  • exteriorfeatures: Pool - Inground
  • waterfrontfeatures: Lake
  • architecturalstyle: Colonial
  • rooms: Bedroom 4, Bathroom 3, Bedroom 3, Bathroom 4, Bathroom 1, Bedroom 2, Basement, Bedroom 1, Bedroom 5, Bathroom 2
  • speciallistingconditions: Standard
  • dock: False
  • poolprivateyn: False
  • spayn: False
  • internetaddressdisplayyn: True
  • internetautomatedvaluationdisplayyn: True
  • internetconsumercommentyn: True
  • location: -83.01716, 42.693275
  • customfields: {"AdditionalInformation":{}, "AlternatePrices":[], "BrokerName":"COMMUNITY CHOICE REALTY INC.", "BuilderEmail":null, "BuilderFax":null, "BuilderPhone":null, "City":null, "Country":null, "CustomSourceId":null, "Expenses":[], "GeocodeOptions":null, "LeadRoutingEmail":"mariam@summitunionre.com", "ListBrokerageCity":"Birmingham", "ListBrokerageCountry":"US", "ListBrokerageEmail":"evans.jonathan@student.oaklandcc.edu", "ListBrokerageLogoUrl":null, "ListBrokerageName":"COMMUNITY CHOICE REALTY INC.", "ListBrokeragePhone":"(248) 729-0011", "ListBrokeragePostalCode":"48009", "ListBrokerageStateOrProvince":"MI", "ListBrokerageUnitNumber":null, "ListBrokerageUnparsedAddress":"261 E. Maple", "ListBrokerageWebsiteUrl":"http://www.cmchoice.com", "ListOfficeAddress1":"261 E Maple ", "ListOfficeAddress2":null, "ListOfficeBrokerMlsId":"338645", "ListOfficeCity":"Birmingham", "ListOfficeCountry":"US", "ListOfficeEmail":"jon@cmchoice.com", "ListOfficePostalCode":"48009", "ListOfficeStateOrProvince":"MI", "ListPriceCurrencyType":"USD", "ListingTitle":"SINGLE_FAMILY - Colonial - Shelby Twp, MI", "ListingURL":"https://www.realtor.com/realestateandhomes-detail/54182-Queensborough-Dr_Shelby-Twp_MI_48315_M35576-94129?f=listhub&s=REALCOMPMI&m=20261055417&c=rexren", "MLSModificationTimestamp":"2026-07-20 12:28:21", "Neighborhoods":[{"Description":null, "Name":"Lake In The Woods Sub"}], "PostalCode":null, "RoomCount":16, "StateOrProvince":null, "Taxes":[{"TaxAnnualAmount":14168, "TaxDescription":"L 58 V LAKE IN THE WOODS SUB LOT 58 LIBER 6616 PAGES 737-767", "TaxYear":null}], "UnitNumber":null, "UnparsedAddress":null}
Listing Changed: 7/20/2026 4:33:22 PM GMT
Source Updated Date: 7/24/2026 12:47:26 AM GMT

Courtesy of: Mariam Boutros, Community Choice Realty Inc, mariam@summitunionre.com

Copyright © 2026 Realcomp Limited II. All rights reserved. All information provided by the listing agent/broker is deemed reliable but is not guaranteed and should be independently verified.

Contact