1=1 and sta <>1437044000 and status<>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))
Long term rent
ID 1044
Historical building
132 m2
2/ 4
4
Rented out
Long term rent
ID 836
70 m2
6/ 2
2
Rented out
Long term rent
ID 1827
108 m2
2/ 6 Elevator
3
Rented out
Long term rent
ID 2052
Historical building
75 m2
3/ 5
3
Rented out
Long term rent
ID 2071
Historical building
116 m2
3/ 4
4
Rented out
Long term rent
ID 83
28 m2
2/ 4
1
600 EUR