SERVEUR  = ESIWEB2
SOCIETE = NADIMMO
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] => 00006779235 [CLAS] => 235/6779 [POST] => 1930 [LOCA] => ZAVENTEM [ADR1] => RUE DE LA STATION [ADRN] => 81 [PAYS] => [CHBR_NBR] => [SURF_HAB] => 70 [SURF_COM] => 0 [SURF_BUR] => 0 [SUPE_TER_1_] => 0 [SUPE_TER_2_] => 0 [SUPE_TER_3_] => 0 [SUPE_TER] => 0 [COMM] => ZAVENTEM [INFO_CLA] => [VISI_VIRT] => [OFFR->TABLIMME.LIBE_FR] => Immeuble commercial [OFFR->TABLGEOG.LIBE_FR] => Zaventem, Diegem, Machelen [FLASH_FR] => Idéalement situé, Salon de coiffure à remettre: Fonds: 35.000€ Bail: 900€/ mois A visiter au plus vite [FLASH_NL] => [FLASH_EN] => Perfect location, Hairdresser to be handed over: 35.000 € Lease: 900 € / month To discover as soon as possible [REGI_TVA] => 0 [PRIX] => 20000 [PHOTO_01] => http://217.145.35.26/Photos/NADIMMO/0100006779235_300_400.jpg [SUSP] => [CREA_DATE] => Oct 2 2017 01:37:29:000PM [GPS_X] => 0 [GPS_Y] => 0 [PRES_CLAS] => [PRIX_WEB] => 1 [PROJ] => [PRIX_MIN] => [PRIX_MAX] => [TABLIMME] => 207 ) [1] => Array ( [OFFR] => V [CODE] => 00004840235 [CLAS] => 235/4840 [POST] => 1030 [LOCA] => SCHAERBEEK [ADR1] => Rue Clays [ADRN] => 60 [PAYS] => [CHBR_NBR] => 6 [SURF_HAB] => 300 [SURF_COM] => 0 [SURF_BUR] => 0 [SUPE_TER_1_] => 0 [SUPE_TER_2_] => 0 [SUPE_TER_3_] => 0 [SUPE_TER] => 0 [COMM] => SCHAERBEEK - CEE [INFO_CLA] => [VISI_VIRT] => [OFFR->TABLIMME.LIBE_FR] => Immeuble à appartements [OFFR->TABLGEOG.LIBE_FR] => Schaerbeek [FLASH_FR] => Idéalement situé dans un quartier proches des Communautés Européennes, un très bel immeuble de rapport. Il vous offre sur 300 m² habitables, 3 appartements d'une chambre, un appartement de deux chambres, un studio. Régulièrement entretenu, il a néanmoins été entièrement rénové en 2009. Rapport qualité prix : excellent ! [FLASH_NL] => Ideaal gelegen in een directe omgeving van de Europese Gemeenschappen, een prachtig gebouw rapport. Het biedt 300 m², appartementen 3 slaapkamers, een appartement met twee slaapkamers, een studio. Regelmatig onderhouden, toch werd het volledig gerenoveerd in 2009. Waar voor je geld: uitstekend! [FLASH_EN] => Ideally located in a close neighborhood of the European Communities, a beautiful building report. It offers 300 m², 3 bedroom apartments, a two bedroom apartment, a studio. Regularly maintained, nevertheless it was completely renovated in 2009. Value for money: excellent! [REGI_TVA] => 0 [PRIX] => 660000 [PHOTO_01] => http://217.145.35.26/Photos/NADIMMO/0100004840235_300_400.jpg [SUSP] => [CREA_DATE] => Nov 14 2017 02:53:54:000PM [GPS_X] => 0 [GPS_Y] => 0 [PRES_CLAS] => E [PRIX_WEB] => 0 [PROJ] => [PRIX_MIN] => [PRIX_MAX] => [TABLIMME] => 201 ) [2] => )

Nos biens à vendre :