05.09.2010 15:33
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(982)
Tekirdağ(26)
Edirne(1)
İçel(Mersin)(1)
Kırklareli(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=3149 AND sehir='1' AND (gm_durumu='1' OR gm_durumu='2' OR gm_durumu='9') AND net_yayin='1' AND emlak.semt='812' 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=3149 AND sehir='1' AND (gm_durumu='1' OR gm_durumu='2' OR gm_durumu='9') AND net_yayin='1' AND emlak.semt='815' 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=3149 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=3149 AND sehir='1' AND (gm_durumu='1' OR gm_durumu='2' OR gm_durumu='9') AND net_yayin='1' AND emlak.semt='831' 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=3149 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_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=3149 AND sehir='1' AND (gm_durumu='1' OR gm_durumu='2' OR gm_durumu='9') AND net_yayin='1' AND emlak.semt='913' 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=3149 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=3149 AND sehir='1' AND (gm_durumu='1' OR gm_durumu='2' OR gm_durumu='9') AND net_yayin='1' AND emlak.semt='11000101' 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=3149 AND sehir='1' AND (gm_durumu='1' OR gm_durumu='2' OR gm_durumu='9') AND net_yayin='1' AND emlak.semt='21000301' 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=3149 AND sehir='1' AND (gm_durumu='1' OR gm_durumu='2' OR gm_durumu='9') AND net_yayin='1' AND emlak.semt='21000401' GROUP BY semt2 ORDER BY semt2_ad
All(982)
All
Bağcılar(1)
Fevzi Çakmak(1)
Güneşli(2)
Hürriyet(5)
Kirazlı(2)
Yıldıztepe(1)
All
Bahçelievler(2)
Çalışlar(1)
Çobançeşme(9)
Fevzi Çakmak(16)
Haznedar(1)
Hürriyet(405)
İstanbul Evleri(1)
Kocasinan(112)
Köyiçi(1)
Merkez(3)
Siyavuşpaşa(5)
Soğanlı(8)
Şirinevler(155)
Yayla(1)
Yenibosna(45)
Zafer(119)
All
Ataköy(1)
Cevizlik(2)
Merkez(2)
Zeytinlik(5)
All
Boğazköy(1)
Esenyurt(4)
Güzelce(1)
Kumburgaz(7)
All
Merkez(2)
Yeşilbayır(4)
All
Başak Şehir(1)
Beşyol(2)
Halkalı(2)
Yeşilova(1)
All
Alibey(1)
Çanta(17)
Değirmenköy(1)
Fenerköy(2)
Gazitepe(5)
Gümüşyaka(3)
Kınalı(1)
Merkez(8)
Ortaköy(3)
Selimpaşa(2)
Seymen(1)
All
Merkez(2)
All
Bahçeşehir(1)
All
Haramidere(3)
Sahil(1)
Status:
Select
For sale
For rent
Special
House
Work
Land
With photo only
Recent For Rent
For rent
For rent
İstanbul/Şirinevler
Type: House
Price: 600TL
EJ-ID: 323166
For rent
İstanbul/Hürriyet
Type: House
Price: 400TL
EJ-ID: 323143
For rent
İstanbul/Hürriyet
Type: House
Price: 500TL
EJ-ID: 323087
For rent
İstanbul/Hürriyet
Type: House
Price: 550TL
EJ-ID: 323063
Recent For Sale
For sale
For sale
İstanbul/Hürriyet
Type: House
Price: 115,000TL
EJ-ID: 325811
For sale
İstanbul/Zafer
Type: House
Price: 85,000TL
EJ-ID: 325285
For sale
İstanbul/Şirinevler
Type: House
Price: 120,000TL
EJ-ID: 325205
For sale
İstanbul/Hürriyet
Type: House
Price: 96,000TL
EJ-ID: 324742
Showroom
Exchange Rates
Date :
05.09.2010
Time :
15:33
USD :
1.4994 TL
EUR :
1.9334 TL
Contact
Wec Şirinevler
Hürriyet Cad. No:75
Şirinevler
Bahçelievler/İstanbul
Tel.1 :
(212)5033824
Tel.2 :
(212)5522614
Mobile1 :
(536)7353985
muharremrisvan@hotmail.com
main page
|
profile
|
Search
|
Infobank(in Turkish)
|
Services
|
Contact
For rent
|
For sale
©2010 Wec Şirinevler
