SELECT * FROM cms_1_shop_categs_hu WHERE SUB='0' AND ACTIVE='1' ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='0' AND ACTIVE='1' AND ( MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="webshop" OR MODULE="workers" OR MODULE="testimonials") ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='85' AND ACTIVE='1' AND ( MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="webshop" OR MODULE="workers" OR MODULE="testimonials") ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='29' AND ACTIVE='1' AND ( MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="webshop" OR MODULE="workers" OR MODULE="testimonials") ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='104' AND ACTIVE='1' AND ( MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="webshop" OR MODULE="workers" OR MODULE="testimonials") ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='83' AND ACTIVE='1' AND ( MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="webshop" OR MODULE="workers" OR MODULE="testimonials") ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='87' AND ACTIVE='1' AND ( MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="webshop" OR MODULE="workers" OR MODULE="testimonials") ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='88' AND ACTIVE='1' AND ( MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="webshop" OR MODULE="workers" OR MODULE="testimonials") ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='89' AND ACTIVE='1' AND ( MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="webshop" OR MODULE="workers" OR MODULE="testimonials") ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='95' AND ACTIVE='1' AND ( MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="webshop" OR MODULE="workers" OR MODULE="testimonials") ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='96' AND ACTIVE='1' AND ( MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="webshop" OR MODULE="workers" OR MODULE="testimonials") ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='97' AND ACTIVE='1' AND ( MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="webshop" OR MODULE="workers" OR MODULE="testimonials") ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='98' AND ACTIVE='1' AND ( MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="webshop" OR MODULE="workers" OR MODULE="testimonials") ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='99' AND ACTIVE='1' AND ( MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="webshop" OR MODULE="workers" OR MODULE="testimonials") ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='100' AND ACTIVE='1' AND ( MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="webshop" OR MODULE="workers" OR MODULE="testimonials") ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='80' AND ACTIVE='1' AND ( MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="webshop" OR MODULE="workers" OR MODULE="testimonials") ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='84' AND ACTIVE='1' AND ( MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="webshop" OR MODULE="workers" OR MODULE="testimonials") ORDER BY NO ASC
SELECT * FROM cms_1_contents_hu WHERE SUB='103' AND ACTIVE='1' AND ( MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="webshop" OR MODULE="workers" OR MODULE="testimonials") ORDER BY NO ASC
SELECT * FROM cms_1_sidebar WHERE CONTENTID="" ORDER BY POSITION ASC
SELECT * FROM cms_1_slider_hu WHERE ACTIVE="1" ORDER BY NUMBER DESC
SELECT * FROM cms_1_pictures WHERE CONTENTID='1' AND CONTENTTYPE='9' ORDER BY ID DESC LIMIT 1
SELECT * FROM cms_1_contents_hu WHERE ACTIVE='1' AND MODULE='home'
SELECT * FROM cms_1_pictures WHERE CONTENTID='1' AND MAIN='1' AND CONTENTTYPE='1'
SELECT * FROM cms_1_contents_hu WHERE ACTIVE='1' AND MAIN!='0' ORDER BY MAIN ASC LIMIT 9
SELECT * FROM cms_1_pictures WHERE CONTENTID='87' AND MAIN='1' AND CONTENTTYPE='1'
SELECT * FROM cms_1_pictures WHERE CONTENTID='88' AND MAIN='1' AND CONTENTTYPE='1'
SELECT * FROM cms_1_pictures WHERE CONTENTID='89' AND MAIN='1' AND CONTENTTYPE='1'
SELECT * FROM cms_1_pictures WHERE CONTENTID='95' AND MAIN='1' AND CONTENTTYPE='1'
SELECT * FROM cms_1_pictures WHERE CONTENTID='96' AND MAIN='1' AND CONTENTTYPE='1'
SELECT * FROM cms_1_pictures WHERE CONTENTID='97' AND MAIN='1' AND CONTENTTYPE='1'
SELECT * FROM cms_1_pictures WHERE CONTENTID='98' AND MAIN='1' AND CONTENTTYPE='1'
SELECT * FROM cms_1_pictures WHERE CONTENTID='99' AND MAIN='1' AND CONTENTTYPE='1'
SELECT * FROM cms_1_pictures WHERE CONTENTID='100' AND MAIN='1' AND CONTENTTYPE='1'
SELECT * FROM cms_1_workers_hu WHERE ACTIVE="1" ORDER BY NO ASC LIMIT 3
SELECT * FROM cms_1_pictures WHERE CONTENTID='6' AND MAIN='1' AND CONTENTTYPE='99'
SELECT * FROM cms_1_pictures WHERE CONTENTID='9' AND MAIN='1' AND CONTENTTYPE='99'
SELECT * FROM cms_1_news_hu WHERE ACTIVE='1' ORDER BY PUBDATE DESC LIMIT 3
SELECT * FROM cms_1_pictures WHERE CONTENTID='4' AND MAIN='1' AND CONTENTTYPE='2'
SELECT * FROM cms_1_pictures WHERE CONTENTID='5' AND MAIN='1' AND CONTENTTYPE='2'
SELECT * FROM cms_1_pictures WHERE CONTENTID='6' AND MAIN='1' AND CONTENTTYPE='2'
SELECT * FROM cms_1_shop_hu WHERE ACTIVE='1' AND MAINPAGE='1' AND STOCK!='1' ORDER BY RAND(),VIEW DESC LIMIT 6
SELECT * FROM cms_1_pictures WHERE CONTENTID='840' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='840' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='855' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='855' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='845' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='845' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='811' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='811' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='878' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='878' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='847' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='847' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_comments WHERE CONTENTTYPE='5' AND ACTIVE='1' ORDER BY RAND() LIMIT 1
SELECT * FROM cms_1_shop_categs_hu WHERE SUB='0' AND ACTIVE='1' ORDER BY NO ASC LIMIT 8
SELECT * FROM cms_1_pictures WHERE CONTENTID='15' AND MAIN='1' AND CONTENTTYPE='89'
SELECT * FROM cms_1_pictures WHERE CONTENTID='19' AND MAIN='1' AND CONTENTTYPE='89'
SELECT * FROM cms_1_pictures WHERE CONTENTID='1' AND MAIN='1' AND CONTENTTYPE='89'
SELECT * FROM cms_1_pictures WHERE CONTENTID='2' AND MAIN='1' AND CONTENTTYPE='89'
SELECT * FROM cms_1_pictures WHERE CONTENTID='3' AND MAIN='1' AND CONTENTTYPE='89'
SELECT * FROM cms_1_pictures WHERE CONTENTID='5' AND MAIN='1' AND CONTENTTYPE='89'
SELECT * FROM cms_1_pictures WHERE CONTENTID='6' AND MAIN='1' AND CONTENTTYPE='89'
SELECT * FROM cms_1_pictures WHERE CONTENTID='7' AND MAIN='1' AND CONTENTTYPE='89'
SELECT * FROM cms_1_shop_categs_hu WHERE ACTIVE='1' AND ID = ''
SELECT * FROM cms_1_shop_categs_hu WHERE ACTIVE='1' AND SUB = ''
SELECT * FROM cms_1_contents_hu WHERE ACTIVE='1' AND MODULE='home' AND SUB='0'
Ingatlan | maingatlan.hu
SELECT * FROM cms_1_news_hu WHERE ACTIVE='1' AND CATEG='1' ORDER BY PUBDATE DESC LIMIT 2
SELECT * FROM cms_1_contents_hu WHERE ACTIVE='1' AND SUB='0' AND ( MODULE="menu" OR MODULE="menu_fullwidth" OR MODULE="contact" OR MODULE="webshop" OR MODULE="workers" OR MODULE="testimonials") ORDER BY NO DESC LIMIT 1
SELECT * FROM cms_1_contents_hu WHERE ACTIVE='1' AND SUB='103' ORDER BY NO ASC
Ingatlan szolgáltatások egy helyen - Minden ami ingatlan
Rólunk mondták
,,
Úgy gondolom napjainkban elengedhetetlen, hogy legyen az ember mellett egy jó ügyvéd, de ez igaz az ingatlan szakértőre is. Emese rendkívül felkészült, türelmes és segítőkész, nem kérdés, hogy számomra ki az, akit bárkinek nyugodt szívvel tudok és fogok ajánlani ingatlannal kapcsolatos ügyben. Köszönöm szépen Emese a segítségedet!
