Front view
Active

54182 Queensbourough Drive

Utica, Michigan 48315
Mark as Favorite
Bed 5

Bed

Bath 4.5

Bath

SqFt4,060

Sqft

Acres0.51

Acre(Lot)

Seller is Listing Agent and Licensed Real Estate Broker in the state of Michigan. Desired Lake In The Woods Sub with lake access 6340 square foot brick colonial with 5 bedrooms, 4.5 bathrooms, fully finished walk out lower level or possible in-law or au pair suite with full kitchen, bathroom, bedroom and living area. Two gas fireplaces, one in entry level great room and one in finished walk out lower level. Large upper deck and large lower brick paver patio that leads out to a beautifully landscaped yard with inground pool, stamped concrete pool deck, gas fire pit, exterior timer lighting and sprinkling system.

Tour with a ByOwner Agent

Detail Ic Property Details

Property Type : Residential

Price : $1,035,000

AD Id : 91075141

MLS Id : 58050217851

Beds : 5

Lot Size : 0.51 Acre

Living Area Size : 4,060 Sq. Ft

Tax Amount : $14,168.29

Year Built : 1997

Garage : 3.5 Car

County : Macomb

Subdivision: Holiday Park Sub

  • Map Map

Map

Map What's Nearby

Map Nearby Areas

Feature Features

  • Bedroom Information

    Total Bedrooms: 5

    Bathroom Information

    Total Baths: 4.5 Full Baths: 4 Half Baths: 1
  • Room Information

    Total Rooms: 19 Porches: Patio,Porch

    Interior Features

    Other Basement Description: Finished,Walk-Out Access Fireplace: Yes Appliances: Dishwasher,Disposal,Dryer,Microwave,Oven,Range/Stove,Refrigerator,Washer
  • Heating & Cooling

    Cooling: Central Air Heating: Forced Air Heating Fuel: Natural Gas

    Fireplace

    Basement,Great Room

    Water Heater

    Natural Gas

  • Building Information

    Year Built: 1997 Building Stories: 2 Story Fireplace: Basement,Great Room Foundation/Basement: Basement Architecture: Colonial
  • Exterior Features

    Pool - Inground Construction: Brick,Wood
  • Utility Features

    Sewer: Septic Tank (Existing)
  • Water

    Water at Street Water Heat: Natural Gas

  • Lot Information

    Lot Size: 0.51 Lot Dimensions: 130 x 170 Frontage Feet: 130 Waterfront Description: Lake Privileges
  • Property Information

    SQ ft: 4060 Subdivision: Lake In The Woods Financing: Cash,Conventional

  • Listing Price Information

    Original List Price: $1,075,000
  • Listing Information

    Possession: Close Plus 31-60 Days Legal Description: L 58 V LAKE IN THE WOODS SUB LOT 58 LIBER 6616 PAGES 737-767

  • Tax Information

    Annual Tax: $14,168 Parcel Number: 230710277008

    Terms/Deposits/Fees

    Assoc Fee Freq: $Annually
  • Possession

    Close Plus 31-60 Days
  • Legal Information

    Legal Description: Section: L 58 V LAKE IN THE WOODS SUB LOT 58 LIBER 6616 PAGES 737-767

  • Parking Information

    Has Garage: Yes Garage Size: 3.5 Car Garage Description: 2+ Assigned Spaces,Attached
  • Multi-Unit Information

    Road Frontage: Paved

  • School Information

    School District: Utica
  • Fire Place Information

    Fire Place: Yes Fire Place Location: Basement,Great Room Fire Place Type: Gas
  • Utility Information

    Water: Water at Street Sewer: Septic Tank (Existing)
Sell a home like this and save $61,601 Find out How

How much is this property worth?

Curious about this home's true market value? Use our free Home Evaluation Tool to instantly get a personalized Comparative Market Analysis (CMA) report. Make smarter, data-driven decisions before you buy.

Images
Loading, please wait...

Nearby Home Value

Address Estimate Bed Bath Sq. Ft Lot Size
12984 Azure Drive , Utica, MI, 48315 $1,090,000 7 5.5 6,380 0.35 Acre
49787 Lakebridge Drive , Utica, MI, 48315 $819,000 4 4 3,446 0.32 Acre
46500 Cypress Street , Utica, MI, 48315 $345,000 4 2 1,888 0.45 Acre
54359 Algonquin Drive , Utica, MI, 48315 $599,999 4 2.5 3,077 0.36 Acre
49949 Serenity Lane , Utica, MI, 48315 $75,000 3 2 1,792 --
55740 Beacon Shore Drive , Utica, MI, 48315 $874,999 5 4 3,385 0.20 Acre
46325 Glen Eagle Drive , Utica, MI, 48315 $460,000 4 2.5 2,554 0.24 Acre
13404 Partridge Run , Utica, MI, 48315 $1,185,000 4 3.5 4,880 0.61 Acre
55513 Caesars Drive , Utica, MI, 48315 $679,000 4 3.5 3,250 0.34 Acre
46547 Glen Eagle Drive , Utica, MI, 48315 $545,000 4 3.5 2,768 0.24 Acre
MLS Logo

Disclosure: The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified. Any use of search facilities of data on the site, other than by a consumer looking to purchase real estate, is prohibited. IDX provided courtesy of Realcomp II Ltd., via ByOwner.com and REALCOMP, Copyright 2026 Realcomp II Ltd. Shareholders. REALTOR (R) licensed in the state of Michigan. The listing broker’s offer of compensation is made only to participants of the MLS where the listing is filed and to participants of any data share partner MLS.

ByOwner last updated this listing 09/17/2026 @ 13:45

MLS: 58050217851 LISTED BY: Nicholas D. Nader , Lakeside Properties LLC 586-286-8887 SOURCE: Realcomp II Ltd

Homes around $1,035,000

Selling? Save $61,601 when you sell a home like this

Tour with a ByOwner Agent