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 21978
Jaunais projekts
140 m2
3/ 4 Lifts
4
3
12 000 EUR
Pārdod
ID 11109
Jaunais projekts
140 m2
3/ 4 Lifts
4
3
1 200 000 EUR
Izīrē
ID 21977
Jaunais projekts
335 m2
2
5
4
800
3 800 EUR
Izīrē
ID 21976
335 m2
2
5
4
800
Izīrēts