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` != '2076' AND `icn_hotels`.`booking_com_active` = '1' AND `icn_city_translate`.`languages_id` = '2' AND `icn_categories_translate`.`languages_id` = '2' AND TRUNCATE (6363 * sqrt(POW( RADIANS('45.84287') - RADIANS(icn_hotels.latitude), 2) + POW(RADIANS('9.666664') - RADIANS(icn_hotels.longitude), 2)), 3) < '30' ORDER BY `icn_hotels`.`stars` DESCArray ( [id] => 1171 [fullname] => GombitHotel [slug] => gombithotel [stars] => 4 [rooms] => 13 [latitude] => 45.70369500000 [longitude] => 9.66381400000 [commission] => 15 [booking_com_id] => 244942 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2010-05-21 09:59:29 [district_id] => 0 [languages_id] => 1 [city_name] => Bergamo [categories_id] => 3 [categories_name] => Castle ) Array ( [id] => 3794 [fullname] => Relais San Vigilio al Castello [slug] => relais-san-vigilio-al-castello [stars] => 4 [rooms] => 9 [latitude] => 45.70910100000 [longitude] => 9.65137500000 [commission] => 18 [booking_com_id] => 3730054 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2018-08-01 09:56:27 [district_id] => 0 [languages_id] => 1 [city_name] => Bergamo [categories_id] => 4 [categories_name] => Relais ) Array ( [id] => 4858 [fullname] => Piajo Relax Hotel [slug] => piajo-relax-hotel [stars] => 4 [rooms] => 45 [latitude] => 45.74848700000 [longitude] => 9.75320900000 [commission] => 0 [booking_com_id] => 84635 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2020-01-23 20:02:33 [district_id] => 0 [languages_id] => 0 [city_name] => Nembro [categories_id] => 4 [categories_name] => Relais ) Array ( [id] => 4483 [fullname] => Locanda Osteria Marascia [slug] => locanda-osteria-marascia [stars] => 0 [rooms] => 5 [latitude] => 45.79089500000 [longitude] => 9.43139500000 [commission] => 0 [booking_com_id] => 771858 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2019-08-22 09:14:29 [district_id] => 0 [languages_id] => 0 [city_name] => Calolziocorte - Lake of Como [categories_id] => 12 [categories_name] => Historical building ) Array ( [id] => 4859 [fullname] => La Ripa Boutique Hotel [slug] => la-ripa-boutique-hotel [stars] => 0 [rooms] => 12 [latitude] => 45.76496400000 [longitude] => 9.80254700000 [commission] => 0 [booking_com_id] => 1480552 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2020-01-23 20:03:23 [district_id] => 0 [languages_id] => 0 [city_name] => Albino [categories_id] => 12 [categories_name] => Historical building ) Luxury Hotels in San Pellegrino Terme - Charming Hotels and Spa

1 Charming and Luxury Hotels in San Pellegrino Terme


Hotels in the surroundings

GombitHotel

GombitHotel

13 Rooms

Benefits
Relais San Vigilio al Castello

Relais San Vigilio al Castello

  • 10
  • Score from 1 review/s
Restaurant, Free WiFi Internet, 9 Rooms

Benefits
Piajo Relax Hotel

Piajo Relax Hotel

45 Rooms

Benefits
Locanda Osteria Marascia

Locanda Osteria Marascia

  • Historical building,
  • Calolziocorte - Lake of Como
  • -
  • Location Map (38.25 km)
5 Rooms

Benefits

Benefits

Join "The Tower" the Exclusive Club dedicated to our preferred guests, earn points and get free nights!


La Ripa Boutique Hotel

La Ripa Boutique Hotel

12 Rooms

Benefits