SELECT o.obqva_id AS o_id, oo.ime AS o_ime, img.img_id AS i_id, img.ifile AS ifile, img.width_sr AS iw, img.height_sr AS ih, img.width_th AS itw, img.height_th AS ith, sp.selishte_id, sp.ime, oo.opis_txt AS o_descr, o.tip_id AS o_tip, ooe.ime AS e_ime, ooe.opis_txt AS e_descr, o.cena AS o_c, o.cena_ot AS o_co, o.cena_zakvm AS o_ckvm, o.cena_otdo AS o_cotdo, v.akronim AS v_akr, o.text_id AS o_tid, o.kvadratura AS o_k, o.kvadratura_min AS o_km, o.valuta_id AS o_valuta FROM obqva o LEFT JOIN obqva_opisanie oo ON o.obqva_id=oo.obqva_id AND oo.ezik_id=1 LEFT JOIN obqva_opisanie ooe ON o.obqva_id=ooe.obqva_id AND ooe.ezik_id=2 LEFT JOIN obqva_img oi ON o.obqva_id = oi.obqva_id AND oi.red = 1 LEFT JOIN img img ON oi.img_id = img.img_id LEFT JOIN obqva_selishte os ON os.obqva_id = o.obqva_id LEFT JOIN selishte s ON s.selishte_id = os.selishte_id LEFT JOIN selishte sup ON s.selishte_up_id = sup.selishte_id LEFT JOIN obqva_imot oim ON oim.obqva_id = o.obqva_id LEFT JOIN selishte_prevod sp ON s.selishte_id = sp.selishte_id AND sp.ezik_id = 1 LEFT JOIN valuta v ON o.valuta_id=v.valuta_id WHERE o.publikuvaj = 1 AND oim.imot_id IN (30〈=bg) AND o.tip_id = 3 ORDER BY o.data_aktualizaciq DESC

#1054 - Unknown column '30〈' in 'where clause'

.: SG Estates :.

Tърсене на имот

Валутни курсове на БНБ към 09.4.2012
1EUR1.9558 BGN
1USD1.4914 BGN
1GBP2.3653 BGN
1CHF1.6262 BGN
100JPY1.8368 BGN

Имоти

Отдава под наем

Няма открити имоти според зададения от Вас критерий.