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` != '1578' 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('36.55454') - RADIANS(icn_hotels.latitude), 2) + POW(RADIANS('29.125456') - RADIANS(icn_hotels.longitude), 2)), 3) < '40' ORDER BY `icn_hotels`.`stars` DESCArray ( [id] => 5441 [fullname] => Rixos Premium Göcek - Adult Only [slug] => rixos-premium-gocek-adult-only [stars] => 5 [rooms] => 192 [latitude] => 36.75877000000 [longitude] => 28.92990000000 [commission] => 0 [booking_com_id] => 889138 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2022-04-15 22:09:00 [district_id] => 0 [languages_id] => 0 [city_name] => Göcek [categories_id] => 9 [categories_name] => Resort ) Array ( [id] => 3962 [fullname] => D-Resort Gocek [slug] => d-resort-gocek [stars] => 0 [rooms] => 103 [latitude] => 36.75253000000 [longitude] => 28.94383000000 [commission] => 0 [booking_com_id] => 371437 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2018-12-10 10:22:04 [district_id] => 0 [languages_id] => 0 [city_name] => Göcek [categories_id] => 9 [categories_name] => Resort ) Hotel di Lusso a Ölüdeniz - Alberghi di Charme e Spa

1 Alberghi di Charme e di Lusso a Ölüdeniz


Alberghi nelle vicinanze

Rixos Premium Göcek - Adult Only

Rixos Premium Göcek - Adult Only

  • Resort,
  • Göcek
  • -
  • Mappa (57.27 km)
192 Camere

Vantaggi
D-Resort Gocek

D-Resort Gocek

  • Resort,
  • Göcek
  • -
  • Mappa (54.67 km)
103 Camere

Vantaggi