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`="deira-creek"

Deira Creek

Deira creek is the lifeline and pulses of the city which separates the city from deira to the north and burdubai to the south. dubai creek previously extended to ras al khor wild life sanctuary but as a part of new dubai canal it is extended through the arabian gulf.

© All rights reserved 2024 Leos yacht.