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
WEST BLOOMFIELD, MI. 48323
$4,999,999
4 Beds 10 Baths 5,906 Sq Ft
Schools: Bloomfield Hills 0.35 Acres Year Built: 2000
Property Description
An absolute gem located on an all sport Orchard Lake. Offering unparallel luxury living in this grand lake front residence boasting over 7,500+ SqFt. of opulent living space. The house is purposefully east-facing, ensuring absolute stunning sunset views from every rooms & abundant natural light throughout the day. Welcoming into home with a grand double door entry dramatic double height foyer, featuring custom Baccarat Crystal Chandelier & Marble flooring. (Heated marble flooring throughout the home except stairs). Unveil a realm of elegance in the custom library meticulously designed & decorated with high amenities, elevator/lift, & full bath. This eminent space offers a perfect blend of architectural craftsmanship & practicality, creating an inviting ambiance for both work & relaxation. Get ready to be greeted by most elegant formal dining room with Mosaic Dome uniquely designed by custom skilled artisans, featuring custom Baccarat Crystal chandelier. Kitchen with spacious laid out custom cabinetry, seated Island, Thermador Appliance’s, Subzero, & spacious pantry. A double height Family room w/ Dual Fireplace w/ stunning views of Orchard Lake as you embrace your day in comfort & luxury. Impressive living room designed with wet bar & custom tray ceiling, featuring gorgeous sunset views of Orchard Lake as you enjoy the evening. Entertain smoothly in the fully finished Walkout Lower Level, complete with a full second Kitchen, gorgeous bar, a spacious Family Room for entertainment, a media and/or Exercise room, his and her half bathrooms, ample amount of storage. Bedroom with full bath. Marble stairs leading onto second floor with exquisite Master Bedroom Suite with stunning lake view, fire place, wet bar, custom large Walk in Closet w/ elevator, Custom Master Bath with Jacuzzi, steam shower and Dressing area. The Home features with 2 additional Second Floor Bedroom suites with lake view. Central Vacuum thru out. Beautifully designed to ensure a comfortable & luxury lake front life style. Price Improvement!
Features
Baths: 6 full, 4 half
Style: Colonial
Subdivision: VISTAS OF ORCHARD LAKE CONDO
Construction: Brick,Stucco
Exterior: Brick,Stucco
Fireplaces: 1
Garage: 3 Car
Garage Description: Attached
Basement: Yes
Basement Description: Finished,Walkout Access
Appliances: Wine Cooler,Dishwasher,Disposal,Double Oven,Dryer,Electric Cooktop,Free-Standing Refrigerator,Range Hood,Wine Refrigerator,Bar Fridge
Cooling: Central Air
Heating: Forced Air
Fuel: Natural Gas
Waste: Public Sewer (Sewer-Sanitary),Sewer at Street
Watersource: Public (Municipal),Water at Street
Foundation : Basement
Special Features
Central Vacuum,Elevator/Lift,Air Purifier,Humidifier,Programmable Thermostat,Sound System,Wet Bar
Tax, Fees & Legal
Home warranty: No
Land Contract: No
Est. Summer Taxes: $24,059
Est. Winter Taxes: $5,669
County: Oakland
HOA fees: 1
HOA fees Period: Monthly
Month Lease:
Legal Description: T2N, R9E, SEC 14 OAKLAND COUNTY CONDOMINIUM PLAN NO 907 THE VISTAS OF ORCHARD LAKE CONDOMINIUM UNIT 7 L 15306 P 135 3-30-95 FR 101-001
    
Waterfront
Water Name: Orchard Lake
Water Description: Beach Access,Lake Front,Lake Privileges
Feet On Water: 0
Rooms
Bedroom 1:
Bedroom 2 :
Bedroom 3:
Bedroom 4:
Family Room:
Greatroom:
Dinning Room:
Kitchen:
Livingroom:
Lot Details
Acres: 0.35
Lot Dimensions: 131x113x194x231
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   Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address   3.12.136.191
Referrer  
Date/Time   30-Jun-24 11:18 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)