1=1 and sta <>1437044000 and status<>1 and sta <>1309210861 and sta<>1309210830 and status<>1 and (price_rent>0 or price_rentdaily>0 or price_rentsummer>0 or price_rent_rq=1 or price_rentdaily_rq=1 or price_rentsummer_rq=1) and region LIKE '%|66|%' 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))
Izīrē
ID 21973
Renovēta ēka
91 m2
1 814 EUR
Izīrē
ID 21974
Renovēta ēka
82 m2
1 556 EUR
Izīrē
ID 21967
Jaunais projekts
30 m2
3/ 8 Lifts
1
1
500 EUR
Izīrē
ID 10226
Renovēta ēka
246 m2
5/ 6 Lifts
5
3
Pēc pieprasījuma
Izīrē
ID 4903
Jaunais projekts
81 m2
4/ 7 Lifts
2
850 EUR