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

Array ( [0] => Array ( [OFFR] => V [CODE] => 00000094505 [CLAS] => 0094 [POST] => 7340 [LOCA] => COLFONTAINE [ADR1] => rue de Pâturages [ADRN] => 115 [PAYS] => BE [CHBR_NBR] => 3 [SURF_HAB] => 0 [SURF_COM] => 0 [SURF_BUR] => 0 [SUPE_TER_1_] => 0 [SUPE_TER_2_] => 4 [SUPE_TER_3_] => 25 [SUPE_TER] => 425 [COMM] => COLFONTAINE [INFO_CLA] => [VISI_VIRT] => [OFFR->TABLIMME.LIBE_FR] => Immeuble [OFFR->TABLGEOG.LIBE_FR] => [FLASH_FR] => ''rue de Pâturages 115. Immeuble commercial et privé comp. caves, hall, grande surface de bureaux + appartement 3 ch. Grenier non aménagé. Sup. terrain: 4 ares 25 ca. RC: 1646 €. Chauffage central gaz.'' offre à partir de 115.000 €. Renseignements: AIZ 065/840.640 [FLASH_NL] => [FLASH_EN] => [REGI_TVA] => 0 [PRIX] => 115000 [PHOTO_01] => http://217.145.35.26/Photos/ZARKOS/0100000094505_300_400.jpg [SUSP] => [CREA_DATE] => Sep 22 2016 04:33:33:000PM [GPS_X] => 0 [GPS_Y] => 0 [PRES_CLAS] => F [PRIX_WEB] => 1 [PROJ] => [PRIX_MIN] => [PRIX_MAX] => [TABLIMME] => 20 ) [1] => Array ( [OFFR] => V [CODE] => 00000224505 [CLAS] => 0224 [POST] => 7070 [LOCA] => LE ROEULX [ADR1] => Rue de la Station [ADRN] => 43 [PAYS] => BE [CHBR_NBR] => [SURF_HAB] => 0 [SURF_COM] => 0 [SURF_BUR] => 0 [SUPE_TER_1_] => 0 [SUPE_TER_2_] => 1 [SUPE_TER_3_] => 40 [SUPE_TER] => 140 [COMM] => LE ROEULX [INFO_CLA] => [VISI_VIRT] => [OFFR->TABLIMME.LIBE_FR] => Immeuble [OFFR->TABLGEOG.LIBE_FR] => Mons Est [FLASH_FR] => ''Le Roeulx rue de la Station 43. Immeuble à rénover totalement avec permis d'urbanisme périmé en vue d'obtenir 3 appartements 2 chambres de 90m² sur 2 étages, 3 caves, une cour. Châssis en bois double vitrage.'' Faire offre à partir de 160.000€. Pour visites et renseignements : AIZ 065-840 640-www.aiz.immo [FLASH_NL] => [FLASH_EN] => [REGI_TVA] => 0 [PRIX] => 160000 [PHOTO_01] => http://217.145.35.26/Photos/ZARKOS/0100000224505_300_400.jpg [SUSP] => [CREA_DATE] => Oct 16 2017 02:02:28:000PM [GPS_X] => 0 [GPS_Y] => 0 [PRES_CLAS] => [PRIX_WEB] => 1 [PROJ] => [PRIX_MIN] => [PRIX_MAX] => [TABLIMME] => 20 ) [2] => Array ( [OFFR] => V [CODE] => 00000070505 [CLAS] => 0070 [POST] => 7870 [LOCA] => LENS [ADR1] => Rue de la Baille [ADRN] => 36 24 [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] => LENS [INFO_CLA] => [VISI_VIRT] => [OFFR->TABLIMME.LIBE_FR] => Appartement [OFFR->TABLGEOG.LIBE_FR] => [FLASH_FR] => ''Lens - Rue de la Baille 36/24 Résidence du Bailly, très bel appart. comprenant hall, séjour, cuis. ent. éq., sdb, wc, 2 ch, buanderie, terrasse, cave et empl. parking int.'' Libre d'occupation. prix souhaité : 170.000 €. Pour renseignements et visites: AIZ 065/840 640 [FLASH_NL] => [FLASH_EN] => [REGI_TVA] => 0 [PRIX] => 170000 [PHOTO_01] => http://217.145.35.26/Photos/ZARKOS/0100000070505_300_400.jpg [SUSP] => VEND [CREA_DATE] => Oct 7 2016 09:20:10:000AM [GPS_X] => 0 [GPS_Y] => 0 [PRES_CLAS] => C [PRIX_WEB] => 1 [PROJ] => [PRIX_MIN] => [PRIX_MAX] => [TABLIMME] => 03 ) [3] => Array ( [OFFR] => V [CODE] => 00000085505 [CLAS] => 0085 [POST] => 7020 [LOCA] => NIMY (MONS) [ADR1] => Route d'Ath [ADRN] => 179 08 [PAYS] => BE [CHBR_NBR] => 2 [SURF_HAB] => 85 [SURF_COM] => 0 [SURF_BUR] => 0 [SUPE_TER_1_] => 0 [SUPE_TER_2_] => 0 [SUPE_TER_3_] => 0 [SUPE_TER] => 0 [COMM] => NIMY [INFO_CLA] => [VISI_VIRT] => [OFFR->TABLIMME.LIBE_FR] => Appartement [OFFR->TABLGEOG.LIBE_FR] => Nimy [FLASH_FR] => ''Route d'Ath, 179/08 Bel appartement de 91 m² avec hall, séjour, cuis. équip, SDB , WC, 2 ch, buanderie, terrasse, garage. Chauff. élec. à accumulation'' Prix souhaité: 170.000€ Pour renseignements et visites: AIZ 065/840 640 [FLASH_NL] => [FLASH_EN] => [REGI_TVA] => 0 [PRIX] => 170000 [PHOTO_01] => http://217.145.35.26/Photos/ZARKOS/0100000085505_300_400.jpg [SUSP] => VEND [CREA_DATE] => Aug 8 2017 04:31:19:000PM [GPS_X] => 0 [GPS_Y] => 0 [PRES_CLAS] => D [PRIX_WEB] => 1 [PROJ] => [PRIX_MIN] => [PRIX_MAX] => [TABLIMME] => 03 ) [4] => )

Nos biens à vendre :