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 Side, 60 km from Antalya airport, 5 km from Manavgat and 1 km from Side.
Vendossja: The hotel possesses a total of 760. There are rooms in the main building and at Villa & Lake Villas. Main building rooms: Standard room (31m², one bedroom, one bathroom, max.2 + 1pax), Family room (43m², two bedrooms with connecting doors, one bathroom, max.4pax), Suite rooms (91m², one bedroom and a living room, bathroom with Jacuzzi, max4pax) and a King suit. Villa Lake s (located behind the main building and spread over 13 blocks): Standard Villa & Lake (31m², some of these rooms have direct access to the pool and can be found on the first or second floor, max .3pax), Villa & Lake family rooms (54 m², double with direct pool access, ceramic floor, max 4pax). All rooms have private bathrooms with shower and bathtub, hairdryer, central air-conditioning system, direct dial telephone, mini bar (water, refreshing drinks and refilled beer every day), safe box, TV and music channels, WI-FI internet connection, balcony or terrace. The cottage rooms are behind the main building in the garden area.
Service: Ultra All Inclusive - open buffet for breakfast, late morning, lunch, light afternoon meals, coffee and cakes, dinners and midnight snacks. All local and standard drinks from alcoholic and non-alcoholic beverages, orange juice only for breakfast, A'la Carte restaurants with advance reservation, mini bar in the rooms (with water, juices and refilled beers twice a week) are included in the concept. They are not involved in the concept: special drink from imported, fresh juice, specialty drinks and bottled drinks.
Content: Main restaurant with open dressing. A'la Carte restaurants: Italian, Fish, Mexican, Turkish, Fond, BBQ and Far East, lobby bar, near the pool and on the beach, disco bar. Medical service, caretaker, washing and dry cleaning, hairdresser, shopping center, telephone, fax, internet and computer games, rent a car are at a charge.
Beach: The hotel has private beach, pebble and sand, beds, umbrellas and beach towels are free of charge.
Sports and entertainment: The hotel has 6 swimming pools for adults and children, an indoor pool with hot water, water slides, fitness center, tennis court, table tennis, football, beach volleyball, mini golf are included in the price. Massage, Turkish bath, sauna, wellness & spa center, bowling alley, tennis court, billiards, water sports are at a charge. Entertainment program during the day, racing near the pool and on the beach, evening show program, live music, Disco Club. Special programs for children at the Mini Club. Luna Park - the first two tickets are free.