• Listing status icon

    $1,300,000

  • Active | MLS#: 31306785
  • 4Beds
  • 4.5Baths
  • 5,164Sq Ft

54400 Queensborough Shelby Twp, MI 48315

Favorite
Share
Close
Info Visit Virtual Tour Search
My Property Finder members always view full listing details. Login or Register

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.

Listing provided courtesy of: RE/MAX Suburban, Inc.

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

Ask a Question

Price & Status History

Days on Market

  • This property has been listed on the market for 411 days
  • Average days-on-market for homes between $1,040,000 - $1,560,000 = 224 (in zip code 48315)

Location

The property map location is: Accurate, based on Google's address match.

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.

BEACON TREE ELEMENTARY SCHOOL 55885 SCHOENHERR RD SHELBY TOWNSHIP, MI 48315 Phone: 5867977300 K-6th
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
RICHARD J. DUNCAN ELEMENTARY 14500 26 MILE RD SHELBY TOWNSHIP, MI 48315 Phone: 5867974600 K-6th
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.

CHILDRENS WORLD LEARNING CTR Utica, MI 48315 Phone: 8103236250 PreK-K
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


Information is provided in part by the IDX program of the MI Realsource Michigan Multiple Listing Service. All information provided is deemed reliable but is not guaranteed and should be independently verified.

* Rates and payment information listed in the mortgage calculator are provided as for general reference only. Specific mortgage information should be verified with a qualified lending professional