My Office Location:
American Associates
18035 Silver Pkwy
Fenton, MI 48430
 
Listings Presented by:
Geri Schnekenburger
Call: (810) 845-7861
Fax: (888) 696-4544
Office: (810) 750-3333
5975 UPPER STRAITS BOULEVARD
WEST BLOOMFIELD, MI. 48324
$3,900,000
6 Beds 8 Baths 6,200 Sq Ft
Schools: West Bloomfield 1.68 Acres Year Built: 2014
Property Description
The Masterpiece of Upper Straits Lake – Artful design and quality craftsmanship throughout with attention to detail that is unparalleled. This is not a spec home, this is a high-quality and painstakingly crafted residence built for the generations. Perfectly placed on 131 feet of all-sports lake frontage with sought after southern exposure featuring the most gorgeous panoramic waterfront vistas. Well-planned and flowing open-concept spaces graciously accommodates both a simple lifestyle as well as the ambitious entertainer. Stunning gourmet kitchen showcases marble counters and appliances by Viking and Fisher & Paykel. Expansive and private master suite with vaulted ceiling and luxurious marble bathroom with steam shower and soaking tub. Spacious guest suites feature beautifully appointed en-suite bathrooms. Art deco inspired movie theater. Wet bar and game room. Rustic climate-controlled wine room. Fixtures by Grohe and Victoria & Albert. Ann Sacks tile and marble fireplace façades.
Features
Baths: 5 full, 3 half
Style: Other
Subdivision: UPPER STRAITS BEACH
Construction: Other
Exterior: Other
Porchs: Balcony,Patio,Porch - Covered,Terrace
Fireplaces: 1
Fireplace Description: Gas
Garage: 5 Car
Garage Description: Attached,Basement Access,Detached,Direct Access,Door Opener,Electricity
Basement: Yes
Basement Description: Finished,Walkout Access
Appliances: Bar Fridge,Dishwasher,Disposal,Dryer,Microwave,Refrigerator,Stove,Washing Machine
Cooling: Ceiling Fans 2+,Central Air
Heating: Forced Air,Radiant,Zoned
Fuel: Natural Gas
Waste: Sewer-Sanitary
Watersource: Well-Existing
Foundation : Basement
Special Features
Air Cleaner,Cable Available,Central Vacuum,High Spd Internet Avail,Humidifier,Pets Allowed,Security Alarm (owned),Sound System,Water Softener (owned),Wet Bar
Tax, Fees & Legal
Home warranty: No
Land Contract: No
Est. Summer Taxes: $39,530
Est. Winter Taxes: $13,259
County: Oakland
HOA fees:
Month Lease:
Legal Description: T2N, R9E, SEC 17 UPPER STRAITS BEACH LOT 23
    
Waterfront
Water Name: Upper Straits Lake
Water Description: All Sports Lake
Feet On Water: 0
Rooms
Bedroom 1:
Bedroom 2 :
Bedroom 3:
Bedroom 4:
Family Room:
Greatroom:
Dinning Room:
Kitchen:
Livingroom:
Lot Details
Acres: 1.68
Lot Dimensions: 100x706x130x780
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 284
Called from C:\inetpub\wwwroot\AmericanAssociates\pop_print_view.cfm: line 22
Called from C:\inetpub\wwwroot\AmericanAssociates\pop_print_view.cfm: line 1
282 : <div class="detail_grouping">Map</div>
283 : <cfif isdefined("latitude") and latitude gt 0 and longitude lt 0>
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#"/>

Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   3.235.180.193
Referrer  
Date/Time   30-Nov-22 04:55 PM
Stack Trace
at cfpop_print_view2ecfm1017774844._factor9(C:\inetpub\wwwroot\AmericanAssociates\pop_print_view.cfm:284) 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:284)
	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)