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-27:2022-10-27' 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 Kundu region, 20 km from Antalya airport, 17 km from Antalya center.
Placement: The rooms are located in five blocks. Luxury room (34m², one bedroom with a French bed + one single bed, one bathroom, max.2 + 2pax), Superior luxury room (37m², located on the 2nd and 4th floor of the building, (40m², located on the ground floor of the blocks, two bedrooms with doors in the middle, one bathroom, max.4pax / terrace), Deluxe Family Room (46m², located at the ends of the blocks, two bedrooms with a door in the middle, a bathroom, max. 4pax), Deluxe Duplex family rooms (59m², located on the last floor of the blocks, with French bed, upper floor with two single beds, there is a door between the floors, two bathrooms, max.5pax) All rooms They have private bathrooms with shower, hairdryer, individual air-conditioning system, direct dial telephone, mini bar (water, mineral water, refreshing daily refreshments), tea, tea and coffee set, and music channels, laminated floors , balcony or terrace.
Service: Ultra All-inclusive, open buffet for breakfast, late breakfast, lunch, snacks during the day, dinner, evening dinner, early morning. All soft and local alcoholic drinks and standard imported drinks, mini bars in the rooms, ice cream during certain hours, patisserie. Not included: premium premium drinks, special wines, fresh fruit juices, A'la Carte restaurants with advance booking and with extra charge, energy drinks, room service, water pipe.
Contents: The main restaurant with open buffet,, A'la Carte restaurants - Turkish and international cuisine, bars around the hotel complex. The doctor, laundry and dry cleaning, babysitting, telephone, fax, internet and computer games, rent a car and shopping center are due to charge. Wi-Fi internet connection (low speed) in all hotels is free of charge.
Beach: The private sandy beach of the hotel. Sun beds, sun umbrellas and beach towels are free of charge. Private pavilions on the beach with advance reservation and with extra charge.
Sports and recreation: Outdoor and indoor pools for adults and children, water slides, tennis courts, basketball, beach volleyball, fitness center, sauna, Turkish bath. Free of charge: water sports, SPA & wellness center, massage, tennis court lighting. Daytime entertainment programs, pool and beach races, evening shows live music programs, disco. Mini Club for children from 04 to 12 years old, with various programs during the day and Mini Disco in the evening.
Note: It is not possible to use Asteria Kremlin Place Hotel facilities or to go from one hotel to another as before.