When it comes to property investment, the classic advice of buying the worst house on the best street has stood the test of time.