1=1 and sta <>1437044000 and status<>1 and (parent='3' or parent2='3' or parent3='3' or parent IN(1391538917,1391538962,1391539227,1391539326,1391539371,1391605442,1391605562) or parent2 IN(1391538917,1391538962,1391539227,1391539326,1391539371,1391605442,1391605562) or parent3 IN(1391538917,1391538962,1391539227,1391539326,1391539371,1391605442,1391605562))
Izīrē
ID 21186
Renovēta ēka
448 m2
2/ 3
12 EUR
Pārdod
ID 20899
Pirmskara ēka
148 m2
1/ 6
4
2
266 000 EUR