08.09.2010 13:46
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(12)
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=4108 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=4108 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_ad
All(12)
All
Kartaltepe(2)
Osmaniye(9)
All
Kabakça Köyü(1)
Status:
Select
For sale
For rent
Special
House
Work
Land
With photo only
Recent For Rent
For rent
For rent
İstanbul/Osmaniye
Type: House
Price: 1,000TL
EJ-ID: 71241
For rent
İstanbul/Osmaniye
Type: House
Price: 900TL
EJ-ID: 61600
For rent
İstanbul/Osmaniye
Type: Work
Price: 1,100TL
EJ-ID: 60730
For rent
İstanbul/Osmaniye
Type: House
Price: 750TL
EJ-ID: 60089
Recent For Sale
For sale
For sale
İstanbul/Osmaniye
Type: House
Price: 180,000TL
EJ-ID: 63980
For sale
İstanbul/Kartaltepe
Type: House
Price: 180,000TL
EJ-ID: 63813
For sale
İstanbul/Kabakça Köyü
Type: Land
Price: 30,000TL
EJ-ID: 60729
For sale
İstanbul/Kartaltepe
Type: House
Price: 280,000TL
EJ-ID: 60441
Showroom
Exchange Rates
Date :
08.09.2010
Time :
13:46
USD :
1.5033 TL
EUR :
1.9272 TL
Contact
Wec Aksu
Osmaniye Mah. Ümraniye Cad. No:17/B
Bakırköy/İstanbul
Tel.1 :
(212)4664119
Mobile1 :
(535)4338238
Fax :
(212)5832634
info@wecaksu.com
main page
|
profile
|
Search
|
Infobank(in Turkish)
|
Services
|
Contact
For rent
|
For sale
©2010 Wec Aksu
