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-22:2023-01-22' 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, 35 km from Antalya airport.
Location: The hotel possesses a total of 595 in a main building, in the Villa and Lagoon area is located 200 meters from the main building. Standard rooms in the main building DZX2 (26m², one bedroom with French bed + sofa bed, one bathroom, max.2 + 1pax), standard bungalow room in the cottage part DZX1 (22-24m², one bedroom with French bed,. 2 double bedrooms (49m2, one bedroom with French bed + sofa bed, bathroom, max.3 + 1pax), Family room in the main building FZX2 (38m², two bedrooms, bathroom, max. .3 + 1pax), Family Lagoon FZX3 in the lagoon (58m², two bedrooms, bathroom, direct access to the pool, max.3 + 1pax). All rooms have private bathroom with shower, hairdryer, separate air-conditioning system, direct dial telephone, mini bar (water, soft drinks upon arrival), safe box, LCD satellite TV and music channels, laminate flooring , Free Wi-Fi internet (All rooms are approximately 350 - 400m from the beach)
Service: Ultra All Inclusive - open buffet, breakfast service, late breakfast, lunch, dinner, snack during the day and light snack at night, local alcoholic and non-alcoholic drinks, A'la Carte (Turkish, Italian, International) restaurants with reservations in advance and once in a stand. Not included: imported drinks, fresh fruit juices, specialty wines, all bottled drinks, room service, Japanese restaurants A'la Carte with advance booking and with extra charge, room service.
Content: Main restaurant with open buffet, A'la Carte Restaurants: Fish, Turkey, Japan, International, bars around the hotel complex, Disco bar. Doctor, laundry, hair-chair, telephone, fax, internet cafe, shopping area, car hire are extra charge. The Wi-Fi internet in the Lobby area and the rooms is free of charge.
Beach: The hotel's beach, with sand and pebble, with sun beds, sun umbrellas and beach towels are free of charge.
Sports and recreation: Open and indoor pools for adults and children, water slides, Turkish bath, sauna, fitness center, tennis courts, table tennis, beach volleyball. Water sports, floodlighting for tennis courts and equipment, massage, SPA center, billiards, computer game and golf are at extra charge. Entertainment programs during the day, races, evening show programs. Mini-club for children in different age groups from 03 to 16 years old divided into groups of ages with programs during the day and in the evening.