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>='150000' and price_sell<='350000')
To buy
ID 20836
New project
92 m2
1/ 3 Elevator
3
2
192 800 EUR
To buy
ID 20878
New project
67 m2
2/ 3 Elevator
3
2
187 600 EUR
To buy
ID 20886
New project
80 m2
3/ 3 Elevator
3
2
235 120 EUR
To buy
ID 20888
New project
121 m2
3/ 3 Elevator
4
2
319 760 EUR
To buy
ID 20879
New project
94 m2
2/ 3 Elevator
3
2
Sold
To buy
ID 21668
New project
115 m2
15/ 23 Elevator
3
2
344 000 EUR
To buy
ID 21622
New project
129 m2
1/ 4 Elevator
3
349 000 EUR
To buy
ID 20699
84 m2
1/ 2 Elevator
2
1
239 870 EUR