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 2 out of 16
$1,199,000 For Sale

54400 Queensborough Drive
Shelby Twp, MI 48315

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

Description

THIS ARCHITECTURAL LAKEFRONT MASTERPIECE LOCATED IN THE PRESTIGIOUS "LAKE IN THE WOODS" COMMUNITY IS AN ENTERTAINMENT SHOWPLACE! MAIN ROOMS EFFORTLESSLY TRANSITION, ONE TO ANOTHER, IN AN INTUITIVE, OPEN AIRY FLOOR PLAN W/~9,000 OF LUXURIOUS LIVING SPACE. THIS CUSTOM BUILT HOME RENOVATED IN 2017 OFFERS EXCEPTIONAL CRAFTSMANSHIP & UPGRADES. IMPORTED MARBLE FLOORS, EXTENSIVE CUSTOM WOODWORK & ARCHED ENTRIES. GOURMET STYLE ISLAND KITCHEN W/NEWER CUSTOM CABINETRY, GRANITE COUNTERS, TOP OF THE LINE APPLIANCES & BUTLERS PANTRY. SUNROOM OFF KITCHEN. GRAND 1ST FLR MASTER SUITE W/SITTING AREA, DRESSING AREA, WALK-IN CLOSET & SPA LIKE MASTER BATH. 1ST FLR LIBRARY W/CUSTOM BUILT INS & WOOD PANELING. 2 UPPER LEVEL BEDROOMS W/JACK & JILL BATHS PLUS ONE ADDITIONAL ENSUITE. FINISHED W/O LOWER LEVEL W/LARGE REC ROOM, BILLIARDS ROOM, FULL KITCHEN & BAR, FULL BATHROOM & TONS OF STORAGE SPACE. 4 CAR ATTACHED GARAGE W/INSULATED DOORS. PROFESSIONALLY LANDSCAPED YARD W/BRICK PAVER PATIO. I.D.R.B.N.G.

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: 2 Story
  • Total Rooms: 16
  • Bedrooms: 4
  • Full Baths: 5
  • Half Baths: 1
  • Basement: Finished, Walkout Access
  • Garage: 4 Car
  • Fireplace: Basement,Family Room
  • Lot Size: 0.98 acres
  • Baths: 6
  • View: Lake View
  • Waterfront: Lake Front, Lake/River Priv, Lake In The Woods
  • Bedroom - Mstr: 20 x 20 Entry-Level
  • Construction Materials: Brick
  • Cooling: Central Air
  • Entry Location: Ground Level
  • Exterior Features: Outside Lighting
  • Foundation Details: Basement
  • Foundation Features: Sump Pump
  • Foundation Materials: Poured
  • Frontage Feet: 109
  • Garage Features: Attached, Direct Access, Door Opener
  • Heating: Forced Air
  • Heating Fuel: Natural Gas
  • Interior Features: Central Vacuum, Humidifier, Wet Bar
  • Kitchen Appliances: Bar Fridge, Dishwasher, Disposal, Dryer, Microwave, Washer
  • Listing Financing: Cash, Conventional
  • Lot Dimensions: 315X228X89X196
  • Lot Features: Corner Lot, Irregular, Lake View
  • Originating MLS: Realcomp Ii Ltd
  • Ownership Status: Private Owned, Short Sale - No
  • Pets Allowed: Yes
  • Porch Type: Balcony, Patio, Porch
  • Road Frontage Type: Paved
  • Roof Material: Asphalt
  • Sewer: Septic-Existing
  • Sqft Combined: 8950
  • Sqft Lower Floor: 3786
  • Sqft Total Bsmt: 3786
  • Water Frontage Feet: 89.00
  • Water Heater Fuel: Natural Gas
  • Water Source: Municipal Water
  • Year Remodeled: 2017
Courtesy of Kw Domain



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