The Duke on The Test in Romsey has been honoured with a prestigious ROSE Award by VisitEngland.