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 = '39326' ) ) 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
Kasr-I Ala Residences Apartments Istanbul Deniz Istanbul - Ready To Move
Selenium Retro 9 Residences Apartments Istanbul Istanbul - Ready To Move
Selenium Retro Residences Apartments Istanbul Istanbul Ready To Move
Selenium Ataköy Residences Apartments Istanbul Istanbul Ready To Move
Adres Atakent Residences Apartments Istanbul Istanbul Ready To Move
Karat 34 Residences Apartments Istanbul Istanbul Ready To Move
Marina 24 Apartments Istanbul Istanbul - -
Prime Istanbul Residences Apartments Istanbul Istanbul - Ready To Move
Sedef Mansions Apartments Istanbul Deniz Istanbul Ready To Move
Mercan Mansions Apartments Istanbul Deniz Istanbul Ready To Move
Marina Houses Villas Istanbul Deniz Istanbul Ready To Move
Tem Express Apartments Apartments Istanbul Istanbul - Ready To Move
Nurol Park Residences Apartments Istanbul Istanbul - Ready To Move
Time Tower Apartments Istanbul Istanbul - Q2 2022
Mega 2 Blok Flats Apartments Istanbul Istanbul - Q4 2021
5 Levent Apartments Apartments Istanbul Istanbul - Ready To Move
Varlik Tower Apartments Istanbul Istanbul - Ready To Move
Show more
Turkey
+905314375810
Chat on WhatsApp WhatsApp
Callback RequestEmail
Submit your referrals

Contact Turkey

Turkey
10 + 5 =
error: Content is protected !!