Stay away from house on main road??

[Eric Schuster]

There's a house on the "main road" that I'm interested in, but my realtor says we should look for one not on the main road. 

The house is in a very desirable neighborhood because of the school district. The house is listed for 130k, foreclosure. Houses that are further in the neighborhood, comparable size, are 230k.

I plan on buying and renting it out for a long-term buy-and-hold strategy. But I'm brand new to this and don't know what I'm doing. Do renters refuse to rent houses on the main road even if it's a desirable neighborhood?