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` != '564' 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('46.774734') - RADIANS(icn_hotels.latitude), 2) + POW(RADIANS('2.983968') - RADIANS(icn_hotels.longitude), 2)), 3) < '40' ORDER BY `icn_hotels`.`stars` DESCArray ( [id] => 620 [fullname] => Château d'Ygrande [slug] => chateau-dygrande [stars] => 4 [rooms] => 6 [latitude] => 46.54759200000 [longitude] => 2.98022100000 [commission] => 15 [booking_com_id] => 53485 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 0000-00-00 00:00:00 [district_id] => 0 [languages_id] => 4 [city_name] => Ygrande [categories_id] => 3 [categories_name] => Castello ) Array ( [id] => 2186 [fullname] => Château de Clusors [slug] => chteau-de-clusors [stars] => 0 [rooms] => 2 [latitude] => 46.59339100000 [longitude] => 3.15536700000 [commission] => 0 [booking_com_id] => 416486 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2013-03-16 20:00:41 [district_id] => 0 [languages_id] => 4 [city_name] => Saint-Menoux [categories_id] => 3 [categories_name] => Castello ) Hotel di Lusso a Château-sur-Allier - Alberghi di Charme e Spa

1 Alberghi di Charme e di Lusso a Château-sur-Allier


Château de Saint Augustin

  • Castello,
  • Château-sur-Allier
  • -
  •  Mappa
Ristorante, Ristorante Gastronomico & Bistro, Ristorante su prenotazione, 5 Camere

Vantaggi

Alberghi nelle vicinanze

Château d'Ygrande

Château d'Ygrande

  • Castello,
  • Ygrande
  • -
  • Mappa (50.52 km)
Piscina Idromassaggio scoperta, Piscina scoperta, Ristorante su prenotazione, 6 Camere

Vantaggi
Château de Clusors

Château de Clusors

  • Castello,
  • Saint-Menoux
  • -
  • Mappa (48.06 km)
Piscina scoperta, 2 Camere

Vantaggi