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 21146
New project
103 m2
4/ 4 Elevator
4
2
268 060 EUR
To buy
ID 3267
New project
118 m2
7/ 7 Elevator
4
480 000 EUR
To buy
ID 20830
New project
96 m2
1/ 1 Elevator
3
2
Sold
To buy
ID 20834
New project
247 m2
1/ 3 Elevator
3
2
Sold
To buy
ID 20835
New project
162 m2
1/ 3 Elevator
4
2
Sold
To buy
ID 5253
New project
97 m2
2/ 4 Elevator
4
410 000 EUR
To buy
ID 11045
New project
268 m2
1/ 3 Elevator
4
3
695 000 EUR
To buy
ID 21621
New project
160 m2
3/ 3 Elevator
4
3
850 000 EUR