1=1 and sta <>1437044000 and status<>1 and (parent='2' or parent2='2' or parent3='2' or parent IN(1449437064,1391539796,1308171469,1308171533,1308171441) or parent2 IN(1449437064,1391539796,1308171469,1308171533,1308171441) or parent3 IN(1449437064,1391539796,1308171469,1308171533,1308171441))
Long term rent
ID 6120
Renovated house
215 m2
3
7
257
Rented out
To buy
ID 21950
Detached house
114 m2
2
5
500
249 000 EUR
To buy
ID 21801
Detached house
1 500 m2
2
9
7
11 365
4 500 000 EUR
To buy
ID 21949
Detached house
345 m2
3
5
1 610
500 000 EUR