My Office Location:
American Associates

,
 
Listings Presented by:
Amy Jeffery
Call: (810) 241-6679
Fax: (888) 696-4544
3372 LEDGEWOOD COURT
COMMERCE TOWNSHIP, MI. 48382
$1,300,000
4 Beds 6 Baths 4,729 Sq Ft
Schools: Huron Valley 0.34 Acres Year Built: 2006
Property Description
FULLY RENOVATED incredible all brick, lake front property on Lake Sherwood. Entering the home you have sprawling wood/tile floors that are heated on all three levels, with impeccable tall ceilings. Open floor plan that flows from great room to FULLY updated gourmet kitchen w/granite counter tops, massive center island, and never ending cabinet space. off the main floor there are multiple balconies, that give a spectacular view of the water. Dining room w/step ceiling, office w/bay window, Breakfast nook, first floor laundry w/giant mudroom, and a miraculous first floor master w/ incredible views of the water. 3 enormous beds, with covered balconies on upper level, and 5.1 updated baths throughout the home. Completely finished walkout access basement. Kitchen, Movie Theater, Workout room, full bath, 2 beds, and everything else in-between. Walks out to perfectly paved landscape, brand new Playmor dock, and small beach. You can't beat this lavish way of lake living!
Features
Baths: 5 full, 1 half
Style: Contemporary
Subdivision: LAKE SHERWOOD SUB NO 12
Construction: Brick,Stucco
Exterior: Brick,Stucco
Porchs: Balcony,Porch - Covered,Deck,Patio,Porch,Terrace
Fireplaces: 1
Fireplace Description: Gas
Garage: 4 Car
Garage Description: Direct Access,Electricity,Door Opener,Heated,Attached
Basement: Yes
Basement Description: Finished,Walkout Access
Appliances: Built-In Gas Oven,Built-In Refrigerator,Dishwasher,Disposal,Dryer,Microwave,Plumbed For Ice Maker,Washer,Wine Refrigerator
Cooling: Attic Fan,Ceiling Fan(s),Central Air
Heating: High Efficiency Sealed Combustion,Radiant,Zoned
Fuel: Natural Gas
Waste: Public Sewer (Sewer-Sanitary)
Watersource: Well (Existing)
Foundation : Basement
Special Features
Humidifier,Water Softener (owned),Utility Smart Meter,Central Vacuum,Dual-Flush Toilet(s),High Spd Internet Avail,Jetted Tub,Other,Programmable Thermostat,Wet Bar,Air Purifier,Security Alarm (owned),Cable Available
Tax, Fees & Legal
Home warranty: No
Land Contract: No
Est. Summer Taxes: $12,953
Est. Winter Taxes: $5,312
County: Oakland
HOA fees: 1
HOA fees Period: Annually
Month Lease:
Legal Description: T2N, R8E, SEC 7 LAKE SHERWOOD SUB NO 12 LOT 236 7-26-04 FR 013
    
Waterfront
Water Name: Lake Sherwood
Water Description: Lake Front,Private Water Frontage,River Front,Water Front
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: 136 X 145 X 76 X 153
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   18.191.176.228
Referrer  
Date/Time   24-Sep-24 02:36 PM
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)