SELECT `ujingatlan`.`azonosito`,`ujingatlan`.`jelleg`,`ujingatlan`.`ear`,`ujingatlan`.`terulet`,`ujingatlan`.`terulet2` FROM `ujingatlan` LEFT JOIN `ingatlan_ext` ON `ujingatlan`.`azonosito` = `ingatlan_ext`.`azonosito`AND `ujingatlan`.`kieg` = `ingatlan_ext`.`kieg` JOIN `listak_jellegek` ON `listak_jellegek`.`lj_id` = `ujingatlan`.`jelleg` JOIN `listak_megyekkeruletek` ON `listak_megyekkeruletek`.`lmk_id` = `ujingatlan`.`helyseg` JOIN `ovezetek` ON `ovezetek`.`ovezetid` = `ujingatlan`.`ovezet` WHERE kereskinal= '2' AND archive= '' AND (1=1) AND (ujingatlan.privat = 0 AND ujingatlan.front=1 AND ujingatlan.lcn=1 AND (`ujingatlan`.`kieg` IN ('_v','_hitel','_leebesfia','_as','_csaszi','_webing2','_marker','_maxingatlan','_ci','_bj','_bin','_laha','_sopron','_peen','_op','_bh','_bhi','_gb','_nlak','_eb','_ai','_az','_mo','_ott','_astra','_hi','_nlev','_mil','_kj','_mj','_bet','_pr','_pre','_sis','_bl','_boi','_dim','_mix','_cas','_bp','_rid','_mk','_ujei','_nh','_sii','_kejo','_pla','_mlux','_cc','_whit','_bb','_idea','_ipl','_evob','_blm','_bli','_ide','_zlc','_jobt','_ahi','_cai','_ol','_red','_ic','_ben','_csll','_one','_sza','_cii','_mfw','_ets','_kov','_na','_rar','_kgy','_int','_dotimp','_mad','_ema','_ehm','_tb','_keu','_trb','_pat','_pic','_jd','_czp','_uho','_btj','_gaimp','_szli','_kk','_den','_hiteladam','_dan','_kem','_afo','_gyf','_kh','_agr','_mszf','_pck','_pel','_ihs','_pi','_gz','_pp','_adimp','_ocgi','_ar','_bhv','_sbr','_pbx','_ik','_kor','_koimp','_te','_la','_np','_ipe','_per','_matm','_gm','_drh','_bm','_rtd','_itr','_njk','_hel','_pkl','_otc','_kpz','_ph','_pl','_kg','_ktn','_oad','_hx','_szie','_kf','_med','_mhi','_fiimp','_bel','_jkr','_tkimp','_isz','_kk2','_gci','_eli','_mb','_pt','_at','_nco','_er','_sri','_pbl','_gbn','_mkr','_pbs','_hfh','_dj','_mib','_hzs','_biz','_brz','_inc','_hah','_mmo','_nii','_bpx','_cni','_in','_ps','_kol','_zt','_fum','_szp','_hhi','_kd','_fvt','_fmk','_szis','_pih','_bho','_pal','_thh','_bf','_eni','_kot','_ji','_szt','_hhy','_gyb','_rds','_gll','_tkt','_k2h'))) AND `jelleg` IN (12) AND `uj` = 'on' AND `uj` = 'ujsz' AND `uj` NOT IN('ujsz', 'on') AND `ert_allapot` in (0,2) AND `masaltalfelvitt` in (0,1) AND ((`ujingatlan`.`helyseg` > 23)) Építési telek keresése országszerte

+36-30-328- info@