SELECT wpey_posts.*, 1 rooms_available, 0 rooms_booked , IFNULL((SELECT price_meta2.meta_value + 0 FROM wpey_postmeta price_meta2 WHERE price_meta2.post_id=wpey_posts.ID AND price_meta2.meta_key='_accommodation_min_price:2026-04-24:2028-04-24' LIMIT 1), 0) accommodation_price , IFNULL((SELECT price_meta3.meta_value + 0 FROM wpey_postmeta price_meta3 WHERE price_meta3.post_id=wpey_posts.ID AND price_meta3.meta_key='accommodation_static_from_price' LIMIT 1), 0) accommodation_static_price
FROM wpey_posts INNER JOIN wpey_postmeta ON ( wpey_posts.ID = wpey_postmeta.post_id )
WHERE 1=1 AND (
( wpey_postmeta.meta_key = 'accommodation_location_post_id' AND wpey_postmeta.meta_value IN ('1534') )
) AND wpey_posts.post_type = 'accommodation' AND ((wpey_posts.post_status = 'publish'))
GROUP BY wpey_posts.ID HAVING 1=1
ORDER BY wpey_posts.post_title ASC
From
$
Designed in a contemporary style, Habtoor Grand Resort, Autograph Collection, overlooks the Arabian Gulf and provides guests with a comfortable base from which to explore Dubai. There are various on-site restaurants and bars to choose from, serving Middle Eastern, Italian, and international cuisines. Dubai Marina Walk, the chic waterfront, is 0.6 miles (1 kilometer) from the resort and is home to designer shops and outdoor pop-ups. ALL-INCLUSIVE/MEAL-PLAN PURCHASE IS MANDATORY; IT MAY BE BASED ON A 7-NIGHT STAY AND MAXIMUM OCCUPANCY
Unfortunately no cruises were found.
Unfortunately no car rentals were found.