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:2020-10-28:2022-10-28' 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','wpforms_log','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','wpforms_log','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 city center and 35 from the airport.
Setting: Total number of rooms 503 in three hotel blocks. Standard room with bunk bed (23-28m², one bedroom with French bed + double bed + double bed, one bathroom, one bedroom, one bedroom, max.3 + 2pax), family room (31m², two bedrooms with doors in the middle, one bathroom, max.4pax). All rooms have private bathroom with bathtub, shower and hairdryer, central air-conditioning system, direct dial telephone, laminated flooring, safe box, mini bar (refreshing water and refreshed daily), satellite TV and music channels, WI-FI internet service, balcony or terrace.
Service: Ultimate all inclusive - 24 hour food and drink service. Good morning fresh towels and traditional Turkish drinks - after arrival, morning, late morning, lunch and dinner, buffet diet, special buffet for children, open-air restaurants during the day, ice cream service at the bar from 17:00 to 19:00, cakes afternoon tea and coffee, evening dinner in the evening, all local and standard alcoholic and non-alcoholic drinks, restaurants A'la Carte with advance reservation and once in a stay (children under 7 are not allowed to enter). Not included in the comprehensive concept: premium alcoholic beverages, international and special wines, room service, fresh fruit juices, Italian and Mexican restaurants A'la Carte, imported spirits from 23:00 to 10:00.
Content: Main restaurant A'la Carte restaurants - Turkish, Fish, Mexican and Italian, pool bar, lobby bar, snack bar and restaurant. Shops, hair, doctor, babysitting, laundry and dry cleaning, car hire, telephone, fax, internet corner and game room are charged extra.
Beach: Private hotel beach, with sand, with towels, sun beds and sun umbrella free of charge. The private rooms on the beach are at extra charge.
Sports and entertainment: Indoor and indoor swimming pools for adults and children, water park, gym, Turkish bath, sauna, steam room, 5 tennis courts, table tennis, volleyball, basketball, mini football, beach volleyball. Not included: SPA and wellness center, reflective spotlight for tennis courts, tennis equipment, bowls, billiards and computer games, all water sports, golf (shuttle service to Titanic Golf is free of charge). Music programs with highly professional team during the day and special show programs in the evenings. Kids Crispy Kids mini club for children from 04 to 12 years old, are available during the day and mini disco in the evening.