My Office Location:
American Associates

,
 
Listings Presented by:
Randy Haney
Call: 810-691-4124
Fax: 888-696-4544
Office: 810-733-3435
497 W TROY STREET
FERNDALE, MI. 48220
$445,000
4 Beds 4 Baths 1,865 Sq Ft
Schools: Ferndale 0.12 Acres Year Built: 1927
Property Description
Beautifully renovated home just a block away from bustling downtown Ferndale. This home had a full renovation in 2015 down to the studs. All woodwork is upgraded to larger crown, larger base & trim molding, solid core doors, thicker handrails, etc. Kitchen has SS GE Café series appliances, white shaker cabinets, and granite counters. The living room has a brand new custom built fireplace mantle with storage cabinets on each side. The second floor has 10 ft vaulted ceilings, 3 bedrooms with ceiling fans, and 2 full baths. Primary bedroom has a huge walk-in closet w/ exposed brick, and a massive (3.5 x 8.5 ft) shower with 3 shower heads, 2 body sprays, a side window, and a skylight. The other 2nd floor bedrooms offer custom Martha Stewart brand built-in closets with drawers. There is also a 4th bedroom/office on the first floor. Basement is finished with a full bathroom, main room, laundry room, and a pub room with built-in wet bar / beer tap. Basement did NOT flood in the great flood 8 years ago. 2 new high efficiency furnaces and 2 air conditioners, one set for each floor, allows for significant savings - as you only need to condition 1 floor at a time depending on time of day. New BAT insulation on the first floor, and closed cell spray foam insulation upstairs. (Open cell for the hot roof) Electrical box has been updated to a 200 amp service. This home has so many amenities, and is close enough to walk to the grocery store, and many restaurants on 9 mile. Come see it today! Seller is a licensed agent. Exclusions include family room curtains, shed, and children's playset in backyard. Shed and playset may be negotiable.
Features
Baths: 3 full, 1 half
Style: Colonial
Subdivision: TENNYSON PARK SUB
Construction: Vinyl
Exterior: Vinyl
Exterior Misc: Chimney Cap(s),ENERGY STAR® Qualified Skylights,Gutter Guard System,Lighting,Fenced
Porchs: Deck,Porch
Fireplaces: 1
Fireplace Description: Natural
Garage: 1.5 Car
Garage Description: Electricity,Door Opener,Detached
Basement: Yes
Basement Description: Partially Finished
Appliances: Convection Oven,Dishwasher,Disposal,Double Oven,Dryer,ENERGY STAR® qualified dishwasher,ENERGY STAR® qualified refrigerator,Free-Standing Gas Range,Gas Cooktop,Microwave,Stainless Steel Appliance(s),Washer
Cooling: Ceiling Fan(s),Central Air
Heating: Forced Air
Fuel: Natural Gas
Waste: Public Sewer (Sewer-Sanitary),Sewer at Street
Watersource: Public (Municipal)
Foundation : Basement
Special Features
100 Amp Service,Circuit Breakers,Furnished - No,High Spd Internet Avail,Programmable Thermostat,Wet Bar,Cable Available,ENERGY STAR® Qualified Window(s)
Tax, Fees & Legal
Home warranty: No
Land Contract: No
Est. Summer Taxes: $7,733
Est. Winter Taxes: $266
County: Oakland
Month Lease:
Legal Description: T1N, R11E, SEC 34 TENNYSON PARK SUB LOT 20
    
Rooms
Bedroom 1:
Bedroom 2 :
Bedroom 3:
Bedroom 4:
Family Room:
Greatroom:
Dinning Room:
Kitchen:
Livingroom:
Lot Details
Acres: 0.12
Lot Dimensions: 47 x 114 x 47 x 114
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 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.147.57.161
Referrer  
Date/Time   01-Jul-24 05:41 AM
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)