SERVEUR  = ESIWEB2
SOCIETE = ZARKOS
SELECT = SELECT TOP 40 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' ORDER BY PRIX ASC,COMM ASC,CODE, PROJ

Array ( [0] => Array ( [OFFR] => V [CODE] => 00000141505 [CLAS] => 0141 [POST] => 7050 [LOCA] => ERBISOEUL [ADR1] => Rue du Canard [ADRN] => 19 [PAYS] => BE [CHBR_NBR] => 3 [SURF_HAB] => 231 [SURF_COM] => 0 [SURF_BUR] => 0 [SUPE_TER_1_] => 0 [SUPE_TER_2_] => 29 [SUPE_TER_3_] => 29 [SUPE_TER] => 2929 [COMM] => ERBISOEUL [INFO_CLA] => [VISI_VIRT] => [OFFR->TABLIMME.LIBE_FR] => Villa [OFFR->TABLGEOG.LIBE_FR] => ERBISOEUL [FLASH_FR] => ''Rue du Canard 19. Superbe villa comtemporaine comprenant hall, grand et lumineux séjour, magnifique cuisine super équipée, véranda, WC, buanderie, bureau, hall de nuit en mezzanine, SDB, SDD, 3 chambres, splendide jardin arboré et clôturé avec terrasse et abris en bois, cave et garage + annexe neuve de +/- 70 m², idéale pour profession libérale ou chambres complémentaires avec SDB.'' Offre actuelle à 310.000 € Disponible à l'acte. Visites et renseignements: AIZ : 065/840.640 [FLASH_NL] => [FLASH_EN] => [REGI_TVA] => 0 [PRIX] => 350000 [PHOTO_01] => http://217.145.35.26/Photos/ZARKOS/0100000141505_300_400.jpg [SUSP] => VEND [CREA_DATE] => Feb 3 2017 12:17:20:000PM [GPS_X] => 0 [GPS_Y] => 0 [PRES_CLAS] => D [PRIX_WEB] => 1 [PROJ] => [PRIX_MIN] => [PRIX_MAX] => [TABLIMME] => 01B ) [1] => )

Nos biens à vendre :