My Office Location:
American Associates
18035 Silver Pkwy
Fenton, MI 48430
 
Listings Presented by:
Sally Newland
Call: (810) 955-4898
Fax: (810) 579-3400
Office: (810) 600-2175
597 YARBORO DRIVE
BLOOMFIELD HILLS, MI. 48304
$2,850,000
6 Beds 8 Baths 6,017 Sq Ft
Schools: Bloomfield Hills 1 Acres Year Built: 2012
Property Description
WOW! THIS EXQUISITE NEVER-BEFORE-SEEN RESIDENCE OFFERS THE MOST EXCEPTIONAL QUALITY & LUXURIOUS DETAILS THRU-OUT 10,000+ SF OF UNPARALLELED LIVING SPACE. AN INCOMPARABLE OASIS ACHIEVING THE PERFECT SYMPHONY OF STYLE, SOPHISTICATION & SOLITUDE, THIS ONE-OF-A-KIND HOME IS SITUATED ON A SPECTACULAR SOUTHERN-EXPOSURE 1-ACRE FENCED LOT W/IN-GROUND POOL/SPA/JUMPING PLATFORM/SLIDE/ WATERFALLS PLUS POOL HOUSE W/HALF-BATH & OUTDOR SHOWER. RARE 1ST-FLOOR OWNER'S SUITE W/LUXURIOUS BATH & PHENOMENAL CLOSETS. STATE-OF-THE-ART DREAM KITCHEN W/BREAKFAST NOOK OVERLOOKING YARD & GREAT ROOM. STUNNING LIBRARY W/FIREPLACE, FOUR GENEROUS BEDROOM SUITES PLUS A LOFT UPSTAIRS & SO MUCH MORE! FULLY FINISHED LL W/2ND KITCHEN, FAMILY ROOM, GYM, 6TH BEDROOM SUITE, FULL THEATRE & PLENTY OF ROOM TO ENTERTAIN. SIDE ENTRY 3-CAR GARAGE PLUS FRONT MOTOR COURT, TOO! SMART-HOME, SOUND THRU-OUT & EVEN HIDDEN SAFES. THE FINAL "PIES DE RESISTANCE": EVERY SINGLE FLOOR (INCLUDING GARAGE & LOWER LEVEL) IS HEATED. BETTER HURRY!
Features
Baths: 7 full, 1 half
Style: Colonial,Tuscan
Construction: Brick,Stone
Exterior: Brick,Stone
Exterior Misc: Spa/Hot-tub,Whole House Generator,Awning/Overhang(s),BBQ Grill,Chimney Cap(s),Lighting,Permeable Paving,Fenced,Cabana,Pool - Inground
Porchs: Porch - Covered,Deck,Patio,Porch,Terrace
Fireplaces: 1
Fireplace Description: Gas
Garage: 3 Car
Garage Description: Direct Access,Electricity,Door Opener,Side Entrance,Heated,Attached
Basement: Yes
Basement Description: Daylight,Finished,Walkout Access
Appliances: Vented Exhaust Fan,Built-In Freezer,Built-In Gas Oven,Built-In Refrigerator,Dishwasher,Disposal,Double Oven,Dryer,Exhaust Fan,Free-Standing Freezer,Free-Standing Gas Range,Free-Standing Refrigerator,Gas Cooktop,Microwave,Range Hood,Stainless Steel Applian
Cooling: Central Air
Heating: Forced Air,Radiant,Zoned
Fuel: Natural Gas
Waste: Public Sewer (Sewer-Sanitary)
Watersource: Public (Municipal)
Foundation : Basement
Special Features
Humidifier,Central Vacuum,High Spd Internet Avail,Jetted Tub,Programmable Thermostat,Sound System,Wet Bar,Air Purifier,Intercom,Security Alarm (owned),Cable Available
Tax, Fees & Legal
Home warranty: Yes
Land Contract: No
Est. Summer Taxes: $36,404
Est. Winter Taxes: $11,567
County: Oakland
Month Lease:
Legal Description: T2N, R10E, SEC 22 PART OF SE 1/4 BEG AT PT DIST N 89-39-30 E 378.50 FT & N 02-06-10 E 276.05 FT FROM S 1/4 COR, TH N 02-06-10 E 292 FT, TH S 87-19-25 E 150 FT, TH S 02-23-50 W 291.99 FT, TH N 87-19-25 W 148.50 FT TO BEG 1 A 7-23-92 FR 017
    
Rooms
Bedroom 1:
Bedroom 2 :
Bedroom 3:
Bedroom 4:
Family Room:
Greatroom:
Dinning Room:
Kitchen:
Livingroom:
Lot Details
Acres: 1
Lot Dimensions: 150 x 293
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 286
Called from C:\inetpub\wwwroot\AmericanAssociates\pop_print_view.cfm: line 22
Called from C:\inetpub\wwwroot\AmericanAssociates\pop_print_view.cfm: line 1
 
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#"/>
287 : </cfif>
288 :
Resources:

Browser   Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address   3.133.116.126
Referrer  
Date/Time   17-Jun-24 09:11 AM
Stack Trace
at cfpop_print_view2ecfm1017774844._factor9(C:\inetpub\wwwroot\AmericanAssociates\pop_print_view.cfm:286) 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:286)
	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)