08.09.2010 13:49 Türkçe  |  English

main page profile Search Services Infobank(in Turkish) Contact Quick Search EJ-ID: City: İstanbul(12) County: SELECT semt.isim AS semt2_ad, semt2, COUNT(emlak.id) AS count FROM emlak LEFT JOIN semt ON semt.id=emlak.semt2 WHERE firma_id=4108 AND sehir='1' AND (gm_durumu='1' OR gm_durumu='2' OR gm_durumu='9') AND net_yayin='1' AND emlak.semt='817' GROUP BY semt2 ORDER BY semt2_adSELECT semt.isim AS semt2_ad, semt2, COUNT(emlak.id) AS count FROM emlak LEFT JOIN semt ON semt.id=emlak.semt2 WHERE firma_id=4108 AND sehir='1' AND (gm_durumu='1' OR gm_durumu='2' OR gm_durumu='9') AND net_yayin='1' AND emlak.semt='840' GROUP BY semt2 ORDER BY semt2_adAll(12)AllKartaltepe(2)Osmaniye(9)AllKabakça Köyü(1) Status: Select For sale For rent Special House Work Land With photo only Recent For Rent For rent For rent İstanbul/Osmaniye Type: House Price: 1,000TL EJ-ID: 71241 For rent İstanbul/Osmaniye Type: House Price: 900TL EJ-ID: 61600 For rent İstanbul/Osmaniye Type: Work Price: 1,100TL EJ-ID: 60730 For rent İstanbul/Osmaniye Type: House Price: 750TL EJ-ID: 60089 Recent For Sale For sale For sale İstanbul/Osmaniye Type: House Price: 180,000TL EJ-ID: 63980 For sale İstanbul/Kartaltepe Type: House Price: 180,000TL EJ-ID: 63813 For sale İstanbul/Kabakça Köyü Type: Land Price: 30,000TL EJ-ID: 60729 For sale İstanbul/Kartaltepe Type: House Price: 280,000TL EJ-ID: 60441 Showroom Exchange Rates Date : 08.09.2010 Time : 13:49 USD : 1.5033 TL EUR : 1.9272 TL Contact Wec Aksu Osmaniye Mah. Ümraniye Cad. No:17/B Bakırköy/İstanbul Tel.1 : (212)4664119 Mobile1 : (535)4338238 Fax : (212)5832634 info@wecaksu.com

main page  |   profile  |   Search  |   Infobank(in Turkish)  |   Services  |   Contact For rent  |   For sale ©2010 Wec Aksu