It was a classic case of the worst house in the best street, but there was a sought-after feature that made it such a hit with would-be buyers.