- 4Beds
- 4.5Baths
- 5,164Sq Ft
54400 Queensborough Shelby Twp, MI 48315

Listing provided courtesy of: RE/MAX Suburban, Inc.
Overview
Total makeover on this mini mansion with a new built feel. TOP QUALITY painting techniques, new cabinets, tops, flooring, trim, appliances, high end alarm and camera system. Custom unique features include, hand hammered hood vent, trendy vanity's in all baths, vessel sinks, cut crystal knobs and handles, gorgeous new lighting and fireplace surrounds. We've opened up walls, torn down pillars, brick paver terrace completely redone with new landscaping, fully stripped front door, custom staircase refinished with HIGH end wool carpet exquisite patterns. 100% of the full walk out has been redone with new tile, HUGE gym mirrored walls, kitchen with glass tile, updated cabinets, and handles. Solid full brick, tons of limestone, over a 4 car garage, largest lot in the sub irrigation by well. You could never build this new with the type of quality solid construction and with all the massively expensive updates this seller has done, must see to believe.
General Features
- Acreage 0.98
- Area Municipality Shelby Twp (50007)
- Association Fee Y/N Yes
- County Macomb
- Ownership Private
- Structure Style 2 Story
- Subdivision Lake in The Woods
- Waterfront Y/N Yes
- Year Built 2000
- Zoning Residential
- Originating MLS MiRealSource
Building Features
- Appliances Dishwasher, Disposal, Dryer, Microwave, Range/Oven, Refrigerator, Washer
- Basement Type Finished, Full, Walk Out, Poured
- Bath Descriptions Basement Full Bath,First Flr Lavatory,MstrBdrm Full Bathroom,First Flr Full Bathroom,Second Flr Full Bathroom
- Cooling System Ceiling Fan(s), Central A/C
- Dining Kitchen Breakfast Nook/Room,Pantry,Eat-In Kitchen,Formal Dining Room
- Exterior Construction Brick, Stone
- Exterior Features Lawn Sprinkler, Patio, Porch, Sidewalks, Street Lights, Terrace
- Fireplace Features Basement Fireplace, Grt Rm Fireplace
- Foundation Type Basement
- Garage Type Attached Garage, Electric in Garage, Gar Door Opener, Side Loading Garage
- Heating System Floor Furnace
- Interior Features 9 ft + Ceilings, Interior Balcony, Cable/Internet Avail., Hardwood Floors, Spa/Jetted Tub, Walk-In Closet, Wet Bar/Bar
Property Features
- Lot Size 100x220
- Roads Paved Street
- Sewer Septic Septic
- Water Private Well, Public Water
- Water Features Lake Frontage, Water View, Waterfront
Schools
- School District Utica Community Schools
Price & Status History
Days on Market
- This property has been listed on the market for 538 days
- Average days-on-market for homes between $1,040,000 - $1,560,000 = 538 (in zip code 48315)
Location

Maggie Moraco
248-505-3143RE/MAX Defined
Ask A Question
Community Demographics for Zip Code 48315 (Shelby Twp)
Housing Occupancy
- Home Owners: 9,334 (81%)
- Renters: 1,358 (12%)
- Vacant: 835 (7%)
- Total Housing Units: 11,527
Households
- Average Household Size: 2.66
- Housing Density (People per square mile): 2,249
Age Range (number of people)
- Age 0-14: 5,010
- Age 15-24: 3,445
- Age 25-39: 5,324
- Age 40-59: 6,578
- Age 60-79: 6,351
- Age 80+: 2,011
- Total: 28,719
* All numbers in this section are 2016 projections provided by Geolytics Inc
School Information for 48315 (Shelby Twp)
Public Schools in Zip Code 48315 (Shelby Twp)
* This list of schools may not match the property above.
Grade Size Distribution
- Knd: 97
- 1st: 108
- 2nd: 91
- 3rd: 90
- 4th: 92
- 5th: 86
- 6th: 76
School Population
- Teachers: 32
- Students per Teacher: 20.0
- Students: 640
- Male/Female: 318/321
School District
- UTICA COMMUNITY SCHOOLS
- 11303 GREENDALE DR STERLING HEIGHTS, MI 48312
- Phone: 5867971000
District Population
- Schools: 44
- Full-Time Teachers: 1461
- Students per Teacher: 20.1
- Staff: 3039
- Students: 29364
Grade Size Distribution
- Knd: 108
- 1st: 124
- 2nd: 106
- 3rd: 120
- 4th: 125
- 5th: 129
- 6th: 108
School Population
- Teachers: 38
- Students per Teacher: 21.6
- Students: 820
- Male/Female: 430/390
School District
- UTICA COMMUNITY SCHOOLS
- 11303 GREENDALE DR STERLING HEIGHTS, MI 48312
- Phone: 5867971000
District Population
- Schools: 44
- Full-Time Teachers: 1461
- Students per Teacher: 20.1
- Staff: 3039
- Students: 29364
Private Schools in Zip Code 48315 (Shelby Twp)
* This list of schools may not match the property above.
Grade Size Distribution
- PreK: 22
- Knd: 8
School Population
- Teachers: 0
- Students per Teacher: N/A
- Students: 30
* School data provided by US Department of Education