SERVEUR  = ESIWEB2
SOCIETE = SOHO
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] => 00001419501 [CLAS] => 1419 [POST] => 1050 [LOCA] => ELSENE [ADR1] => Avenue Louise [ADRN] => 215 [PAYS] => BE [CHBR_NBR] => 1 [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] => IXELLES [INFO_CLA] => [VISI_VIRT] => [OFFR->TABLIMME.LIBE_FR] => Immeuble mixte [OFFR->TABLGEOG.LIBE_FR] => Ixelles [FLASH_FR] => Situés sur l'Avenue Louise Belle surface commerciale de 135m² + studio nouvellement aménagé de + ou - 40m² Le rez de chaussée avant comporte une grande vitrine et une grande pièce arrière servant actuellement de salle d'archives, en mezzanine un bureau et à l'arrière (avec accès privé également) un studio comprenant un hall d'entrée, une pièce de vie avec belle terrasse, une kitchinette et une salle de bain. A voir! Infos et visite 02/265.85.82 [FLASH_NL] => [FLASH_EN] => Located on Avenue Louise, Beautiful 135 m² commercial surface + a 40 m² flat newly arranged. The commercial area is facing the street with a large storefront and includes a second spacious room at the back. The mezzanine is currently used as an office space and the back (with private access) is a flat that offers a lovely living room, a kitchenette, a bathroom and a terrace. Information and visits: 02/265.85.82 [REGI_TVA] => 0 [PRIX] => 525000 [PHOTO_01] => http://217.145.35.26/Photos/SOHO/0100001419501_300_400.jpg [SUSP] => [CREA_DATE] => Aug 6 2017 04:36:57:000PM [GPS_X] => 0 [GPS_Y] => 0 [PRES_CLAS] => [PRIX_WEB] => 1 [PROJ] => [PRIX_MIN] => [PRIX_MAX] => [TABLIMME] => 209 ) [1] => Array ( [OFFR] => V [CODE] => 00002102501 [CLAS] => 2102 [POST] => 1030 [LOCA] => SCHAERBEEK [ADR1] => rue liedts [ADRN] => 15 [PAYS] => BE [CHBR_NBR] => 8 [SURF_HAB] => 350 [SURF_COM] => 0 [SURF_BUR] => 0 [SUPE_TER_1_] => 0 [SUPE_TER_2_] => 0 [SUPE_TER_3_] => 0 [SUPE_TER] => 0 [COMM] => SCHAERBEEK [INFO_CLA] => [VISI_VIRT] => [OFFR->TABLIMME.LIBE_FR] => Immeuble [OFFR->TABLGEOG.LIBE_FR] => Schaerbeek [FLASH_FR] => En Exclusivité totale, l'agence soho properties vous propose a proximité de la rue des brabants un Immeuble de rapport composé de 4 unités : un grand Rez de chaussée composée de 2 flats, une grande pièce de vie ainsi que de 2 kots au 1er étage arrière. au 1er, 2ème et 3ème étage appartement de 2 chambres, living, sdb avec wc et cuisine. Compteurs séparés. Chaudières individuelles. double vitrage, Potentiel locatif :3550 €/mois Pour plus d’informations, contactez l’agence Soho Properties au 02/265.85.82 [FLASH_NL] => Opbrengstwoning bestaande uit 4 woongelegenheden: Ondergronds: een zitplaats, keuken, badkamer, koer/tuin 20 m2 Gelijkvloers/tussenverdieping: 2 slaapkamers + berging 1ste verdieping: zitplaats, eetkamer, 2 slaapkamers + badkamer op de tussenverdieping 2de verdieping: zitplaats, keuken, badkamer en 2 slaapkamers 3de verdieping: zitplaats met open keuken, een slaapkamer met doucheruimte + mogelijk terras Aparte meters. individuele verwarmingsinstallaties. Potentieel verhuurbaar: 3000€/mois Voor verdere inlichtingen, contacteer het agentschap Soho Properties op 02/265.85.82. PEB in aanvraag. [FLASH_EN] => Building of 4 flats: Basement with living room, kitchen, bathroom and courtyard / terrace 20 m2 Rez / entresol: 2 rooms + buanderie 1st floor: Living room, Dining room, Kitchen, 2 Bedrooms + Bathroom on the mezzanine 2nd floor: living room, kitchen, bathroom, 2 bedrooms 3rd floor: Living room with open kitchen, Bedroom with shower + Possibility terrace Separate counters. Individual boilers. Rental potential: 3000 € / month For more information, contact the agency Soho Properties at 02 / 265.85.82 [REGI_TVA] => 0 [PRIX] => 550000 [PHOTO_01] => http://217.145.35.26/Photos/SOHO/0100002102501_300_400.jpg [SUSP] => [CREA_DATE] => Jan 17 2018 07:28:32:000PM [GPS_X] => 0 [GPS_Y] => 0 [PRES_CLAS] => [PRIX_WEB] => 1 [PROJ] => [PRIX_MIN] => [PRIX_MAX] => [TABLIMME] => 20 ) [2] => )

Nos biens à vendre :