The derelict mansion was on the market for £5mil in 2021 but is now available at a bargain price, with the sellers calling it a "wonderful opportunity".