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="29" ORDER BY POSITION ASC
SELECT * FROM cms_1_pictures WHERE CONTENTID='' AND CONTENTTYPE='1' AND MAIN!='1'
SELECT * FROM cms_1_pictures WHERE CONTENTID='' AND MAIN='1' AND CONTENTTYPE='1'
SELECT * FROM cms_1_pictures WHERE CONTENTID='' AND MAIN='1' AND CONTENTTYPE='1'
SELECT * FROM cms_1_shop_hu WHERE SEARCHNAME = 'elado-csaladi-haz-torokbalint-ofalu-576'
SELECT * FROM cms_1_shop_hu WHERE ID!='' ORDER BY RAND(),VIEW DESC LIMIT 3
SELECT * FROM cms_1_pictures WHERE CONTENTID='595' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='529' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='801' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='576' AND CONTENTTYPE='88' AND MAIN!='1'
SELECT * FROM cms_1_pictures WHERE CONTENTID='576' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='6' AND MAIN='1' AND CONTENTTYPE='99'
Eladó családi ház - Törökbálint, Ófalu | 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
Különleges kivitelezésű, egyedi ház eladó Törökbálint központi részén egy 294 nm-es telken. Az igényesen, teljeskörűen felújított, dupla sor mészkőből épült, 138 nm-es ház 4 szobával, fedett verandával és 2 fürdőszobával ellátott.
A 12 éve történt felújítás során a tetőszerkezet, a vízvezeték és a villanyvezetékek is kicserélésre kerültek. Új burkolatokkal és 2+1 rétegű üvegezéssel ellátott ablakokkal korszerűsítették az épületet.
A fűtés gázkazánnal történik, az egyik szobában cserépkályha is található.
Kis, bekerített intim kert nyújt kikapcsolódásra lehetőséget. Itt valóban elbújhat a világ elől.
Minden megtalálható a közelben. Iskola, óvoda, boltok, orvos, gyógyszertár. A közlekedés kiváló, Budapestre is 15 perc alatt be lehet jutni.
Ha különlegesre vágyik, szépségre, harmóniára, kényelemre, hívjon bizalommal és nézze meg ezt a házat! Szívből ajánlom!