1=1 and sta <>1437044000 and status<>1 and region LIKE '%|10|%' and (price_rent>0 or price_rent_rq=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 21676
Detached house
2
8
1 800
3 500 EUR
Long term rent
ID 10818
Detached house
365 m2
2
8
1 788
Rented out
Long term rent
ID 21827
Detached house
2
5
2
1 133
Rented out
Long term rent
ID 10090
Detached house
253 m2
3
5
400
Rented out