One of the most widely-told pieces of real estate wisdom is to buy the worst house in the best neighborhood.