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?

[Russell Holmes]

Another small detail that can make a large difference in usability: can one turn around in the driveway or is there a horseshoe or loop driveway? In my area there are lots of houses that, when built, were likely on small rural roads. Those roads have since widened and now access whole neighborhoods and expansion. The ones with enough room to pull in forward, turn around at some point, and pull out forward seem fine. They all seem to fence the back and use the front yard only for parking and access. If the driveway is short and forces people to back on to a main road, I'd pass it up