SELECT SQL_CALC_FOUND_ROWS wp_rh9xgp_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wp_rh9xgp_postmeta price_meta2 WHERE price_meta2.post_id=wp_rh9xgp_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2021-01-18:2023-01-18' LIMIT 1), 0) accommodation_price FROM wp_rh9xgp_posts JOIN wp_rh9xgp_icl_translations wpml_translations
ON wp_rh9xgp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_rh9xgp_posts.post_type) LEFT JOIN wp_rh9xgp_icl_translations wpml_translations_default ON wpml_translations_default.trid = wpml_translations.trid AND wpml_translations_default.source_language_code IS NULL WHERE 1=1 AND wp_rh9xgp_posts.post_type = 'accommodation' AND ((wp_rh9xgp_posts.post_status = 'publish')) AND ( ( ( wpml_translations.language_code = 'en' OR (
wpml_translations.language_code = 'en'
AND wp_rh9xgp_posts.post_type IN ( 'product' )
AND ( (
( SELECT COUNT(element_id)
WHERE trid = wpml_translations.trid
AND language_code = 'en'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM wp_rh9xgp_icl_translations t2
JOIN wp_rh9xgp_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'en'
p.post_status = 'publish' OR
p.post_type='attachment' AND p.post_status = 'inherit'
) = 0 ) )
) ) AND wp_rh9xgp_posts.post_type IN ('post','page','attachment','custom_css','customize_changeset','oembed_cache','user_request','wp_block','wpforms','wpb_safe-file','wpb_safe-metrics','wp-backitup_backup','wp-backitup_restore','wp-backitup_cleanup','location','extra_item','room_type','accommodation','tour','cabin_type','cruise','car_rental','product','product_variation','shop_order_refund','wpcf7_contact_form' ) ) OR wp_rh9xgp_posts.post_type NOT IN ('post','page','attachment','custom_css','customize_changeset','oembed_cache','user_request','wp_block','wpforms','wpb_safe-file','wpb_safe-metrics','wp-backitup_backup','wp-backitup_restore','wp-backitup_cleanup','location','extra_item','room_type','accommodation','tour','cabin_type','cruise','car_rental','product','product_variation','shop_order_refund','wpcf7_contact_form' ) ) GROUP BY wp_rh9xgp_posts.ID HAVING 1=1 ORDER BY wp_rh9xgp_posts.post_date DESC LIMIT 0, 3
Position: The hotel is located in the Belek region 45 km from Antalya and 35 km from the airport.
Location: The hotel possesses a total of 375. There are rooms in the main building 209 and in the tourist building 166. Standard rooms of the main buildings (30m², max.2 + 1pax), family rooms (45m², two bedrooms with doors in the middle, two bathrooms max .2 + 2pax). Tourist building: standard rooms (35m², max.2 + 1pax), family rooms 16 (two bedrooms with doors in the middle, two bathrooms, max.4pax). Also there are 81 luxury family rooms (two bedrooms, two bathrooms, but no door between rooms). All rooms are equipped with balcony, sea view or garden (optional), private bathroom with bathtub and shower, hairdryer, central air-conditioning, direct dial telephone, carpeted floors, safe, mini bar, TV satellite and music channels, FI internet connection, balcony.
Service: Ultra All Inclusive - open buffet for breakfast, late breakfast, lunch, afternoon light meals, afternoon ice cream at Likya bar, dinner, late evening dress. All local drinks and some standards of alcoholic beverages and liquids, mini bars of water, juices and beers are refilled every day. A'la Carte restaurants Dynasty, Sushida and Tandori are on prior reservation, room service between 02:00 and 04:30 is free of charge for certain types of meals. They are not included in the concept: luxury beverage from imports, all bottled drinks, specialty wines, fresh juice, ice cream in packing, room service from 04:30 until 02:00, La Cucina, Poseidon and El Saguaro A`la Restaurant cards are subject to prior reservation and payment.
Contents: Main restaurant Pinea, open buffet, A'la Carte restaurants: Dynasty (Turk), Laila (Italian), El Saguaro (Mexican), Poseidon (fish), Sushida (Japanese), Tandori (Indian) hotel complexes. Shopping center, hairdresser, doctor, caretaker, clothes washing and dry cleaning, beauty center and spa, telephone and fax, internet cafe and computer games are at a charge.
Beach: The hotel has a private sandy beach. Towels, beds and umbrellas are free of charge. Private sunbeds on the beach are subject to prior reservation and payment.
Sports and entertainment: Pool with separate swimming pools, indoor swimming pool, water slide, fitness center, sauna, Turkish bath, Jacuzzi, tennis courts, tennis courts, table tennis, basketball, volleyball, beach volleyball, motorized are free of charge. With extra charge equipment, lessons, bowling, billiards, motorized water sports, massage, wellness & SPA center. Music programs at the time of the day, pool and beach races, show the programs in the evenings. Mini Club for children from 04 to 12 years old and Junior Club from 13 to 16 years old, with professional staff during the day and early evening.