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 5092
Renovated house
264 m2
1/ 7 Elevator
9
2 500 EUR
Long term rent
ID 8320
Renovated house
250 m2
1/ 3
Rented out
Long term rent
ID 10186
Historical building
220 m2
1/ 1
1 000 EUR
Long term rent
ID 439
Renovated house
64 m2
1/ 5 Elevator
2
744 EUR
Long term rent
ID 438
Renovated house
84 m2
1/ 5 Elevator
2
955 EUR
Long term rent
ID 20773
New project
106 m2
2/ 7 Elevator
1 034 EUR
To buy
ID 20752
Renovated house
82 m2
1/ 6
2
314 820 EUR
Long term rent
ID 10412
Historical building
245 m2
1/ 6
5 000 EUR