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` != '2063' 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.48555') - RADIANS(icn_hotels.latitude), 2) + POW(RADIANS('11.50954') - RADIANS(icn_hotels.longitude), 2)), 3) < '40' ORDER BY `icn_hotels`.`stars` DESCArray ( [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] => 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] => 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] => 3515 [fullname] => Il Borro Tuscany [slug] => il-borro-tuscany [stars] => 5 [rooms] => 40 [latitude] => 43.54148200000 [longitude] => 11.71503600000 [commission] => 18 [booking_com_id] => 80564 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2017-10-09 16:23:20 [district_id] => 0 [languages_id] => 1 [city_name] => San Giustino Valdarno [categories_id] => 20 [categories_name] => Historical village ) 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] => 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] => 148 [fullname] => La Bagnaia Golf & Spa Resort Siena - Curio, A Collection by Hilton [slug] => borgo-la-bagnaia-resort-spa [stars] => 5 [rooms] => 72 [latitude] => 43.21673300000 [longitude] => 11.29232800000 [commission] => 15 [booking_com_id] => 84018 [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] => Siena [categories_id] => 9 [categories_name] => Resort ) Array ( [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] => 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] => 4519 [fullname] => Laticastelli Country Relais [slug] => laticastelli-country-relais [stars] => 4 [rooms] => 21 [latitude] => 43.30759500000 [longitude] => 11.58315200000 [commission] => 18 [booking_com_id] => 14492 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2019-09-10 10:20:25 [district_id] => 0 [languages_id] => 1 [city_name] => Rapolano Terme [categories_id] => 10 [categories_name] => Country house ) 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] => 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] => 5100 [fullname] => Villa Bordoni [slug] => villa-bordoni [stars] => 4 [rooms] => 12 [latitude] => 43.58605100000 [longitude] => 11.28833400000 [commission] => 0 [booking_com_id] => 566315 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2020-10-08 11:29:50 [district_id] => 0 [languages_id] => 0 [city_name] => Greve in Chianti [categories_id] => 5 [categories_name] => Villa ) 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] => 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] => 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] => 5422 [fullname] => Chimera Tuscany Resort [slug] => chimera-tuscany-resort [stars] => 4 [rooms] => 6 [latitude] => 43.51228200000 [longitude] => 11.85374400000 [commission] => 0 [booking_com_id] => 7155677 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2022-03-03 10:55:42 [district_id] => 0 [languages_id] => 0 [city_name] => Arezzo [categories_id] => 9 [categories_name] => Resort ) 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] => 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] => 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] => 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] => 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] => 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] => 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] => 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 ) 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] => 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] => 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] => 5174 [fullname] => Borgo Del Cabreo [slug] => borgo-del-cabreo [stars] => 0 [rooms] => 11 [latitude] => 43.58662800000 [longitude] => 11.30734600000 [commission] => 0 [booking_com_id] => 2210822 [booking_com_type_thumbnail] => booking [booking_com_active] => 1 [publication_date] => 2020-12-13 14:44:40 [district_id] => 0 [languages_id] => 0 [city_name] => Greve in Chianti [categories_id] => 20 [categories_name] => Historical village ) 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] => 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] => 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] => 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] => 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] => 2395 [fullname] => Castello di San Fabiano [slug] => castello-di-san-fabiano [stars] => 0 [rooms] => 6 [latitude] => 43.23692400000 [longitude] => 11.42429100000 [commission] => 18 [booking_com_id] => 506558 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2013-05-27 16:29:47 [district_id] => 0 [languages_id] => 1 [city_name] => Monteroni d'Arbia [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] => 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] => 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] => 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] => 1148 [fullname] => Castello delle Serre [slug] => castello-delle-serre [stars] => 0 [rooms] => 14 [latitude] => 43.25828900000 [longitude] => 11.61766100000 [commission] => 15 [booking_com_id] => 12324 [booking_com_type_thumbnail] => icastelli [booking_com_active] => 1 [publication_date] => 2010-03-08 15:23:29 [district_id] => 0 [languages_id] => 1 [city_name] => Rapolano Terme [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] => 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] => 207 [fullname] => Castello di Gargonza [slug] => castello-di-gargonza [stars] => 0 [rooms] => 45 [latitude] => 43.34018700000 [longitude] => 11.67307800000 [commission] => 15 [booking_com_id] => 321987 [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] => Monte San Savino [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] => 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 ) Luxury Hotels in Montevarchi - Charming Hotels and Spa

1 Charming and Luxury Hotels in Montevarchi


Hotels in the surroundings

Villa Armena Relais

Villa Armena Relais

  • 8.5
  • Score from 4 review/s
Outdoor Swimming pool, Restaurant Gastronomic & Bistro, Free parking, Free WiFi Internet, 10 Rooms

Benefits
Antica Villa Poggitazzi

Antica Villa Poggitazzi

  • 8
  • Score from 4 review/s
Outdoor Swimming pool, Restaurant on request, Pets Friendly, Free parking, Free WiFi Internet, 25 Rooms

Benefits
Villa Casagrande Resort e SPA

Villa Casagrande Resort e SPA

  • 9.1
  • Score from 30 review/s
Indoor Swimming pool, Outdoor Swimming pool, Restaurant, Spa beauty center, 60 Rooms

Benefits
Albergo Casalta

Albergo Casalta

  • 10
  • Score from 2 review/s
Restaurant, Pets Friendly, 10 Rooms

Benefits

Benefits

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


Podere Castellare

Podere Castellare

  • 10
  • Score from 1 review/s
Outdoor Swimming pool, Restaurant, Pets Friendly, Free parking, Free WiFi Internet, 12 Rooms

Benefits
Castel Monastero

Castel Monastero

  • 10
  • Score from 1 review/s
Indoor Swimming pool, Outdoor Swimming pool, Restaurant, Spa beauty center, Free parking, Free WiFi Internet, 73 Rooms

Benefits
Ville Sull'Arno

Ville Sull'Arno

45 Rooms

Benefits
Villa La Massa

Villa La Massa

51 Rooms

Benefits
Il Borro Tuscany

Il Borro Tuscany

  • Historical village,
  • San Giustino Valdarno
  • -
  • Location Map (35.40 km)
Golf, Outdoor Swimming pool, Restaurant, Pets Friendly, Free parking, Free WiFi Internet, 40 Rooms

Benefits

Benefits

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


Grand Hotel Continental Siena - Starhotels Collezione

Grand Hotel Continental Siena - Starhotels Collezione

  • 10
  • Score from 1 review/s
Restaurant, 51 Rooms

Benefits
COMO Castello Del Nero

COMO Castello Del Nero

  • 9.2
  • Score from 13 review/s
Outdoor Swimming pool, Restaurant, Spa beauty center, Pets Friendly, Free parking, Free WiFi Internet, 50 Rooms

Benefits
La Bagnaia Golf & Spa Resort Siena - Curio, A Collection by Hilton

La Bagnaia Golf & Spa Resort Siena - Curio, A Collection by Hilton

  • 9
  • Score from 2 review/s
Golf 18 holes, Outdoor Swimming pool, Restaurant, Spa beauty center, Pets Friendly, Free parking, Free WiFi Internet, 72 Rooms

Benefits
Castello di Spaltenna Exclusive Resort & Spa

Castello di Spaltenna Exclusive Resort & Spa

  • 9.4
  • Score from 29 review/s
Indoor Swimming pool, Outdoor Swimming pool, Restaurant, Spa beauty center, Free parking, Free WiFi Internet, 37 Rooms

Benefits
Romantik Hotel Monteriggioni

Romantik Hotel Monteriggioni

  • Historical building,
  • Monteriggioni
  • -
  • Location Map (50.88 km)
  • 4
  • Score from 1 review/s
Outdoor Swimming pool, Free parking, Free WiFi Internet, 13 Rooms

Benefits

Benefits

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


Laticastelli Country Relais

Laticastelli Country Relais

Outdoor Swimming pool, Restaurant, Pets Friendly, Free parking, Free WiFi Internet, 21 Rooms

Benefits
Locanda Le Piazze

Locanda Le Piazze

  • Country house,
  • Castellina in Chianti
  • -
  • Location Map (45.56 km)
20 Rooms

Benefits
Hotel Certosa Di Maggiano

Hotel Certosa Di Maggiano

  • 10
  • Score from 1 review/s
Outdoor Swimming pool, 17 Rooms

Benefits
Castello di Leonina Relais

Castello di Leonina Relais

  • 8.6
  • Score from 10 review/s
Outdoor Jacuzzi, Outdoor Swimming pool, Restaurant, Spa beauty center, Pets Friendly, Free parking, Free WiFi Internet, 21 Rooms

Benefits
Villa Bordoni

Villa Bordoni

12 Rooms

Benefits
Villa Le Barone

Villa Le Barone

  • 10
  • Score from 1 review/s
Outdoor Swimming pool, Restaurant, Free parking, 28 Rooms

Benefits
Il Borgo di Vescine

Il Borgo di Vescine

  • Historical village,
  • Radda in Chianti
  • -
  • Location Map (29.10 km)
  • 8
  • Score from 1 review/s
Outdoor Swimming pool, Restaurant, 28 Rooms

Benefits
Castelletto di Montebenichi

Castelletto di Montebenichi

  • 9.3
  • Score from 3 review/s
Outdoor Swimming pool, 9 Rooms

Benefits
Chimera Tuscany Resort

Chimera Tuscany Resort

6 Rooms

Benefits
Relais Vignale & Spa

Relais Vignale & Spa

  • 9.4
  • Score from 10 review/s
Outdoor Swimming pool, Restaurant, Free parking, Free WiFi Internet, 42 Rooms

Benefits
Ultimo Mulino Wellness Country Hotel

Ultimo Mulino Wellness Country Hotel

  • Country house,
  • Gaiole in Chianti
  • -
  • Location Map (18.23 km)
13 Rooms

Benefits
Villa Olmi Firenze

Villa Olmi Firenze

  • 10
  • Score from 1 review/s
Outdoor Swimming pool, Restaurant, Free WiFi Internet, 62 Rooms

Benefits
Relais Borgo Scopeto

Relais Borgo Scopeto

  • 8
  • Score from 6 review/s
Outdoor Swimming pool, Restaurant, Spa beauty center, Pets Friendly, Free parking, 58 Rooms

Benefits
Brolio Agriroom

Brolio Agriroom

  • Country house,
  • Gaiole in Chianti
  • -
  • Location Map (17.67 km)
4 Rooms

Benefits
Hotel Certosa di Pontignano Residenza d'Epoca

Hotel Certosa di Pontignano Residenza d'Epoca

  • Convent-monastery,
  • Ponte A Bozzone
  • -
  • Location Map (35.35 km)
13 Rooms

Benefits
Castello di Volpaia

Castello di Volpaia

  • 10
  • Score from 1 review/s
8 Rooms

Benefits
Badia a Coltibuono

Badia a Coltibuono

  • Historical village,
  • Gaiole in Chianti
  • -
  • Location Map (9.89 km)
13 Rooms

Benefits
Rocca Di Castagnoli

Rocca Di Castagnoli

  • Historical village,
  • Gaiole in Chianti
  • -
  • Location Map (13.29 km)
13 Rooms

Benefits
Castello La Leccia

Castello La Leccia

  • 8
  • Score from 1 review/s
12 Rooms

Benefits
Bellavista Castello di Bossi

Bellavista Castello di Bossi

8 Rooms

Benefits
Castello di Tornano Wine & Relais

Castello di Tornano Wine & Relais

  • 9.7
  • Score from 20 review/s
Outdoor Swimming pool, Restaurant, Pets Friendly, Free parking, Free WiFi Internet, 19 Rooms

Benefits
Villa Il Sasso - Dimora d'Epoca

Villa Il Sasso - Dimora d'Epoca

7 Rooms

Benefits
Relais La Costa

Relais La Costa

  • Historical village,
  • Monteriggioni
  • -
  • Location Map (54.99 km)
Indoor Swimming pool, Outdoor Jacuzzi, Outdoor Swimming pool, Restaurant, Spa beauty center, Free parking, Free WiFi Internet, 7 Rooms

Benefits
Borgo Del Cabreo

Borgo Del Cabreo

  • Historical village,
  • Greve in Chianti
  • -
  • Location Map (39.60 km)
11 Rooms

Benefits
Tenuta Cortedomina

Tenuta Cortedomina

7 Rooms

Benefits
Borgo dé Brandi

Borgo dé Brandi

  • Historical village,
  • Monteriggioni
  • -
  • Location Map (50.82 km)
11 Rooms

Benefits
Relais Castel Bigozzi

Relais Castel Bigozzi

  • 8.8
  • Score from 71 review/s
Outdoor Swimming pool, Pets Friendly, Free parking, Free WiFi Internet, 18 Rooms

Benefits
Castello di Fonterutoli

Castello di Fonterutoli

  • 8.4
  • Score from 5 review/s
Restaurant, Pets Friendly, Free parking, Free WiFi Internet, 12 Rooms

Benefits
Castello di Bibbione

Castello di Bibbione

  • Castle,
  • San Casciano in Val di Pesa
  • -
  • Location Map (61.13 km)
  • 9.1
  • Score from 7 review/s
Outdoor Swimming pool, Pets Friendly, Free parking, Free WiFi Internet, 13 Rooms

Benefits
Castello di San Fabiano

Castello di San Fabiano

  • 10
  • Score from 2 review/s
Outdoor Swimming pool, Pets Friendly, Free parking, Free WiFi Internet, 6 Rooms

Benefits
Wine Resort Villa Dievole

Wine Resort Villa Dievole

  • 8.9
  • Score from 7 review/s
Outdoor Swimming pool, Restaurant, Free parking, Free WiFi Internet, 27 Rooms

Benefits
Salvadonica Borgo del Chianti

Salvadonica Borgo del Chianti

  • Country house,
  • San Casciano in Val di Pesa
  • -
  • Location Map (57.56 km)
  • 10
  • Score from 3 review/s
Outdoor Swimming pool, Restaurant, Pets Friendly, Free WiFi Internet, 19 Rooms

Benefits
Residenza d'Epoca Campo Regio Relais

Residenza d'Epoca Campo Regio Relais

6 Rooms

Benefits
Castel Pietraio

Castel Pietraio

  • 10
  • Score from 8 review/s
Outdoor Swimming pool, Pets Friendly, Free parking, Free WiFi Internet, 8 Rooms

Benefits
Borgo di Pietrafitta

Borgo di Pietrafitta

  • 8
  • Score from 5 review/s
Outdoor Swimming pool, Free parking, Free WiFi Internet, 15 Rooms

Benefits
Castello delle Serre

Castello delle Serre

  • 9.6
  • Score from 10 review/s
Outdoor Swimming pool, Restaurant on request, Free parking, Free WiFi Internet, 14 Rooms

Benefits
Castello di Gabbiano

Castello di Gabbiano

  • Castle,
  • San Casciano in Val di Pesa
  • -
  • Location Map (51.15 km)
  • 9.7
  • Score from 12 review/s
Restaurant, Pets Friendly, 16 Rooms

Benefits
Tenuta di Lupinari

Tenuta di Lupinari

  • 9.3
  • Score from 6 review/s
Outdoor Swimming pool, Restaurant, Pets Friendly, Free parking, Free WiFi Internet, 14 Rooms

Benefits
Castello di Gargonza

Castello di Gargonza

  • 9.6
  • Score from 23 review/s
Outdoor Swimming pool, Restaurant, Pets Friendly, Free parking, Free WiFi Internet, 45 Rooms

Benefits
Castello di Cafaggio

Castello di Cafaggio

  • 8.9
  • Score from 7 review/s
Outdoor Swimming pool, Pets Friendly, Free parking, Free WiFi Internet, 4 Rooms

Benefits
Castello di Meleto

Castello di Meleto

  • 8.7
  • Score from 30 review/s
Outdoor Swimming pool, Pets Friendly, Free parking, Free WiFi Internet, 19 Rooms

Benefits