09.09.2010 04: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(333)
Tekirdağ(6)
Balıkesir(1)
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=4133 AND sehir='1' AND (gm_durumu='1' OR gm_durumu='2' OR gm_durumu='9') AND net_yayin='1' AND emlak.semt='811' 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=4133 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=4133 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=4133 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=4133 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=4133 AND sehir='1' AND (gm_durumu='1' OR gm_durumu='2' OR gm_durumu='9') AND net_yayin='1' AND emlak.semt='859' 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=4133 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=4133 AND sehir='1' AND (gm_durumu='1' OR gm_durumu='2' OR gm_durumu='9') AND net_yayin='1' AND emlak.semt='939' 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=4133 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=4133 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=4133 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(333)
All
Ambarlı(1)
Cihangir(1)
Deniz Köşkler(2)
Firüzköy(1)
Gümüşpala(3)
Merkez(2)
Parseller(1)
Üniversite(1)
All
Çamlıkkahve(1)
Çobançeşme(1)
Siyavuşpaşa(1)
Şirinevler(1)
Yenibosna(3)
All
Basınköy(6)
Florya(2)
Osmaniye(1)
All
Ahmediye(1)
Atatürk(1)
Esenyurt(4)
Fatih(1)
Güzelce(1)
Kumburgaz(2)
Mimaroba(5)
Sinanoba(1)
Turgut Özal Bulvarı(1)
All
Kaleiçi(1)
All
Kocamustafapaşa(1)
All
K.Çekmece(3)
Altınşehir(1)
Beşyol(5)
Cennet(158)
Cumhuriyet(26)
Fatih(5)
Gültepe(6)
Halkalı(2)
İnönü(1)
Sefaköy(11)
Sultan Murat(1)
Yeni Mahalle(15)
Yeşilova(41)
Ziya Gökalp(2)
All
Bahçeköy(1)
All
Silivri(1)
Değirmenköy(1)
Ortaköy(1)
All
İstiklal(2)
All
Merkez(3)
Status:
Select
For sale
For rent
Special
House
Work
Land
With photo only
Recent For Rent
For rent
For rent
İstanbul/Cennet
Type: House
Price: 650TL
EJ-ID: 327556
For rent
İstanbul/Cennet
Type: House
Price: 550TL
EJ-ID: 327517
For rent
İstanbul/Cennet
Type: Work
Price: 500TL
EJ-ID: 326158
For rent
İstanbul/Cennet
Type: House
Price: 650TL
EJ-ID: 324950
Recent For Sale
For sale
For sale
İstanbul/Beşyol
Type: Work
Price: 200,000TL
EJ-ID: 323555
For sale
İstanbul/Cennet
Type: House
Price: 140,000TL
EJ-ID: 323205
For sale
İstanbul/Yeşilova
Type: House
Price: 200,000TL
EJ-ID: 322761
For sale
Tekirdağ/Yenice
Type: House
Price: 300,000TL
EJ-ID: 322105
Showroom
Exchange Rates
Date :
09.09.2010
Time :
04:33
USD :
1.5033 TL
EUR :
1.9272 TL
Contact
Wec Berhan
Cennet Mah. Tunç Sok. No:12/1
K.Çekmece/İstanbul
Tel.1 :
(212)6244295
Mobile1 :
(532)6118082
Fax :
(212)6240785
gurkanli@hotmail.com
main page
|
profile
|
Search
|
Infobank(in Turkish)
|
Services
|
Contact
For rent
|
For sale
©2010 Wec Berhan
