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` != '1231' 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('42.826411') - RADIANS(icn_hotels.latitude), 2) + POW(RADIANS('12.132443') - RADIANS(icn_hotels.longitude), 2)), 3) < '20' ORDER BY `icn_hotels`.`stars` DESCArray ( [id] => 1555 [fullname] => Locanda Palazzone [slug] => locanda-palazzone [stars] => 0 [rooms] => 7 [latitude] => 42.72863600000 [longitude] => 12.05946900000 [commission] => 15 [booking_com_id] => 298938 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2012-07-23 10:38:20 [district_id] => 0 [languages_id] => 1 [city_name] => Orvieto [categories_id] => 7 [categories_name] => Convento-monasterio-abadía ) Array ( [id] => 2866 [fullname] => Relais Borgo San Faustino [slug] => relais-borgo-san-faustino [stars] => 0 [rooms] => 13 [latitude] => 42.80278700000 [longitude] => 12.16649300000 [commission] => 18 [booking_com_id] => 279273 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2016-02-18 15:24:43 [district_id] => 0 [languages_id] => 1 [city_name] => Orvieto [categories_id] => 10 [categories_name] => Masía ) Array ( [id] => 4712 [fullname] => Castello di Titignano [slug] => castello-di-titignano [stars] => 0 [rooms] => 45 [latitude] => 42.75677600000 [longitude] => 12.28744600000 [commission] => 0 [booking_com_id] => 2884256 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2019-11-25 14:01:04 [district_id] => 0 [languages_id] => 0 [city_name] => Orvieto [categories_id] => 3 [categories_name] => Castillo-parador ) Array ( [id] => 4875 [fullname] => Altarocca Wine Resort [slug] => altarocca-wine-resort [stars] => 0 [rooms] => 30 [latitude] => 42.72398400000 [longitude] => 12.06141700000 [commission] => 0 [booking_com_id] => 265883 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2020-02-06 09:24:08 [district_id] => 0 [languages_id] => 0 [city_name] => Orvieto [categories_id] => 10 [categories_name] => Masía ) Hoteles de Lujo en Terni - Hoteles con encanto y Spa

1 Hoteles con encanto y de Lujo Terni


Hoteles en los alrededores

Locanda Palazzone

Locanda Palazzone

  • Convento-monasterio-abadía,
  • Orvieto
  • -
  • Mapa (24.79 km)
Piscina al aire libre, Restaurante con reservación, Aparcamiento gratuito, Conexión internet Wi-Fi gratuito, 7 Habitaciones

Ventajas
Relais Borgo San Faustino

Relais Borgo San Faustino

  • Masía,
  • Orvieto
  • -
  • Mapa (7.65 km)
Piscina al aire libre, Restaurante, SPA Centro de Bienestar, Mascotas permitidas, Aparcamiento gratuito, 13 Habitaciones

Ventajas
Castello di Titignano

Castello di Titignano

  • Castillo-parador,
  • Orvieto
  • -
  • Mapa (29.66 km)
  • 8
  • Puntuación basada en 2 comentario/s
45 Habitaciones

Ventajas
Altarocca Wine Resort

Altarocca Wine Resort

  • Masía,
  • Orvieto
  • -
  • Mapa (25.56 km)
30 Habitaciones

Ventajas