54400 Queensborough Dr., Utica, MI 48315

  • $949,900
  • reduced $39,100 on 9/24/2015
  • 89 Days on site
  • Beds: 4
  • Baths: 5
  • Single Family Home
  • 5,164 sq ft


Absolutely stunning Mansion on largest lot in Lake in the Woods! ABOUT 9Ksqft of living space, HUGE side turn 4 car garage has upper level for additional storage, insulated doors, garden area with sink. Custom built home by builder, solid full brick , limestone accents, brick pavers, top of the line windows. Wood floors in master bedroom with walk in closest, closet organizers, huge master bath. Large kitchen with corner sink overlooking lake, giant island, built in china cabinet, butlers pantry, built in appliances. Triple HVAC, dual HWH, Central Vac, Separate well for outside sprinklers, Home is filled with top quality material granite and marble throughout. Full finished walk out basement with additional bedroom, Canning Room ,full bath along with Full Kitchen, bar, Rec room and family room with another fireplace. Click here to learn more about this listing.

  • Single Family Home
  • Beds: 4
  • Baths: 5

Listing Details

Lot Size
Approximately 0.98 Acres
3 Car Garage
Assessed Taxable Amount
Tax Amount
Last Transaction Date
Property Type
Single Family Residence
Lot Size (Sqft)
Lot Size (Acres)
Cooling System

Public Facts: As provided by County Assessor and Recorder offices. May not reflect recent additions or improvements. If you see any errors, the best way to get the records updated is to contact your local county records office. If any of the information in this section conflicts with property information provided by a listing agent or broker, agent-provided information should be deemed more reliable.

Local Info

Median Household Income
Median Years In Residence
Median Homeowner Age
Households with Children
Percent of Homes Rented

Nearby Elementary Schools

53550 Wolf Dr
55885 Schoenherr Rd
6580 24 Mile Rd

Nearby Middle Schools

51700 Van Dyke Ave
6400 25 Mile Rd
6580 24 Mile Rd

Nearby High Schools

6500 25 Mile Rd
16825 24 Mile Rd
47255 Shelby Rd

These are the closest schools to your requested location. Proximity does not guarantee enrollment eligibility. Please consult your real estate agent or school district to confirm the schools you are zoned to attend.

Mortgage Rates

Loading rates...

Property Contact Info

Listing Provided By: Re/Max Suburban
(586) 262-2000
Listing Agent: Ryan Milo

Need More Information?

Please fill out this form to request more photos or more information regarding this property.

We guarantee 100% privacy. Your information will not be shared with additional third parties.