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` != '2059' 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('43.5863395') - RADIANS(icn_hotels.latitude), 2) + POW(RADIANS('11.29784') - RADIANS(icn_hotels.longitude), 2)), 3) < '40' ORDER BY `icn_hotels`.`stars` DESCArray ( [id] => 147 [fullname] => Castello di Spaltenna Exclusive Resort & Spa [slug] => castello-di-spaltenna [stars] => 5 [rooms] => 37 [latitude] => 43.46558200000 [longitude] => 11.42996500000 [commission] => 15 [booking_com_id] => 16586 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 0000-00-00 00:00:00 [district_id] => 0 [languages_id] => 1 [city_name] => Gaiole in Chianti [categories_id] => 3 [categories_name] => Castle ) Array ( [id] => 5110 [fullname] => Villa La Massa [slug] => villa-la-massa [stars] => 5 [rooms] => 51 [latitude] => 43.76479500000 [longitude] => 11.33407100000 [commission] => 0 [booking_com_id] => 322864 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2020-10-08 11:56:12 [district_id] => 0 [languages_id] => 0 [city_name] => Bagno a Ripoli [categories_id] => 5 [categories_name] => Villa ) Array ( [id] => 4794 [fullname] => Golden Tower Hotel & Spa [slug] => golden-tower-hotel-and-spa [stars] => 5 [rooms] => 30 [latitude] => 43.77085700000 [longitude] => 11.25208100000 [commission] => 0 [booking_com_id] => 49960 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2019-12-05 17:31:56 [district_id] => 0 [languages_id] => 0 [city_name] => Florence [categories_id] => 12 [categories_name] => Historical building ) Array ( [id] => 5420 [fullname] => Agri Resort & SPA Le Colline del Paradiso [slug] => agri-resort-and-spa-le-colline-del-paradiso [stars] => 5 [rooms] => 10 [latitude] => 43.88551200000 [longitude] => 11.31959400000 [commission] => 0 [booking_com_id] => 4777573 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2022-03-03 10:40:28 [district_id] => 0 [languages_id] => 0 [city_name] => Vaglia [categories_id] => 4 [categories_name] => Relais ) Array ( [id] => 5524 [fullname] => Ville Sull'Arno [slug] => ville-sullarno [stars] => 5 [rooms] => 45 [latitude] => 43.76594900000 [longitude] => 11.28457900000 [commission] => 0 [booking_com_id] => 80077 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2022-09-17 19:02:31 [district_id] => 0 [languages_id] => 0 [city_name] => Florence [categories_id] => 9 [categories_name] => Resort ) Array ( [id] => 230 [fullname] => Rocco Forte Hotel Savoy [slug] => hotel-savoy [stars] => 5 [rooms] => 102 [latitude] => 43.77183900000 [longitude] => 11.25444700000 [commission] => 12 [booking_com_id] => 187251 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 0000-00-00 00:00:00 [district_id] => 0 [languages_id] => 1 [city_name] => Florence [categories_id] => 12 [categories_name] => Historical building ) Array ( [id] => 5525 [fullname] => Helvetia&Bristol Firenze – Starhotels Collezione [slug] => helvetiaandbristol-firenze-starhotels-collezione [stars] => 5 [rooms] => 89 [latitude] => 43.77190200000 [longitude] => 11.25219900000 [commission] => 0 [booking_com_id] => 14907 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2022-09-17 19:03:58 [district_id] => 0 [languages_id] => 0 [city_name] => Florence [categories_id] => 12 [categories_name] => Historical building ) Array ( [id] => 5526 [fullname] => Four Seasons Hotel Firenze [slug] => four-seasons-hotel-firenze [stars] => 5 [rooms] => 116 [latitude] => 43.77701700000 [longitude] => 11.26636500000 [commission] => 0 [booking_com_id] => 453635 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2022-09-17 19:05:44 [district_id] => 0 [languages_id] => 0 [city_name] => Florence [categories_id] => 12 [categories_name] => Historical building ) Array ( [id] => 163 [fullname] => COMO Castello Del Nero [slug] => castello-del-nero-hotel-spa [stars] => 5 [rooms] => 50 [latitude] => 43.55236100000 [longitude] => 11.18759900000 [commission] => 15 [booking_com_id] => 252550 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 0000-00-00 00:00:00 [district_id] => 0 [languages_id] => 1 [city_name] => Tavarnelle Val di Pesa [categories_id] => 3 [categories_name] => Castle ) Array ( [id] => 5527 [fullname] => Dimora Palanca [slug] => dimora-palanca [stars] => 5 [rooms] => 19 [latitude] => 43.77823500000 [longitude] => 11.24189800000 [commission] => 0 [booking_com_id] => 7364746 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2022-09-17 19:07:08 [district_id] => 0 [languages_id] => 0 [city_name] => Florence [categories_id] => 12 [categories_name] => Historical building ) Array ( [id] => 3231 [fullname] => Villa San Michele, A Belmond Hotel, Florence [slug] => belmond-villa-san-michele [stars] => 5 [rooms] => 46 [latitude] => 43.80276100000 [longitude] => 11.29719600000 [commission] => 0 [booking_com_id] => 480115 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2017-05-24 15:33:21 [district_id] => 0 [languages_id] => 0 [city_name] => Florence [categories_id] => 5 [categories_name] => Villa ) Array ( [id] => 2966 [fullname] => NH Collection Firenze Porta Rossa [slug] => nh-collection-firenze-porta-rossa [stars] => 5 [rooms] => 70 [latitude] => 43.77025900000 [longitude] => 11.25202900000 [commission] => 0 [booking_com_id] => 236708 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2016-09-23 23:40:26 [district_id] => 0 [languages_id] => 0 [city_name] => Florence [categories_id] => 12 [categories_name] => Historical building ) Array ( [id] => 81 [fullname] => Relais Santa Croce by Baglioni Hotels [slug] => relais-santa-croce-by-baglioni-hotels [stars] => 5 [rooms] => 24 [latitude] => 43.76998700000 [longitude] => 11.26224000000 [commission] => 15 [booking_com_id] => 83355 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 0000-00-00 00:00:00 [district_id] => 0 [languages_id] => 1 [city_name] => Florence [categories_id] => 12 [categories_name] => Historical building ) Array ( [id] => 1930 [fullname] => Il Salviatino [slug] => il-salviatino [stars] => 5 [rooms] => 45 [latitude] => 43.78672800000 [longitude] => 11.29593300000 [commission] => 10 [booking_com_id] => 49957 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2013-02-05 16:10:51 [district_id] => 0 [languages_id] => 1 [city_name] => Florence [categories_id] => 5 [categories_name] => Villa ) Array ( [id] => 1928 [fullname] => The Place Firenze [slug] => jk-place-firenze [stars] => 5 [rooms] => 20 [latitude] => 43.77302700000 [longitude] => 11.24976900000 [commission] => 0 [booking_com_id] => 186384 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2013-02-05 16:09:03 [district_id] => 0 [languages_id] => 1 [city_name] => Florence [categories_id] => 12 [categories_name] => Historical building ) Array ( [id] => 1820 [fullname] => Castel Monastero [slug] => castel-monastero [stars] => 5 [rooms] => 73 [latitude] => 43.35066800000 [longitude] => 11.55997200000 [commission] => 18 [booking_com_id] => 189868 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2013-01-31 15:46:44 [district_id] => 0 [languages_id] => 1 [city_name] => Castelnuovo Berardenga [categories_id] => 3 [categories_name] => Castle ) Array ( [id] => 1926 [fullname] => Grand Hotel Continental Siena - Starhotels Collezione [slug] => grand-hotel-continental [stars] => 5 [rooms] => 51 [latitude] => 43.32088800000 [longitude] => 11.33064800000 [commission] => 0 [booking_com_id] => 14895 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2013-02-05 16:04:53 [district_id] => 0 [languages_id] => 1 [city_name] => Siena [categories_id] => 12 [categories_name] => Historical building ) Array ( [id] => 3552 [fullname] => Borgo San Luigi [slug] => borgo-san-luigi [stars] => 4 [rooms] => 73 [latitude] => 43.38876800000 [longitude] => 11.16160500000 [commission] => 18 [booking_com_id] => 80327 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2018-01-09 16:02:06 [district_id] => 0 [languages_id] => 1 [city_name] => Monteriggioni [categories_id] => 20 [categories_name] => Historical village ) Array ( [id] => 5522 [fullname] => 25hours Hotel Florence Piazza San Paolino [slug] => 25hours-hotel-florence-piazza-san-paolino [stars] => 4 [rooms] => 171 [latitude] => 43.77281000000 [longitude] => 11.24812000000 [commission] => 0 [booking_com_id] => 7632706 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2022-09-17 18:57:33 [district_id] => 0 [languages_id] => 0 [city_name] => Florence [categories_id] => 12 [categories_name] => Historical building ) Array ( [id] => 2911 [fullname] => Brunelleschi Hotel [slug] => hotel-brunelleschi [stars] => 4 [rooms] => 96 [latitude] => 43.77172100000 [longitude] => 11.25597300000 [commission] => 18 [booking_com_id] => 81995 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2016-03-31 21:57:46 [district_id] => 0 [languages_id] => 1 [city_name] => Florence [categories_id] => 12 [categories_name] => Historical building ) Array ( [id] => 4331 [fullname] => Locanda Le Piazze [slug] => locanda-le-piazze [stars] => 4 [rooms] => 20 [latitude] => 43.45513100000 [longitude] => 11.23036600000 [commission] => 0 [booking_com_id] => 238343 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2019-06-20 10:40:27 [district_id] => 0 [languages_id] => 0 [city_name] => Castellina in Chianti [categories_id] => 10 [categories_name] => Country house ) Array ( [id] => 4836 [fullname] => Palazzo Alfieri Residenza D'Epoca - Alfieri Collezione [slug] => palazzo-alfieri-residenza-depoca-alfieri-collezione [stars] => 4 [rooms] => 24 [latitude] => 43.76978400000 [longitude] => 11.25025300000 [commission] => 0 [booking_com_id] => 1035385 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2019-12-30 13:33:49 [district_id] => 0 [languages_id] => 0 [city_name] => Florence [categories_id] => 12 [categories_name] => Historical building ) Array ( [id] => 4837 [fullname] => Horto Convento [slug] => horto-convento [stars] => 4 [rooms] => 34 [latitude] => 43.76922100000 [longitude] => 11.23983200000 [commission] => 0 [booking_com_id] => 1952188 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2019-12-30 13:36:09 [district_id] => 0 [languages_id] => 0 [city_name] => Florence [categories_id] => 12 [categories_name] => Historical building ) Array ( [id] => 5113 [fullname] => Villa Sassolini Luxury Boutique Hotel, The Originals Collection [slug] => villa-sassolini-luxury-boutique-hotel-the-originals-collection [stars] => 4 [rooms] => 20 [latitude] => 43.48555000000 [longitude] => 11.50954000000 [commission] => 0 [booking_com_id] => 1866926 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2020-10-08 14:53:05 [district_id] => 0 [languages_id] => 0 [city_name] => Montevarchi [categories_id] => 5 [categories_name] => Villa ) Array ( [id] => 5375 [fullname] => Ultimo Mulino Wellness Country Hotel [slug] => ultimo-mulino-country-hotel-gaiole [stars] => 4 [rooms] => 13 [latitude] => 43.47867500000 [longitude] => 11.39695800000 [commission] => 0 [booking_com_id] => 81050 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2021-10-15 16:09:08 [district_id] => 0 [languages_id] => 0 [city_name] => Gaiole in Chianti [categories_id] => 10 [categories_name] => Country house ) Array ( [id] => 5403 [fullname] => Villa Sabolini [slug] => villa-sabolini [stars] => 4 [rooms] => 30 [latitude] => 43.38159300000 [longitude] => 11.11867000000 [commission] => 0 [booking_com_id] => 241772 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2022-01-31 18:21:06 [district_id] => 0 [languages_id] => 0 [city_name] => Colle di Val d'Elsa [categories_id] => 5 [categories_name] => Villa ) Array ( [id] => 13 [fullname] => Castelletto di Montebenichi [slug] => castelletto-di-montebenichi [stars] => 4 [rooms] => 9 [latitude] => 43.40556800000 [longitude] => 11.54476700000 [commission] => 10 [booking_com_id] => 251819 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 0000-00-00 00:00:00 [district_id] => 0 [languages_id] => 1 [city_name] => Bucine [categories_id] => 3 [categories_name] => Castle ) Array ( [id] => 5528 [fullname] => Hotel Balestri - WTB Hotels [slug] => hotel-balestri-wtb-hotels [stars] => 4 [rooms] => 51 [latitude] => 43.76719700000 [longitude] => 11.25793100000 [commission] => 0 [booking_com_id] => 80871 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2022-09-17 19:08:30 [district_id] => 0 [languages_id] => 0 [city_name] => Florence [categories_id] => 12 [categories_name] => Historical building ) Array ( [id] => 5529 [fullname] => Hotel Glance In Florence [slug] => hotel-glance-in-florence [stars] => 4 [rooms] => 68 [latitude] => 43.77773500000 [longitude] => 11.25271500000 [commission] => 0 [booking_com_id] => 1842438 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2022-09-17 19:10:39 [district_id] => 0 [languages_id] => 0 [city_name] => Florence [categories_id] => 12 [categories_name] => Historical building ) Array ( [id] => 5530 [fullname] => NH Collection Palazzo Gaddi [slug] => nh-collection-palazzo-gaddi [stars] => 4 [rooms] => 86 [latitude] => 43.77415900000 [longitude] => 11.25161700000 [commission] => 0 [booking_com_id] => 220694 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2022-09-17 19:11:52 [district_id] => 0 [languages_id] => 0 [city_name] => Florence [categories_id] => 12 [categories_name] => Historical building ) Array ( [id] => 5531 [fullname] => Hotel Cerretani Firenze - MGallery Collection [slug] => hotel-cerretani-firenze-mgallery-collection [stars] => 4 [rooms] => 86 [latitude] => 43.77361200000 [longitude] => 11.25231200000 [commission] => 0 [booking_com_id] => 81442 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2022-09-17 19:13:17 [district_id] => 0 [languages_id] => 0 [city_name] => Florence [categories_id] => 12 [categories_name] => Historical building ) Array ( [id] => 5532 [fullname] => Hotel Lungarno Vespucci 50 [slug] => hotel-lungarno-vespucci-50 [stars] => 4 [rooms] => 16 [latitude] => 43.77422400000 [longitude] => 11.23903500000 [commission] => 0 [booking_com_id] => 89271 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2022-09-17 19:14:30 [district_id] => 0 [languages_id] => 0 [city_name] => Florence [categories_id] => 12 [categories_name] => Historical building ) Array ( [id] => 5533 [fullname] => Hotel Torre di Bellosguardo [slug] => hotel-torre-di-bellosguardo [stars] => 4 [rooms] => 16 [latitude] => 43.76328100000 [longitude] => 11.23377500000 [commission] => 0 [booking_com_id] => 1103001 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2022-09-17 19:16:13 [district_id] => 0 [languages_id] => 0 [city_name] => Florence [categories_id] => 20 [categories_name] => Historical village ) Array ( [id] => 5534 [fullname] => Palazzo Castri 1874 [slug] => palazzo-castri-1874 [stars] => 4 [rooms] => 58 [latitude] => 43.77893200000 [longitude] => 11.25387300000 [commission] => 0 [booking_com_id] => 84688 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2022-09-17 19:18:15 [district_id] => 0 [languages_id] => 0 [city_name] => Florence [categories_id] => 12 [categories_name] => Historical building ) Array ( [id] => 5535 [fullname] => Hotel Orto de' Medici [slug] => hotel-orto-de-medici [stars] => 4 [rooms] => 42 [latitude] => 43.77876000000 [longitude] => 11.25755200000 [commission] => 0 [booking_com_id] => 80704 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2022-09-17 19:19:59 [district_id] => 0 [languages_id] => 0 [city_name] => Florence [categories_id] => 12 [categories_name] => Historical building ) Array ( [id] => 222 [fullname] => Villa Campestri Olive Oil Resort [slug] => villa-campestri-olive-oil-resort [stars] => 4 [rooms] => 26 [latitude] => 43.90706300000 [longitude] => 11.43968900000 [commission] => 15 [booking_com_id] => 16515 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 0000-00-00 00:00:00 [district_id] => 0 [languages_id] => 1 [city_name] => Mugello [categories_id] => 5 [categories_name] => Villa ) Array ( [id] => 1249 [fullname] => Il Borgo di Vescine [slug] => il-borgo-di-vescine [stars] => 4 [rooms] => 28 [latitude] => 43.48536100000 [longitude] => 11.32918700000 [commission] => 18 [booking_com_id] => 81065 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2011-03-17 15:45:55 [district_id] => 0 [languages_id] => 1 [city_name] => Radda in Chianti [categories_id] => 20 [categories_name] => Historical village ) Array ( [id] => 1848 [fullname] => Hotel Certosa Di Maggiano [slug] => hotel-certosa-di-maggiano [stars] => 4 [rooms] => 17 [latitude] => 43.31037600000 [longitude] => 11.35024500000 [commission] => 0 [booking_com_id] => 86977 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2013-02-04 12:49:33 [district_id] => 0 [languages_id] => 1 [city_name] => Siena [categories_id] => 7 [categories_name] => Convent-monastery ) Array ( [id] => 10 [fullname] => Castello di Leonina Relais [slug] => castello-di-leonina-relais [stars] => 4 [rooms] => 21 [latitude] => 43.28796400000 [longitude] => 11.45366000000 [commission] => 15 [booking_com_id] => 80552 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 0000-00-00 00:00:00 [district_id] => 0 [languages_id] => 1 [city_name] => Asciano [categories_id] => 3 [categories_name] => Castle ) Array ( [id] => 1179 [fullname] => Villa I Barronci Resort & Spa [slug] => villa-i-barronci [stars] => 4 [rooms] => 21 [latitude] => 43.66178700000 [longitude] => 11.16805600000 [commission] => 15 [booking_com_id] => 84234 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2010-06-07 09:35:44 [district_id] => 0 [languages_id] => 1 [city_name] => San Casciano in Val di Pesa [categories_id] => 5 [categories_name] => Villa ) Array ( [id] => 74 [fullname] => Relais della Rovere [slug] => relais-della-rovere [stars] => 4 [rooms] => 31 [latitude] => 43.42225600000 [longitude] => 11.13307300000 [commission] => 15 [booking_com_id] => 80180 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 0000-00-00 00:00:00 [district_id] => 0 [languages_id] => 1 [city_name] => Colle di Val d'Elsa [categories_id] => 4 [categories_name] => Relais ) Array ( [id] => 885 [fullname] => Relais Vignale & Spa [slug] => relais-vignale [stars] => 4 [rooms] => 42 [latitude] => 43.48632500000 [longitude] => 11.37277000000 [commission] => 15 [booking_com_id] => 82958 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 0000-00-00 00:00:00 [district_id] => 0 [languages_id] => 1 [city_name] => Radda in Chianti [categories_id] => 4 [categories_name] => Relais ) Array ( [id] => 1253 [fullname] => Villa Le Barone [slug] => villa-le-barone [stars] => 4 [rooms] => 28 [latitude] => 43.53472100000 [longitude] => 11.31460400000 [commission] => 15 [booking_com_id] => 14497 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2011-03-30 10:22:18 [district_id] => 0 [languages_id] => 1 [city_name] => Panzano in Chianti [categories_id] => 5 [categories_name] => Villa ) Array ( [id] => 1269 [fullname] => Romantik Hotel Monteriggioni [slug] => romantik-hotel-monteriggioni [stars] => 4 [rooms] => 13 [latitude] => 43.39023400000 [longitude] => 11.22313200000 [commission] => 18 [booking_com_id] => 171467 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2011-05-31 12:06:27 [district_id] => 0 [languages_id] => 1 [city_name] => Monteriggioni [categories_id] => 12 [categories_name] => Historical building ) Array ( [id] => 114 [fullname] => Relais Borgo Scopeto [slug] => relais-borgo-scopeto [stars] => 4 [rooms] => 58 [latitude] => 43.39275400000 [longitude] => 11.36964800000 [commission] => 15 [booking_com_id] => 17289 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 0000-00-00 00:00:00 [district_id] => 0 [languages_id] => 1 [city_name] => Castelnuovo Berardenga [categories_id] => 4 [categories_name] => Relais ) Array ( [id] => 225 [fullname] => Villa Olmi Firenze [slug] => villa-olmi-firenze [stars] => 4 [rooms] => 62 [latitude] => 43.75707000000 [longitude] => 11.31254900000 [commission] => 15 [booking_com_id] => 86816 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 0000-00-00 00:00:00 [district_id] => 0 [languages_id] => 1 [city_name] => Bagno a Ripoli [categories_id] => 5 [categories_name] => Villa ) Array ( [id] => 865 [fullname] => Villa Il Poggiale [slug] => villa-il-poggiale [stars] => 0 [rooms] => 24 [latitude] => 43.66586300000 [longitude] => 11.16439700000 [commission] => 12 [booking_com_id] => 85583 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 0000-00-00 00:00:00 [district_id] => 0 [languages_id] => 1 [city_name] => San Casciano in Val di Pesa [categories_id] => 5 [categories_name] => Villa ) Array ( [id] => 637 [fullname] => Tenuta di Lupinari [slug] => tenuta-di-lupinari [stars] => 0 [rooms] => 14 [latitude] => 43.44901900000 [longitude] => 11.59202500000 [commission] => 15 [booking_com_id] => 911797 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 0000-00-00 00:00:00 [district_id] => 0 [languages_id] => 1 [city_name] => Bucine [categories_id] => 3 [categories_name] => Castle ) Array ( [id] => 5523 [fullname] => Casa Botticelli [slug] => casa-botticelli [stars] => 0 [rooms] => 6 [latitude] => 43.76529500000 [longitude] => 11.24800700000 [commission] => 0 [booking_com_id] => 3518453 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2022-09-17 18:59:06 [district_id] => 0 [languages_id] => 0 [city_name] => Florence [categories_id] => 12 [categories_name] => Historical building ) Array ( [id] => 140 [fullname] => Castello di Bibbione [slug] => castello-di-bibbione [stars] => 0 [rooms] => 13 [latitude] => 43.63246100000 [longitude] => 11.18893400000 [commission] => 15 [booking_com_id] => 355682 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 0000-00-00 00:00:00 [district_id] => 0 [languages_id] => 1 [city_name] => San Casciano in Val di Pesa [categories_id] => 3 [categories_name] => Castle ) Array ( [id] => 980 [fullname] => Castello di Gabbiano [slug] => castello-di-gabbiano [stars] => 0 [rooms] => 16 [latitude] => 43.62823800000 [longitude] => 11.26058100000 [commission] => 15 [booking_com_id] => 370495 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 0000-00-00 00:00:00 [district_id] => 0 [languages_id] => 1 [city_name] => San Casciano in Val di Pesa [categories_id] => 3 [categories_name] => Castle ) Array ( [id] => 5376 [fullname] => Brolio Agriroom [slug] => brolio-agriroom [stars] => 0 [rooms] => 4 [latitude] => 43.41556800000 [longitude] => 11.45769500000 [commission] => 0 [booking_com_id] => 6271852 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2021-10-15 16:10:17 [district_id] => 0 [languages_id] => 0 [city_name] => Gaiole in Chianti [categories_id] => 10 [categories_name] => Country house ) Array ( [id] => 5373 [fullname] => Tenuta Cortedomina [slug] => tenuta-cortedomina [stars] => 0 [rooms] => 7 [latitude] => 43.49264300000 [longitude] => 11.37050200000 [commission] => 0 [booking_com_id] => 3681332 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2021-10-14 11:27:54 [district_id] => 0 [languages_id] => 0 [city_name] => Radda in Chianti [categories_id] => 10 [categories_name] => Country house ) Array ( [id] => 137 [fullname] => Castello di Meleto [slug] => castello-di-meleto [stars] => 0 [rooms] => 19 [latitude] => 43.45010700000 [longitude] => 11.42499300000 [commission] => 15 [booking_com_id] => 325852 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 0000-00-00 00:00:00 [district_id] => 0 [languages_id] => 1 [city_name] => Gaiole in Chianti [categories_id] => 3 [categories_name] => Castle ) Array ( [id] => 132 [fullname] => Castello di Cafaggio [slug] => castello-di-cafaggio [stars] => 0 [rooms] => 4 [latitude] => 43.67487500000 [longitude] => 11.25323500000 [commission] => 15 [booking_com_id] => 1714182 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 0000-00-00 00:00:00 [district_id] => 0 [languages_id] => 1 [city_name] => Impruneta [categories_id] => 3 [categories_name] => Castle ) Array ( [id] => 94 [fullname] => Wine Resort Villa Dievole [slug] => villa-dievole [stars] => 0 [rooms] => 27 [latitude] => 43.42004600000 [longitude] => 11.36065700000 [commission] => 12 [booking_com_id] => 13807 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 0000-00-00 00:00:00 [district_id] => 0 [languages_id] => 1 [city_name] => Castelnuovo Berardenga [categories_id] => 5 [categories_name] => Villa ) Array ( [id] => 75 [fullname] => Relais Castel Bigozzi [slug] => relais-castel-bigozzi [stars] => 0 [rooms] => 18 [latitude] => 43.37663600000 [longitude] => 11.17206800000 [commission] => 15 [booking_com_id] => 80176 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 0000-00-00 00:00:00 [district_id] => 0 [languages_id] => 1 [city_name] => Monteriggioni [categories_id] => 3 [categories_name] => Castle ) Array ( [id] => 19 [fullname] => Castello di Tornano Wine & Relais [slug] => castello-di-tornano [stars] => 0 [rooms] => 19 [latitude] => 43.42433000000 [longitude] => 11.40916700000 [commission] => 15 [booking_com_id] => 252821 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 0000-00-00 00:00:00 [district_id] => 0 [languages_id] => 1 [city_name] => Gaiole in Chianti [categories_id] => 3 [categories_name] => Castle ) Array ( [id] => 5536 [fullname] => Ricasoli Firenze Luxury Apartments | UNA Esperienze [slug] => ricasoli-firenze-luxury-apartments-una-esperienze [stars] => 0 [rooms] => 7 [latitude] => 43.77621500000 [longitude] => 11.25820000000 [commission] => 0 [booking_com_id] => 281285 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2022-09-17 19:21:19 [district_id] => 0 [languages_id] => 0 [city_name] => Florence [categories_id] => 12 [categories_name] => Historical building ) Array ( [id] => 5537 [fullname] => Repubblica Firenze Luxury Apartments | UNA Esperienze [slug] => repubblica-firenze-luxury-apartments-una-esperienze [stars] => 0 [rooms] => 4 [latitude] => 43.77186400000 [longitude] => 11.25399800000 [commission] => 0 [booking_com_id] => 252594 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2022-09-17 19:22:33 [district_id] => 0 [languages_id] => 0 [city_name] => Florence [categories_id] => 12 [categories_name] => Historical building ) Array ( [id] => 5540 [fullname] => Palazzo Portinari Salviati Residenza D'Epoca [slug] => palazzo-portinari-salviati-residenza-depoca [stars] => 0 [rooms] => 13 [latitude] => 43.77151300000 [longitude] => 11.25739000000 [commission] => 0 [booking_com_id] => 8269080 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2022-10-10 13:00:37 [district_id] => 0 [languages_id] => 0 [city_name] => Florence [categories_id] => 12 [categories_name] => Historical building ) Array ( [id] => 4705 [fullname] => Ottantotto Firenze [slug] => ottantotto-firenze [stars] => 0 [rooms] => 7 [latitude] => 43.76579700000 [longitude] => 11.24461500000 [commission] => 0 [booking_com_id] => 2527349 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2019-11-25 08:27:17 [district_id] => 0 [languages_id] => 0 [city_name] => Florence [categories_id] => 12 [categories_name] => Historical building ) Array ( [id] => 1754 [fullname] => Salvadonica Borgo del Chianti [slug] => salvadonica-borgo-del-chianti [stars] => 0 [rooms] => 19 [latitude] => 43.63609500000 [longitude] => 11.21897000000 [commission] => 15 [booking_com_id] => 314750 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2013-01-16 09:39:51 [district_id] => 0 [languages_id] => 1 [city_name] => San Casciano in Val di Pesa [categories_id] => 10 [categories_name] => Country house ) Array ( [id] => 1592 [fullname] => Relais Borgo Petrognano [slug] => relais-borgo-petrognano [stars] => 0 [rooms] => 13 [latitude] => 43.53555500000 [longitude] => 11.14208300000 [commission] => 0 [booking_com_id] => 494703 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2012-09-13 11:49:18 [district_id] => 0 [languages_id] => 1 [city_name] => Barberino Val D'Elsa [categories_id] => 3 [categories_name] => Castle ) Array ( [id] => 2793 [fullname] => Relais La Costa [slug] => relais-la-costa- [stars] => 0 [rooms] => 7 [latitude] => 43.35367500000 [longitude] => 11.22156900000 [commission] => 18 [booking_com_id] => 494717 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2015-09-22 09:55:54 [district_id] => 0 [languages_id] => 1 [city_name] => Monteriggioni [categories_id] => 20 [categories_name] => Historical village ) Array ( [id] => 2881 [fullname] => Castello di Fonterutoli [slug] => castello-di-fonterutoli [stars] => 0 [rooms] => 12 [latitude] => 43.43518000000 [longitude] => 11.30593300000 [commission] => 18 [booking_com_id] => 493296 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2016-02-24 16:38:29 [district_id] => 0 [languages_id] => 1 [city_name] => Castellina in Chianti [categories_id] => 3 [categories_name] => Castle ) Array ( [id] => 1343 [fullname] => Castello di Montegufoni [slug] => castello-di-montegufoni [stars] => 0 [rooms] => 37 [latitude] => 43.67070300000 [longitude] => 11.09026400000 [commission] => 0 [booking_com_id] => 1188433 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2012-02-21 09:28:55 [district_id] => 0 [languages_id] => 1 [city_name] => Montespertoli [categories_id] => 3 [categories_name] => Castle ) Array ( [id] => 1324 [fullname] => Casa Howard Guest House [slug] => casa-howard-guest-house [stars] => 0 [rooms] => 8 [latitude] => 43.77427000000 [longitude] => 11.24754600000 [commission] => 12 [booking_com_id] => 84347 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2012-01-21 09:25:57 [district_id] => 0 [languages_id] => 1 [city_name] => Florence [categories_id] => 12 [categories_name] => Historical building ) Array ( [id] => 1318 [fullname] => Residenza d'Epoca Campo Regio Relais [slug] => residenza-depoca-campo-regio-relais [stars] => 0 [rooms] => 6 [latitude] => 43.32039900000 [longitude] => 11.32842800000 [commission] => 18 [booking_com_id] => 84087 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2011-12-29 09:15:40 [district_id] => 0 [languages_id] => 1 [city_name] => Siena [categories_id] => 12 [categories_name] => Historical building ) Array ( [id] => 1312 [fullname] => Castel Pietraio [slug] => castel-pietraio [stars] => 0 [rooms] => 8 [latitude] => 43.37904700000 [longitude] => 11.17741700000 [commission] => 18 [booking_com_id] => 13081 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2011-12-19 15:47:56 [district_id] => 0 [languages_id] => 1 [city_name] => Monteriggioni [categories_id] => 3 [categories_name] => Castle ) Array ( [id] => 4551 [fullname] => Borgo dé Brandi [slug] => borgo-de-brandi [stars] => 0 [rooms] => 11 [latitude] => 43.38161600000 [longitude] => 11.22930400000 [commission] => 0 [booking_com_id] => 1687814 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2019-10-06 11:59:21 [district_id] => 0 [languages_id] => 0 [city_name] => Monteriggioni [categories_id] => 20 [categories_name] => Historical village ) Array ( [id] => 1160 [fullname] => Palazzo Niccolini al Duomo [slug] => palazzo-niccolini-al-duomo [stars] => 0 [rooms] => 10 [latitude] => 43.77369300000 [longitude] => 11.25744300000 [commission] => 15 [booking_com_id] => 49281 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2010-04-14 15:22:36 [district_id] => 0 [languages_id] => 1 [city_name] => Florence [categories_id] => 12 [categories_name] => Historical building ) Array ( [id] => 4755 [fullname] => Hotel Certosa di Pontignano Residenza d'Epoca [slug] => hotel-certosa-di-pontignano-residenza-depoca [stars] => 0 [rooms] => 13 [latitude] => 43.36939300000 [longitude] => 11.36012600000 [commission] => 0 [booking_com_id] => 1232110 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2019-11-30 15:37:57 [district_id] => 0 [languages_id] => 0 [city_name] => Ponte A Bozzone [categories_id] => 7 [categories_name] => Convent-monastery ) Array ( [id] => 1262 [fullname] => Residenza d’Epoca Palazzo Tolomei [slug] => residenza-depoca-palazzo-tolomei [stars] => 0 [rooms] => 7 [latitude] => 43.77658300000 [longitude] => 11.25576400000 [commission] => 15 [booking_com_id] => 240467 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2011-05-05 12:01:40 [district_id] => 0 [languages_id] => 1 [city_name] => Florence [categories_id] => 12 [categories_name] => Historical building ) Array ( [id] => 4841 [fullname] => Castello di Volpaia [slug] => castello-di-volpaia [stars] => 0 [rooms] => 8 [latitude] => 43.51671200000 [longitude] => 11.38097200000 [commission] => 0 [booking_com_id] => 451605 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2020-01-08 21:07:21 [district_id] => 0 [languages_id] => 0 [city_name] => Radda in Chianti [categories_id] => 3 [categories_name] => Castle ) Array ( [id] => 4892 [fullname] => Badia a Coltibuono [slug] => badia-a-coltibuono [stars] => 0 [rooms] => 13 [latitude] => 43.49496600000 [longitude] => 11.44964800000 [commission] => 0 [booking_com_id] => 89654 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2020-02-16 18:38:33 [district_id] => 0 [languages_id] => 0 [city_name] => Gaiole in Chianti [categories_id] => 20 [categories_name] => Historical village ) Array ( [id] => 4893 [fullname] => Rocca Di Castagnoli [slug] => rocca-di-castagnoli [stars] => 0 [rooms] => 13 [latitude] => 43.44294500000 [longitude] => 11.45176600000 [commission] => 0 [booking_com_id] => 83827 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2020-02-16 18:39:21 [district_id] => 0 [languages_id] => 0 [city_name] => Gaiole in Chianti [categories_id] => 20 [categories_name] => Historical village ) Array ( [id] => 5052 [fullname] => Castello La Leccia [slug] => castello-la-leccia [stars] => 0 [rooms] => 12 [latitude] => 43.43924100000 [longitude] => 11.27909700000 [commission] => 0 [booking_com_id] => 302868 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2020-09-20 11:59:28 [district_id] => 0 [languages_id] => 0 [city_name] => Castellina in Chianti [categories_id] => 3 [categories_name] => Castle ) Array ( [id] => 1198 [fullname] => Borgo di Pietrafitta [slug] => borgo-di-pietrafitta [stars] => 0 [rooms] => 15 [latitude] => 43.49366400000 [longitude] => 11.30203200000 [commission] => 18 [booking_com_id] => 83716 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2010-09-14 22:33:37 [district_id] => 0 [languages_id] => 1 [city_name] => Castellina in Chianti [categories_id] => 4 [categories_name] => Relais ) Array ( [id] => 5111 [fullname] => Villa Il Sasso - Dimora d'Epoca [slug] => villa-il-sasso-dimora-depoca [stars] => 0 [rooms] => 7 [latitude] => 43.72968000000 [longitude] => 11.29857700000 [commission] => 0 [booking_com_id] => 16759 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2020-10-08 11:57:19 [district_id] => 0 [languages_id] => 0 [city_name] => Bagno a Ripoli [categories_id] => 5 [categories_name] => Villa ) Array ( [id] => 5374 [fullname] => Bellavista Castello di Bossi [slug] => bellavista-castello-di-bossi [stars] => 0 [rooms] => 8 [latitude] => 43.37727300000 [longitude] => 11.45304300000 [commission] => 0 [booking_com_id] => 2421108 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2021-10-14 11:37:41 [district_id] => 0 [languages_id] => 0 [city_name] => Castelnuovo Berardenga [categories_id] => 3 [categories_name] => Castle )