My Office Location:
American Associates

,
 
Listings Presented by:
Randy Haney
Call: 810-691-4124
Fax: 888-696-4544
Office: 810-733-3435
2354 HERONWOOD 
BLOOMFIELD HILLS, MI. 48302
$1,500,000
5 Beds 7 Baths 4,359 Sq Ft
Schools: Bloomfield Hills School District 0.46 Acres Year Built: 1992
Property Description
Opportunity knocks once more as this home reenters the market, courtesy of a buyer whose financing plans have unraveled the Located within the GATED Heron Woods community, this exquisite Guido Grassi custom-built Bloomfield home offers 7,000+ sq ft of luxurious living space. Step into the grand 2-story foyer adorned with custom polished marble flooring and the meticulous attention to detail becomes apparent. The light-soaked formal living room with floor to ceiling bay window & a custom one-of-a-kind fireplace is a focal point. Gaze through the Romeo & Juliet balconies & savor views of the lower level 4 season indoor pool room complete with a Jacuzzi, air conditioning, new pool heater, 10 skylights, & a full bath. The perfect year-round space to gather with friends and family! The expansive kitchen is a cook’s delight featuring abundant natural light, a sub zero refrigerator, double oven, Jenn Air stove, large pantry, dual sided fireplace open to the family room and a breakfast nook with panoramic views of the grounds. Immerse yourself in luxury while working or retreating to the entry level library with floor to ceiling custom woodwork, built-ins and French doors for privacy. The lower level has an expansive home theatre room featuring high-end Runco projector, surround sound speakers & fireplace. Adjacent to the pool is a perfectly placed exercise room! The 2nd kitchen doubles as a bar & is the perfect place to gather. Not only is there a 5th bedroom & full bath in the lower level, but an additional flex room & the perfect play or craft room with a window for that “part of the action” feeling. Let your imagination run wild with what you can do with all the space! Upstairs, the primary suite is massive featuring a tray ceiling, separate vanity room, large his & hers walk-in closets and an oversized bath with jetted tub & shower. 2 additional bedrooms share a Jack & Jill bath and a 4th bedroom has an ensuite bath perfect for guests. The oversized
Features
Baths: 5 full, 2 half
Style: Colonial,Contemporary
Subdivision: HERON WOODS
Exterior: Brick,Wood
Exterior Misc: Deck,Inground Pool,Lawn Sprinkler,Porch
Fireplaces: Yes
Fireplace Description: Basement Fireplace,FamRoom Fireplace,Gas Fireplace,LivRoom Fireplace
Garage: 3
Garage Description: Attached Garage,Electric in Garage,Gar Door Opener,Side Loading Garage
Basement: Yes
Basement Description: Finished,Walk Out
Appliances: Dishwasher,Disposal,Dryer,Microwave,Range/Oven,Trash Compactor,Washer
Cooling: Central A/C
Heating: Forced Air
Fuel: Natural Gas
Waste: Public Sanitary
Watersource: Public Water
Foundation : Basement
Tax, Fees & Legal
Est. Summer Taxes: $8,470
Est. Winter Taxes: $7,776
County: Oakland
HOA fees: 3500
HOA fees Period: Yearly
Month Lease:
    
Rooms
Bedroom 1: 19x18
Bedroom 2 : 14x12
Bedroom 3: 13x13
Bedroom 4: 16x14
Family Room: 21x17
Greatroom:
Dinning Room: 17x13
Kitchen: 14x12
Kitchen Flooring: Ceramic
Livingroom: 21x20
Livingroom Flooring: Carpet
Lot Details
Acres: 0.46
Lot Dimensions: 120x169x120x166
Barns:
Stalls:
Pole Buildings:
Paved Road: Paved Street
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   18.117.75.168
Referrer  
Date/Time   28-Jun-24 10:47 PM
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)