My Office Location:
American Associates
18035 Silver Pkwy
Fenton, MI 48430
 
Listings Presented by:
Janice Stuckey
Call: (810) 577-8496
Fax: (810) 579-3400
Office: (810) 750-3333
1700 GREAT FOSTERS 
ROCHESTER, MI. 48306
$8,500,000
6 Beds 14 Baths 20,064 Sq Ft
Schools: Rochester 7.66 Acres Year Built: 2011
Property Description
Welcome to an exceptional estate set on nearly 8 acres, encompassing over 30,000 square feet of luxury living. Step into the grand foyer leading to a stunning main level featuring a great room adorned with unparalleled woodwork. The adjacent dining area showcases ceiling and floor woodwork that beautifully harmonize. Indulge in entertainment with a first-floor theater and retreat to a private indoor oasis featuring a cascading waterfall, hot tub, full kitchen, two full baths, and a changing room all in the indoor pool area. The primary suite is a lavish escape with an enormous bath and expansive closets. Additionally there are 5 other bedroom suites that will certainly impress. Discover hidden luxuries like a private game room with a full bar. The property also boasts a unique garage with an elevator lift capable of accommodating over 15 cars. An in home elevator services all levels, including the custom walkout lower level. This home epitomizes luxury and sophistication—it's a true masterpiece of design and comfort, complete with exceptional amenities for the discerning homeowner.
Features
Baths: 8 full, 6 half
Style: Country French
Construction: Other,Stone,Stucco
Exterior: Other,Stone,Stucco
Exterior Misc: Pool - Inground
Porchs: Porch - Covered,Patio,Porch,Terrace,Patio - Covered
Fireplaces: 1
Fireplace Description: Gas
Garage: 6 or More
Garage Description: Lift,Heated,Attached
Basement: Yes
Basement Description: Finished
Appliances: Induction Cooktop,Built-In Refrigerator,Dishwasher,Disposal,Double Oven,Dryer,Exhaust Fan,Microwave,Washer,Bar Fridge
Cooling: Central Air
Heating: Heat Pump
Fuel: Heat Pump,Natural Gas
Waste: Sewer at Street
Watersource: Well (Existing)
Foundation : Basement
Special Features
Elevator/Lift,Other,Humidifier,Indoor Pool,Spa/Hot-tub,Wet Bar
Tax, Fees & Legal
Home warranty: No
Land Contract: No
Est. Summer Taxes: $71,017
Est. Winter Taxes: $37,520
County: Oakland
HOA fees: 1
HOA fees Period: Annually
Month Lease:
Legal Description: T4N, R11E, SEC 33 PART OF NW 1/4 BEG AT PT DIST W 631.97 FT & S 02-22-19 E 695.67 FT FROM N 1/4 COR, TH S 02-22-19 E 705.19 FT, TH N 84-54-35 W 667.70 FT, TH N 02-18-37 W 413.43 FT, TH S 81-27-00 E 135.63 FT, TH S 08-50-00 W 44.41 FT, TH N 70-02-00 E 97.09 FT, TH S 87-40-00 E 17.40 FT, TH N 75-00-00 E 83.05 FT, TH S 79-30-00 E 52.58 FT, TH N 11-10-00 W 31.71 FT, TH N 68-10-00 W 49.70 FT, TH N 40-20-00 E 125.92 FT, TH S 83-50-00 E 39.11 FT, TH N 70-00-00 E 99.67 FT, TH N 53-00-00 E 79.72 FT, TH N 64-20-00 E 65.75 FT TO BEG 7.66 A 11-19-07 FR 038 & 039
    
Rooms
Bedroom 1:
Bedroom 2 :
Bedroom 3:
Bedroom 4:
Family Room:
Greatroom:
Dinning Room:
Kitchen:
Livingroom:
Lot Details
Acres: 7.66
Lot Dimensions: 706x666x415x720
Barns:
Stalls:
Pole Buildings:
Paved Road: Paved,Private
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.144.118.149
Referrer  
Date/Time   01-Jul-24 01:24 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)