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 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] => 00000043505 [CLAS] => 0043 [POST] => 7000 [LOCA] => MONS [ADR1] => Avenue de l'Hopital [ADRN] => 1 [PAYS] => BE [CHBR_NBR] => 2 [SURF_HAB] => 80 [SURF_COM] => 0 [SURF_BUR] => 0 [SUPE_TER_1_] => 0 [SUPE_TER_2_] => 0 [SUPE_TER_3_] => 0 [SUPE_TER] => 0 [COMM] => MONS [INFO_CLA] => [VISI_VIRT] => [OFFR->TABLIMME.LIBE_FR] => Appartement [OFFR->TABLGEOG.LIBE_FR] => [FLASH_FR] => ''Avenue de l'Hopital 1/D2 Hall, vestiaire, séjour, cuisine, WC, 2 ch, SDB avec coin buanderie, 2 terrasses, parking intérieur et cave. Chauff. au gaz'' Libre d'occupation. Offre actuelle : 135.000 € - Prix souhaité: 150.000 €. Pour renseignements et visites: AIZ 065/840 640 [FLASH_NL] => [FLASH_EN] => [REGI_TVA] => 0 [PRIX] => 135000 [PHOTO_01] => http://217.145.35.26/Photos/ZARKOS/0100000043505_300_400.jpg [SUSP] => VEND [CREA_DATE] => Oct 7 2016 09:20:10:000AM [GPS_X] => 0 [GPS_Y] => 0 [PRES_CLAS] => B [PRIX_WEB] => 1 [PROJ] => [PRIX_MIN] => [PRIX_MAX] => [TABLIMME] => 03 ) [1] => Array ( [OFFR] => V [CODE] => 00000082505 [CLAS] => 0082 [POST] => 7110 [LOCA] => STREPY-BRACQUEGNIES [ADR1] => Rue Tombou [ADRN] => 106 [PAYS] => BE [CHBR_NBR] => 1 [SURF_HAB] => 45 [SURF_COM] => 0 [SURF_BUR] => 0 [SUPE_TER_1_] => 0 [SUPE_TER_2_] => 0 [SUPE_TER_3_] => 80 [SUPE_TER] => 80 [COMM] => STREPY-BRACQUEGNIES [INFO_CLA] => [VISI_VIRT] => [OFFR->TABLIMME.LIBE_FR] => Maison [OFFR->TABLGEOG.LIBE_FR] => STREPY-BRACQUEGNIES [FLASH_FR] => ''Rue Tombou 106 Séjour, cuis. équip, 1 ch, bureau, sdd, WC, coin buanderie. Cour, jardin. Chauff. central gaz.'' Offre actuelle : 68.000€ Prix souhaité: 85.000€ Pour renseignements et visites: AIZ 065/840 640 [FLASH_NL] => [FLASH_EN] => [REGI_TVA] => 0 [PRIX] => 68000 [PHOTO_01] => http://217.145.35.26/Photos/ZARKOS/0100000082505_300_400.jpg [SUSP] => VEND [CREA_DATE] => Aug 19 2016 01:34:45:000PM [GPS_X] => 0 [GPS_Y] => 0 [PRES_CLAS] => F [PRIX_WEB] => 1 [PROJ] => [PRIX_MIN] => [PRIX_MAX] => [TABLIMME] => 01 ) [2] => Array ( [OFFR] => V [CODE] => 00000135505 [CLAS] => 0135 [POST] => 7020 [LOCA] => NIMY (MONS) [ADR1] => Route d'Ath [ADRN] => 173 07 [PAYS] => BE [CHBR_NBR] => 2 [SURF_HAB] => 88 [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 173/07. Très bel appartement en parfait état comprenant hall, séjour, cuisine équipée, SDB, 2 chambres, buanderie, large terrasse côté jardin, garage intérieur, luminaires et volets partout .'' Libre à l'acte. Offre actuelle à 167.000 € Pour renseignements et visites: AIZ 065/840 640 [FLASH_NL] => [FLASH_EN] => [REGI_TVA] => 0 [PRIX] => 167000 [PHOTO_01] => http://217.145.35.26/Photos/ZARKOS/0100000135505_300_400.jpg [SUSP] => VEND [CREA_DATE] => Dec 5 2016 09:54:23:000AM [GPS_X] => 0 [GPS_Y] => 0 [PRES_CLAS] => D [PRIX_WEB] => 1 [PROJ] => [PRIX_MIN] => [PRIX_MAX] => [TABLIMME] => 031 ) [3] => 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 ) [4] => Array ( [OFFR] => V [CODE] => 00000128505 [CLAS] => 0128 [POST] => 7080 [LOCA] => FRAMERIES [ADR1] => rue de l'Enseignement [ADRN] => 5 [PAYS] => BE [CHBR_NBR] => 3 [SURF_HAB] => 132 [SURF_COM] => 0 [SURF_BUR] => 0 [SUPE_TER_1_] => 0 [SUPE_TER_2_] => 2 [SUPE_TER_3_] => 5 [SUPE_TER] => 205 [COMM] => FRAMERIES [INFO_CLA] => [VISI_VIRT] => [OFFR->TABLIMME.LIBE_FR] => Maison [OFFR->TABLGEOG.LIBE_FR] => Frameries [FLASH_FR] => ''Rue de l'Enseignement 5. Jolie maison en parfait état comp. hall, WC séparé, beau séjour donnant sur la terrasse et le jardin, cuis. équipée séparée, buanderie, hall de nuit, 3 belles ch, SDB équipée, grenier. Jardin agréablement planté, belle terrasse, garage. Chauffage central gaz.'' Ofre actuelle à 190.000 €. Disponible à l'acte. Visites et renseignements: AIZ : 065/840.640 [FLASH_NL] => [FLASH_EN] => [REGI_TVA] => 0 [PRIX] => 190000 [PHOTO_01] => http://217.145.35.26/Photos/ZARKOS/0100000128505_300_400.jpg [SUSP] => VEND [CREA_DATE] => Apr 28 2017 04:14:00:000PM [GPS_X] => 0 [GPS_Y] => 0 [PRES_CLAS] => B [PRIX_WEB] => 1 [PROJ] => [PRIX_MIN] => [PRIX_MAX] => [TABLIMME] => 01 ) [5] => 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 ) [6] => 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 ) [7] => Array ( [OFFR] => V [CODE] => 00000189505 [CLAS] => 0189 [POST] => 7020 [LOCA] => CASTEAU (MONS) [ADR1] => Chaussée de Bruxelles 137 [ADRN] => 22 [PAYS] => BE [CHBR_NBR] => 2 [SURF_HAB] => 111 [SURF_COM] => 0 [SURF_BUR] => 0 [SUPE_TER_1_] => 0 [SUPE_TER_2_] => 0 [SUPE_TER_3_] => 0 [SUPE_TER] => 0 [COMM] => CASTEAU [INFO_CLA] => [VISI_VIRT] => [OFFR->TABLIMME.LIBE_FR] => Appartement [OFFR->TABLGEOG.LIBE_FR] => [FLASH_FR] => ''Chaussée de Bruxelles 137/22 Hall, gd séjour avec terrasse, cuis. ent. équip, SDB + douche, WC, buanderie, 2 ch, garage. Chauff. élec. avec accumulation'' Faire offre à partir de 185.000 €. Libre à l'acte. Pour visites et renseignements: AIZ 065/840.640 [FLASH_NL] => [FLASH_EN] => [REGI_TVA] => 0 [PRIX] => 185000 [PHOTO_01] => http://217.145.35.26/Photos/ZARKOS/0100000189505_300_400.jpg [SUSP] => VEND [CREA_DATE] => Aug 8 2017 04:31:19:000PM [GPS_X] => 0 [GPS_Y] => 0 [PRES_CLAS] => B [PRIX_WEB] => 1 [PROJ] => [PRIX_MIN] => [PRIX_MAX] => [TABLIMME] => 03 ) [8] => Array ( [OFFR] => V [CODE] => 00000040505 [CLAS] => 0040 [POST] => 7000 [LOCA] => MONS [ADR1] => Avenue d'Hyon [ADRN] => 51 31 [PAYS] => BE [CHBR_NBR] => 2 [SURF_HAB] => 91 [SURF_COM] => 0 [SURF_BUR] => 0 [SUPE_TER_1_] => 0 [SUPE_TER_2_] => 0 [SUPE_TER_3_] => 0 [SUPE_TER] => 0 [COMM] => MONS [INFO_CLA] => [VISI_VIRT] => [OFFR->TABLIMME.LIBE_FR] => Appartement [OFFR->TABLGEOG.LIBE_FR] => MONS EXTRA MUROS [FLASH_FR] => ''Mons av d'Hyon 51/31.Rés La Tannerie bel appartement comprenant hall, séjour, cuis. éq., buanderie, hall de nuit, wc, sdb, 2 chambres.Emplacement parking intérieur (47/03).'' Libre d'occupation.Prix souhaité: 165.000€. Pour renseignements et visites: AIZ 065/840 640 [FLASH_NL] => [FLASH_EN] => [REGI_TVA] => 0 [PRIX] => 165000 [PHOTO_01] => http://217.145.35.26/Photos/ZARKOS/0100000040505_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 ) [9] => Array ( [OFFR] => V [CODE] => 00000180505 [CLAS] => 0180 [POST] => 7033 [LOCA] => CUESMES [ADR1] => Rue des Combattants [ADRN] => 54 [PAYS] => BE [CHBR_NBR] => 2 [SURF_HAB] => 91 [SURF_COM] => 0 [SURF_BUR] => 0 [SUPE_TER_1_] => 0 [SUPE_TER_2_] => 1 [SUPE_TER_3_] => 3 [SUPE_TER] => 103 [COMM] => CUESMES [INFO_CLA] => [VISI_VIRT] => [OFFR->TABLIMME.LIBE_FR] => Maison [OFFR->TABLGEOG.LIBE_FR] => Cuesmes [FLASH_FR] => ''Rue des Combattants 54. Salon, salle à manger, cuisine, 2 ch, SDD, grenier aménageable. 2 Caves. Jardin avec terrasse, remise.'' Offre actuelle à 75.000€ Pour renseignements et visites: AIZ 065/840 640 [FLASH_NL] => [FLASH_EN] => [REGI_TVA] => 0 [PRIX] => 75000 [PHOTO_01] => http://217.145.35.26/Photos/ZARKOS/0100000180505_300_400.jpg [SUSP] => VEND [CREA_DATE] => Aug 8 2017 04:31:19:000PM [GPS_X] => 0 [GPS_Y] => 0 [PRES_CLAS] => G [PRIX_WEB] => 1 [PROJ] => [PRIX_MIN] => [PRIX_MAX] => [TABLIMME] => 011 ) [10] => Array ( [OFFR] => V [CODE] => 00000181505 [CLAS] => 0181 [POST] => 7033 [LOCA] => CUESMES [ADR1] => Rue Emile Vandervelde [ADRN] => 195 [PAYS] => BE [CHBR_NBR] => 3 [SURF_HAB] => 150 [SURF_COM] => 0 [SURF_BUR] => 0 [SUPE_TER_1_] => 0 [SUPE_TER_2_] => 2 [SUPE_TER_3_] => 35 [SUPE_TER] => 235 [COMM] => CUESMES [INFO_CLA] => [VISI_VIRT] => [OFFR->TABLIMME.LIBE_FR] => Maison [OFFR->TABLGEOG.LIBE_FR] => Cuesmes [FLASH_FR] => ''Rue Emile Vandervelde 195. Maison comp. hall, gd living, cuis. éq., SDB, 2 ch + 1 petit bureau, grand grenier aménageable, 2 caves. Jardin, terrasse. Chauffage central gaz.'' Faire offre à partir de 110.000€ Pour renseignements et visites: AIZ 065/840 640 [FLASH_NL] => [FLASH_EN] => [REGI_TVA] => 0 [PRIX] => 110000 [PHOTO_01] => http://217.145.35.26/Photos/ZARKOS/0100000181505_300_400.jpg [SUSP] => VEND [CREA_DATE] => Sep 19 2017 12:33:34:000PM [GPS_X] => 0 [GPS_Y] => 0 [PRES_CLAS] => G [PRIX_WEB] => 1 [PROJ] => [PRIX_MIN] => [PRIX_MAX] => [TABLIMME] => 01 ) [11] => Array ( [OFFR] => V [CODE] => 00000116505 [CLAS] => 0116 [POST] => 7050 [LOCA] => JURBISE [ADR1] => Rue de la Fabrique [ADRN] => 1 3.1 [PAYS] => BE [CHBR_NBR] => 3 [SURF_HAB] => 147 [SURF_COM] => 0 [SURF_BUR] => 0 [SUPE_TER_1_] => 0 [SUPE_TER_2_] => 0 [SUPE_TER_3_] => 0 [SUPE_TER] => 0 [COMM] => JURBISE [INFO_CLA] => [VISI_VIRT] => [OFFR->TABLIMME.LIBE_FR] => Appartement [OFFR->TABLGEOG.LIBE_FR] => Mons Nord [FLASH_FR] => ''Idéalement située la Résidence Gardenia propose ce splendide penthouse neuf comprenant un large hall d'entrée, vaste séjour avec terrasse de 50 m², cuisine équipée, hall de nuit, 3 chambres, WC séparé, SDB, SDD et buanderie.'' Bâtiment éco-responsable de très basse énergie et à l'architecture comtemporaine. Vente sous régime TVA. Prix : 276.000 € + parking intérieur 14.500 € et cave 4.000 € - hors frais [FLASH_NL] => [FLASH_EN] => [REGI_TVA] => 1 [PRIX] => 276000 [PHOTO_01] => http://217.145.35.26/Photos/ZARKOS/0100000116505_300_400.jpg [SUSP] => VEND [CREA_DATE] => Mar 2 2017 10:47:14:000AM [GPS_X] => 0 [GPS_Y] => 0 [PRES_CLAS] => B [PRIX_WEB] => 1 [PROJ] => 00000103505 [PRIX_MIN] => [PRIX_MAX] => [TABLIMME] => 031 ) [12] => Array ( [OFFR] => V [CODE] => 00000117505 [CLAS] => 0117 [POST] => 7050 [LOCA] => JURBISE [ADR1] => Rue de la Fabrique [ADRN] => 1 3.2 [PAYS] => BE [CHBR_NBR] => 3 [SURF_HAB] => 151 [SURF_COM] => 0 [SURF_BUR] => 0 [SUPE_TER_1_] => 0 [SUPE_TER_2_] => 0 [SUPE_TER_3_] => 0 [SUPE_TER] => 0 [COMM] => JURBISE [INFO_CLA] => [VISI_VIRT] => [OFFR->TABLIMME.LIBE_FR] => Appartement [OFFR->TABLGEOG.LIBE_FR] => Mons Nord [FLASH_FR] => ''Idéalement située la Résidence Gardenia offre ce splendide penthouse neuf comprenant un large hall d'entrée, vaste séjour avec terrasse de 50 m², cuisine équipée, hall de nuit, 3 chambres, WC séparé, SDB, SDD et buanderie.'' Bâtiment éco-responsable de très basse énergie et à l'architecture comtemporaine. Vente sous régime TVA. Prix : 283.000 € hors frais. [FLASH_NL] => [FLASH_EN] => [REGI_TVA] => 1 [PRIX] => 283000 [PHOTO_01] => http://217.145.35.26/Photos/ZARKOS/0100000117505_300_400.jpg [SUSP] => VEND [CREA_DATE] => Mar 2 2017 10:47:14:000AM [GPS_X] => 0 [GPS_Y] => 0 [PRES_CLAS] => B [PRIX_WEB] => 1 [PROJ] => 00000103505 [PRIX_MIN] => [PRIX_MAX] => [TABLIMME] => 031 ) [13] => )

Nos références