An "impressive" detached double-fronted property with three workshops is on the market in the village of Hayton, near ...