One of the North-east's most historic properties has been put up for sale with a price tag of over £1.2million.