My Office Location:
American Associates
2240 Hill Rd. Ste B
Grand Blanc, MI 48439
 
Listings Presented by:
Brigitte Hawley
Call: (810) 869-1041
Fax: (888) 696-4544
Office: (810) 600-2158
3760 SLEETH ROAD
COMMERCE TWP, MI. 48382
$3,999,999
5 Beds 7 Baths 6,097 Sq Ft
Schools: Huron Valley 1.73 Acres Year Built: 2018
Property Description
ENTER GATE TO A PRIVATE PENINSULA,1.73 ACRES OF BREATHTAKING WATERFRONT,ON EXCLUSIVE LAKE SHERWOOD!NEW SEA WALL AND 400 FT OF BOULDERS LINE THE SHORE,2 PRIV. DOCKS W/POWER,WATER AND ENABLED WI-FI.AN EXCEPTIONALLY DESIGNED ARCHITECTURAL MASTERPIECE OF A HOME,W/EXQUISITE FINISHES.IPE BRAZILIAN WOOD AND LIMESTONE BLEND SEAMLESSLY DISPLAYING LUXURY AT ITS FINEST.IMPORTED GERMAN GROKE DOORS INVITE YOU INTO 9300 SQ FT OF TRANQUILITY.270 DEGREES OF WATERFRONT VIEWS,THIS 5 BDRM SMART HOME W/3 SPACIOUS BDRM SUITES,2 HALF BATHS,HAS IT ALL.BDRMS HAVE COVERED BALCONIES W/SNOW MELT DECKS FOR YEAR ROUND ENJOYMENT.HEATED ITALIAN PORCELAIN FLRS THROUGHOUT MAIN LEVEL,GREAT RM W/FLR TO CEILING WINDOWS INVITE SUNSHINE ALL YEAR.1ST FLR MSTR STE W/STEAM SHOWER, SOAKING TUB,HIS AND HERS WIC’S.2 GOURMET KITCHENS,2BUILT IN SUB ZERO'S W/CHEF PANTRY.MAJESTIC FLOATING OAK STAIRCASE CONNECTS ALL LEVELS.LL WALKOUT,3,000 SQ FT OF LIVABLE SPACE,HEATED POLISHED CONCRETE,STEAM SHOWER W/SEATING.6 CAR GAR W/HEATED FLR!
Features
Baths: 5 full, 2 half
Style: Prairie
Subdivision: LAKE SHERWOOD SUB NO 9
Construction: Stone,Wood
Exterior: Stone,Wood
Exterior Misc: Whole House Generator,Awning/Overhang(s),Lighting
Porchs: Balcony,Porch - Covered,Deck,Patio,Porch,Terrace
Fireplaces: 1
Fireplace Description: Gas
Garage: 6 or More
Garage Description: Direct Access,Electricity,Door Opener,Side Entrance,Heated,Tandem,Attached
Basement: Yes
Basement Description: Finished,Walkout Access
Appliances: Vented Exhaust Fan,Water Purifier Owned,Built-In Refrigerator,Dishwasher,Disposal,Double Oven,Dryer,Electric Cooktop,Exhaust Fan,Free-Standing Gas Range,Microwave,Other,Range Hood,Stainless Steel Appliance(s),Washer
Cooling: Ceiling Fan(s),Central Air
Heating: Forced Air,Radiant,Zoned
Fuel: Natural Gas
Waste: Public Sewer (Sewer-Sanitary)
Watersource: Well (Existing)
Foundation : Basement
Special Features
Humidifier,Water Softener (owned),Programmable Thermostat,Wet Bar,Air Purifier,De-Humidifier,Intercom,Security Alarm (owned),ENERGY STAR® Qualified Window(s)
Tax, Fees & Legal
Home warranty: No
Land Contract: No
Est. Summer Taxes: $25,341
Est. Winter Taxes: $10,421
County: Oakland
HOA fees: 1
HOA fees Period: Annually
Month Lease:
Legal Description: T2N, R8E, SEC 7 LAKE SHERWOOD SUB NO 9 LOT 190
    
Waterfront
Water Name: Lake Sherwood
Water Description: Lake Front
Feet On Water: 0
Rooms
Bedroom 1:
Bedroom 2 :
Bedroom 3:
Bedroom 4:
Family Room:
Greatroom:
Dinning Room:
Kitchen:
Livingroom:
Lot Details
Acres: 1.73
Lot Dimensions: 420.00X150.00
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   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   98.82.120.188
Referrer  
Date/Time   09-Sep-24 04:08 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)