SELECT wp_posts.* FROM wp_posts LEFT JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id AND wp_postmeta.meta_key = 'wpcf-bedroomscat' ) LEFT JOIN wp_postmeta AS mt1 ON ( wp_posts.ID = mt1.post_id ) WHERE 1=1 AND ( wp_postmeta.post_id IS NULL AND ( mt1.meta_key = 'property_agent' AND mt1.meta_value = '52170' ) ) AND wp_posts.post_type = 'property' AND ((wp_posts.post_status = 'publish')) AND (wp_posts.post_content='' OR wp_posts.post_content LIKE '%![:en!]%' ESCAPE '!' OR wp_posts.post_content LIKE '%%' OR (wp_posts.post_content NOT LIKE '%![:!]%' ESCAPE '!' AND wp_posts.post_content NOT LIKE '%%')) GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC ')
Project NameProperty TypeDevelopment NameMin. PriceCompletion Date
Edison House Apartments Apartments Dubai Dubai Residential Complex 793,315 Q4 2022
AG Tower Apartments Dubai Business Bay 963,450 Ready To Move

Arabian Gulf Properties is one of the leading property developers, and this developer has proved its genius by developing a diverse range of projects, including health spas, mixed-use community complexes, hotels, and strategically positioned retail businesses.

Show more
Arabian Gulf Properties
Callback Request
Chat on WhatsApp WhatsApp
ContactEmail
Submit your referrals

Contact Arabian Gulf Properties

Arabian Gulf Properties
10 + 5 =
testttttttt