SERVEUR  = ESIWEB2
SOCIETE = BURIMMO
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 '43%')) ORDER BY PRIX ASC,COMM ASC,CODE, PROJ

Array ( [0] => Array ( [OFFR] => V [CODE] => 00012334246 [CLAS] => 246/12334 [POST] => 1200 [LOCA] => WOLUWE-SAINT-LAMBERT [ADR1] => avenue du Castel [ADRN] => 72 a [PAYS] => BE [CHBR_NBR] => [SURF_HAB] => 80 [SURF_COM] => 0 [SURF_BUR] => 80 [SUPE_TER_1_] => 0 [SUPE_TER_2_] => 3 [SUPE_TER_3_] => 17 [SUPE_TER] => 317 [COMM] => WSL - CASTEL [INFO_CLA] => [VISI_VIRT] => [OFFR->TABLIMME.LIBE_FR] => Bureaux [OFFR->TABLGEOG.LIBE_FR] => Woluwé-Saint-Lambert [FLASH_FR] => Idéalement situé à l'angle des avenues du Castel et Prekelinden, lumineux CABINET MEDICAL développant ±85 m² sis au rez-de-chaussée d'un petit immeuble avec entrée séparée. Double vitrage avec volets, chauffage gaz individuel et accès aisé vers transports en commun. Possibilité d'acquérir l'appartement au 1er étage et un box garage. [FLASH_NL] => [FLASH_EN] => [REGI_TVA] => 0 [PRIX] => 245000 [PHOTO_01] => http://217.145.35.26/Photos/BURIMMO/0100012334246_300_400.jpg [SUSP] => VEND [CREA_DATE] => Mar 2 2017 10:07:08:000AM [GPS_X] => -1 [GPS_Y] => -1 [PRES_CLAS] => [PRIX_WEB] => 1 [PROJ] => [PRIX_MIN] => [PRIX_MAX] => [TABLIMME] => 43 ) [1] => )

Nos biens à vendre :