Logo

Look & Book

Find your perfect hotel

  • from
  • Search by region Click here to enlarge map
  • Nominate a hotel

Our sponsors

Scotland Magazine is the bi-monthly magazine and online information source for all those who love this great nation. Filled with history, heritage and travel, Scotland Magazine brings the country to life wherever you live around the world. The publication has been the official media partner of the SHA for a number of years and includes coverage in every issue - including a special awards results bumper issue each April.

WINNER SELECT * FROM ( SELECT * FROM v2_Hotels LEFT JOIN v2_Winners ON ( hotel_id = winner_hotel AND winner_year = 2019 ) LEFT JOIN v2_Images ON hotel_id = img_hotel WHERE hotel_member = 'Yes' ORDER BY FIELD(winner_category, 'Scottish Hotel of the Year') DESC, FIELD(winner_awarded,'Scottish Hotel of the Year','National Winner','Regional Winner','Class Winner') ASC, hotel_name ASC, img_sort ASC ) as xxx WHERE winner_year = 2019 AND ( winner_awarded = 'National Winner' OR winner_awarded = 'Scottish Hotel of the Year' ) GROUP BY hotel_id ORDER BY FIELD(winner_category, 'Scottish Hotel of the Year') DESC, winner_category ASC, hotel_name ASC
ORTHER