My Office Location:
American Associates

,
 
Listings Presented by:
Randy Haney
Call: (810) 691-4124
Fax: (888) 696-4544
Office: (810) 733-3435
2589 SYLVAN SHORES DRIVE
WATERFORD, MI. 48328
$599,000
3 Beds 2 Baths 1,557 Sq Ft
Schools: Waterford 0.2 Acres Year Built: 1954
Property Description
Sylvan Lakefront mid-century modern masterpiece with spectacular MILLION $ unobstructed views of Sylvan & Otter Lakes. Quality construction throughout with attention to detail. Gorgeous hardwood floors, custom cabinetry and lighting with in-floor radiant heat. Open floor plan perfect for indoor and outdoor entertaining. Great room with vaulted ceilings flowing to dining room and serving area. One-of-a-kind Kitchen with high-end cabinetry, SS appliances, granite counters & glass tile backsplash. Master bedroom with doorwall to enclosed tiled Florida room with 2 additional bedrooms and centrally located full tile bath. Florida room overflows with natural light and panoramic views leading to multi-level decking extending your living space. Stairway leading to sundeck, terraced gardens and lush lakefront and docking. Sandy bottom awaits you.
Features
Baths: 1 full, 1 half
Style: Ranch
Subdivision: SYLVAN SHORES
Construction: Brick,Vinyl
Exterior: Brick,Vinyl
Exterior Misc: BBQ Grill,Lighting
Porchs: Porch - Covered,Deck,Patio,Porch
Garage: 2 Car
Garage Description: Electricity,Door Opener,Heated,Attached
Basement: No
Appliances: Built-In Electric Range,Dishwasher,Disposal,Double Oven,Dryer,Free-Standing Refrigerator,Microwave,Washer
Cooling: Window Unit(s)
Heating: Radiant
Fuel: Natural Gas
Waste: Public Sewer (Sewer-Sanitary)
Watersource: Public (Municipal)
Foundation : Slab
Special Features
Water Softener (owned),High Spd Internet Avail,Security Alarm (owned),Cable Available
Tax, Fees & Legal
Home warranty: No
Land Contract: No
Est. Summer Taxes: $3,490
Est. Winter Taxes: $2,291
County: Oakland
Month Lease:
Legal Description: T3N, R9E, SEC 36 SYLVAN SHORES PART OF LOTS 63 & 64 DESC AS BEG ON N LINE OF LOT 63 DIST E 23.3 FT FROM NW LOT COR, TH ELY ALG N LOT LINES 45 FT, TH S 07-56-00 W 192.29 FT TO SE COR OF LOT 63, TH N 69-00-00 W 50 FT TO SW COR LOT 63, TH N 09-06-00 E 182.73 FT TO BEG
    
Waterfront
Water Name: Sylvan Lake
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: 0.2
Lot Dimensions: 50.00X187.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   Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address   18.225.57.126
Referrer  
Date/Time   28-Sep-24 09:17 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)