Homes by Email

Be the first to see new listings as soon as they hit the market!

Quick Search


view all


Any

Any

$1,000,000

No Max.



David Elya
Broker Owner
Brookview Realty
623 North Main Street

Rochester, MI 48307
248-652-7000

Email Us
Our Testimonials

Contact Us





* fields are required
Back to Saved Search
Listing 1 out of 11
$1,300,000 For Sale

54400 Queensborough
Shelby Twp, MI 48315

4 beds, 4 full, 1 partial baths | Single Family Home
5,164 sq ft; lot: 0.98 acres - MLS# 219016495
Property Photo
1/54

Description

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.

Features

  • Property Type: Single Family Home
  • Sub Type: Residential
  • Listing Status: Active
  • County/Area: Macomb County
  • Zip Code: 48315
  • Year Built: 2000
  • Subdivision/Neighborhood: Lake In The Woods
  • School District: Utica
  • Sq.Ft.: 5,164 sq ft
  • Style: Colonial
  • Stories: Split Level
  • Total Rooms: 15
  • Bedrooms: 4
  • Full Baths: 4
  • Half Baths: 1
  • Basement: Finished
  • Garage: 4 Car
  • Fireplace: Basement,Great Room
  • Lot Size: 0.98 acres
  • Baths: 5
  • Waterfront: Lake Front, Lake In The Woods
  • Association Fee Frequency: Annually
  • Bedroom - Mstr: 20 x 20 Entry-Level
  • Construction Materials: Brick
  • Cooling: Central Air
  • Exterior Features: Bbq Grill, Outside Lighting, Sprinkler(S)
  • Fireplace Fuel: Natural
  • Foundation Details: Basement
  • Foundation Materials: Poured
  • Frontage Feet: 100
  • Garage Features: Attached, Electricity
  • Heating: Forced Air
  • Heating Fuel: Natural Gas
  • Interior Features: Cable Available, Central Vacuum, High Spd Internet Avail, Intercom, Jetted Tub, Sump Pump, Wet Bar
  • Kitchen Appliances: Dishwasher, Disposal, Microwave, Refrigerator, Stove, Washing Machine
  • Listing Financing: Cash, Conventional
  • Lot Dimensions: 100.00X220.00
  • Lot Features: Lake View
  • Originating MLS: Realcomp Ii Ltd
  • Ownership Status: Private Owned, Short Sale - No
  • Porch Type: Patio, Porch
  • Road Frontage Type: Paved
  • Roof Material: Asphalt
  • Sewer: Septic-Existing
  • Sqft Combined: 8950
  • Sqft Lower Floor: 3786
  • Sqft Source: Prd
  • Sqft Total Bsmt: 3786
  • Water Frontage Feet: 90.00
  • Water Heater Fuel: Natural Gas
  • Water Source: Municipal Water
Courtesy of Re/Max Suburban, Inc



Brookview Realty | 248-652-7000 | Contact Us
623 N. Main Street - Rochester, MI 48307
Copyright © , All Rights Reserved

Real Estate Websites by iHOUSEweb iconiHOUSEweb | Admin Menu