1=1 and sta <>1437044000 and status<>1 and type3='9' 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)
To buy
ID 20883
New project
81 m2
2/ 3 Elevator
3
2
Sold
To buy
ID 20880
New project
108 m2
2/ 3 Elevator
3
2
Sold
To buy
ID 6545
New project
117 m2
2/ 3 Elevator
3
565 250 EUR
To buy
ID 4270
New project
124 m2
2/ 3 Elevator
3
5 352
588 600 EUR
To buy
ID 21328
New project
113 m2
3/ 4
4
2
350 000 EUR
To buy
ID 3215
New project
547 m2
2/ 3 Elevator
5
3
1 200 000 EUR
To buy
ID 21294
New project
130 m2
1/ 3 Elevator
3
3
630 000 EUR
To buy
ID 21796
New project
589 m2
4/ 4 Elevator
4
2
379 000 EUR