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` != '2161' AND `icn_hotels`.`booking_com_active` = '1' AND `icn_city_translate`.`languages_id` = '3' AND `icn_categories_translate`.`languages_id` = '3' AND TRUNCATE (6363 * sqrt(POW( RADIANS('37.377108') - RADIANS(icn_hotels.latitude), 2) + POW(RADIANS('13.318914') - RADIANS(icn_hotels.longitude), 2)), 3) < '50' ORDER BY `icn_hotels`.`stars` DESCArray ( [id] => 1038 [fullname] => Verdura Resort, a Rocco Forte Hotel [slug] => verdura-resort [stars] => 5 [rooms] => 203 [latitude] => 37.46972400000 [longitude] => 13.19552400000 [commission] => 15 [booking_com_id] => 239237 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 0000-00-00 00:00:00 [district_id] => 0 [languages_id] => 1 [city_name] => Sciacca [categories_id] => 9 [categories_name] => Resort / Ferienanlage ) Array ( [id] => 3089 [fullname] => Hotel Villa Athena [slug] => hotel-villa-athena [stars] => 5 [rooms] => 27 [latitude] => 37.29248300000 [longitude] => 13.59010900000 [commission] => 18 [booking_com_id] => 88902 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2017-01-14 15:52:56 [district_id] => 0 [languages_id] => 1 [city_name] => Agrigento [categories_id] => 5 [categories_name] => Villa / Residenz ) Array ( [id] => 166 [fullname] => Foresteria Baglio Della Luna [slug] => baglio-della-luna [stars] => 4 [rooms] => 23 [latitude] => 37.27881000000 [longitude] => 13.57304800000 [commission] => 15 [booking_com_id] => 250032 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 0000-00-00 00:00:00 [district_id] => 0 [languages_id] => 1 [city_name] => Agrigento [categories_id] => 8 [categories_name] => Landgut / Gutshof ) Array ( [id] => 5497 [fullname] => Borgo delle Pietre [slug] => borgo-delle-pietre [stars] => 4 [rooms] => 7 [latitude] => 37.30452700000 [longitude] => 13.50694600000 [commission] => 0 [booking_com_id] => 7454857 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2022-08-03 10:22:46 [district_id] => 0 [languages_id] => 0 [city_name] => Porto Empedocle [categories_id] => 4 [categories_name] => Relais ) Array ( [id] => 4078 [fullname] => Alba Palace Hotel [slug] => alba-palace-hotel [stars] => 4 [rooms] => 18 [latitude] => 37.31405300000 [longitude] => 13.66032900000 [commission] => 0 [booking_com_id] => 2149279 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2019-01-30 21:59:01 [district_id] => 0 [languages_id] => 0 [city_name] => Favara [categories_id] => 12 [categories_name] => Historischer Palazzo ) Array ( [id] => 5500 [fullname] => Regina Bianca - Camere, Suite & Spa [slug] => regina-bianca-camere-suite-and-spa [stars] => 0 [rooms] => 4 [latitude] => 37.50869800000 [longitude] => 13.08202300000 [commission] => 0 [booking_com_id] => 7202819 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2022-08-04 11:00:26 [district_id] => 0 [languages_id] => 0 [city_name] => Sciacca [categories_id] => 4 [categories_name] => Relais ) Array ( [id] => 5367 [fullname] => Resort Borgo Giallonardo Wine Relais [slug] => resort-borgo-giallonardo-wine-relais [stars] => 0 [rooms] => 7 [latitude] => 37.31570400000 [longitude] => 13.43076500000 [commission] => 0 [booking_com_id] => 1131606 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2021-09-04 10:43:14 [district_id] => 0 [languages_id] => 0 [city_name] => Realmonte [categories_id] => 4 [categories_name] => Relais ) Array ( [id] => 5318 [fullname] => Rocco Forte Private Villas [slug] => rocco-forte-private-villas [stars] => 0 [rooms] => 20 [latitude] => 37.46698200000 [longitude] => 13.19736700000 [commission] => 0 [booking_com_id] => 6958406 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2021-04-23 10:00:56 [district_id] => 0 [languages_id] => 0 [city_name] => Sciacca [categories_id] => 5 [categories_name] => Villa / Residenz ) Array ( [id] => 5116 [fullname] => Oikos in Terre di Zaccanello [slug] => oikos-in-terre-di-zaccanello [stars] => 0 [rooms] => 6 [latitude] => 37.38204600000 [longitude] => 13.72376300000 [commission] => 0 [booking_com_id] => 5162561 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2020-10-08 15:10:56 [district_id] => 0 [languages_id] => 0 [city_name] => Racalmuto [categories_id] => 10 [categories_name] => Country House / Landsitz ) Array ( [id] => 4997 [fullname] => Resort Fontes Episcopi [slug] => resort-fontes-episcopi [stars] => 0 [rooms] => 7 [latitude] => 37.38535000000 [longitude] => 13.61729900000 [commission] => 0 [booking_com_id] => 1729676 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2020-07-18 19:09:49 [district_id] => 0 [languages_id] => 0 [city_name] => Aragona [categories_id] => 9 [categories_name] => Resort / Ferienanlage ) Array ( [id] => 4754 [fullname] => Le Maestranze Deluxe Rooms [slug] => le-maestranze-deluxe-rooms [stars] => 0 [rooms] => 6 [latitude] => 37.50731900000 [longitude] => 13.08173200000 [commission] => 0 [booking_com_id] => 4349890 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2019-11-30 15:32:50 [district_id] => 0 [languages_id] => 0 [city_name] => Sciacca [categories_id] => 12 [categories_name] => Historischer Palazzo ) Array ( [id] => 4529 [fullname] => Diodorus Luxury Experience [slug] => diodorus-luxury-experience [stars] => 0 [rooms] => 6 [latitude] => 37.29994900000 [longitude] => 13.64201500000 [commission] => 0 [booking_com_id] => 4523238 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2019-09-12 10:19:18 [district_id] => 0 [languages_id] => 0 [city_name] => Favara [categories_id] => 5 [categories_name] => Villa / Residenz ) Array ( [id] => 4517 [fullname] => Kete Deluxe Rooms [slug] => kete-deluxe-rooms [stars] => 0 [rooms] => 4 [latitude] => 37.17796900000 [longitude] => 13.71788900000 [commission] => 0 [booking_com_id] => 2225678 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2019-09-08 22:46:19 [district_id] => 0 [languages_id] => 0 [city_name] => Palma di Montechiaro [categories_id] => 4 [categories_name] => Relais ) Array ( [id] => 3667 [fullname] => Domus Maris Relais Boutique Hotel [slug] => domus-maris-relais-boutique-hotel [stars] => 0 [rooms] => 6 [latitude] => 37.50621400000 [longitude] => 13.08312400000 [commission] => 0 [booking_com_id] => 2349636 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2018-05-07 23:39:29 [district_id] => 0 [languages_id] => 0 [city_name] => Sciacca [categories_id] => 4 [categories_name] => Relais ) Array ( [id] => 3553 [fullname] => Masseria Agnello [slug] => masseria-agnello [stars] => 0 [rooms] => 10 [latitude] => 37.32695300000 [longitude] => 13.46096600000 [commission] => 20 [booking_com_id] => 1320902 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2018-01-09 20:50:42 [district_id] => 0 [languages_id] => 1 [city_name] => Realmonte [categories_id] => 8 [categories_name] => Landgut / Gutshof ) Array ( [id] => 2996 [fullname] => Tonnara di Sciacca [slug] => tonnara-di-sciacca [stars] => 0 [rooms] => 6 [latitude] => 37.50436800000 [longitude] => 13.05468100000 [commission] => 20 [booking_com_id] => 1868422 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2016-11-16 09:53:54 [district_id] => 0 [languages_id] => 1 [city_name] => Sciacca [categories_id] => 4 [categories_name] => Relais ) Array ( [id] => 1175 [fullname] => Abbazia Santa Maria del Bosco [slug] => abbazia-santa-maria-del-bosco [stars] => 0 [rooms] => 12 [latitude] => 37.71200900000 [longitude] => 13.20524500000 [commission] => 20 [booking_com_id] => 1223378 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2010-05-25 10:24:26 [district_id] => 0 [languages_id] => 1 [city_name] => Contessa Entellina [categories_id] => 7 [categories_name] => Kloster / Abtei ) Luxus-Hotels in Siculiana - Charme Hotels und Spa

1 Charme und Luxus-Hotels Siculiana



Hotels in der Umgebung

Verdura Resort, a Rocco Forte Hotel

  • Resort / Ferienanlage,
  • Sciacca
  • -
  • Karte (29.99 km)
  • 9.6
  • Ergebnis aus 47 Bewertung/en
Freiluftpool, Golf 18 Loch, Pool mit Hydromassage im Freien, PrivatStrand mit Liegestühlen, Restaurant, SPA WellnessCentre, Überdachter Pool, Kostenlose Parkplätze, Free WiFi, 203 Zimmern

Vorteile

Hotel Villa Athena

  • Villa / Residenz,
  • Agrigento
  • -
  • Karte (51.51 km)
  • 10
  • Ergebnis aus 2 Bewertung/en
Freiluftpool, Restaurant, SPA WellnessCentre, Haustiere erlaubt, Kostenlose Parkplätze, Free WiFi, 27 Zimmern

Vorteile

Foresteria Baglio Della Luna

  • Landgut / Gutshof,
  • Agrigento
  • -
  • Karte (49.98 km)
  • 7.9
  • Ergebnis aus 18 Bewertung/en
Restaurant, Kostenlose Parkplätze, Free WiFi, 23 Zimmern

Vorteile

Borgo delle Pietre

  • Relais,
  • Porto Empedocle
  • -
  • Karte (36.96 km)
7 Zimmern

Vorteile

Vorteile

Schreiben Sie sich in den "The Tower" Club ein dem exklusiven Programm für unsere privilegierten Kunden, sammeln Sie Punkte und Sie erhalten Gratis-Nächte !

Alba Palace Hotel

  • Historischer Palazzo,
  • Favara
  • -
  • Karte (61.97 km)
Restaurant, 18 Zimmern

Vorteile

Regina Bianca - Camere, Suite & Spa

  • Relais,
  • Sciacca
  • -
  • Karte (51.05 km)
4 Zimmern

Vorteile

Resort Borgo Giallonardo Wine Relais

  • Relais,
  • Realmonte
  • -
  • Karte (24.03 km)
7 Zimmern

Vorteile

Rocco Forte Private Villas

  • Villa / Residenz,
  • Sciacca
  • -
  • Karte (29.33 km)
20 Zimmern

Vorteile

Oikos in Terre di Zaccanello

  • Country House / Landsitz,
  • Racalmuto
  • -
  • Karte (71.55 km)
6 Zimmern

Vorteile

Vorteile

Schreiben Sie sich in den "The Tower" Club ein dem exklusiven Programm für unsere privilegierten Kunden, sammeln Sie Punkte und Sie erhalten Gratis-Nächte !

Resort Fontes Episcopi

  • Resort / Ferienanlage,
  • Aragona
  • -
  • Karte (52.76 km)
  • 10
  • Ergebnis aus 1 Bewertung/en
7 Zimmern

Vorteile

Le Maestranze Deluxe Rooms

  • Historischer Palazzo,
  • Sciacca
  • -
  • Karte (50.92 km)
6 Zimmern

Vorteile

Diodorus Luxury Experience

  • Villa / Residenz,
  • Favara
  • -
  • Karte (59.65 km)
6 Zimmern

Vorteile

Kete Deluxe Rooms

  • Relais,
  • Palma di Montechiaro
  • -
  • Karte (83.34 km)
  • 10
  • Ergebnis aus 1 Bewertung/en
4 Zimmern

Vorteile

Domus Maris Relais Boutique Hotel

  • Relais,
  • Sciacca
  • -
  • Karte (50.57 km)
6 Zimmern

Vorteile

Vorteile

Schreiben Sie sich in den "The Tower" Club ein dem exklusiven Programm für unsere privilegierten Kunden, sammeln Sie Punkte und Sie erhalten Gratis-Nächte !

Masseria Agnello

  • Landgut / Gutshof,
  • Realmonte
  • -
  • Karte (27.48 km)
Freiluftpool, Restaurant, Haustiere erlaubt, Kostenlose Parkplätze, Free WiFi, 10 Zimmern

Vorteile

Tonnara di Sciacca

  • Relais,
  • Sciacca
  • -
  • Karte (54.57 km)
6 Zimmern

Vorteile

Abbazia Santa Maria del Bosco

  • Kloster / Abtei,
  • Contessa Entellina
  • -
  • Karte (77.13 km)
  • 10
  • Ergebnis aus 1 Bewertung/en
Freiluftpool, Restaurant, Kostenlose Parkplätze, Free WiFi, 12 Zimmern

Vorteile