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-16:2023-04-16' 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
Get the celebrity treatment with world-class service at Lujo Hotel A`la Carte All Inclusive
Featuring luxurious retreat with 3 private beaches, 4 different concept outdoor swimming pool and a spa, Lujo Bodrum A`la Carte All Inclusive is situated in Guvercinlik, 26 km from Bodrum. There is a water park on site and guests can enjoy the on-site restaurant and bar. Free WiFi is available throughout the property and free private parking is available on site.
All rooms are luxuriously decorated and provide private balconies or terrace. Nestled within spectacular boulders, villas come with private pools and a garden. Forest rooms offers magnificent sea view and located under the pine trees. Every room at this hotel is air conditioned and comes with a flat-screen TV with satellite channels. Certain units feature walk-in wardrobe and a seating area where you can relax. All rooms have a private bathroom. Some of them comes with double sinks. Extras include bathrobes, slippers and free toiletries.
Boasting several fine dining options, you can enjoy 9 different cuisines in the evenings in the main restaurant with a’la carte service which is open for service 24 hours. For a relaxed dining experience Teppanyaki serves sample delicious meats and fresh seafood paired with cocktails and wines. Pablo Esco Bar serves vintage whiskeys and premium hand-rolled cigars.
This hotel has water sports, cycling and fishing facilities. Alternatively, guests can request for pampering massage and body treatments at the spa. There is also a modern fitness center on site. Kids can get entertained at Kijo Club offering kids' water slides, private music classes, art room, lego room, laser tag, fun and educational workshops and evening programmes tailored for kids
The hotel also offers car hire. Milas-Bodrum Airport is 16.5 km away.
Couples particularly like the location — they rated it 8.9 for a two-person trip.