Waterfront
Address
2955 Erma Drive Shelby Twp, MI
Price
$ 900,000
Property Attributes
  • ML#2200085984
  • TypePending
  • CountyMACOMB
  • CityShelby Twp
  • AreaShelby Twp
  • NeighborhoodLOUIS LAKES ESTATES SITE CONDO
  • Zip48317
  • StyleSplit Level,Tudor
  • Year Built2006
  • Taxes5157
  • Price$ 900,000
  • Bedrooms4
  • Full Bathrooms4
  • Half Bathrooms1
  • Sqr Footage4000
  • Lot Size0.34 Acres
Listing Provided Courtesy Of:
EXP Realty
Property 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!

Price History
10/16/2020 Listed $900,000

General Features

Association Fee Frequency Annually
Basement Type Finished, Walkout Access
Construction Materials Brick, Vinyl, Wood
Cooling Ceiling Fan(s), Central Air
Cumulative Days on Market 24
Down Payment Resource Yes
HOA Fee Includes Maintenance Grounds
Heating Forced Air
Homestead Yes
Listing Agent Public Id 378518
Originating MLS Realcomp II Ltd
Ownership Status Private Owned, Short Sale - No
Parcel Number 0731199010
Possession Negotiable
Property Type Residential
School District Utica
Sewer Sewer-Sanitary
Short Sale No
Status Pending
Subdivision Name LOUIS LAKES ESTATES SITE CONDO
Terms Offered Cash, Conventional
Total Sq Ft 4000
Transaction Type Sale
Warranty No
Year Built 2006

Interior Features

Basement Y/N Yes
Fireplace Yes
Fireplace Fuel Gas
Fireplace Locations Great Room
Full Baths 4
Half Baths 1
Heating Fuel Natural Gas
Interior Features Cable Available, Central Vacuum, High Spd Internet Avail, Humidifier, Programmable Thermostat, Security Alarm (owned), Sound System, Spa/Hot-tub, Wet Bar
Kitchen Appliances Dishwasher, Disposal, Dryer, Exhaust Fan, Free-Standing Freezer, Microwave, Free-Standing Gas Oven, Range Hood, Free-Standing Refrigerator, Stainless Steel Appliance(s), Vented Exhaust Fan, Washer/Dryer Stacked
Total Baths 4.10

Exterior Features

Architecture Level 2 Story
Architecture Style Split Level, Tudor
Exterior Features BBQ Grill, Outside Lighting
Foundation Basement
Foundation Materials Poured
Frontage Feet 80
Garage Capacity 2.5 Car
Garage Features Attached, Direct Access, Door Opener, Electricity
Garage Y/N Yes
Lot Description Sprinkler(s), Water View
Lot Size Area 0.34
Lot Size Dimensions 80X160
Porch Porch - Covered
Roof Material Asphalt
Water Source Municipal Water
WaterFront Features Dock Facilities
Waterfront Yes
Waterfront Description Direct Water Frontage, Lake Front, Lake Privileges, Water Front, Lake/River Priv
Waterfront Name Louis Lake

Amenities

  • Foreclosure
  • Views
  • Short Sale
  • New Construction
  • Adult 55+
  • Lease To Own
  • No HOA Fees
  • Furnished
  • Master On Main
  • Air Conditioning
  • Seller Finance
  • Green
  • Fixer Upper
  • Horse
  • Golf
  • Fireplace
  • Deck
  • Garage
  • Basement
  • Pool


IDX provided courtesy of Realcomp II Ltd., via Stonway Group and The Originating MLS(found above), © 2020 Realcomp II Ltd. Shareholders. Shareholders. The information being provided is for consumers personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.

Data is updated as of December 5, 2020 2:56 AM UTC Information deemed reliable but not guaranteed. The data relating to real estate on this web site comes in part from the Internet Data Exchange (IDX) Program of Realcomp Ltd

Property vs Zip Code Average in 48317

Price
AVG $260K
$900K
Taxes
AVG $2,643
$5,157
Visits
AVG 14
33
Year Built
AVG 1982
2006
Walkscore
AVG 27
20
Data Provided by Walkscore ® not using MLS data

Areas We Cover