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-17:2023-01-17' 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, 32 km from Antalya airport and 5 km from the nearest Kadriye village.
SETTING: The hotel possesses a total of 555 rooms. Standard rooms 244 (25m², main building, max.2 + 1pax); Mimoza garden rooms (35m², in garden, max.3 + 1pax), Junior Suit rooms (main building, one bedroom with max.3 + 1pax reduction), family room (40-45m², two bedrooms with connecting door Camelia Family Superior (50m², in the garden, one bedroom and one bedroom, one bathroom max.4pax), Camelia garden rooms (22m², in garden, max.2 + 1pax) , Jasmine Lake Houses, in the garden and across the pool: Jasmine pool view (42m², one bedroom, one bathroom, max.3 + pax), Jasmine pool view family (80m², two bedrooms with connecting door, max.5 + 1 pax), Jasmine Lagoon (42m², one bedroom, a bathroom and direct access to the pool, max3 + 1 pax). All rooms are equipped with private bathroom with shower, hairdryer, central air conditioning system, direct dial telephone, mini bar (fresh water and refreshments, refreshment daily), cash dispenser, LCD TV, satellite and music channels, WI- FI internet connection in the room, balcony or terrace.
SERVICE: Ultra All inclusive - open buffet for breakfast, late breakfast, lunch, light meals during the day, tea, coffee, cakes, light snacks at midnight, all local drinks and standard drinks from alcoholic and non-alcoholic beverages , ice cream. Not included: imported luxury drinks, A'la Carte restaurants with pre-booking and covered cover, all drinks in cans and bottles, fresh juice, room service.
A'la Carte Restaurant - A'la Carte: Kalamata (Mediterranean & Aegean Cuisine), Grill Restaurant (Mexican & Turkish Cuisine), Steak House (International Cuisine), Ikebana Sushi House (Cuisine of the East) Far East), Confectionery, bars throughout the hotel complex. Free of charge are: doctor, laundry, hairdresser, telephone, fax, internet, shopping center, rent a car. WI - FI internet in the lobby area is free of charge.
PLAZA: The hotel has sandy beach, beds, umbrellas and beach towels are free of charge. Private pavilions are with advance reservation and payment.
SPORTS AND SPORTS: Outdoor and indoor swimming pools, Aqua Park, fitness center, Turkish bath, sauna, tennis court, steam bath, table tennis, beach volleyball, basketball, mini golf. Free of charge: water sports, massages, SPA & Wellnes Center, tennis court, tennis, horse riding, billiards. Daytime entertainment programs, racing near the pool and on the beach, evening show programs, live music a few times a week. Mini Clubs for children aged 04-11 years and junior clubs12-16 for teenagers, zoo.