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` != '1975' AND `icn_hotels`.`booking_com_active` = '1' AND `icn_city_translate`.`languages_id` = '5' AND `icn_categories_translate`.`languages_id` = '5' AND TRUNCATE (6363 * sqrt(POW( RADIANS('35.512313') - RADIANS(icn_hotels.latitude), 2) + POW(RADIANS('23.976357') - RADIANS(icn_hotels.longitude), 2)), 3) < '50' ORDER BY `icn_hotels`.`stars` DESCArray ( [id] => 4399 [fullname] => Domus Renier Boutique Hotel [slug] => domus-renier-boutique-hotel [stars] => 5 [rooms] => 9 [latitude] => 35.51700700000 [longitude] => 24.01607300000 [commission] => 0 [booking_com_id] => 1745443 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2019-07-23 11:50:37 [district_id] => 0 [languages_id] => 0 [city_name] => Chania [categories_id] => 12 [categories_name] => Edificio histórico ) Array ( [id] => 4433 [fullname] => Domes Zeen Chania, a Luxury Collection Resort, Crete [slug] => casa-cook-chania [stars] => 5 [rooms] => 35 [latitude] => 35.51011700000 [longitude] => 23.99503000000 [commission] => 0 [booking_com_id] => 3485091 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2019-08-06 07:47:58 [district_id] => 0 [languages_id] => 0 [city_name] => Chania [categories_id] => 9 [categories_name] => Resort ) Array ( [id] => 5655 [fullname] => Asterion Suites & Spa - Designed for Adults [slug] => asterion-suites-and-spa-designed-for-adults [stars] => 5 [rooms] => 67 [latitude] => 35.52178300000 [longitude] => 23.86205300000 [commission] => 0 [booking_com_id] => 96071 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2023-07-08 15:25:24 [district_id] => 0 [languages_id] => 0 [city_name] => Gerani Chanion [categories_id] => 9 [categories_name] => Resort ) Array ( [id] => 2820 [fullname] => Amalthia Beach Resort [slug] => amalthia-beach-resort [stars] => 4 [rooms] => 68 [latitude] => 35.51984500000 [longitude] => 23.93445600000 [commission] => 18 [booking_com_id] => 45872 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2015-11-23 15:17:13 [district_id] => 0 [languages_id] => 2 [city_name] => Agia Marina Nea Kydonias [categories_id] => 9 [categories_name] => Resort ) Array ( [id] => 4365 [fullname] => Alcanea Boutique Hotel [slug] => alcanea-boutique-hotel [stars] => 4 [rooms] => 8 [latitude] => 35.51800900000 [longitude] => 24.01587500000 [commission] => 0 [booking_com_id] => 315410 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2019-07-17 12:14:20 [district_id] => 0 [languages_id] => 0 [city_name] => Chania [categories_id] => 12 [categories_name] => Edificio histórico ) Array ( [id] => 4374 [fullname] => Arcus Suites [slug] => arcus-suites [stars] => 4 [rooms] => 5 [latitude] => 35.28734700000 [longitude] => 24.33550500000 [commission] => 0 [booking_com_id] => 190281 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2019-07-17 14:40:50 [district_id] => 0 [languages_id] => 0 [city_name] => Rétino [categories_id] => 12 [categories_name] => Edificio histórico ) Array ( [id] => 3864 [fullname] => Conte Marino Villas [slug] => conte-marino-villas [stars] => 0 [rooms] => 1 [latitude] => 35.51033000000 [longitude] => 23.85434100000 [commission] => 0 [booking_com_id] => 882732 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2018-10-28 15:10:36 [district_id] => 0 [languages_id] => 0 [city_name] => Kondomárion [categories_id] => 5 [categories_name] => Villa ) Array ( [id] => 4391 [fullname] => Consolato Boutique [slug] => consolato-boutique [stars] => 0 [rooms] => 5 [latitude] => 35.51712800000 [longitude] => 24.01539200000 [commission] => 0 [booking_com_id] => 2225841 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2019-07-19 16:36:34 [district_id] => 0 [languages_id] => 0 [city_name] => Chania [categories_id] => 12 [categories_name] => Edificio histórico ) Hoteles de Lujo en Agioi Apostoloi - Hoteles con encanto y Spa

1 Hoteles con encanto y de Lujo Agioi Apostoloi


Hoteles en los alrededores

Domus Renier Boutique Hotel

Domus Renier Boutique Hotel

  • Edificio histórico,
  • Chania
  • -
  • Mapa (7.26 km)
9 Habitaciones

Ventajas
Domes Zeen Chania, a Luxury Collection Resort, Crete

Domes Zeen Chania, a Luxury Collection Resort, Crete

  • Resort,
  • Chania
  • -
  • Mapa (3.42 km)
35 Habitaciones

Ventajas
Asterion Suites & Spa - Designed for Adults

Asterion Suites & Spa - Designed for Adults

  • Resort,
  • Gerani Chanion
  • -
  • Mapa (20.80 km)
67 Habitaciones

Ventajas
Amalthia Beach Resort

Amalthia Beach Resort

  • Resort,
  • Agia Marina Nea Kydonias
  • -
  • Mapa (7.77 km)
Piscina al aire libre, Playa privada equipado, SPA Centro de Bienestar, Aparcamiento gratuito, Conexión internet Wi-Fi gratuito, 68 Habitaciones

Ventajas

Ventajas

Regístrate a "The Tower" el exclusivo Club dedicado para nuestros Clientes Privilegiados!


Alcanea Boutique Hotel

Alcanea Boutique Hotel

  • Edificio histórico,
  • Chania
  • -
  • Mapa (7.26 km)
8 Habitaciones

Ventajas
Arcus Suites

Arcus Suites

  • Edificio histórico,
  • Rétino
  • -
  • Mapa (82.11 km)
5 Habitaciones

Ventajas
Conte Marino Villas

Conte Marino Villas

  • Villa,
  • Kondomárion
  • -
  • Mapa (22.09 km)
1 Habitaciones

Ventajas
Consolato Boutique

Consolato Boutique

  • Edificio histórico,
  • Chania
  • -
  • Mapa (7.15 km)
5 Habitaciones

Ventajas