1=1 and sta <>1437044000 and status<>1 and (parent='3' or parent2='3' or parent3='3' or parent IN(1391538917,1391538962,1391539227,1391539326,1391539371,1391605442,1391605562) or parent2 IN(1391538917,1391538962,1391539227,1391539326,1391539371,1391605442,1391605562) or parent3 IN(1391538917,1391538962,1391539227,1391539326,1391539371,1391605442,1391605562))
Long term rent
ID 21533
New project
90 m2
2/ 5 Elevator
910 EUR
Long term rent
ID 21532
New project
59 m2
4/ 5 Elevator
2
1
850 EUR
Long term rent
ID 21530
Individual project
101 m2
2/ 2
4
1
610 EUR
Long term rent
ID 2481
New project
80 m2
4/ 4 Elevator
2
560 EUR
Long term rent
ID 21457
Renovated house
161 m2
1/ 6
2
1
2 700 EUR
Long term rent
ID 21423
Historical building
84 m2
1/ 3
1
1 330 EUR
Long term rent
ID 21450
Renovated house
31 m2
1/ 3
2
1
836 EUR
Long term rent
ID 21451
Renovated house
32 m2
1/ 3
1
1
1 000 EUR