SERVEUR  = ESIWEB2
SOCIETE = NADIMMO
SELECT = SELECT TOP 40 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] => L [CODE] => 00006484235 [CLAS] => 235/6484 [POST] => 1040 [LOCA] => BRUXELLES 4 [ADR1] => avenue Edouard de thibault [ADRN] => 3 [PAYS] => BE [CHBR_NBR] => 1 [SURF_HAB] => 56 [SURF_COM] => 0 [SURF_BUR] => 0 [SUPE_TER_1_] => 0 [SUPE_TER_2_] => 0 [SUPE_TER_3_] => 0 [SUPE_TER] => 0 [COMM] => ETTERBEEK - PLACE SAINT-PIERRE - MERODE [INFO_CLA] => [VISI_VIRT] => [OFFR->TABLIMME.LIBE_FR] => Appartement [OFFR->TABLGEOG.LIBE_FR] => Etterbeek [FLASH_FR] => A proximité du quartier européen, un appartement très lumineux comprenant: un hall d’entrée – une cuisine équipée avec électro-ménager neuf : frigo – freezer, plaques vitrocéramique et four électrique , hotte , lave- linge de 8kg (en sèche linge 5kg) – une salle de Bains rénovée – un living de 23m² avec un parquet de chêne clair – un chambre de 14m² avec nouveau parquet de chêne - 1 cave privative. (1 cave commune à vélos) Fenêtres double vitrage haute isolation, vannes thermostatiques. Nouvelles peintures. [FLASH_NL] => [FLASH_EN] => EU aera, a very bright apartment with an entrance hall - kitchen with new appliances: -freezer fridge, ceramic hob and electric oven, hob, washing machine 8kg (in dryer 5kg) - bathroom - Living 25 sqm. with new parquet light oak -bedroom 14 m2 with new oak floor - 1 private cellar. (1 shared cellar bike) Double glazed windows high insulation .New paintings. Available. [REGI_TVA] => [PRIX] => 750 [PHOTO_01] => http://217.145.35.26/Photos/NADIMMO/0100006484235_300_400.jpg [SUSP] => LOUE [CREA_DATE] => Mar 11 2017 12:03:37:000PM [GPS_X] => 0 [GPS_Y] => 0 [PRES_CLAS] => C [PRIX_WEB] => 1 [PROJ] => [PRIX_MIN] => [PRIX_MAX] => [TABLIMME] => 031 ) [1] => )