SERVEUR  = ESIWEB2
SOCIETE = NELIS
SELECT = SELECT TOP 20 OFFR,CODE,CLAS,POST,LOCA,ADR1,ADRN,PAYS,CHBR_NBR,SURF_HAB,SURF_COM,SURF_BUR,SUPE_TER_1_,SUPE_TER_2_,SUPE_TER_3_,round(SUPE_TER_1_ * 10000 + SUPE_TER_2_ * 100 + SUPE_TER_3_, 2) AS SUPE_TER,COMM,INFO_CLA,VISI_VIRT,(SELECT LIBE_FR FROM TABLIMME WHERE TABLIMME.CODE=TABLIMME) AS "OFFR->TABLIMME.LIBE_FR",(SELECT LIBE_FR FROM TABLGEOG WHERE TABLGEOG.CODE=TABLGEOG) AS "OFFR->TABLGEOG.LIBE_FR",FLSH_FR collate SQL_Latin1_General_CP1_CI_AS +FLSH_FR2 collate SQL_Latin1_General_CP1_CI_AS AS FLASH_FR,FLSH_NL collate SQL_Latin1_General_CP1_CI_AS +FLSH_NL2 collate SQL_Latin1_General_CP1_CI_AS AS FLASH_NL,FLSH_EN collate SQL_Latin1_General_CP1_CI_AS +FLSH_EN2 collate SQL_Latin1_General_CP1_CI_AS AS FLASH_EN,REGI_TVA,PRIX,PHOTO_01,SUSP,ESIW_DATE as CREA_DATE,GPS_X,GPS_Y,PRES_CLAS,PRIX_WEB,PROJ,PRIX_MIN,PRIX_MAX,TABLIMME FROM OFFRE WHERE OFFR<>'L' and OFFR<>'P' AND (PAYS='' OR PAYS='B' OR PAYS like 'BE%') AND ACTI<>'P' AND ACTI<>'X' AND ACTI<>'V' AND EXISTS (SELECT * FROM OFFRMULT WHERE OFFR=OFFRE.CODE AND TABL='TABLIMME' AND (CODE LIKE '03%')) ORDER BY PRIX ASC,COMM ASC,CODE, PROJ

