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 21650
New project
157 m2
4/ 7 Elevator
4
385 000 EUR
To buy
ID 3470
New project
265 m2
7/ 7 Elevator
5
850 000 EUR
To buy
ID 21638
New project
57 m2
1/ 3
2
2
25
300 000 EUR
To buy
ID 10602
New project
67 m2
2/ 3
2
Sold
To buy
ID 21667
New project
115 m2
15/ 23 Elevator
3
2
337 000 EUR
To buy
ID 20954
New project
116 m2
17/ 23 Elevator
3
2
357 000 EUR
To buy
ID 21196
New project
86 m2
3/ 7 Elevator
3
2
492 000 EUR
To buy
ID 21195
New project
118 m2
2/ 7 Elevator
4
2
625 000 EUR