In practice, having lived a couple houses from one (as a renter), it's more a theoretical problem than a practical one.

Given that the two condos that sold near me (one next door, and one two doors away) went in the 300k-350k range, it doesn't seem to be depressing the property values much either.