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` != '910' 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('47.421441') - RADIANS(icn_hotels.latitude), 2) + POW(RADIANS('0.891333') - RADIANS(icn_hotels.longitude), 2)), 3) < '10' ORDER BY `icn_hotels`.`stars` DESCArray ( [id] => 775 [fullname] => Château De La Bourdaisière [slug] => chateau-de-la-bourdaisiere [stars] => 3 [rooms] => 29 [latitude] => 47.36982600000 [longitude] => 0.83853600000 [commission] => 15 [booking_com_id] => 53797 [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] => Montlouis-sur-Loire [categories_id] => 3 [categories_name] => Château ) Array ( [id] => 901 [fullname] => Chateau de Jallanges [slug] => chateau-de-jallanges [stars] => 0 [rooms] => 5 [latitude] => 47.44446700000 [longitude] => 0.82987000000 [commission] => 12 [booking_com_id] => 297422 [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] => Vernou-Sur-Brenne [categories_id] => 3 [categories_name] => Château ) Hôtels de luxe à Noizay - Hôtels de charme avec Spa

1 Hotels de Charme et de Luxe à Noizay


Hôtels dans les environs

Château De La Bourdaisière

Château De La Bourdaisière

  • Château,
  • Montlouis-sur-Loire
  • -
  • Carte (13.96 km)
  • 9
  • Note sur 4 commentaire/s
Piscine en plein air, Restaurant, Animaux acceptés, Parking gratuit, Connexion Internet WiFi gratuit, 29 Chambres

Privilèges
Chateau de Jallanges

Chateau de Jallanges

  • Château,
  • Vernou-Sur-Brenne
  • -
  • Carte (10.57 km)
  • 9.5
  • Note sur 4 commentaire/s
Golf, Piscine en plein air, 5 Chambres

Privilèges