07.09.2010 05:53
Türkçe
|
English
main page
profile
Search
Services
Infobank(in Turkish)
Contact
News (in Turkish)
İstanbul Umum Emlak Komisyoncuları Odası ve EmlakJET'ten Büyük Anlaşma
Mortgage Brokerları Mesleki Kimliklerine Kavuşuyor
NEDEN EXPO 2015?
Mortgage konutta kaliteyi artıracak
Konut Değerleme Uzmanlığı
14.CEREAN Toplantısı The Marmara Otel'inde Gerçekleşti
Quick Search
EJ-ID:
City:
İstanbul(45)
Kocaeli(İzmit)(1)
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=3647 AND sehir='1' AND (gm_durumu='1' OR gm_durumu='2' OR gm_durumu='9') AND net_yayin='1' AND emlak.semt='821' 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=3647 AND sehir='1' AND (gm_durumu='1' OR gm_durumu='2' OR gm_durumu='9') AND net_yayin='1' AND emlak.semt='823' 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=3647 AND sehir='1' AND (gm_durumu='1' OR gm_durumu='2' OR gm_durumu='9') AND net_yayin='1' AND emlak.semt='890' 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=3647 AND sehir='1' AND (gm_durumu='1' OR gm_durumu='2' OR gm_durumu='9') AND net_yayin='1' AND emlak.semt='896' 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=3647 AND sehir='1' AND (gm_durumu='1' OR gm_durumu='2' OR gm_durumu='9') AND net_yayin='1' AND emlak.semt='919' 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=3647 AND sehir='1' AND (gm_durumu='1' OR gm_durumu='2' OR gm_durumu='9') AND net_yayin='1' AND emlak.semt='930' 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=3647 AND sehir='1' AND (gm_durumu='1' OR gm_durumu='2' OR gm_durumu='9') AND net_yayin='1' AND emlak.semt='945' 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=3647 AND sehir='1' AND (gm_durumu='1' OR gm_durumu='2' OR gm_durumu='9') AND net_yayin='1' AND emlak.semt='951' 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=3647 AND sehir='1' AND (gm_durumu='1' OR gm_durumu='2' OR gm_durumu='9') AND net_yayin='1' AND emlak.semt='963' 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=3647 AND sehir='1' AND (gm_durumu='1' OR gm_durumu='2' OR gm_durumu='9') AND net_yayin='1' AND emlak.semt='964' GROUP BY semt2 ORDER BY semt2_ad
All(45)
All
Ulus(1)
All
Acarkent(1)
All
Sahrayıcedid(3)
All
Merkez(1)
All
Küçükyalı(1)
All
Ömerli(1)
All
Kınalı(1)
All
Ahmetli(1)
All
Atakent(1)
Ihlamurkuyu(1)
All
Bahçelievler(2)
Çamlıca(8)
Çengelköy(5)
Ferah(12)
Kısıklı(2)
Murat Reis(2)
Sultantepe(1)
Yavuztürk(1)
Status:
Select
For sale
For rent
Special
House
Work
Land
With photo only
Recent For Rent
For rent
For rent
İstanbul/Bahçelievler
Type: House
Price: 725TL
EJ-ID: 323350
For rent
İstanbul/Ferah
Type: House
Price: 775TL
EJ-ID: 319875
For rent
İstanbul/Ferah
Type: House
Price: 750TL
EJ-ID: 314662
For rent
İstanbul/Ferah
Type: House
Price: 700TL
EJ-ID: 314258
Recent For Sale
For sale
For sale
İstanbul/Murat Reis
Type: House
Price: 120,000TL
EJ-ID: 326727
For sale
İstanbul/Ferah
Type: House
Price: 159,000TL
EJ-ID: 312398
For sale
İstanbul/Küçükyalı
Type: House
Price: 390,000TL
EJ-ID: 293867
For sale
İstanbul/Ferah
Type: House
Price: 230,000TL
EJ-ID: 279845
Showroom
Exchange Rates
Date :
07.09.2010
Time :
05:53
USD :
1.4936 TL
EUR :
1.9345 TL
Contact
Wec İlke Gayrimenkul
Çamlıca ilke- 2 sitesi
No:77/1 Natoyolu Ferah Mah.
Çamlıca Üsküdar İstanbul
Üsküdar/İstanbul
Tel.1 :
(216)4123030
Tel.2 :
(216)3357576
Mobile1 :
(532)3518530
Fax :
(216)3357576
ilkeemlak.emine@hotmail.com
main page
|
profile
|
Search
|
Infobank(in Turkish)
|
Services
|
Contact
For rent
|
For sale
©2010 Wec İlke
