My Office Location:
American Associates

,
 
Listings Presented by:
Randy Haney
Call: (810) 691-4124
Fax: (888) 696-4544
Office: (810) 733-3435
5295 MIDDLEBELT 
WEST BLOOMFIELD, MI. 48323
$5,990,000
6 Beds 8 Baths 7,568 Sq Ft
Schools: Birmingham City School District 1.74 Acres Year Built: 1990
Property Description
Custom built and designed by DesRosiers architects, the spectacular contemporary is perched over 8 acres of rolling grounds with 269 feet of water front on Walnut Lake. Floor to ceiling windows capture lakefront views from every angle. Kitchen with granite island, stainless appliances, breakfast nook, built in work area and more. For the person that needs a real office space this home offers a second floor office wing with multiple TV monitors, architectural ceiling details, panoramic views and storage space. The Owner’s suite has a private tv viewing room and sunrise views from every angle. Sitting lounge for relaxation flanks the 4 additional guest rooms on this level, all with ensuites. Multi-teared garage is ideal for the car enthusiasts. A finished lower level with recreational space featuring granite seated bar w/ dining, fireplace, TV/Movie/ billiards area, additional bedroom & bath, and a fantastic walkout to the lake complete this magnificent masterpiece! Vacant Lot included in sale: property ID: 1824351037.
Features
Baths: 6 full, 2 half
Style: Contemporary
Subdivision: WALNUT LAKE ESTATES
Exterior: Stone
Exterior Misc: BBQ/Grill Built-in,Patio,Terrace
Fireplaces: Yes
Fireplace Description: Basement Fireplace,DinRoom Fireplace,FamRoom Fireplace,Gas Fireplace,Primary Bedroom Fireplace
Garage: 6
Garage Description: Attached Garage,Heated Garage
Basement: Yes
Basement Description: Finished,Walk Out
Appliances: Dishwasher,Disposal,Dryer,Microwave,Range/Oven,Trash Compactor,Washer
Cooling: Ceiling Fan(s),Central A/C
Heating: Forced Air
Fuel: Natural Gas
Waste: Septic
Watersource: Public Water
Foundation : Basement
Tax, Fees & Legal
Est. Summer Taxes: $24,638
Est. Winter Taxes: $17,779
County: Oakland
HOA fees:
Month Lease:
    
Waterfront
Water Name: Walnut Lake
Water Description: All Sports Lake,Lake Frontage,Waterfront
Feet On Water: 0
Rooms
Bedroom 1: 33x24
Bedroom 2 : 13x13
Bedroom 3: 26x11
Bedroom 4: 16x13
Family Room: 22x15
Greatroom:
Dinning Room: 15x14
Kitchen: 18x29
Kitchen Flooring: Other
Livingroom: 29x20
Livingroom Flooring: Wood
Lot Details
Acres: 1.74
Lot Dimensions: IRREGULAR
Barns:
Stalls:
Pole Buildings:
Paved Road: Paved Street
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   Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address   18.227.134.133
Referrer  
Date/Time   28-Sep-24 05:00 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)