Has anybody ever heard of a landlord losing everything he owns including his primary residence where his children are raised and his family getting kicked to the street because they didn't install a banister correctly or there was a fire because of an outlet was not wired properly?!  

It's just like if someone is house buying and there is the best house on the street but also the highest price.

If they are modern and the rest of the home is nice it will probably not make a much difference.On a SFR it will impair the use of the yard space in the summer, that will put you in the same category as a corner lot.IMO a lot of major inner city roads are equal or worse than a freeway, because of ambulance and police cars, accelerating traffic and the occasional nonsense souped up car.I down own a property on a major street, so this is just my humble opinion.

I've also found that the rent in that particular building is lower than rent across the street. 

So potential tenants find the listing on some site, then they call the number and are prompted to enter in the street address.  

As to NNN, yes, loans are made, but on a different level, anchor stores, larger commercial or industrial properties with tenants wearing wall-street names.

I'm in Springville and there are 3 "duplexes" along our street.

Retired couple wanting to move to a single story home, closer to their church (which was in the neighborhood), and closer to their grandkids who live just down the street. 

Does your site have street frontage?

Add a vibrant color as an accent wall and the space will have much more appeal.