My Office Location:
American Associates
18035 Silver Pkwy.
Fenton, MI 48430
 
Listings Presented by:
Manuel Salazar
Call: (281) 639-4289
Fax: (888) 696-4544
2955 ERMA DRIVE
SHELBY TWP, MI. 48317
$900,000
4 Beds 5 Baths 4,000 Sq Ft
Schools: Utica 0.34 Acres Year Built: 2006
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!
Features
Baths: 4 full, 1 half
Style: Split Level,Tudor
Subdivision: LOUIS LAKES ESTATES SITE CONDO
Construction: Brick,Vinyl,Wood
Exterior: Brick,Vinyl,Wood
Exterior Misc: BBQ Grill,Lighting
Porchs: Porch - Covered
Fireplaces: 1
Fireplace Description: Gas
Garage: 2.5 Car
Garage Description: Attached,Direct Access,Door Opener,Electricity
Basement: Yes
Basement Description: Finished,Walkout Access
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
Cooling: Ceiling Fan(s),Central Air
Heating: Forced Air
Fuel: Natural Gas
Waste: Public Sewer (Sewer-Sanitary)
Watersource: Public (Municipal)
Foundation : Basement
Special Features
Cable Available,Central Vacuum,High Spd Internet Avail,Humidifier,Programmable Thermostat,Security Alarm (owned),Sound System,Spa/Hot-tub,Wet Bar
Tax, Fees & Legal
Home warranty: No
Land Contract: No
Est. Summer Taxes: $2,925
Est. Winter Taxes: $2,232
County: Macomb
HOA fees: 1
HOA fees Period: Annually
Month Lease:
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).
    
Waterfront
Water Name: Louis Lake
Water Description: Direct Water Frontage,Lake Front,Lake Privileges,Water Front,Lake/River Priv
Feet On Water: 0
Rooms
Bedroom 1:
Bedroom 2 :
Bedroom 3:
Bedroom 4:
Family Room:
Greatroom:
Dinning Room:
Kitchen:
Livingroom:
Lot Details
Acres: 0.34
Lot Dimensions: 80X160
Barns:
Stalls:
Pole Buildings:
Paved Road: Paved
Map

Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.

The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request

Variable BINGMAPKAY is undefined.

 
The error occurred in C:\inetpub\wwwroot\AmericanAssociates\pop_print_view.cfm: line 286
Called from C:\inetpub\wwwroot\AmericanAssociates\pop_print_view.cfm: line 22
Called from C:\inetpub\wwwroot\AmericanAssociates\pop_print_view.cfm: line 1
 
284 : <img src="http://dev.virtualearth.net/REST/v1/Imagery/Map/Road/#gethomes.latitude#,#gethomes.longitude#/14?pp=#gethomes.latitude#,#gethomes.longitude#;20;&mapSize=320,240&key=#BingMapKay#"/>
285 : <cfelse>
286 : <img src="http://dev.virtualearth.net/REST/V1/Imagery/Map/Road/#URLEncodedFormat(streetnumber)#<cfif isdefined("StreetDirection") and StreetDirection IS NOT ""> #URLEncodedFormat(StreetDirection)#</cfif> #URLEncodedFormat(StreetName)#<cfif isdefined("StreetSuffix") and StreetSuffix IS NOT ""> #URLEncodedFormat(StreetSuffix)#</cfif>,#URLEncodedFormat(ZIP)#/?mapSize=320,240&key=#BingMapKay#"/>
287 : </cfif>
288 :
Resources:

Browser   Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address   3.148.108.28
Referrer  
Date/Time   28-Jun-24 11:28 AM
Stack Trace
at cfpop_print_view2ecfm1017774844._factor9(C:\inetpub\wwwroot\AmericanAssociates\pop_print_view.cfm:286) at cfpop_print_view2ecfm1017774844._factor10(C:\inetpub\wwwroot\AmericanAssociates\pop_print_view.cfm:22) at cfpop_print_view2ecfm1017774844.runPage(C:\inetpub\wwwroot\AmericanAssociates\pop_print_view.cfm:1) 

coldfusion.runtime.UndefinedVariableException: Variable BINGMAPKAY is undefined.
	at coldfusion.runtime.CfJspPage._get(CfJspPage.java:221)
	at coldfusion.runtime.CfJspPage._autoscalarize(CfJspPage.java:928)
	at cfpop_print_view2ecfm1017774844._factor9(C:\inetpub\wwwroot\AmericanAssociates\pop_print_view.cfm:286)
	at cfpop_print_view2ecfm1017774844._factor10(C:\inetpub\wwwroot\AmericanAssociates\pop_print_view.cfm:22)
	at cfpop_print_view2ecfm1017774844.runPage(C:\inetpub\wwwroot\AmericanAssociates\pop_print_view.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:152)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:349)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:210)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:51)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:86)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:69)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.RequestThrottleFilter.invoke(RequestThrottleFilter.java:115)
	at coldfusion.CfmServlet.service(CfmServlet.java:107)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:78)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
	at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doRequestNoFilter(FusionReactorCoreFilter.java:712)
	at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doFusionRequest(FusionReactorCoreFilter.java:341)
	at com.intergral.fusionreactor.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:246)
	at com.intergral.fusionreactor.filter.FusionReactorFilter.doFilter(FusionReactorFilter.java:121)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
	at com.seefusion.Filter.doFilter(Filter.java:49)
	at com.seefusion.SeeFusion.doFilter(SeeFusion.java:1500)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
	at jrun.servlet.FilterChain.service(FilterChain.java:101)
	at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
	at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:257)
	at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:541)
	at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:204)
	at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:318)
	at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:426)
	at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:264)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)