1=1 and sta <>1437044000 and status<>1 and region LIKE '%|20|%' and (price_rent>0 or price_rent_rq=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 3750
Renovated house
47 m2
4/ 7 Elevator
2
Rented out
Long term rent
ID 3782
Renovated house
39 m2
2/ 3
1
Sold
Long term rent
ID 4328
Historical building
175 m2
3/ 6
4
Rented out
Long term rent
ID 2278
Historical building
82 m2
6/ 6 Elevator
3
Rented out
Long term rent
ID 1137
New project
42 m2
2/ 7 Elevator
1
Rented out