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` != '2150' AND `icn_hotels`.`booking_com_active` = '1' AND `icn_city_translate`.`languages_id` = '1' AND `icn_categories_translate`.`languages_id` = '1' AND TRUNCATE (6363 * sqrt(POW( RADIANS('38.248492') - RADIANS(icn_hotels.latitude), 2) + POW(RADIANS('26.384035') - RADIANS(icn_hotels.longitude), 2)), 3) < '40' ORDER BY `icn_hotels`.`stars` DESCArray ( [id] => 5440 [fullname] => Reges, a Luxury Collection Resort & Spa, Cesme [slug] => reges-a-luxury-collection-resort-and-spa-cesme [stars] => 5 [rooms] => 104 [latitude] => 38.32790800000 [longitude] => 26.32162800000 [commission] => 0 [booking_com_id] => 5204683 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2022-04-15 22:03:06 [district_id] => 0 [languages_id] => 0 [city_name] => Çeşme [categories_id] => 9 [categories_name] => Resort ) Hotel di Lusso a Alaçatı - Alberghi di Charme e Spa

1 Alberghi di Charme e di Lusso a Alaçatı


Alberghi nelle vicinanze

Reges, a Luxury Collection Resort & Spa, Cesme

Reges, a Luxury Collection Resort & Spa, Cesme

  • Resort,
  • Çeşme
  • -
  • Mappa (20.75 km)
104 Camere

Vantaggi