select `post`.*,`medias`.`m_img`,`categories`.`cat_name`,`cat_b`.`m_img` as `cat_banner` from `post` left join `medias` on `medias`.`i_id`=`post`.`t_img`left join `categories` on `categories`.`id`=`post`.`cat_id` left join `medias` cat_b on `cat_b`.`i_id`=`categories`.`b_img` WHERE `post`.`post_type`="destination" and `post`.`hide_pro`=0 and `post`.`url_name`="jbr"


Dubai's most popular hangout place where the city meets the sea, jbr offers white sands with clear turquoise blue water, stunning skyscrapers, beach entertainments, adventures, restaurants /pubs, street foods and many more.

© All rights reserved 2024 Leos yacht.