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 1732
Detached house
315 m2
2
7
1 768 m2
385 700 EUR
To buy
ID 1408
Detached house
270 m2
2
6
2 200 m2
350 000 EUR
Long term rent
ID 1289
New project
120 m2
2
3
390 m2
Rented out