If you need assistance, please call 586-202-0499

  • 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:
    • 4,000
    • Acreage:
    • 0.34
    • Year Built:
    • 2006
    • MLS #:
    • 2200085984
    • Street Address:
    • 2955 Erma Dr
    • City:
    • Shelby Township
    • State:
    • MI
    • Postal Code:
    • 48317
    • County:
    • Macomb
    • Area:
    • Shelby Twp
    • Subdivision:
    • Louis Lakes Estates Site Condo
    • Listing Status:
    • For Sale - Pending

    Building

    • Architecture Style:
    • Split Level, Tudor
    • Basement Type:
    • Finished, Walkout Access
    • Exterior Features:
    • Bbq Grill, Outside Lighting
    • Fireplace:
    • Gas
    • Fireplace:
    • 1
    • Fireplace Location:
    • Great Room
    • Foundation:
    • Basement
    • Foundation Material:
    • Poured
    • Has Basement:
    • 1
    • Interior Features:
    • Cable Available, Central Vacuum, High Spd Internet Avail, Humidifier, Programmable Thermostat, Security Alarm (owned), Sound System, Spa/Hot-Tub, Wet Bar
    • Porch Description:
    • Porch - Covered
    • Siding:
    • Brick, Vinyl, Wood
    • Stories:
    • 2 Story
    • Total Building Square Footage:
    • 4000
    • Type Of Roof:
    • Asphalt
    • Year Built:
    • 2006

    Land

    • Lot Features:
    • Sprinkler(s), Water View
    • Road Frontage:
    • 80
    • Road Frontage Type:
    • Paved

    Listing

    • Days On Market:
    • 24
    • Financing Options:
    • Cash, Conventional
    • For Sale Or Lease?:
    • Sale

    Money

    • Association Fee Payment Frequency:
    • Annually
    • Hoa Fee Includes:
    • Maintenance Grounds
    • Hoa Y/N:
    • 1
    • Summer Tax:
    • 2925.0000
    • Winter Tax:
    • 2232.0000

    Rooms

    • 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 Rooms:
    • 15

    Structures

    • Garage Description:
    • Attached, Direct Access, Door Opener, Electricity
    • Garage Type:
    • 2.5 Car
    • Has Garage:
    • 1

    Systems

    • Cooling System:
    • Ceiling Fan(s), Central Air
    • Existing Water:
    • Municipal Water
    • Heating:
    • Forced Air
    • Heating Fuel:
    • Natural Gas
    • Sewage Type:
    • Sewer-Sanitary
    • Water Heater:
    • Natural Gas

    Water

    • Water Amenities:
    • Dock Facilities
    • Water Name:
    • Louis Lake
    • Waterfront:
    • 1
    • Waterfront Description:
    • Direct Water Frontage, Lake Front, Lake Privileges, Water Front, Lake/River Priv
    • Waterfront Footage:
    • 80.00

    Source

    • Provided By:
    • IDX provided courtesy of Realcomp II Ltd. Exp Realty

      IDX provided courtesy of Realcomp II Ltd., via Keller Williams Realty and Realcomp II Ltd, ©2020 Realcomp II Ltd. Shareholders


      FARMHILL
    REQUEST SHOWING
    SCHOOL RATINGS
    n/a

    SCHOOL DISTRICT: UTICA

    NOTES

    No notes have been added for this home.

    SCORECARD

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