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=2 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 = 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 = 2 LEFT JOIN valuta v ON o.valuta_id=v.valuta_id WHERE o.publikuvaj = 1 AND oim.imot_id IN (47〈=bg) AND o.tip_id = 1 ORDER BY o.data_aktualizaciq DESC

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

.: SG Estates :.

Find Property

Bulgarian National Bank exchange rates as on 09.4.2012
1EUR1.9558 BGN
1USD1.4914 BGN
1GBP2.3653 BGN
1CHF1.6262 BGN
100JPY1.8368 BGN


For sale

No properties found based on the selected criteria.