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 5137
Pirmskara ēka
112 m2
5/ 6 Lifts
1 495 EUR
Pārdod
ID 5125
104 m2
1/ 5
200 000 EUR
Izīrē
ID 5084
Renovēta ēka
220 m2
1/ 2
1 320 EUR
Izīrē
ID 4001
Renovēta ēka
250 m2
1/ 5
5
4 900 EUR
Pārdod
ID 2502
Jaunais projekts
115 m2
1/ 1
6
200 000 EUR