1=1 and sta <>1437044000 and status<>1 and (price_sell>0 or price_sell_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)) and (price_sell>='150000' and price_sell<='350000')
Sale and rental of real estate in Latvia.
Would like to receive the best website experience? Agree to our Cookie policy
95 m2
5/
9 Elevator
3
