Выберите отель:
--
select id_hotel, type_hotel,category,name ,(select id_partition from partition where partition_type='H' and id_top=hotel.id_hotel order by sort_order limit 1) as id_part from hotel where id_town=98 and is_show=1 order by category desc, name asc Aldemar Knossos Royal Village & Villas Hotel 5* Aldemar Royal Mare Village Hotel 5* Annabelle Village Hotel 5* Apollonia Beach Hotel 5* Aquis Bella Beach Hotel 5* Capsis Crystal Energy Hotel 5* Capsis Divine Thalassa Hotel 5* Capsis OH! All Suite Hotel 5* Creta Maris Hotel 5* Grecotel Amirandes Hotel 5* Ikaros Village Hotel 5* Movenpick Resort & Thalasso Crete Hotel 5* Sensimar Sea Side Resort & Spa Hotel 5* Terra Maris Hotel 5* Albatros Spa Resort Hotel 4* Aldemar Cretan Village Hotel 4* Alexander Beach Hotel 4* Anissa Beach Hotel 4* Anthoussa Beach Resort & Spa Hotel 4* Aphrodite Beach Hotel 4* Aquis Zorbas Village Hotel 4* Arina Sand Hotel 4* Astir Beach Hotel 4* Chrissi Amoudia Hotel 4* Creta Beach Hotel 4* Eri Beach & Village Hotel 4* Europa Beach Hotel 4* Golden Star Hotel 4* Hersonissos Maris Hotel 4* Hersonissos Park Hotel 4* Kernos Beach Hotel 4* Malia Beach Hotel 4* Marilena Hotel 4* Sbokos Agapi Beach Hotel 4* Sbokos Cretan Malia Park Hotel 4* Silva Beach Hotel 4* Star Beach Hotel 4* Stella Village Hotel 4* Themis Beach Hotel 4* Ariadne Beach Hotel 3* Bali Star Hotel 3* Blue Sea Village Resort & Spa Hotel 3* Dimitrion Hotel 3* Golden Beach Hotel 3* Heronissos Hotel 3* Malia Bay Hotel 3* Mari Kristin Hotel 3* Pela Maria Hotel 3* Sofia Mythos Beach Hotel 3* Talea Beach Hotel 3* Australia Hotel 2* Zervas Hotel 2* Stelva APP 0*
Заказать тур в Регион А Греция с бронированием отеля Ariadne Beach Hotel с вылетом из МосквпїЅ по доступным ценам. Отдых в отеле Ariadne Beach Hotel Греция от туроператора ЮГО-СТАР.
