1=1 and sta <>1437044000 and status<>1 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>='1' and price_sell<='150000')
Pārdod
ID 21147
Jaunais projekts
34 m2
2/ 3 Lifts
2
2
91 530 EUR
Pārdod
ID 20780
Jaunais projekts
49 m2
3/ 5 Lifts
2
Pārdots
Pārdod
ID 10667
Jaunais projekts
61 m2
3/ 5 Lifts
2
Pārdots
Pārdod
ID 10669
Jaunais projekts
50 m2
3/ 5 Lifts
3
119 000 EUR
Pārdod
ID 6086
Jaunais projekts
61 m2
3/ 7 Lifts
2
Pārdots
Pārdod
ID 8305
Renovēta ēka
59 m2
3/ 7 Lifts
2
1
150 000 EUR