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
3797 N ADAMS ROAD
BLOOMFIELD HILLS, MI. 48304
$574,900
4 Beds 3 Baths 3,417 Sq Ft
Schools: Birmingham 0.81 Acres Year Built: 1966
Property Description
Beautifully Updated w/AMAZING Location! You'll Love this Secluded, Almost Acre, Corner Parcel Complete w/Professional Landscaping, Invisible Fence, Circle Drive, & Large Deck, Located on Cozy Private Dr. Easy Commuting, Short Drive to Somerset Mall & Downtown Birmingham. Birmingham Schools, Walking Distance to Elementary & Just a Mile from Middle School! Inviting Foyer Greets you Entering this Spacious Home. Large, Bright, Open Kitchen w/Breakfast Nook, Open to Living Rm Complete w/Cozy Fireplace & Formal Dining. Layout w/Great Rm, Study, Family Rm, & 4 Season Recreational Rm, Provides Many Wonderful Possibilities for Entertaining, Working from Home, & Virtual Learning! Second Story Provides Master w/Beautifully Bright, On-Suite Bath Complete w/Lg Walk-in Closet, 3 Lg Bedrooms w/Lg Closets & Full Bath. Finished Basement Boasts TONS of Storage & Large Family Rm! 1st Flr Laundry, Appliances Incld, New Water Heater, Furnace, AC & Gutters. High End, Whole Home Humidifier w/UV Cleaner!
Features
Baths: 2 full, 1 half
Style: Colonial
Construction: Aluminum,Brick
Exterior: Aluminum,Brick
Exterior Misc: Lighting
Porchs: Deck,Porch
Fireplaces: 1
Fireplace Description: Gas,Natural
Garage: 2.5 Car
Garage Description: Attached,Direct Access,Door Opener
Basement: Yes
Basement Description: Finished
Appliances: Electric Cooktop,Dishwasher,Dryer,Microwave,Double Oven,Built-In Refrigerator,Washer
Cooling: Ceiling Fan(s),Central Air
Heating: Forced Air
Fuel: Natural Gas
Waste: Public Sewer (Sewer-Sanitary)
Watersource: Public (Municipal)
Foundation : Basement
Special Features
Security Alarm (owned)
Tax, Fees & Legal
Home warranty: No
Land Contract: No
Est. Summer Taxes: $3,927
Est. Winter Taxes: $3,098
County: Oakland
Month Lease:
Legal Description: T2N, R10E, SEC 24 PART OF NE 1/4 BEG AT PT DIST S 02-10-00 E 903.72 FT FROM NE SEC COR, TH S 89-07-00 W 284 FT, TH S 02-10-53 E 120.89 FT, TH S 89-47-00 E 284.15 FT, TH N 02-10-00 W 126.31 FT TO BEG 0.81 A C205A-2
    
Rooms
Bedroom 1:
Bedroom 2 :
Bedroom 3:
Bedroom 4:
Family Room:
Greatroom:
Dinning Room:
Kitchen:
Livingroom:
Lot Details
Acres: 0.81
Lot Dimensions: 284 x 120.89 x 284.15 x 126.31
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 286
Called from C:\inetpub\wwwroot\AmericanAssociates\pop_print_view.cfm: line 22
Called from C:\inetpub\wwwroot\AmericanAssociates\pop_print_view.cfm: line 1
 
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#"/>
287 : </cfif>
288 :
Resources:

Browser   Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address   3.137.188.200
Referrer  
Date/Time   07-Jul-24 02:03 PM
Stack Trace
at cfpop_print_view2ecfm1017774844._factor9(C:\inetpub\wwwroot\AmericanAssociates\pop_print_view.cfm:286) 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:286)
	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)