A 'hidden gem' mansion with views of Durham Cathedral has been put on the market for £1.75m.