04.09.2010 23:25
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(79)
Çanakkale(2)
Tekirdağ(2)
Bursa(1)
İzmir(1)
Kırklareli(1)
Muğla(1)
Sakarya(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=2933 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=2933 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=2933 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=2933 AND sehir='1' AND (gm_durumu='1' OR gm_durumu='2' OR gm_durumu='9') AND net_yayin='1' AND emlak.semt='858' 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=2933 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=2933 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=2933 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(79)
All
Cihangir(1)
Gümüşpala(1)
All
B.Çekmece(2)
Albatros(2)
Atatürk(2)
Boğazköy(1)
Dizdariye(1)
Esenkent(1)
Esenyurt(1)
Fatih(7)
Kumburgaz(2)
Merkez(1)
Mimarsinan(2)
Tepecik(2)
Turgut Özal Bulvarı(2)
All
Hadımköy Beldesi(1)
All
Kemerburgaz(1)
All
Ortaköy(1)
All
Hadımköy(1)
All
Adnan Kahveci(1)
Beykent(18)
Cumhuriyet(10)
Gürpınar(8)
Haramidere(2)
Merkez(7)
Yeşilkent(1)
Status:
Select
For sale
For rent
Special
House
Work
Land
With photo only
Recent For Rent
For rent
For rent
İstanbul/Merkez
Type: House
Price: 500TL
EJ-ID: 324722
For rent
İstanbul/Atatürk
Type: House
Price: 600TL
EJ-ID: 319339
For rent
İstanbul/Beykent
Type: House
Price: 850TL
EJ-ID: 318055
For rent
İstanbul/Albatros
Type: House
Price: 600TL
EJ-ID: 314663
Recent For Sale
For sale
For sale
İstanbul/Dizdariye
Type: House
Price: 130,000TL
EJ-ID: 325013
For sale
İstanbul/Hadımköy
Type: Land
Price: 1,350,000USD
EJ-ID: 324067
For sale
İstanbul/Beykent
Type: House
Price: 130,000TL
EJ-ID: 314391
For sale
Sakarya/Erenler
Type: Work
Price: 870,000TL
EJ-ID: 311858
Showroom
Exchange Rates
Date :
04.09.2010
Time :
23:25
USD :
1.4994 TL
EUR :
1.9334 TL
Contact
Wec Çağdaş
Cumhuriyet Mah. Beykent Çarşısı N:215 Beykent
B.Çekmece/İstanbul
Tel.1 :
(212)8712070
Mobile1 :
(212)8712071
Fax :
(212)8713423
info@weccagdasemlak.com
main page
|
profile
|
Search
|
Infobank(in Turkish)
|
Services
|
Contact
For rent
|
For sale
©2010 Wec Çağdaş
