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` != '1877' AND `icn_hotels`.`booking_com_active` = '1' AND `icn_city_translate`.`languages_id` = '4' AND `icn_categories_translate`.`languages_id` = '4' AND TRUNCATE (6363 * sqrt(POW( RADIANS('44.0098095') - RADIANS(icn_hotels.latitude), 2) + POW(RADIANS('8.173253') - RADIANS(icn_hotels.longitude), 2)), 3) < '40' ORDER BY `icn_hotels`.`stars` DESCArray ( [id] => 1852 [fullname] => La Meridiana Relais & Chateaux [slug] => la-meridiana-relais-chateaux [stars] => 5 [rooms] => 25 [latitude] => 44.03114400000 [longitude] => 8.11465300000 [commission] => 0 [booking_com_id] => 368975 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2013-02-04 12:59:28 [district_id] => 0 [languages_id] => 1 [city_name] => Garlenda [categories_id] => 9 [categories_name] => Resort ) Array ( [id] => 1212 [fullname] => Hotel Riviera dei Fiori [slug] => hotel-riviera-dei-fiori [stars] => 4 [rooms] => 40 [latitude] => 43.86043200000 [longitude] => 7.96950800000 [commission] => 15 [booking_com_id] => 257109 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2010-11-23 09:14:03 [district_id] => 0 [languages_id] => 1 [city_name] => San Lorenzo al Mare [categories_id] => 9 [categories_name] => Resort ) Array ( [id] => 1213 [fullname] => Aregai Marina Hotel & Residence [slug] => aregai-marina-hotel-residence [stars] => 4 [rooms] => 106 [latitude] => 43.84060000000 [longitude] => 7.91399200000 [commission] => 15 [booking_com_id] => 88217 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2010-11-23 09:30:09 [district_id] => 0 [languages_id] => 1 [city_name] => Santo Stefano Al Mare [categories_id] => 9 [categories_name] => Resort ) Array ( [id] => 3556 [fullname] => Relais Del Maro [slug] => relais-del-maro [stars] => 0 [rooms] => 14 [latitude] => 43.97560600000 [longitude] => 7.94592000000 [commission] => 0 [booking_com_id] => 400531 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2018-01-10 15:21:39 [district_id] => 0 [languages_id] => 0 [city_name] => Borgomaro [categories_id] => 4 [categories_name] => Relais ) Array ( [id] => 4862 [fullname] => Locanda Fra Diavolo [slug] => locanda-fra-diavolo [stars] => 0 [rooms] => 8 [latitude] => 43.91029000000 [longitude] => 8.08515800000 [commission] => 0 [booking_com_id] => 1916926 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2020-01-24 13:32:38 [district_id] => 0 [languages_id] => 0 [city_name] => Diano Marina [categories_id] => 12 [categories_name] => Demeure historique ) Hôtels de luxe à Alassio - Hôtels de charme avec Spa

2 Hotels de Charme et de Luxe à Alassio


Hôtels dans les environs

Castellaro Golf Resort

Castellaro Golf Resort

  • Resort,
  • Castellaro
  • -
  • Carte (58.47 km)
  • 8
  • Note sur 1 commentaire/s

Privilèges
La Meridiana Relais & Chateaux

La Meridiana Relais & Chateaux

  • Resort,
  • Garlenda
  • -
  • Carte (10.50 km)
Golf, Piscine en plein air, 25 Chambres

Privilèges
Hotel Riviera dei Fiori

Hotel Riviera dei Fiori

  • Resort,
  • San Lorenzo al Mare
  • -
  • Carte (46.56 km)
  • 7
  • Note sur 2 commentaire/s
Restaurant, Spa centre bienêtre, Animaux acceptés, 40 Chambres

Privilèges
Aregai Marina Hotel & Residence

Aregai Marina Hotel & Residence

  • Resort,
  • Santo Stefano Al Mare
  • -
  • Carte (56.04 km)
  • 6
  • Note sur 1 commentaire/s
Plage privée equipée, Restaurant, 106 Chambres

Privilèges

Privilèges

Entrez dans notre Club"The Tower"le programme exclusif dédié à nos clients privilégiés, accumulez vos points et vous recevrez des nuits gratuites !


Relais Del Maro

Relais Del Maro

  • Relais,
  • Borgomaro
  • -
  • Carte (37.16 km)
14 Chambres

Privilèges
Locanda Fra Diavolo

Locanda Fra Diavolo

  • Demeure historique,
  • Diano Marina
  • -
  • Carte (26.24 km)
Restaurant, 8 Chambres

Privilèges