My Office Location:
American Associates
18035 Silver Pkwy
Fenton, MI 48430
 
Listings Presented by:
Janice Stuckey
Call: (810) 577-8496
Fax: (810) 579-3400
Office: (810) 750-3333
490 MARTELL DRIVE
BLOOMFIELD HILLS, MI. 48304
$4,499,000
4 Beds 6 Baths 5,805 Sq Ft
Schools: Bloomfield Hills 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. Quartz 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
Construction: Brick,Stone,Wood
Exterior: Brick,Stone,Wood
Exterior Misc: Spa/Hot-tub,BBQ Grill,Lighting,Fenced,Pool - Inground
Porchs: Patio,Porch
Fireplaces: 1
Fireplace Description: Gas
Garage: 4 Car
Garage Description: Electricity,Attached
Basement: Yes
Basement Description: Finished
Appliances: Built-In Gas Range,Built-In Refrigerator,Dishwasher,Disposal,Dryer,Microwave,Range Hood,Stainless Steel Appliance(s),Warming Drawer,Washer,Wine Refrigerator
Cooling: Ceiling Fan(s),Central Air
Heating: Forced Air
Fuel: Natural Gas
Waste: Public Sewer (Sewer-Sanitary)
Watersource: Public (Municipal)
Foundation : Basement
Special Features
Smoke Alarm,220 Volts,Other,High Spd Internet Avail,Humidifier,Programmable Thermostat,Sound System
Tax, Fees & Legal
Home warranty: No
Land Contract: No
Est. Summer Taxes: $33,328
Est. Winter Taxes: $6,605
County: Oakland
Month Lease:
Legal Description: T2N, R10E, SEC 22 PART OF SE 1/4 BEG AT NE COR OF LOT 31 OF 'SOUTH CRANBROOK NO 1', TH N 01-05-30 E 214 FT, TH N 88-54-30 W 120.67 FT, TH ALG CURVE TO LEFT, RAD OF 40 FT, DIST OF 64.4 FT, TH S 01-09-08 E 121.02 FT, TH ALG CURVE TO RIGHT, RAD OF 916 FT, DIST OF 51.55 FT, TH S 88-54-30 E 164.23 FT TO BEG 0.80 A
    
Rooms
Bedroom 1:
Bedroom 2 :
Bedroom 3:
Bedroom 4:
Family Room:
Greatroom:
Dinning Room:
Kitchen:
Livingroom:
Lot Details
Acres: 0.8
Lot Dimensions: 204x168x219x165
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 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.148.102.142
Referrer  
Date/Time   27-Jun-24 05:07 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)