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 = '51375' ) ) 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
Lagoon Residences Apartments Muscat Al Mouj Muscat - Ready To Move
Golf Beach Residences Villas Muscat Al Mouj Muscat - Q4 2022
Juman Two Apartments Apartments Muscat Al Mouj Muscat - Ready To Move
Ghadeer Villas Villas Muscat Al Mouj Muscat - Ready To Move
Ghadeer Parks Villas Villas Muscat Al Mouj Muscat - Ready To Move
Juman One Apartments Apartments Muscat Al Mouj Muscat - Ready To Move
Marsa Gardens Apartments Muscat Al Mouj Muscat - Ready To Move

Show more
Al Mouj Muscat
Callback Request
Chat on WhatsApp WhatsApp
ContactEmail
Submit your referrals

Contact Al Mouj Muscat

Al Mouj Muscat
10 + 5 =
testttttttt