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 1 out of 14
Sold for $975,000 Sold

54462 Queensborough
Shelby Twp, MI 48315

4 beds, 4 baths | Single Family Home
5,420 sq ft; lot: 0.58 acres - MLS# 58031382438
Property Photo


Sold for $975,000 on Aug 8, 2019


Spectacular Lakefront Colonial in highly sought after Lake in the Woods sub. Gorgeous foyer entry into majestic great room w/ 23 ft stepped ceiling, awe inspiring lake views thru oversize windows, two way fireplace and beautiful built in cherry wood entertainment center. This home exudes quality throughout, solid doors, built in cherry wood cabinetry in library and classy gallery area with views of sweeping staircase. 4 Bdrms...Huge master bdrm with ensuite bath, amazing lake views and a unbelievable 11 x17 walk in closet. One of the bdrms is it's own suite with sep living room,full bath. Awesome Finished basement w/ full kitchen, tv/movie room, large rec area, classy wine cellar, exercise room, wet bar and lots of storage. Brand New Roof being installed summer 2019 Fantastic home is a must see for pre-approved buyers only.


  • Property Type: Single Family Home
  • Sub Type: Residential
  • Listing Status: Sold
  • Listing Price: $1,099,000
  • County/Area: Macomb County
  • Zip Code: 48315
  • Year Built: 1997
  • Subdivision/Neighborhood: Lake In The Woods
  • School District: Utica
  • Sq.Ft.: 5,420 sq ft
  • Style: Colonial
  • Stories: 2 Story
  • Total Rooms: 12
  • Bedrooms: 4
  • Full Baths: 4
  • Basement: Finished, Walkout Access
  • Garage: > 3 Car
  • Lot Size: 0.58 acres
  • Baths: 4
  • Waterfront: Lake Front
  • Construction Materials: Brick
  • Cooling: Ceiling Fan(S), Central Air
  • Exterior Features: Outside Lighting
  • Fireplace Fuel: Gas
  • Foundation Details: Basement
  • Frontage Feet: 183
  • Garage Features: Attached, Door Opener, Electricity, Heated
  • Heating: Forced Air
  • Heating Fuel: Natural Gas
  • Interior Features: Security Alarm, Wet Bar
  • Kitchen Appliances: Dishwasher, Disposal, Dryer, Microwave, Refrigerator, Washer
  • Lease Type: Single Family House
  • Listing Financing: Cash, Conventional
  • Lot Dimensions: 183x227x85x182
  • Originating MLS: Mirealsource
  • Porch Type: Patio, Porch
  • Road Frontage Type: Paved, Pub. Sidewalk
  • Sewer: Septic-Existing
  • Sqft Combined: 7620
  • Sqft Lower Floor: 2200
  • Sqft Source: Public Rec
  • Sqft Total Bsmt: 2757
  • Water Heater Fuel: Natural Gas
  • Water Source: Municipal Water
  • Sold Price: 975000.0000
  • Sold Date: 2019-08-08
Courtesy of Rooms Realty 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