Constanta, zona Sat Vacanta
locatie comerciala!
61.500 EUR
Palazu Mare, zona Central
vanzare casa 4 camere in palazu mare p+1+m. casa propusa spre vanzare se afla pe un teren de 250 mp si are o suprafata utila de 180 mp + 60 mp mansarda + 14 mp de beci, un balcon si o terasa la...
149.000 EUR
|
Ultimele anunturi imobiliareYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-8, 8' at line 8 (SELECT a_id FROM t_anunturi AS a INNER JOIN t_anunturi_detalii AS ad ON ad_anunt=a_id INNER JOIN t_localitati AS loc ON a_localitate=loc_id WHERE 1 AND a_activ=1 AND a_sters=0 ORDER BY a_data DESC LIMIT -8, 8 ) |