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='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_shop_hu WHERE MAINPAGE='1'
SELECT * FROM cms_1_pictures WHERE CONTENTID='540' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='541' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='542' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='543' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='544' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='548' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='549' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='589' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='590' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='592' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='593' AND MAIN='1' AND CONTENTTYPE='88'
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='8' AND MAIN='1' AND CONTENTTYPE='99'
SELECT * FROM cms_1_pictures WHERE CONTENTID='7' 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='549' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='549' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='541' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='541' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='542' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='542' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='589' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='589' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='590' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='590' 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='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_pictures WHERE CONTENTID='8' 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
,,
És akkor végre összehozott a sors Emesével. Házvásárláskor már a végét jártuk – leginkább az időnek – így aztán félő volt, hogy valami olyan kompromisszumba megyünk bele, ami hosszútávon mégsem lesz jó. Aztán Emese mutatott egy házat, amiről elsőre éreztük, hogy ez jó lesz. Tényleg jó. De azért kellett volna egy statikus. Egy info itt, egy info ott. Ügyvéd, földmérő. Nem gond, Emese megoldotta. A tárgyalások során az eladó is, és mi is végig úgy éreztük, hogy a win-win szituáció elérésében segít minket, kicsit a háttérbe húzódva, szakembereket, hivatalokat, megoldásokat keresve. Nem nyomult, nem zavart – segített. De a lényeg csak ez után jött. Amikor, megkötöttük a szerződést és nem maradt már stressz. Kiköltöztek, beköltöztünk. Megérkeztünk. Akkor egyszer csak rádöbbentem, hogy Emese pontosan azt a házat találta meg nekünk, amiről – nem viccelek – óvodás korom óta álmodtam.
