select * from `ao_anunturi` a join `ao_categorii` b on b.`idcat` = a.`sitecatid` join `ao_zone` c on (c.`idzona`= a.`localitateid` and c.`idgrup`= a.`grupid`) where `filialaid` = '3445' and `online_site`='1' and `sters`='0' and `online` = '2' and `idanunt` IN(55515155,55532280,55536214,55582122,55696699,55739273,55739298,55745838,55768099,55772032,55773901,55816276,55844797,55846409,55863741,315441296,315461178,315481584,315481591,315495633,315495635,315505748,315511225,315524266,315536206,315536345,315536683,315542633,315563182,315563183,315578486,315578764,315632520) and c.`zona` = 'corbeanca'Aristocrat Imobiliare Corbeanca - Paduri Corbeanca
Vanzare teren in Corbeanca, mixt padure si teren construibil, in suprafata de 2500mp, se poate extinde suprafata cumparata pana la 10 000 mp, sosea asfaltata, vecinatati construite, gaze, curent elect ... Detalii oferta
Vanzare vila deosebita in Corbeanca, pozitionare aparte, la marginea padurii, 5 camere, 3 dormitoare, P+1E+M, in casa/vila, structura cadre de beton si caramida, constructie finalizata 2006, supr. tot ... Detalii oferta
220.000 EUROPaduri, Vanzari Terenuri, CORBEANCASuprafata: 2500 mp |Vanzare teren in Corbeanca, mixt padure si teren construibil, in suprafata de 2500mp, se poate extinde suprafata cumparata pana la 10 000 mp, sosea asfaltata, vecinatati construite, gaze, curent elect ... Detalii oferta
450.000 EUROPaduri, Vanzari Case / vile, CORBEANCASuprafata: 400 mp | Dormitoare: 3 | Suprafata teren: 2000 | Tip: individuala | Structura: beton/bca/caramida |Vanzare vila deosebita in Corbeanca, pozitionare aparte, la marginea padurii, 5 camere, 3 dormitoare, P+1E+M, in casa/vila, structura cadre de beton si caramida, constructie finalizata 2006, supr. tot ... Detalii oferta