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 14
$1,099,000 For Sale

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
1/55

Description

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.

Features

  • Property Type: Single Family Home
  • Sub Type: Residential
  • Listing Status: Active
  • 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
  • Association Fee Frequency: Annually
  • Construction Materials: Brick
  • Cooling: Ceiling Fan, Central Air
  • Exterior Features: Outside Lighting, Sprinkler(S)
  • 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, Stove, Washing Machine
  • 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: Sewer-Sanitary
  • Sqft Combined: 7620
  • Sqft Lower Floor: 2200
  • Sqft Source: Public Rec
  • Sqft Total Bsmt: 2757
  • Water Heater Fuel: Natural Gas
  • Water Source: Municipal Water
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