Imobiliare Constanta. Apartamente, garsoniere, case, terenuri, birouri si spatii comerciale

Cauta anunturi

Adauga cerere/oferta Exclusivitati Constructii Portofoliu lucrari Anunturi negociate Blog
Proiecte rezidentiale proprii
Constanta, zona Sat Vacanta

locatie comerciala! 
sat vacanta, apartament de 2 camere, confort 1, circular, et 2/4, 50 mp, cu balcon, bloc stradal, amenajari interioare medii. apartamentul ce se propune spre...

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

Imobile tranzactionate

Du-te la pagina:
1 2 3 Inainte Ultima
In total 179 oferte | 23 pagini
You 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 AND (a_vandut=1 OR a_inchiriat=1) ORDER BY a_data DESC LIMIT -8, 8 )