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
00 MOHAWK COURT 
BLOOMFIELD HILLS, MI. 48302
$1,999,000
4 Beds 4 Baths 4,864 Sq Ft
Schools: Birmingham City School District 1.2 Acres Year Built: 2024
Property Description
Outstanding "To Be Built Cranbrook Custom Home" with exceptional finishes throughout. Nestled in Bloomfield's most sought-after location with a waterfront 1.2-acre parcel of land inside the Lone Pine Heights community. Welcome Home to this fantastic opportunity to build this nearly 5,000 sqft 4 Bedroom, 4 Bathroom residence with an unparalleled floor plan highlighting an open concept layout that includes high ceilings, a chef's kitchen with top-of-the-line appliances, custom cabinetry, and multiple fireplaces. This rare offering is a once-in-a-lifetime opportunity with oversized rooms, an excellent primary suite with an enormous closet, a soaking tub, dual vanities, a water closet, and a separate shower, all while having maximum privacy. Additional highlights upstairs include an entire bedroom suite, Jack and Jill bedrooms, upstairs laundry, and much more. Outside features exceptional architecture and landscape, a multiple-car garage, and maximum privacy, all while being situated in this highly sought-after location with many multi-million dollar properties nearby. Learn more about private viewing opportunities with Cranbrook's model home.
Features
Baths: 3 full, 1 half
Style: Contemporary
Subdivision: LONE PINE HEIGHTS NO 1
Exterior: Brick,Stone,Wood
Exterior Misc: Deck,Patio,Porch
Fireplaces: Yes
Fireplace Description: FamRoom Fireplace,Gas Fireplace,LivRoom Fireplace,Primary Bedroom Fireplace
Garage: 3
Garage Description: Attached Garage,Electric in Garage,Direct Access
Basement: Yes
Basement Description: Finished
Appliances: Dishwasher,Disposal,Dryer,Freezer,Range/Oven,Washer
Cooling: Central A/C
Heating: Forced Air
Fuel: Natural Gas
Waste: Septic
Watersource: Public Water
Foundation : Basement
Tax, Fees & Legal
Est. Summer Taxes: $813
Est. Winter Taxes: $676
County: Oakland
HOA fees:
Month Lease:
    
Waterfront
Water Name: Indianwood Pond/Walnut La
Water Description: All Sports Lake,Lake Frontage,Lake/River Access,Waterfront
Feet On Water: 0
Rooms
Bedroom 1: 23x19
Bedroom 2 : 14x12
Bedroom 3: 14x14
Bedroom 4: 19x12
Family Room:
Greatroom:
Dinning Room: 12x19
Kitchen: 14x19
Kitchen Flooring: Wood
Livingroom:
Lot Details
Acres: 1.2
Lot Dimensions: 206x196x118x253x205
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   3.145.48.33
Referrer  
Date/Time   28-Jun-24 08: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)