54182 Queensbourough Drive
Utica, MI 48315
Single Family Residence · MLS # 58050217851 · Listing courtesy of Lakeside Properties LLC
About this home
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.
Interior
Systems and utilities
Exterior and lot
Taxes, HOA and more
Schools
How it compares in Utica
Over the last 90 days, 99 homes sold in Utica for a median of $335,000, about $162 per square foot, and the typical one went under contract in 18 days. This home is listed at $1,035,000, or $163 per square foot, about the same as the city median, and has been on the market 32 days. Size, condition, updates and the exact street all move the number, so treat this as context. See recent Utica sales or ask us for the comparable sales on this one.
Property taxes for a new owner
The current owner pays about $14,168 a year. A buyer who lives here would pay about $16,044 a year once the taxable value resets after the sale, at the 2025 homestead rate of 30.70 mills for Shelby Twp and Utica schools, plus the 1% administration fee. Michigan resets a home's taxable value the year after it sells, so the seller's bill isn't a good number to budget with. See the math.
Monthly payment estimate
Estimate only, 30 year fixed, includes taxes at a new owner's rate and HOA when listed. Ask us for a lender quote.
Location
Similar homes in Utica
IDX information provided courtesy of Realcomp II Ltd. via The MJA Company at National Realty Centers, © 2026 Realcomp II Ltd. Shareholders. IDX information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. The accuracy of all information, regardless of source, is not guaranteed or warranted. All information should be independently verified. Data updated Nov 14, 2026, 8:18 PM.