09.09.2010 07:06
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(32)
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=2932 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=2932 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(32)
All
Albatros(1)
Büyükşehir(4)
All
Adakent(1)
Beykent(1)
Gürpınar(2)
Merkez(22)
Yeşilkent(1)
Status:
Select
For sale
For rent
Special
House
Work
Land
With photo only
Recent For Rent
For rent
For rent
İstanbul/Gürpınar
Type: Land
Price: 4,000TL
EJ-ID: 191694
For rent
İstanbul/Adakent
Type: House
Price: 650TL
EJ-ID: 191666
For rent
İstanbul/Merkez
Type: Work
Price: 2,000TL
EJ-ID: 132538
For rent
İstanbul/Merkez
Type: House
Price: 550TL
EJ-ID: 128325
Recent For Sale
For sale
For sale
İstanbul/Gürpınar
Type: House
Price: 90,000,000TL
EJ-ID: 191688
For sale
İstanbul/Büyükşehir
Type: House
Price: 105,000,000TL
EJ-ID: 191684
For sale
İstanbul/Merkez
Type: House
Price: 105,000,000TL
EJ-ID: 191662
For sale
İstanbul/Merkez
Type: House
Price: 120,000,000TL
EJ-ID: 152181
Showroom
Exchange Rates
Date :
09.09.2010
Time :
07:06
USD :
1.5033 TL
EUR :
1.9272 TL
Contact
Wec Beylikdüzü
Beylikdüzü Plaza İş Merkezi No:2
B.Çekmece/İstanbul
Tel.1 :
(212)8733030
Mobile1 :
(532)3326884
Fax :
(212)8726650
sahin_ozgur78@hotmail.com
main page
|
profile
|
Search
|
Infobank(in Turkish)
|
Services
|
Contact
For rent
|
For sale
©2010 Wec Beylikdüzü
