SELECT `icn_hotels`.`id` AS `id`, `icn_hotels`.`fullname` AS `fullname`, `icn_hotels`.`slug` AS `slug`, `icn_hotels`.`stars` AS `stars`, `icn_hotels`.`rooms` AS `rooms`, `icn_hotels`.`latitude` AS `latitude`, `icn_hotels`.`longitude` AS `longitude`, `icn_hotels`.`commission` AS `commission`, `icn_hotels`.`booking_com_id` AS `booking_com_id`, `icn_hotels`.`booking_com_type_thumbnail` AS `booking_com_type_thumbnail`, `icn_hotels`.`booking_com_active` AS `booking_com_active`, `icn_hotels`.`publication_date` AS `publication_date`, `icn_hotels`.`district_id` AS `district_id`, `icn_hotels`.`languages_id` AS `languages_id`, `icn_city_translate`.`fullname` AS `city_name`, `icn_categories_translate`.`categories_id` AS `categories_id`, `icn_categories_translate`.`fullname` AS `categories_name` FROM `icn_hotels` LEFT JOIN `icn_city_translate` ON `icn_city_translate`.`city_id` = `icn_hotels`.`city_id` LEFT JOIN `icn_categories_translate` ON `icn_categories_translate`.`categories_id` = `icn_hotels`.`categories_id` WHERE `icn_hotels`.`active` = '1' AND `icn_hotels`.`show_booking` = '1' AND `icn_hotels`.`city_id` != '1532' AND `icn_hotels`.`booking_com_active` = '1' AND `icn_city_translate`.`languages_id` = '2' AND `icn_categories_translate`.`languages_id` = '2' AND TRUNCATE (6363 * sqrt(POW( RADIANS('38.743977666667') - RADIANS(icn_hotels.latitude), 2) + POW(RADIANS('8.1971375') - RADIANS(icn_hotels.longitude), 2)), 3) < '50' ORDER BY `icn_hotels`.`stars` DESCArray ( [id] => 1406 [fullname] => Hotel Riviera [slug] => hotel-riviera [stars] => 4 [rooms] => 43 [latitude] => 39.14336300000 [longitude] => 8.30723900000 [commission] => 20 [booking_com_id] => 85191 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2012-04-15 18:07:48 [district_id] => 0 [languages_id] => 1 [city_name] => Carloforte [categories_id] => 12 [categories_name] => Historical building ) Luxury Hotels in St. Moritz - Charming Hotels and Spa

6 Charming and Luxury Hotels in St. Moritz


Hotels in the surroundings

Hotel Riviera

Hotel Riviera

Restaurant, Pets Friendly, Free parking, Free WiFi Internet, 43 Rooms

Benefits