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 3508
Renovēta ēka
194 m2
1/ 2
7 776 EUR
Pārdod
ID 3514
Jaunais projekts
2 469 m2
-/ 4
2 515 m2
2 500 000 EUR
Pārdod
ID 4995
Specprojekts
1 864 m2
1/ 1
899 000 EUR