1=1 and sta <>1437044000 and status<>1 and (parent='3' or parent2='3' or parent3='3' or parent IN(1391538917,1391538962,1391539227,1391539326,1391539371,1391605442,1391605562) or parent2 IN(1391538917,1391538962,1391539227,1391539326,1391539371,1391605442,1391605562) or parent3 IN(1391538917,1391538962,1391539227,1391539326,1391539371,1391605442,1391605562))
Pārdod
ID 7696
Jaunais projekts
186 m2
1/ 6 Lifts
300 000 EUR
Pārdod
ID 6797
Renovēta ēka
147 m2
1/ 5 Lifts
4
351 840 EUR