Flat's incredible! Magnificent mansion is on sale in Yorkshire for less ...