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
P+2 etaje + M, Techirghiol
P+2 etaje + M, Techirghiol
P+1, zona Kamsas
P+1, zona Kamsas
Vanzare apartament
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
Vanzare casa/vila
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

Anunturi negociate

Du-te la pagina:
1 2 3 Inainte Ultima
In total 158 oferte | 20 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_id IN (23,31,36,76,87,100,106,114,126,135,150,151,155,160,162,164,171,180,184,187,194,210,231,235,237,246,251,253,255,257,262,264,266,271,277,279,280,282,287,288,290,291,297,300,301,303,307,310,313,319,320,321,325,330,336,338,344,345,347,349,351,358,360,366,369,383,384,393,395,396,397,399,403,409,412,413,414,422,429,430,432,433,434,435,438,439,441,445,447,448,449,452,454,455,456,460,467,468,476,478,480,483,489,495,496,497,500,502,506,507,509,514,515,517,519,520,521,526,527,531,532,534,535,538,541,542,545,546,548,550,551,552,553,556,559,560,563,564,566,573,575,577,579,584,585,589,596,601,603,604,608,609,610,612,615,616,618,621,624,625,633,634,637,638,640,642,645,646,647,649,651,652,657,660,665,668,670,672,680,698,699,728,731,733,740,744,746,747,749,755,756,757,760,761,762,765,766,773,774,777,782,793,796,799,802,803,804,805,806,814,816,819,824,825,827,837,838,843,846,868,872,887,888,903,909,912,916,917,925,926,929,935,936,942,943,954,959,962,976,986,987,988,990,991,993,997,1009,1011,1020,1022,1025,1034,1036,1037,1051,1055,1063,1067,1069,1071,1075,1077,1078,1079,1081,1085,1086,1089,1092,1095,1097,1103,1116,1117,1130,1131,1133,1135,1137,1143,1144,1149,1151,1152,1154,1160,1163,1165,1167,1168,1171,1173,1174,1176,1181,1183,1185,1187,1190,1206,1207,1211,1216,1223,1227,1240,1247,1256,1257,1263,1283,1286,1287,1300,1307,1325,1330,1333,1334,1335,1337,1340,1342,1348,1350,1353,1357,1374,1376,1377,1386,1387,1392,1395,1403,1415,1416,1418,1420,1430,1435,1436,1437,1443,1445,1447,1448,1450,1451,1453,1455,1457,1459,1478,1485,1487,1491,1496,1497,1499,1500,1506,1509,1511,1512,1521,1523,1532,1535,1538,1541,1542,1545,1546,1547,1553,1554,1556,1557,1558,1559,1562,1567,1570,1572,1573,1583,1585,1587,1588,1590,1592,1593,1598,1599,1603,1614,1616,1623,1625,1626,1627,1631,1633,1636,1637,1640,1649,1654,1656,1659,1661,1662,1664,1665,1668,1679,1680,1682,1684,1691,1692,1700,1703,1705,1709,1712,1715,1716,1717,1718,1722,1725,1727,1728,1731,1732,1738,1740,1770,1780,1785,1801,1806,1810,1812,1820,1822,1825,1837,1839,1840,1842,1843,1844,1849,1851,1856,1859,1860,1861,1865,1876,1880,1896,1906,1908,1913,1916,1918,1922,1924,1929,1931,1932,1939,1940,1942,1948,1949,1960,1962,1963,1974,1981,1983,1985,1990,1993,2007,2008,2009,2014,2015,2041,2042,2043,2047,2049,2052,2057,2060,2064,2068,2076,2077,2078,2083,2086,2092,2096,2099,2106,2118,2120,2123,2127,2134,2136,2137,2140,2141,2148,2149,2151,2159,2164,2168,2173,2175,2177,2180,2181,2183,2184,2188,2193,2198,2212,2213,2216,2218,2219,2221,2225,2227,2246,2247,2250,2253,2256,2258,2270,2277,2292,2294,2308,2309,2312,2315,2320,2322,2326,2335,2342,2343,2345,2347,2360,2361,2367,2391,2393,2398,2400,2411,2423,2431,2440,2441,2442,2446,2451,2453,2457,2460,2468,2470,2490,2491,2493,2495,2496,2518,2525,2526,2532,2534,2537,2539,2541,2542,2544,2548,2550,2555,2558,2571,2588,2616,2621,2624,2628,2644,2647,2665,2666,2673,2681,2686,2700,2709,2737,2740,2761,2766,2768,2770,2777,2839,2846,2885,2897,2898,2915,2934,2941,2948,3018,3042,3070,3097,3121,3149,3164,3178,3179,3191,3196,3201,3207,3274,3303,3321,3342,3367,3374,3382,3472,3507,3623,3694,3699,3717,3774,3828,3829,3905,3907,3945,3997,4010,4024,4041,4057,4076,4092,4117,4175,4302,4480,4485,4616,4738,4747,4785) ORDER BY a_data DESC LIMIT -8, 8 )