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-04-15:2023-04-15' 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 Lara region, 15km from Antalya airport and 17km from the city center. The hotel is directly on the beach.
Location: The hotel has a total of 457 rooms. Superior standard rooms (36m², one bedroom, one bathroom, max.3 + 1pax), Junior Suita (70m², one bedroom, one room of the day, one bathroom and Jacuzzi in the bedroom with the middle door, max.4pax) , 20 family rooms (48m², duplex, rooms on the upper floor and bathroom with shower, downstairs is one bedroom with one bed, one bath with bathtub, max.4pax) and two Royal King suites (80m², two rooms bedroom, one day room, two bathrooms, max.4pax) and 4 disabled rooms. All rooms are very comfortable with balcony, private bath with shower / bath, hairdryer, central air conditioning system, direct phone, floor carpet, mini bar (juices and beer, refilled every day), cash register and satellite TV with music channels, WI-FI internet.
Service: Ultra All Inclusive - open buffet for breakfast, late breakfast, lunch, diet buffet and children's cupboard, beach food, dinners, light meals in late hours. All local alcoholic and non-alcoholic drinks and imported drinks, tea, coffee, A'la Carte restaurant with advance reservation (one restaurant per week), ice cream during lunch and dinner. Free: room service, fresh juice, fresh fruits and vegetables, imported champagne, imported luxury drinks such as old whiskey, cognac etc. all local and imported bottled wines. Second use at A'la Carte restaurant during your stay is at extra charge.
Contents: Main restaurant with open buffet, A'la Carte restaurants - Sahan (Turkish cuisine), Gondol (Italian cuisine), Bambo Garden (middle east kitchen) and Deep Sea (seafood), Passticeri, bars along the catering complex with 24 hours of service. Free of charge: doctor, caretaker, laundry and dry cleaning, hairdresser, beauty center, rent a car, telephone, fax, internet café, computer games, shopping center.
Beach: The hotel has private sandy beach, beds, sun umbrellas and towels are free of charge.
Sports and Entertainment: The outdoor and indoor pool for adults and children, the Aqua Park (9 water slides and a swimming pool) and the Luna Park (mole goes round), the fitness center, Turkish bath, sauna, Jacuzzi, steam room, tennis court, beach volleyball, ping-pong are free of charge. Free of charge: tennis courts and tennis schools, massages, bowling, billiards, water spores, diving school, beauty salon and SPA center. Daytime entertainment programs, competing games, evening show programs with professional groups. Mini Club for Kids and Junior Club for Teenager. Mini club for children aged from 04 to 12 years.