Îles Amami

À propos de Îles Amami

Meilleurs hôtels en Îles Amami

Miru Amami Tatsugo, Îles Amami €286

Voir plus de photos

familles  -  Les villas avec piscine sont idéales pour les familles, car elles peuvent facilement accueillir quatre personnes et disposent d'une piscine privée.
Restaurant  -  Amanari propose une cuisine japonaise moderne et raffinée, élaborée à partir des ingrédients locaux les plus frais.
Pêche  -  Pour ceux qui ne se contentent pas de prendre le soleil sur la plage, le complexe organise des sorties de pêche.
Piscine privée  -  Les villas avec piscine sont dotées d'une piscine privée

Villas privées donnant sur la magnifique plage de sable du complexe, à Tatsugo. L'intérieur est simple et chic, avec du linge de maison impeccable, des planchers en bois et des vues imprenables depuis les fenêtres allant du sol au plafond. Certains disposent d'une piscine et d'une terrasse privées. Le restaurant propose des plats fabuleux issus de l'agriculture locale. Un refuge sur l'île Voir plus d'informations

Vérifier la disponibilité

Init : 1.5974044799805E-5
Dispatch : 0.24418020248413
Output : 0.00093889236450195
Total : 0.24513506889343
Peak memory: 1.4577331542969mb
Server name: Linux ip-172-26-7-178 5.4.0-1030-aws #31-Ubuntu SMP Fri Nov 13 11:40:37 UTC 2020 x86_64

