Emlak Arama
Adress Emlak

Kiralık Konut  (16)

select * from ilanlar where yayin ='1' AND durum = 1 AND tip = 31 order by reklam5 desc, id desc limit 0, 100