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 21424
Renovated house
79 m2
1/ 3
1 500 EUR
Long term rent
ID 21448
Historical building
74 m2
1/ 7
2
2
1 110 EUR
Long term rent
ID 21449
Renovated house
60 m2
1/ 6
4
1
850 EUR
Long term rent
ID 21412
Historical building
50 m2
1/ 3
1
1
Rented out
Long term rent
ID 21437
Renovated house
146 m2
5/ 6
Rented out
Long term rent
ID 21550
Renovated house
65 m2
1/ 5
3
2
510 EUR
Long term rent
ID 21529
Individual project
147 m2
5/ 5
5
1 325 EUR