Well if you really want to drop in on Andy you could try Moss Cottage Hotel
Nottingham Road, RIPLEY, Derbyshire, DE5 3JT and say hello to Andy.
LOL
A little closer to Nottingham there is the Hoggs Head at Awsworth both the pubs I mentioned are on the Rainbow 1 bus route all you need to do is catch it from the Vic centre bus station.
Try the link below for closer lodgings just type in the postcode or city in location and you should find a lot of places to choose from.