1=1 and sta <>1437044000 and status<>1 and (parent='1' or parent2='1' or parent3='1' or parent IN(1308171351,1499675386,1313763792,1413455766,1308171407,1308171373,1308171391,1308171426) or parent2 IN(1308171351,1499675386,1313763792,1413455766,1308171407,1308171373,1308171391,1308171426) or parent3 IN(1308171351,1499675386,1313763792,1413455766,1308171407,1308171373,1308171391,1308171426))
Izīrē
ID 20958
335 m2
2
5
4
800
3 300 EUR
Izīrē
ID 21190
Renovēta ēka
145 m2
3/ 5
4
2 000 EUR
Pārdod
ID 21797
Pirmskara ēka
82 m2
6/ 7 Lifts
3
1
250 000 EUR
Pārdod
ID 21897
Renovēta ēka
158 m2
2/ 6
5
2
499 000 EUR
Izīrē
ID 22023
Renovēta ēka
101 m2
4/ 6 Lifts
3
2
2 515 EUR