My Office Location:
American Associates
18035 Silver Pkwy
Fenton, MI 48430
 
Listings Presented by:
Christine Johnson
Call: (248) 702-5352
Fax: (888) 696-4544
Office: (810) 750-3333
490 MARTELL 
BLOOMFIELD HILLS, MI. 48304
$4,499,000
4 Beds 6 Baths 5,805 Sq Ft
Schools: Bloomfield Hills School District 0.8 Acres Year Built: 1938
Property Description
Discover an extraordinary residence gracing the coveted streets of Bloomfield Hills – 490 Martell Drive. This unparalleled property captures attention with its impeccable craftsmanship and meticulous attention to detail with its noteworthy upgrades. Entering the 2-story foyer you are graced by natural light, marble flooring, coved archways and wainscoting. The living room features a gas fireplace, plantation shutters, with access to the screened-in porch with bead board ceiling. The office includes exquisite trim details, built-in shelving and french doors leading to terrace. Formal dining room with bay window leads you through the butler's pantry to the stunning gourmet kitchen, a culinary masterpiece. Sealed marble counters and backsplash, Wolf appliances, farm sink, warming drawers, 2 dishwashers and a generously sized center island with ample barstool seating and commercial sized refrigerator flanked by wine refrigerators. Spacious breakfast nook completes the dream kitchen and opens to the family room where you will find a stone hearth fireplace, bay window and French doors leading to the incredible terrace. Gorgeous laundry room and mudroom make living efficient as well as beautiful. The grand staircase winds to the upper level sleeping quarters with 4 bedrooms, plantation shutters, and custom built-ins throughout the upper level. The primary suite will take your breath away with the generous spaces of grandeur, fireplace, built-ins, dressing areas, large free-standing soaking tub, walk-in shower with 5 shower heads and a rainfall. The walk-in closet with island and cabinetry is exquisite. The lower level, equipped with a workout area, recreation room, wet bar and fireplace. Additional full bath completes the lower level. Impeccably manicured grounds, stonework, and infinity pool are magical to behold. A truly spectacular residence nestled in the Cranbrook community.
Features
Baths: 4 full, 2 half
Style: Colonial
Exterior: Brick,Stone,Wood
Exterior Misc: Fenced Yard,BBQ/Grill Built-in,Inground Pool,Lawn Sprinkler,Patio,Porch,Spa/Hot Tub
Fireplaces: Yes
Fireplace Description: Basement Fireplace,FamRoom Fireplace,Gas Fireplace,LivRoom Fireplace,Primary Bedroom Fireplace
Garage: 4
Garage Description: Attached Garage,Electric in Garage
Basement: Yes
Basement Description: Finished
Appliances: Dishwasher,Disposal,Dryer,Microwave,Range/Oven,Refrigerator,Washer
Cooling: Ceiling Fan(s),Central A/C
Heating: Forced Air
Fuel: Natural Gas
Waste: Public Sanitary
Watersource: Public Water
Foundation : Basement
Tax, Fees & Legal
Est. Summer Taxes: $33,328
Est. Winter Taxes: $6,605
County: Oakland
HOA fees:
Month Lease:
    
Rooms
Bedroom 1: 17x20
Bedroom 2 : 18x13
Bedroom 3: 14x21
Bedroom 4: 11x17
Family Room: 16x18
Greatroom:
Dinning Room: 18x13
Kitchen: 14x18
Kitchen Flooring: Wood
Livingroom: 18x32
Livingroom Flooring: Wood
Lot Details
Acres: 0.8
Lot Dimensions: 204x168x219x165
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.47.230
Referrer  
Date/Time   22-Jun-24 11:24 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)