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="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 = 'haz'
SELECT * FROM cms_1_shop_categs_hu WHERE SEARCHNAME = 'ingatlanok'
SELECT * FROM cms_1_shop_categs_hu WHERE (ACTIVE='1' OR ID='13') AND SEARCHNAME = 'haz'
SELECT * FROM cms_1_shop_categs_hu WHERE ACTIVE='1' AND SUB = '2'
SELECT * FROM cms_1_contents_hu WHERE MODULE='webshop' ORDER BY NO ASC
SELECT * FROM cms_1_pictures WHERE CONTENTID='647' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='652' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='655' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='658' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='660' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='661' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='600' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='601' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='602' AND MAIN='1' AND CONTENTTYPE='88'
SELECT * FROM cms_1_pictures WHERE CONTENTID='2' AND MAIN='1' AND CONTENTTYPE='89'
SELECT * FROM cms_1_shop_categs_hu WHERE ACTIVE='1' AND ID = '0'
SELECT * FROM cms_1_shop_categs_hu WHERE ACTIVE='1' AND SUB = '0'
Ház | 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
SELECT * FROM cms_1_templates_hu WHERE EXTRA="0"

Ház

Családi házak, sorházak, ikerházak, házrész


Értékesítés

Szobák száma

Félszobák száma

Épület szintjei

Kertkapcsolatos

Légkondicionáló

Gépesített

Akadálymentesített

Bútorozott

CSOK

Víz

Villany

Gáz

Csatorna

Minimum bérleti idő

Tájolás

Panel program

Eladó ikerház - Törökbálint, Rudáktelep
Törökbálint
81.9 M Ft
115 m² · 4 szoba
Kiadó családi ház - Törökbálint, Pest megye
Törökbálint
1400 EUR / hó
150 m² · 4 szoba
Eladó ikerház - Törökbálint, Pest megye
Törökbálint
78 M Ft
93 m² · 5 szoba
Eladó családi ház - Törökbálint, Újtelep
Törökbálint
115 M Ft
135 m² · 5 szoba
Eladó családi ház - Érd, Dombosváros
Érd
54.9 M Ft
80 m² · 4 szoba
Eladó családi ház - Érd, Újfalu
Érd
42.5 M Ft
53 m² · 2 szoba
Eladó ikerház - Budapest, 22. kerület
Budapest
86.9 M Ft
95 m² · 3 szoba
 Eladó ikerház - Budapest, 22. kerület
Budapest
114.9 M Ft
124 m² · 4 szoba
 Eladó ikerház - Budapest, 22. kerület
Budapest
134.9 M Ft
145 m² · 4 szoba
Loading
DEVELOPER BAR