The creepy derelict house has been put up for auction at a whopping figure despite being reported as in need of a complete renovation, with exposed pipes, low energy efficiency, and battered exterior