If you need assistance, please call 586-703-1410

DESCRIPTION

IMAGINE! Living on A LAKEFRONT Walkout Property w/ 80 Feet Frontage of Your Own Private Beach & Dock. Welcome Home To This Spectacular Split Level. Experience Amazing Views and endless Sunsets on Your NEW 2020 LIMESTONE and AGGREGATE DOUBLE DECK or Take out Your Pontoon on the Lake. Enjoy Luxury Living at its Finest. Every aspect of this home is fully detailed and breathtaking including Crown Molding/ Wainscoting throughout. 20 Foot Mirror Tinted Windows in Great Room Highlighting Mother Nature Beautiful Scenic Views. Entertain Guests in Your Finished Walkout or Private Movie Theater with Bose Surround System. Sip on some Fine Cognac from your Bar and Stargaze on Your Private BEACH. NEW Iron Entry Doors, Carpet, Custom Paint, 5 Ton AC, Lighting Fixtures & Central Vacuum. State of the Art Garage with METALLIC EPOXY FLOORS. A TRUELY MUST SEE TO REALLY APPRECIATE! All appliances included(EXCEPT Kitchen Refrigerator) Seller including additional items but can't list them all! DRONE VIDEO!

KEY DETAILS
  • Price:
  • $900,000
  • Bedrooms:
  • 4
  • Full Baths:
  • 4
  • Half Baths:
  • 1
  • Square Footage:
  • 6,200
  • Acreage:
  • 0.34
  • Year Built:
  • 2006
  • MLS #:
  • 40114808
  • Street Address:
  • 2955 Erma Dr
  • City:
  • Shelby Township
  • State:
  • MI
  • Postal Code:
  • 48317
  • County:
  • Macomb
  • Area:
  • Shelby Twp (50007)
  • Subdivision:
  • Louis Lakes Estates Site Condo
  • Listing Status:
  • For Sale - Pending

Building

  • Architecture Style:
  • Tudor
  • Basement Type:
  • Finished, Walk Out
  • Construction Description:
  • Brick, Vinyl Siding, Wood
  • Exterior Features:
  • Bbq/Grill Built-In, Porch
  • Finished Above Ground Square Footage:
  • 4000
  • Finished Basement Square Footage:
  • 2200
  • Fireplace:
  • Gas Fireplace, Grt Rm Fireplace
  • Fireplace:
  • Yes
  • Foundation:
  • Basement
  • Has Basement:
  • Yes
  • Interior Features:
  • Cable/Internet Avail., Spa/Jetted Tub, Security System, Sound System, Wet Bar/Bar
  • Style:
  • 2 Story
  • Year Built:
  • 2006

Land

  • Lot Frontage:
  • 80
  • Lot Size:
  • 80x160
  • Road Type:
  • Paved Street

Listing

  • Community Features:
  • Grounds Maintenance
  • Days On Market:
  • 24
  • For Sale Or Lease?:
  • For Sale
  • Originating Mls:
  • Realcomp
  • Terms:
  • Cash, Conventional

Location

  • Subdivision:
  • Louis Lakes Estates Site Condo
  • Tax Municipality:
  • Shelby Twp

Money

  • Association Fee:
  • 600
  • Association Fee Payment Frequency:
  • Yearly
  • Hoa Y/N:
  • Yes
  • Property Taxes:
  • $5,157
  • Summer Tax:
  • 2925

Rooms

  • Bedroom #1 On Level:
  • First
  • Bedroom #2 On Level:
  • Second
  • Bedroom #3 On Level:
  • Second
  • Bedroom #4 On Level:
  • Second
  • Dining Room Length:
  • 13 Ft
  • Dining Room Level:
  • First
  • Dining Room Width:
  • 12 Ft
  • Great Room Length:
  • 21
  • Great Room Level:
  • First
  • Great Room Width:
  • 16
  • Kitchen Level:
  • First
  • Kitchen Room Length:
  • 28 Ft
  • Kitchen Room Width:
  • 14 Ft
  • Laundry Room Level:
  • First
  • Total Rooms:
  • 15

Rules

  • Show Listing And/Or Property Address:
  • Yes

Structures

  • Garage Capacity:
  • 2.5
  • Garage Description:
  • Attached Garage, Electric In Garage, Gar Door Opener, Direct Access
  • Has Garage:
  • Yes

Systems

  • Appliances:
  • Central Vacuum, Dishwasher, Disposal, Dryer, Freezer, Humidifier, Microwave, Other-See Remarks, Range/Oven, Refrigerator, Washer
  • Cooling System:
  • Ceiling Fan(s), Central A/C
  • Existing Water:
  • Public Water
  • Heating:
  • Forced Air
  • Heating Fuel:
  • Natural Gas
  • Water Heater:
  • Gas

Water

  • Water Name:
  • Louis Lake
  • Waterfront:
  • Yes
  • Waterfront Description:
  • Dock/Pier Facility, Lake Frontage, Lake/River Access, Waterfront

Source

  • Listing Provided By EXP Realty

    MIMLS
REQUEST SHOWING
NOTES

No notes have been added for this home.

CONTACT AN AGENT

SCORECARD

0
PROS
0
CONS
Condition
Location
Nearby
Schools
Taxes
  • Add Note
  • Add to Notebook
  • Share