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
5305 ELMGATE BAY DRIVE
ORCHARD LAKE, MI. 48324
$6,900,000
8 Beds 10 Baths 12,866 Sq Ft
Schools: West Bloomfield 2.22 Acres Year Built: 1991
Property Description
Discover this extraordinary estate situated on almost 2 acres of prime property along the shores of Upper Straits Lake. This meticulously updated residence has been renovated to perfection, offering almost 13,000 square feet of luxurious living space. The grand foyer, featuring a stunning Cinderella staircase, sets a sophisticated tone throughout the home, which is designed to offer the ultimate in elegance and comfort. The residence is thoughtfully designed with numerous areas for both entertaining and unwinding, ensuring every detail meets the highest standards of refinement. The kitchen is a true masterpiece, equipped with two custom built-in refrigerators, top-of-the-line cabinetry, and exquisite stone surfaces. The oversized island provides the ideal workspace in this sumptuous kitchen and is complemented by a dedicated Miele coffee station. The breakfast area boasts breathtaking views of the lake and provides access to the back deck. Choose from a stunning family room, a spacious living room, or one of the many cozy sitting rooms. A first-floor ensuite bedroom completes this level. The second-floor primary suite is a private retreat, featuring a lavish bathroom, a separate sitting area with lake views, a fireplace, a wet bar, and a laundry area. Four additional bedrooms and three luxurious bathrooms complete this level, while the third floor offers two additional bedrooms and a full bath. The lower level offers a spectacular variety for recreation, including a great room with a fireplace, two game rooms, and a spa area equipped with two showers and a laundry room. An oversized swimming pool with a jacuzzi can be used year-round and is complemented by a dry sauna for rejuvenation. The property also boasts maintenance-free decking across the entire back of the home and a brick paver terrace, providing numerous options for enjoying the expansive grounds and magnificent views. Additional features include lake access, docking, two elevators, central vacuum system, and surround sound system. Smart Home!
Features
Baths: 8 full, 2 half
Style: Colonial
Construction: Brick
Exterior: Brick
Porchs: Deck,Terrace
Fireplaces: 1
Fireplace Description: Gas
Garage: 3 Car
Garage Description: Attached
Basement: Yes
Basement Description: Finished
Appliances: Built-In Gas Range,Built-In Refrigerator,Dishwasher,Disposal,Exhaust Fan,Microwave,Range Hood,Bar Fridge
Cooling: Central Air
Heating: Forced Air
Fuel: Natural Gas
Waste: Public Sewer (Sewer-Sanitary)
Watersource: Public (Municipal)
Foundation : Basement
Special Features
Indoor Pool
Tax, Fees & Legal
Home warranty: No
Land Contract: No
Est. Summer Taxes: $60,549
Est. Winter Taxes: $2,934
County: Oakland
Month Lease:
Legal Description: T2N, R9E, SEC 16 PART OF E 1/2 OF SEC BEG AT PT DIST S 1707.17 FT & S 89-41-15 E 349.90 FT & N 60-33-45 E 280.00 FT & S 07-26-31 W 86.76 FT FROM N 1/4 COR, TH N 75-14-00 E 133.03 FT, TH S 83-58-00 E 71.15 FT, TH S 02-51-00 E 99.00 FT, TH S 15-00-00 W 524.91 FT, TH S 15-00-00 W 146 FT TO WATERS EDGE OF UPPER STRAITS LAKE, TH SWLY 155 FT ALG SD WATERS EDGE, TH N 07-26-31 E 50 FT, TH N 07-26-31 E 755.40 FT TO BEG 3.07 A
    
Waterfront
Water Name: Upper Straits Lake
Water Description: Canal Front,Direct 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: 2.22
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   18.97.14.83
Referrer  
Date/Time   05-Dec-24 03: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)