Aristocrat Imobiliare Corbeanca - Ansambluri rezidentiale

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(4396840,4396853,4402997,4417936,4419951,4420042,4420056,4420353,4420354,4420356,4420358,4427419,4434410,4434556,4446574,4452920,4456872,4459612,4464198,4464201,4464203,4466624,4473118,4476277,4476403,4477514,4477702,4492472,4498326,4515556,4524366,4525927,4527601,4534138,4537923,4548747,4550161,4559190,4559194,4573068,4583038,4585437,4591799,4591872,4595920,4597090,4599266,4599398,4603880,4604329,4612318,4616801,4618937,11111467,11116655,55514551,55515263,55515302,55517318,55520960,55521675,55529418,55530363,55536460,55538608,55546038,55546106,55548592,55564158,55567840,55572102,55573682,55575288,55575303,55575520,55575533,55575534,55575535,55578830,55581678,55581798,55586921,55588092,55592446,55593613,55596405,55596413,55602954,55606693,55608354,55609361,55610031,55612240,55612729,55612961,55612979,55613834,55622924,55624685,55627453,55627568,55629663,55630996,55634140,55634361,55634617,55635108,55652429,55653708,55654158,55655450,55657323,55660579,55663823,55666255,55683313,55683648,55683686,55684271,55687288,55690448,55692125,55692818,55692874,55693745,55695963,55701586,55702630,55705373,55709115,55711722,55711735,55713409,55714320,55719182,55722308,55731067,55731091,55732952,55736313,55737989,55755781,55757940,55758439,55759654,55759712,55762637,55762638,55767496,55768817,55768822,55771417,55776693,55783256,55783271,55785036,55793014,55799397,55805458,55809756,55809866,55816942,55818686,55820269,55821229,55822532,55823129,55823530,55823547,55829350,55831242,55834850,55834879,55834922,55834926,55834961,55834971,55835011,55835027,55835254,55835262,55835327,55835642,55837929,55840455,55842586,55845712,55846711,55846729,55847520,55847532,55849712,55850933,55850943,55852132,55852384,55852646,55853185,55853402,55853467,55855101,55856236,55856678,55856689,55860596,55860890,55863685,55863686,55863687,55863688,55863692,55864710,55865056,55865795,55866035,55872628,55873185,55878661,55880593,55881435,55881991,55881999,55882001,55882011,55882058,55882303,55883816,55883821,55884691,55884704,55884727,55891094,55891813,211160853,303215521,303215827,303216330,303216335,303218153,303218996,303219043,303219044,303219047,303219065,306718036,306718098,315435842,315436841,315438607,315440885,315441203,315442610,315442647,315444557,315446421,315446423,315451346,315453257,315460393,315461178,315463757,315463766,315464104,315465150,315467834,315469594,315472006,315472788,315472793,315472794,315477195,315478196,315479641,315481022,315481574,315482898,315482900,315483456,315484079,315484329,315484337,315484344,315484352,315484669,315484987,315490996,315491671,315492582,315493454,315494771,315494788,315494822,315495202,315496357,315496373,315498658,315500740,315502576,315502960,315504807,315506837,315506838,315506847,315507273,315507903,315507905,315507960,315508848,315509048,315509969,315511989,315512980,315515369,315515904,315516297,315517719,315520159,315521714,315523294,315527131,315528958,315529167,315529436,315529456,315529459,315529467,315529473,315530400,315531192,315531193,315531494,315531888,315532271,315533348,315533760,315534180,315535274,315541944,315542454,315542462,315542480,315544297,315545471,315545474,315545988,315546151,315546237,315546516,315548914,315551833,315551926,315552819,315554787,315554791,315555183,315555413,315556659,315557161,315558584,315558749,315560071,315560789,315560802,315560810,315560958,315560964,315561009,315561027,315561032,315561724,315561872,315562076,315562493,315562849,315563119,315564719,315566132,315567186,315567417,315570172,315570173,315574256,315574709,315575214,315576512,315576513,315579039,315582452,315586997,315586998,315588110,315591939,315593847,315594824,315595367,315595368,315595464,315595465,315595668,315596394,315597613,315597809,315597818,315600725,315601470,315602628,315602629,315603962,315605066,315605538,315606092,315606097,315607429,315608743,315610225,315610230,315610245,315610480,315610679,315610787,315610879,315611142,315611983,315615106,315616884,315616999,315617437,315621093,315621136,315773241) Aristocrat Imobiliare Corbeanca - Ansambluri rezidentiale

Ansambluri rezidentiale

List Grid Rezultate: 1

166.400 EURO

Ansambluri rezidentiale, Vanzari Terenuri, OSTRATU

Suprafata: 500 mp |

Vanzare teren in Corbeanca, in cartier rezidential, zona veche a Paradisului Verde, categorie de folosinta: intravilan, construibil, 500mp, supr. max 500, 14 x 37, desch. sosea 14m, apa, gaze, canaliz ... Detalii oferta

1

Cauta proprietati

Cautare avansata