My Office Location:
American Associates

,
 
Listings Presented by:
Cathie Plummer
Call: (810) 252-9467
3567 LOCH BEND DRIVE
COMMERCE TOWNSHIP, MI. 48382
$1,690,000
4 Beds 7 Baths 5,032 Sq Ft
Schools: Walled Lake 0.56 Acres Year Built: 1988
Property Description
MAGNIFICENT SANDY LAKEFRONT! This one-of-a-kind estate begins with sweeping panoramic views of beautiful Lower Straits Lake. Built with the highest standards of excellence, every bit of this property has been exceptionally crafted with the latest and highest quality finishes. This waterfront property includes 3 levels of living space w/over ~7500 sqft: 4/5 BEDROOMS, 5 FULL, & 2 HALF BATHS. Featuring a grand 2 story living rm w/floor to ceiling windows, hardwood flooring, 3 Fireplaces. Newly updated epicurean kitchen designed for luxurious living & entertaining with Wolf, Bosch & Subzero appliances & travertine stone flooring. Private study w/built-in cabinetry. Mission style stair case leading to the master suite, w/ fireplace, new updated master bath w/soaking tub, stone tiled, & 3 more bedroom suites. Custom finished w/o lower level w/a built-in bar, wine cellar, entertainment & exercise rooms. Security system, reverse osmosis system, brick paver circle drive, 3 car garage.
Features
Baths: 5 full, 2 half
Style: Colonial,Traditional
Subdivision: HOMESTEAD SHORES CONDO
Construction: Brick
Exterior: Brick
Exterior Misc: Lighting,Permeable Paving
Porchs: Balcony,Porch - Covered,Deck,Patio,Porch,Terrace
Fireplaces: 1
Fireplace Description: Gas
Garage: 3 Car,3.5 Car
Garage Description: Direct Access,Electricity,Door Opener,Heated,Attached
Basement: Yes
Basement Description: Finished,Walkout Access
Appliances: Built-In Refrigerator,Dishwasher,Disposal,Dryer,Exhaust Fan,Free-Standing Gas Oven,Free-Standing Gas Range,Microwave,Other,Stainless Steel Appliance(s),Warming Drawer,Washer
Cooling: Ceiling Fan(s),Central Air
Heating: Forced Air
Fuel: Natural Gas
Waste: Septic Tank (Existing)
Watersource: Well (Existing)
Foundation : Basement
Special Features
Water Softener (owned),Central Vacuum,High Spd Internet Avail,De-Humidifier,Security Alarm (owned),Cable Available
Tax, Fees & Legal
Home warranty: No
Land Contract: No
Est. Summer Taxes: $10,817
Est. Winter Taxes: $5,241
County: Oakland
HOA fees: 1
HOA fees Period: Annually
Month Lease:
Legal Description: T2N, R8E, SEC 14 OAKLAND COUNTY CONDOMINIUM PLAN NO 455 HOMESTEAD SHORES UNIT 61 L 9452 P 165 7-18-86 FR 003
    
Waterfront
Water Name: Lower Straits
Water Description: Direct Water Frontage,Lake Front,Private Water Frontage,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.56
Lot Dimensions: 91.00X313X74X294
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.144.102.110
Referrer  
Date/Time   07-Jul-24 06:42 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)