1=1 and sta <>1437044000 and status<>1 and region LIKE '%|10|%' and (price_sell>0 or price_sell_rq=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)) and (price_sell>0 or price_sell_rq=1)
Pārdod
ID 21380
Jaunais projekts
85 m2
1/ 3 Lifts
3
1
242 530 EUR
Pārdod
ID 21379
Jaunais projekts
85 m2
1/ 3 Lifts
3
1
242 530 EUR
Pārdod
ID 21378
Jaunais projekts
85 m2
1/ 3 Lifts
3
1
220 894 EUR
Pārdod
ID 21377
Jaunais projekts
85 m2
3/ 3 Lifts
3
1
222 377 EUR
Pārdod
ID 21376
Jaunais projekts
85 m2
3/ 3 Lifts
3
1
231 101 EUR
Pārdod
ID 21375
Jaunais projekts
85 m2
3/ 3 Lifts
3
1
222 377 EUR
Pārdod
ID 21373
Jaunais projekts
85 m2
3/ 3 Lifts
3
1
222 377 EUR
Pārdod
ID 21372
Jaunais projekts
85 m2
2/ 3 Lifts
3
1
216 183 EUR