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))
To buy
ID 5866
Detached house
260 m2
2
5
2 000 m2
650 000 EUR
Long term rent
ID 5228
Detached house
250 m2
2
5
1 200 m2
Rented out
Long term rent
ID 789
New project
220 m2
3
5
987 m2
Rented out
To buy
ID 5766
Detached house
312 m2
2
6
600 m2
300 000 EUR