SERVEUR  = ESIWEB2
SOCIETE = ECOIMMO
SELECT = SELECT TOP 120 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] => 00000342510 [CLAS] => 0342 [POST] => 4102 [LOCA] => OUGREE HAUT [ADR1] => L GIELEN [ADRN] => 40 [PAYS] => BE [CHBR_NBR] => 1 [SURF_HAB] => 90 [SURF_COM] => 0 [SURF_BUR] => 0 [SUPE_TER_1_] => 0 [SUPE_TER_2_] => 2 [SUPE_TER_3_] => 26 [SUPE_TER] => 226 [COMM] => OUGREE [INFO_CLA] => [VISI_VIRT] => [OFFR->TABLIMME.LIBE_FR] => Maison [OFFR->TABLGEOG.LIBE_FR] => [FLASH_FR] => OUGREE-HAUT: Coquette maison 1 chambre partiellement rénovée idéale pour investissement ou comme premier achat!Ne tardez pas ,elle va rapidement trouver son propriétaire. DV PVC, chauffage central gaz, electricité non conforme,toiture en bon état. RC: 319€. Possibilité d' agrandissement. A saisir... Gestionnaire du dossier : 0497/455470 [FLASH_NL] => [FLASH_EN] => [REGI_TVA] => 0 [PRIX] => 97000 [PHOTO_01] => http://217.145.35.26/Photos/ECOIMMO/0100000342510_300_400.jpg [SUSP] => VEND [CREA_DATE] => May 24 2017 12:54:32:000PM [GPS_X] => 0 [GPS_Y] => 0 [PRES_CLAS] => E [PRIX_WEB] => 1 [PROJ] => [PRIX_MIN] => [PRIX_MAX] => [TABLIMME] => 011 ) [1] => Array ( [OFFR] => V [CODE] => 00000387510 [CLAS] => 0387 [POST] => 4101 [LOCA] => JEMEPPE-SUR-MEUSE [ADR1] => Rue Rousseau [ADRN] => 24 [PAYS] => BE [CHBR_NBR] => 2 [SURF_HAB] => 0 [SURF_COM] => 0 [SURF_BUR] => 0 [SUPE_TER_1_] => 0 [SUPE_TER_2_] => 0 [SUPE_TER_3_] => 0 [SUPE_TER] => 0 [COMM] => JEMEPPE [INFO_CLA] => [VISI_VIRT] => [OFFR->TABLIMME.LIBE_FR] => Maison bel-étage [OFFR->TABLGEOG.LIBE_FR] => Jemeppe [FLASH_FR] => Proche de toutes commodités: maison bel-étage en très bon état ! Elle se compose comme suit : hall d'entrée, salon, salle à manger, cuisine, 2 chambres, salle de douche avec toilettes, jardin, cave et garage. Particularités: Chassis pvc double vitrage, chauffage au gaz, électricité conforme (bi-horaire), RC: 324€ ! Ne tardez pas ! Gestionnaire du dossier: 0493/54.54.66. [FLASH_NL] => [FLASH_EN] => [REGI_TVA] => 0 [PRIX] => 114000 [PHOTO_01] => http://217.145.35.26/Photos/ECOIMMO/0100000387510_300_400.jpg [SUSP] => VEND [CREA_DATE] => Sep 18 2017 09:02:57:000AM [GPS_X] => 0 [GPS_Y] => 0 [PRES_CLAS] => F [PRIX_WEB] => 1 [PROJ] => [PRIX_MIN] => [PRIX_MAX] => [TABLIMME] => 013 ) [2] => Array ( [OFFR] => V [CODE] => 00000344510 [CLAS] => 0344 [POST] => 4420 [LOCA] => SAINT-NICOLAS (LG.) [ADR1] => Rue Ferdinand Nicolay [ADRN] => 346 [PAYS] => BE [CHBR_NBR] => 3 [SURF_HAB] => 90 [SURF_COM] => 0 [SURF_BUR] => 0 [SUPE_TER_1_] => 0 [SUPE_TER_2_] => 1 [SUPE_TER_3_] => 69 [SUPE_TER] => 169 [COMM] => SAINT-NICOLAS [INFO_CLA] => [VISI_VIRT] => [OFFR->TABLIMME.LIBE_FR] => Maison [OFFR->TABLGEOG.LIBE_FR] => [FLASH_FR] => VENDU SAINT-NICOLAS: Vous recherchez une maison habitable avec quelques travaux à réaliser?Ne cherchez plus, celle-ci est faite pour vous! Elle est prete à acceuillir votre famille! 3ème chambre dans le grenier. RC MODESTE, garage non attenant, nouvelle toiture. A voir sans tarder. Gestionnaire du dossier: 0497/455470. [FLASH_NL] => [FLASH_EN] => [REGI_TVA] => 0 [PRIX] => 109900 [PHOTO_01] => http://217.145.35.26/Photos/ECOIMMO/0100000344510_300_400.jpg [SUSP] => VEND [CREA_DATE] => May 31 2017 12:26:50:000PM [GPS_X] => 0 [GPS_Y] => 0 [PRES_CLAS] => F [PRIX_WEB] => 1 [PROJ] => [PRIX_MIN] => [PRIX_MAX] => [TABLIMME] => 011 ) [3] => )

Nos références