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 737
Historical building
107 m2
3/ 6
4
Rented out
Long term rent
ID 853
New project
89 m2
2/ 6
3
Rented out
To buy
ID 2080
New project
105 m2
2/ 5 Elevator
3
1 m2
Sold
To buy
ID 3019
Renovated house
155 m2
2/ 4
6
368 500 EUR