Hi There! Is this Your First Time?

Did you know if you Register you have access to free search tools including the ability to save listings and property searches? Did you know that you can bypass the search altogether and have listings sent directly to your email address? Check out our how-to page for more info.


Arterra Realty - The fastest growing real estate company in Michigan

  • Price$1,300,000
  • Beds4
  • Baths5.1
  • SQ. Feet5,164
  • Acres0.98
  • Built2000

54400 Queensborough, SHELBY TWP

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, brand new roof,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.

Essential Information

  • MLS® #58031363015
  • Price$1,300,000
  • Bedrooms4
  • Bathrooms5.10
  • Full Baths5
  • Half Baths1
  • Total Sq. Ft5,164
  • Acres0.98
  • Year Built2000
  • TypeResidential
  • StatusActive

Amenities

  • # of Garages4
  • GaragesAttached, Door Opener, Electricity
  • Is WaterfrontYes
  • WaterfrontLake Frontage, Water Frontage

Exterior

  • ExteriorBrick, Stone
  • Exterior FeaturesOutside Lighting, Sprinkler(s)
  • FoundationBasement

Listing Details

  • Listing OfficeRE/MAX Suburban, Inc.

Community Information

  • Address54400 Queensborough
  • Area03071-Shelby Twp
  • SubdivisionLAKE IN THE WOODS
  • CitySHELBY TWP
  • CountyMacomb
  • StateMI
  • Zip Code48315

Interior

  • Interior FeaturesHigh Spd Internet Avail, Spa/Hot-tub, Wet Bar
  • AppliancesDishwasher, Disposal, Dryer, Microwave, Refrigerator, Stove, Washing Machine
  • HeatingOther
  • CoolingCeiling Fan, Central Air
  • FireplaceYes
  • FireplacesBasement, Great Room

School Information

  • DistrictUtica
Please provide a valid email address.

IDX provided courtesy of Realcomp II Ltd., via Arterra Realty and MIREALSOURCE, Copyright 2018 Realcomp II Ltd. Shareholders. IDX information is provided exclusively for consumers' personal, noncommercial 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.