Homes by Email

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

Quick Search

view all




No Max.

David Elya
Broker Owner
Brookview Realty
623 North Main Street

Rochester, MI 48307

Email Us
Our Testimonials

Contact Us

* fields are required
Back to Saved Search
Listing 2 out of 14
$1,299,900 For Sale

54400 Queensborough Drive
Shelby Twp, MI 48315

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


Luxurious first floor master split completely remodeled in high end rich finishes from second level to the finished walk out basement on the lake! On one of the largest lots in the renowned Lake in the Woods Sub. Interior finishes selected by decorators and completed by artists resonates a rich and modern feel in every room. Fall in love with the beautiful kitchen with attached sun room overlooking the great views of the lake, stainless appliances beautiful granite tops, crystal hardware, marble floors. 2 fireplaces both with gorgeous tile, and the millwork is just as stunning. Thick crown throughout, larger base and double banded casements around all windows and doors. Beautiful landscaping, paver front patio. Huge 4 car attached garage with garden sink and upper deck storage. New roof in 2018, 3 HVAC systems, dual HWH, commercial electric panel, and newer camera/security system.


  • 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
  • Stories: 1 1/2 Story,Split Level
  • Bedrooms: 4
  • Full Baths: 4
  • Half Baths: 1
  • Basement: Finished, Walkout Access
  • Garage: 4 Car
  • Fireplace: Basement,Great Room
  • Lot Size: 0.98 acres
  • Baths: 5
  • Waterfront: Lake Front, Water Front
  • Association Fee Frequency: Annually
  • Bedroom - Mstr: Entry-Level
  • Construction Materials: Brick
  • Cooling: Central Air
  • Exterior Features: Outside Lighting, Sprinkler(S)
  • Foundation Details: Basement
  • Frontage Feet: 109
  • Garage Features: Attached, Door Opener, Electricity
  • Heating: Forced Air
  • Heating Fuel: Natural Gas
  • Interior Features: Central Vacuum, Humidifier, Pets Allowed, Security Alarm, Spa/Hot-Tub, Sump Pump, Wet Bar
  • Kitchen Appliances: Bar Fridge, Dishwasher, Disposal, Dryer, Microwave, Refrigerator, Stove, Washing Machine
  • Lease Type: Single Family House
  • Listing Financing: Cash, Conventional
  • Lot Dimensions: 9x227x89x194x158
  • Originating MLS: Mirealsource
  • Porch Type: Balcony, Patio, Porch
  • Road Frontage Type: Paved, Pub. Sidewalk
  • Sewer: Septic-Existing
  • Sqft Combined: 8950
  • Sqft Lower Floor: 3786
  • Sqft Source: Assessors
  • Sqft Total Bsmt: 3786
  • 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