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 = '54648' ) ) 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
Ahad Residences Apartments Dubai Business Bay 1,215,512 Q2 2023

Ahad Group is an experienced, quality-driven property developer dedicated to transforming the Dubai skyline through unique and innovative properties.

Show more
AHAD Group
Callback Request
Chat on WhatsApp WhatsApp
ContactEmail
Submit your referrals

Contact AHAD Group

AHAD Group
10 + 5 =
testttttttt