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
1747 HERON RIDGE DRIVE
BLOOMFIELD HILLS, MI. 48302
$5,995,000
6 Beds 12 Baths 9,500 Sq Ft
Schools: Bloomfield Hills 1.14 Acres Year Built: 1998
Property Description
Welcome to an unparalleled opportunity to own a prestigious waterfront estate in the exclusive Heron Bay Gated Community of Bloomfield Hills. This elegant masterpiece spans over 10,000 square feet, offering a perfect blend of architectural brilliance and sophisticated design, making it the epitome of luxury living. As you step inside, you are greeted by grand spaces and exquisite detailing featuring custom woodwork and intricate plaster craftsmanship. The gourmet kitchen is a chef's dream, featuring top-of-the-line stainless steel appliances, custom cabinetry, and sleek countertops. With ample storage, an inviting island with seating, and a sunlit breakfast nook, this kitchen is functional and beautiful. Conveniently located off the kitchen are the main-level laundry room, a powder room, and an expansive 4-car garage. Additionally, behind the kitchen, there is a full bedroom suite, providing an ideal space for guests or extended family. This estate is designed for ultimate comfort and convenience, featuring an elevator that services all levels, six opulent bedroom suites, 8 bathrooms, and 4 half baths. The first-floor primary suite is a true sanctuary, offering dual closets, including a breathtaking two-story closet for her, an oversized luxurious bath with a soaking tub and walk-in steam shower, and a private balcony with stunning waterfront views. Upstairs, three additional bedroom suites provide spacious layouts, generous closet space, high-end finishes, and an expansive living room. One serves as a secondary primary suite, perfect for guests or family. The exquisitely finished lower level is an entertainer's dream, boasting a lavish entertainment area, a second kitchen, an additional bedroom suite, an indoor pool surrounded by travertine floors, and a stunning jacuzzi. From here, you can access the beautifully landscaped private backyard, which features a private dock and abundant relaxation and entertainment space. With Bloomfield's award-winning schools and a variety of local amenities nearby, Welcome Home!
Features
Baths: 8 full, 4 half
Style: Other
Subdivision: HERON BAY SUB
Construction: Other,Stone
Exterior: Other,Stone
Exterior Misc: Gate House,Gutter Guard System,Lighting
Porchs: Balcony,Porch - Covered,Deck,Patio,Porch,Terrace,Patio - Covered
Fireplaces: 1
Garage: 4 Car
Garage Description: Direct Access,Electricity,Attached
Basement: Yes
Basement Description: Finished,Walkout Access
Appliances: Built-In Freezer,Built-In Gas Oven,Built-In Refrigerator,Dishwasher,Disposal,Dryer,Gas Cooktop,Range Hood,Washer
Cooling: Central Air
Heating: Forced Air
Fuel: Natural Gas
Waste: Public Sewer (Sewer-Sanitary)
Watersource: Public (Municipal)
Foundation : Basement
Special Features
Central Vacuum,Elevator/Lift,Other,Indoor Pool,Jetted Tub,Programmable Thermostat,Sound System,Wet Bar
Tax, Fees & Legal
Home warranty: No
Land Contract: No
Est. Summer Taxes: $21,495
Est. Winter Taxes: $19,733
County: Oakland
HOA fees: 1
HOA fees Period: Annually
Month Lease:
Legal Description: T2N, R10E, SEC 7 HERON BAY SUBDIVISION LOT 10 10-31-85 FR 003 & 200-002
    
Waterfront
Water Name: Upper Long Lake
Water Description: 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: 1.14
Lot Dimensions: 116x280X344X210
Barns:
Stalls:
Pole Buildings:
Paved Road: Paved,Pub. Sidewalk
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.145.107.244
Referrer  
Date/Time   01-Jul-24 05:15 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)