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 `sitecatid` = '23' and c.`zona` = 'snagov'Aristocrat Imobiliare Corbeanca - Vanzari Terenuri Snagov
Vanzare teren in Snagov, intravilan, construibil, 700mp., desch. sosea 23m, electricitate, in apropiere de padure, lac, acces drum de servitute. ... Detalii oferta
60.000 EURO
Vanzari Terenuri, SNAGOV
Suprafata:3000 mp |
Pret:20,00 EURO/MP |
Vanzare teren in Snagov, intravilan, forestier, 3000mp., supr. max 8000, 50m x 60m, desch. sosea 50m, apa, gaze, electricitate, asfalt, in apropiere de maxi taxi, padure, supermarket, scoala, gradinit ... Detalii oferta
28.000 EUROVanzari Terenuri, SNAGOVSuprafata: 700 mp | Pret: 40,00 EURO/MP |Vanzare teren in Snagov, intravilan, construibil, 700mp., desch. sosea 23m, electricitate, in apropiere de padure, lac, acces drum de servitute. ... Detalii oferta
60.000 EUROVanzari Terenuri, SNAGOVSuprafata: 3000 mp | Pret: 20,00 EURO/MP |Vanzare teren in Snagov, intravilan, forestier, 3000mp., supr. max 8000, 50m x 60m, desch. sosea 50m, apa, gaze, electricitate, asfalt, in apropiere de maxi taxi, padure, supermarket, scoala, gradinit ... Detalii oferta