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 SUSP in ('VK','VW','VKWEB','VH','HW','VHWEB','VEND','VENDU','LOUE','SOLD','RENTED') AND ACTI<>'P' ORDER BY MODI_DATE, LOCA

Array ( [0] => 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 ) [1] => 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 ) [2] => Array ( [OFFR] => L [CODE] => 00000832332 [CLAS] => 332/0832 [POST] => 4020 [LOCA] => LIEGE [ADR1] => Quai Marcellis [ADRN] => 31 /0004 [PAYS] => BE [CHBR_NBR] => 1 [SURF_HAB] => 69 [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] => Rez-de-chaussée [OFFR->TABLGEOG.LIBE_FR] => LIEGE [FLASH_FR] => Entrée indépendante. Rez: hall d'entrée, séjour, cuisine (meubles, évier, égouttoir, taque élec., four, hotte), 1 chambre, salle de bains (lavabo et baignoire), buanderie (raccord. MàL et séchoir), wc séparé. Entrée appartement indépendante. Charges: 100,00 €/mois (communs, chauffage et eaux). PEB n° 20170807003649- PEB:D- E spec: 314 kWh/m².an- E totale: 21779 kWh/an. Pour tout renseignement et/ou visite, contactez le bureau par téléphone. [FLASH_NL] => [FLASH_EN] => [REGI_TVA] => [PRIX] => 495 [PHOTO_01] => http://217.145.35.26/Photos/NELIS/0100000832332_300_400.jpg [SUSP] => LOUE [CREA_DATE] => Aug 9 2017 03:22:13:000PM [GPS_X] => 0 [GPS_Y] => 0 [PRES_CLAS] => D [PRIX_WEB] => 1 [PROJ] => [PRIX_MIN] => [PRIX_MAX] => [TABLIMME] => 033 ) [3] => )

Nos références