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
5295 MIDDLEBELT ROAD
WEST BLOOMFIELD, MI. 48323
$5,990,000
6 Beds 8 Baths 7,568 Sq Ft
Schools: Birmingham 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
Construction: Stone
Exterior: Stone
Exterior Misc: BBQ Grill,Lighting
Porchs: Patio,Terrace
Fireplaces: 1
Fireplace Description: Gas
Garage: 6 or More
Garage Description: Lift,Heated,Attached
Basement: Yes
Basement Description: Finished,Walkout Access
Appliances: Convection Oven,Dishwasher,Disposal,Double Oven,Dryer,Gas Cooktop,Microwave,Stainless Steel Appliance(s),Trash Compactor,Warming Drawer,Washer,Bar Fridge
Cooling: Ceiling Fan(s),Central Air
Heating: Forced Air
Fuel: Natural Gas
Waste: Septic Tank (Existing)
Watersource: Public (Municipal)
Foundation : Basement
Special Features
220 Volts,Cable Available,High Spd Internet Avail,Jetted Tub,Security Alarm (owned)
Tax, Fees & Legal
Home warranty: No
Land Contract: No
Est. Summer Taxes: $24,638
Est. Winter Taxes: $17,779
County: Oakland
Month Lease:
Legal Description: T2N, R9E, SEC 24 WALNUT LAKE ESTATES PART OF LOT 7 DESC AS BEG AT PT DIST S 74-27-02 E 7.02 FT FROM SW LOT COR, TH S 81-30-00 E 310.77 FT, TH S 14-37-25 E 44.12 FT, TH N 74-27-02 W 330.60 FT TO BEG, ALSO PART OF LOT 8 BEG AT PT DIST N 260 FT FROM SW LOT COR, TH N 19-08-00 E 114.60 FT, TH S 74-28-00 E 530 FT TO TRAVERSE PT 'A', TH S 74-28-00 E 105 FT M/L TO WATERS EDGE OF WALNUT LAKE, TH SLY & WLY 450 FT M/L ALG SHORE LINE OF SD LAKE, TH N 71-56-54 W 15 FT M/L TO TRAVERSE PT 'B' LOC S 69-40-27 W 172.42 FT FROM SD TRAVERSE PT 'A', TH N 71-56-54 W 227.49 FT TH N 82-17-11 W 171.79 FT TO BEG CORR 10-15-19
    
Waterfront
Water Name: Walnut Lake
Water Description: Lake Front,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: 1.74
Lot Dimensions: IRREGULAR
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   44.222.82.133
Referrer  
Date/Time   20-Sep-24 10:06 AM
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)