here is one example of the "worst house" on the best street :D
In reality- if you can buy a house in very poor condition in a very good neighbourhood, you can possibly get a much better result (renovate it to match the surrounding houses) than by buying a very good house in a very bad...