0.00265 : SELECT string_id, value FROM `strings_french` WHERE 0 OR `string_id` LIKE('tabs.%')
0.00379 : SELECT string_id, value FROM `strings_french` WHERE 0 OR `string_id` LIKE('hotel.%') OR `string_id` LIKE('general.%')
0.00248 : SELECT * FROM `location` WHERE `handle`='japan/iles-amami' ORDER BY path LIMIT 0, 1
0.00088 : SELECT * FROM `location_french` WHERE `handle`='japan/iles-amami' LIMIT 0, 1
0.00165 : SELECT * FROM `location` WHERE `location_id`='32904' ORDER BY path LIMIT 0, 1
0.00236 : SELECT * FROM `location` WHERE `handle`='japan/iles-amami' ORDER BY path LIMIT 0, 1
0.00379 : SELECT * FROM `location_french` WHERE `handle`='japan/iles-amami' LIMIT 0, 1
0.00419 : SELECT * FROM `location` WHERE `location_id`='32904' ORDER BY path LIMIT 0, 1
0.00444 : SELECT * FROM `location` WHERE `location_id`='21693'
0.00429 : SELECT * FROM `location` WHERE `location_id`='21693'
0.00350 : SELECT * FROM `location_french` WHERE `location_id`='21693' LIMIT 0, 1
0.00072 : SELECT handle FROM `location_german` WHERE `location_id`='32904'
0.00125 : SELECT handle FROM `location_french` WHERE `location_id`='32904'
0.00168 : SELECT handle FROM `where_to_stay` WHERE `is_published`='1' AND `location1_id`='32904' ORDER BY title LIMIT 0, 1
0.00612 : SELECT * FROM `location` WHERE `location_id`='21693'
0.05272 : SELECT hotel_id, locations FROM `_index` WHERE `locations` LIKE('%,32904,%') AND `is_published`='1'
0.00977 : SELECT location_id FROM `location` WHERE `parent_id`='32904' OR `parent2_id`='32904'
0.00190 : SELECT * FROM `location_french` WHERE `location_id`='32904' LIMIT 0, 1
0.00153 : SELECT * FROM `location` WHERE `location_id`='21693'
0.00162 : SELECT * FROM `location` WHERE `location_id`='21693'
0.00101 : SELECT * FROM `location` WHERE `location_id`='21693'
0.00209 : SELECT * FROM `location` WHERE `location_id`='32904' ORDER BY path LIMIT 0, 1
0.00068 : SELECT * FROM `location` WHERE `location_id`='21693'
0.00082 : SELECT * FROM `location_french` WHERE `location_id`='21693' LIMIT 0, 1
0.00065 : SELECT * FROM `location` WHERE `location_id`='32904' ORDER BY path LIMIT 0, 1
0.00155 : SELECT * FROM `location` WHERE `location_id`='21693'
0.00070 : SELECT * FROM `location_french` WHERE `location_id`='21693' LIMIT 0, 1
0.01973 : SELECT hotel_id FROM `_index` WHERE `locations` LIKE('%,32904,%') AND `is_published`='1' ORDER BY is_paid DESC, rate ASC LIMIT 0, 100
0.00221 : SELECT * FROM `hotel` WHERE `hotel_id` IN ('158968') ORDER BY is_paid DESC,IF(rate_min IS NULL,0,1) DESC, rate_min ASC LIMIT 0, 100
0.00349 : SELECT CONCAT(`from`, ":", `to`), rate FROM `currency_conversion` WHERE 1
0.00055 : SELECT * FROM `location` WHERE `location_id`='32904'
0.00099 : SELECT * FROM `location_french` WHERE `location_id`='32904' LIMIT 0, 1
0.00170 : SELECT tag_id, strap,score, tag.title AS title, tag.default_strap AS default_strap FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='158968' AND (hotel_tag.score>1 OR tag.is_featured_list=1) and collection <> 7 ORDER BY hotel_tag.score DESC, LENGTH(hotel_tag.strap) DESC LIMIT 0, 4
0.00057 : SELECT tag_id,strap FROM `hotel_tag_french` WHERE `hotel_id`='158968'
0.00213 : SELECT tag_french.tag_id, title,default_strap FROM `tag_french` WHERE 1
0.00118 : SELECT tag_id,title,handle FROM `hotel_tag` JOIN tag USING(tag_id) WHERE `hotel_id`='158968' AND tag_id in (3,33,423,303,593,1703,123,1193,853,1353,63) ORDER BY hotel_tag.tag_id
0.00075 : SELECT tag.tag_id,tag_french.title,tag.handle FROM `hotel_tag` JOIN tag_french USING(tag_id) JOIN tag USING(tag_id) WHERE `hotel_id`='158968' AND tag_id in (3,33,423,303,593,1703,123,1193,853,1353,63) ORDER BY hotel_tag.tag_id
0.00131 : SELECT * FROM `hotel_french` WHERE `hotel_id`='158968' LIMIT 0, 1
0.00068 : SELECT * FROM `attraction` WHERE `location_id`='32904' ORDER BY title LIMIT 0, 50
0.00050 : SELECT * FROM `location_french` WHERE `location_id`='32904' LIMIT 0, 1
0.00322 : SELECT * FROM `article` WHERE (is_published=1 AND (location1_id=32904 OR location2_id=32904 OR location3_id=32904)) ORDER BY datetime_published DESC LIMIT 0, 1000
0.00185 : SELECT * FROM `imagestore` WHERE `global_id`='137438986344' ORDER BY image_id = "28bd26b11e12436249724715b7a10b91" DESC, position ASC
0.00201 : SELECT * FROM `imagestore` WHERE `image_id`='28bd26b11e12436249724715b7a10b91'
0.00055 : SELECT * FROM `imagestore` WHERE `image_id`='4ade81aea772ffbed08bbfa413f19341'
0.00129 : SELECT * FROM `imagestore` WHERE `image_id`='4ade81aea772ffbed08bbfa413f19341'
0.00094 : SELECT * FROM `imagestore` WHERE `image_id`='28bd26b11e12436249724715b7a10b91'
0.00066 : SELECT * FROM `imagestore` WHERE `image_id`='28bd26b11e12436249724715b7a10b91'
0.00227 : SELECT * FROM `imagestore` WHERE `global_id`='137438986344' ORDER BY image_id = "28bd26b11e12436249724715b7a10b91" DESC, position ASC
0.00056 : SELECT * FROM `imagestore` WHERE `image_id`='28bd26b11e12436249724715b7a10b91'
0.00225 : SELECT * FROM `imagestore` WHERE `image_id`='4ade81aea772ffbed08bbfa413f19341'
0.00056 : SELECT * FROM `imagestore` WHERE `image_id`='4ade81aea772ffbed08bbfa413f19341'
0.00225 : SELECT * FROM `imagestore` WHERE `image_id`='28bd26b11e12436249724715b7a10b91'
0.00059 : SELECT * FROM `imagestore` WHERE `image_id`='28bd26b11e12436249724715b7a10b91'

Îles Amami

Recherchez les meilleurs hôtels de Îles Amami

À propos de Îles Amami

Meilleurs hôtels en Îles Amami

Miru Amami Tatsugo, Îles Amami €286