Array ( [0] => Array ( [OFFR] => V [CODE] => 00000836332 [CLAS] => 332/0836 [POST] => 4020 [LOCA] => LIEGE [ADR1] => Rue Méan [ADRN] => 29 /0014 [PAYS] => BE [CHBR_NBR] => 1 [SURF_HAB] => 44 [SURF_COM] => 0 [SURF_BUR] => 0 [SUPE_TER_1_] => 0 [SUPE_TER_2_] => 0 [SUPE_TER_3_] => 0 [SUPE_TER] => 0 [COMM] => LIEGE [INFO_CLA] => [VISI_VIRT] => [OFFR->TABLIMME.LIBE_FR] => Appartement [OFFR->TABLGEOG.LIBE_FR] => ¦ +-Outremeuse [FLASH_FR] => COMPROMIS DE VENTE EN COURS. Sous-sol: 1 cave. 1er étage: hall d'entrée, débarras, séjour, cuisine non-équipée (armoire, évier), 1 chambre, salle de bains. Charges: ± 70,00 € (communs + eau froide). PEB n° 20110620003858 - PEB: C - E spec 243 kWh/m²/an - E totale: 10804 kWh/an.Pour tout renseignement et/ou visite, contactez notre bureau par téléphone. [FLASH_NL] => [FLASH_EN] => [REGI_TVA] => 0 [PRIX] => 59000 [PHOTO_01] => http://217.145.35.26/Photos/NELIS/0100000836332_300_400.jpg [SUSP] => VEND [CREA_DATE] => Sep 26 2017 09:17:11:000AM [GPS_X] => 0 [GPS_Y] => 0 [PRES_CLAS] => C [PRIX_WEB] => 1 [PROJ] => [PRIX_MIN] => [PRIX_MAX] => [TABLIMME] => 031 ) [1] => Array ( [OFFR] => V [CODE] => 00000801332 [CLAS] => 332/0801 [POST] => 4000 [LOCA] => LIEGE [ADR1] => Rue Henri Vieuxtemps [ADRN] => 76 /005 [PAYS] => BE [CHBR_NBR] => 2 [SURF_HAB] => 97 [SURF_COM] => 0 [SURF_BUR] => 0 [SUPE_TER_1_] => 0 [SUPE_TER_2_] => 0 [SUPE_TER_3_] => 0 [SUPE_TER] => 0 [COMM] => LIEGE [INFO_CLA] => [VISI_VIRT] => [OFFR->TABLIMME.LIBE_FR] => Appartement [OFFR->TABLGEOG.LIBE_FR] => LIEGE [FLASH_FR] => COMPROMIS DE VENTE EN COURS. Sous-sol : 1 cave. 5ème étage: hall, séjour, cuisine (non-équipée), wc séparé (lave-mains), salle de douches, 2 penderies, une petite chambre, une grande chambre. PEB n° 20170330001934 - G - E spec:747 kWh/m²/an - E totale:72760kWh/an. Pour tout renseignement et/ou visite, veuillez contacter le bureau par téléphone. [FLASH_NL] => [FLASH_EN] => [REGI_TVA] => 0 [PRIX] => 115000 [PHOTO_01] => http://217.145.35.26/Photos/NELIS/0100000801332_300_400.jpg [SUSP] => VEND [CREA_DATE] => Jul 26 2017 09:20:05:000AM [GPS_X] => 0 [GPS_Y] => 0 [PRES_CLAS] => G [PRIX_WEB] => 1 [PROJ] => [PRIX_MIN] => [PRIX_MAX] => [TABLIMME] => 03 ) [2] => Array ( [OFFR] => V [CODE] => 00000860332 [CLAS] => 332/0860 [POST] => 4000 [LOCA] => LIEGE [ADR1] => Rue du Vieux Mayeur [ADRN] => 12 /0001 [PAYS] => BE [CHBR_NBR] => 2 [SURF_HAB] => 111 [SURF_COM] => 0 [SURF_BUR] => 0 [SUPE_TER_1_] => 0 [SUPE_TER_2_] => 0 [SUPE_TER_3_] => 0 [SUPE_TER] => 0 [COMM] => LIEGE [INFO_CLA] => [VISI_VIRT] => https://www.nodalview.com/P8NwttyYQCAbrm9xGWXpwBmw [OFFR->TABLIMME.LIBE_FR] => Appartement [OFFR->TABLGEOG.LIBE_FR] => ¦ +-Fragnée - Guillemins [FLASH_FR] => Appt. situé dans le quartier Guillemins-Fragnée. Sous-sol: cave et garage. Rez: hall, coin vestiaire, wc séparé, séjour, cuisine équipée, hall de nuit, salle de bains, 2 chambres, débarras. Charges : 180,00 € (communs, chauffage, eau froide). PEB: 20140128006959 - F - E totale: 48 571 kWh/an- E spec: 438 kWh/m².an. Appt. situé à proximité des commerces, écoles, gare Guillemins, axes autoroutiers et transports en commun. Pour tout renseignement et/ou visite, contactez notre bureau par téléphone. [FLASH_NL] => [FLASH_EN] => [REGI_TVA] => 0 [PRIX] => 159000 [PHOTO_01] => http://217.145.35.26/Photos/NELIS/0100000860332_300_400.jpg [SUSP] => [CREA_DATE] => Nov 13 2017 09:26:03:000AM [GPS_X] => 0 [GPS_Y] => 0 [PRES_CLAS] => F [PRIX_WEB] => 1 [PROJ] => [PRIX_MIN] => [PRIX_MAX] => [TABLIMME] => 03 ) [3] => Array ( [OFFR] => V [CODE] => 00000859332 [CLAS] => 332/0859 [POST] => 4000 [LOCA] => LIEGE [ADR1] => Avenue de l'Observatoire [ADRN] => 215 /0061 [PAYS] => BE [CHBR_NBR] => 3 [SURF_HAB] => 105 [SURF_COM] => 0 [SURF_BUR] => 0 [SUPE_TER_1_] => 0 [SUPE_TER_2_] => 0 [SUPE_TER_3_] => 0 [SUPE_TER] => 0 [COMM] => LIEGE [INFO_CLA] => [VISI_VIRT] => https://www.nodalview.com/XMXqvKpjYb77ibdaVHnrqyo7 [OFFR->TABLIMME.LIBE_FR] => Appartement [OFFR->TABLGEOG.LIBE_FR] => ¦ +-Cointe [FLASH_FR] => Appartement sis dans la Résidence "La Colline". Rez-de-chaussée: cave, box vélos collectif, double box garage dans la Résidence "la Tourelle". 6ème étage: hall d'entrée + vestiaire, cuisine équipée (meubles, lave-vaisselle, taque électrique, four, hotte, frigo) + balcon, débarras, séjour, wc séparé, salle de bains, 3 chambres, 2 terrasses (avant et arrière). Charges: ± 315,00 € (communs, chauffage et eaux, garages). PEB n° 20170608012520 - PEB: C- E spec: 214 kWh/m².an- E totale: 22462 kWh/an. [FLASH_NL] => [FLASH_EN] => [REGI_TVA] => 0 [PRIX] => 215000 [PHOTO_01] => http://217.145.35.26/Photos/NELIS/0100000859332_300_400.jpg [SUSP] => [CREA_DATE] => Nov 24 2017 04:08:12:000PM [GPS_X] => 0 [GPS_Y] => 0 [PRES_CLAS] => C [PRIX_WEB] => 1 [PROJ] => [PRIX_MIN] => [PRIX_MAX] => [TABLIMME] => 031 ) [4] => )

Nos biens à vendre :