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 '01%')) ORDER BY PRIX ASC,COMM ASC,CODE, PROJ

Array ( [0] => Array ( [OFFR] => V [CODE] => 00012365246 [CLAS] => 246/12365 [POST] => 1150 [LOCA] => WOLUWE-SAINT-PIERRE [ADR1] => rue de la Cambre [ADRN] => 143 [PAYS] => [CHBR_NBR] => 3 [SURF_HAB] => 160 [SURF_COM] => 0 [SURF_BUR] => 0 [SUPE_TER_1_] => 0 [SUPE_TER_2_] => 2 [SUPE_TER_3_] => 74 [SUPE_TER] => 274 [COMM] => WSP - LISIERE WSL [INFO_CLA] => [VISI_VIRT] => [OFFR->TABLIMME.LIBE_FR] => Maison de rangée [OFFR->TABLGEOG.LIBE_FR] => Woluwé-Saint-Pierre [FLASH_FR] => Idéalement située entre Gribaumont et la Maison Communale de WSP, agréable MAISON 3 chambres développant ±160 m² habitables (233 m² bâtis) agrémentée d'une belle terrasse prolongée par un jardin plein Sud. Hall, living, cuisine super-équipée, 3 chambres, salle de bains, toilettes séparées, caves et garage. Nombreux commerces et transports à proximité. À découvrir !! [FLASH_NL] => [FLASH_EN] => [REGI_TVA] => 0 [PRIX] => 598000 [PHOTO_01] => http://217.145.35.26/Photos/BURIMMO/0100012365246_300_400.jpg [SUSP] => CV [CREA_DATE] => Oct 3 2017 07:45:49:000AM [GPS_X] => -1 [GPS_Y] => -1 [PRES_CLAS] => F [PRIX_WEB] => 1 [PROJ] => [PRIX_MIN] => [PRIX_MAX] => [TABLIMME] => 011 ) [1] => Array ( [OFFR] => V [CODE] => 00012344246 [CLAS] => 246/12344 [POST] => 1150 [LOCA] => WOLUWE-SAINT-PIERRE [ADR1] => avenue des Grands Prix [ADRN] => 80 [PAYS] => [CHBR_NBR] => 5 [SURF_HAB] => 329 [SURF_COM] => 0 [SURF_BUR] => 13 [SUPE_TER_1_] => 0 [SUPE_TER_2_] => 3 [SUPE_TER_3_] => 27 [SUPE_TER] => 327 [COMM] => WSP - GRANDS PRIX [INFO_CLA] => [VISI_VIRT] => [OFFR->TABLIMME.LIBE_FR] => Maison 3 façades [OFFR->TABLGEOG.LIBE_FR] => Stockel [FLASH_FR] => Idéalement située entre la place Dumon (Stockel) et le parvis Sainte-Alix, spacieuse MAISON 3 façades bâtie en 1960 et agrandie en 2003. Elle développe 237 m² habitables pour 329 m² bâtis. Hall, living avec feu-ouvert, 2 bureaux, cuisine super-équipée avec coin à déjeuner, 5 chambres (dont 2 agrémentées d'une belle terrasse en bangkiraï), 2 salles de bains, vaste family-room, caves, garage et grenier. Double-vitrage, alarme, chaudière à pellets récente et agréable jardin sans vis-à-vis. A découvrir ! [FLASH_NL] => [FLASH_EN] => [REGI_TVA] => 0 [PRIX] => 749000 [PHOTO_01] => http://217.145.35.26/Photos/BURIMMO/0100012344246_300_400.jpg [SUSP] => CVCS [CREA_DATE] => Apr 24 2017 10:41:36:000PM [GPS_X] => 4.4646862 [GPS_Y] => 50.8339789 [PRES_CLAS] => F [PRIX_WEB] => 1 [PROJ] => [PRIX_MIN] => [PRIX_MAX] => [TABLIMME] => 012 ) [2] => )

Nos biens à vendre :