There is a hotel called Purdys just on the A1 at the end of the road that leads to Bambrough castle. The price is reasonable. Last time we went there they only had a room for one night and we wanted two, so they upgraded us to the on site cottage at no extra cost. They made it sound as though we would be doing them a favour.