42.632156 -83.08221

2955 ERMA DR Shelby Township, MI 48317

282733043 42.632156 -83.08221 326 /listing/282733043-150074337/2955-erma-dr-shelby-township-mi-48317 False 0 900000.0 4000 100 4 4.1 2200085984 False
  • $900,000
  • 4 bd
  • 4 full ba
  • 1 half ba
  • 4,000 sqft
  • 0.34 lot
  • Est payment $4831.39/mo

Property & Neighborhood Info

Provided through IDX through Realcomp II Ltd. Courtesy of EXP Realty Copyright 2019 Realcomp II Ltd. Shareholders

Single Family in Shelby Twp

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! ( Additional MLS Data: Summer Tax: $2925, Winter Tax: $2232 )

Provided through IDX through Realcomp II Ltd. Courtesy of EXP Realty Copyright 2019 Realcomp II Ltd. Shareholders
  1. 4 Beds
  2. 4 Full Bath
  3. 1 Half Bath
  4. 4,000 Sq. Ft.
  5. 0.34 Lot

Main Features

  • Year Built: 2006
  • Garage: 5.0
  • Floors: 2
  • Rooms: 15
  • Full Bath: 4
  • Half Bath: 1
  • School District: Utica
  • County: Macomb
  • Taxes: $5,157.00
  • Fees: $600.00
  • Subdivision: Louis Lakes Estates Site Condo
  • MLS Number:2200085984

Additional Features

  • Interior Features:
    • Wet Bar
    • Cable Available
    • Central Vacuum
    • High Spd Internet Avail
    • Humidifier
    • Programmable Thermostat
    • Security Alarm (owned)
    • Sound System
    • Spa/Hot-tub
  • Water Heater:
    • Natural Gas
  • Appliances:
    • Dishwasher
    • Disposal
    • Dryer
    • Exhaust Fan
    • Free-Standing Freezer
    • Free-Standing Gas Oven
    • Free-Standing Refrigerator
    • Microwave
    • Range Hood
    • Stainless Steel Appliance(s)
    • Vented Exhaust Fan
    • Washer/Dryer Stacked
  • Fireplace:
    • Gas
    • Yes
  • Fireplace Location:
    • Great Room
  • Construction:
    • Brick
    • Vinyl
    • Wood
  • Garage:
    • 2.5 Car
    • Attached
    • Direct Access
    • Door Opener
    • Electricity
    • YES
  • Levels:
    • 2 Story
  • Roof:
    • Asphalt
  • Style:
    • SPLIT LEVEL
    • TUDOR
  • Water Source:
    • Municipal Water
  • Basement:
    • Finished
    • Walkout Access
    • YES
  • Foundation:
    • Basement
    • Poured
  • Exterior Features:
    • BBQ Grill
    • OUTSIDE LIGHTING
  • Lot Features:
    • Sprinkler(s)
    • Water View
  • Waterfront:
    • Direct Water Frontage
    • Lake Front
    • Lake Privileges
    • Lake/River Priv
    • Water Front
    • Yes
  • Pool:
    • No
  • Porch/Patio/Deck:
    • Porch - Covered
  • Fee Includes:
    • Maintenance Grounds
  • Heating:
    • Forced Air
    • Natural Gas
  • Sewer:
    • Sewer-Sanitary
  • Road Frontage:
    • Paved
  • Waterfront Features:
    • Dock Facilities
  • Financing:
    • Cash
    • Conventional
  • Homestead:
    • Yes
  • Land Contract:
    • No
  • Legal Description:
    • 9/9/03 SPLIT & COMB 07-31-201-001 (40 ACRES); 07-31-177-013 (50 ACRES); 07-31-128-010 (.825 ACRES) INTO 07-31-177-014 (74.689 ACRES)LOUIS LAKES ESTATES SITE CONDOS MCCSP #811 UNIT 10 LIBER 13949 PAGES 146-200. PURSUANT TO 2ND AMENDMENT REPLAT #1 (LIBER 20316 PAGES 7 TO 12).
  • List Type (Exclusive):
    • Exclusive Right to Sell
  • Lock Box:
    • Appointment/LockBox
  • Settlement:
    • Township
  • Short Sale:
    • No
  • Title:
    • Private - Owned
  • Transaction Type:
    • Sale
  • Warranty:
    • No
  • Assessment:
    • 0
  • Dues Frequency:
    • Annually
  • HOA Fee:
    • 600
  • Below Ground Sq Ft:
    • 2800
  • MLSSystem ID:
    • Realcomp II Ltd
  • Ownership:
    • Private Owned
    • Short Sale - No
  • Possession:
    • Negotiable
  • Square Footage Total:
    • 4000
  • Tax ID:
    • 0731199010
  • Cooling:
    • Ceiling Fan(s)
    • Central Air
  • Kitchen Dim:
    • 28.00x14.00
  • Bed2 Dim:
    • 16.00x13.00
  • Bed3 Dim:
    • 14.00x13.00
  • Bed4 Dim:
    • 17.00x13.00
  • Dining Room Dim:
    • 13.00x12.00
  • Great Room Dim:
    • 21.00x16.00
  • Master Bed Dim:
    • 16.00x16.00
  • Office Den Dim:
    • 13.00x13.00
Neighborhood info courtesy of Homes.com © 2020

What's My Mortgage?

$38,769.95*
*Estimated monthly payment is a starting point to help assist you with your home search. To find out more about mortgage pre-qualification, click here.
Janet & Steve Stockton
Janet & Steve Stockton
2730 Union Lake Rd Commerce Township MI 48382
request more info.
42.632156 -83.08221

2955 ERMA DR Shelby Township, MI 48317

282733043 42.632156 -83.08221 326 /listing/282733043-150074337/2955-erma-dr-shelby-township-mi-48317 False 0 900000.0 4000 100 4 4.1 2200085984 False
  • $900,000
  • 4 bd
  • 4 full ba
  • 1 half ba
  • 4,000 sqft
  • 0.34 lot
  • Est payment $4831.39/mo