A pub known as "Sexiest Pub in Dumfries" since 2019.