

UPDATE `bien` SET
`refsoftbien` = "",
`id_address` = "",
`timesaisiebien` = "2016-03-05 12:18:00",
`timelastmodifbien` = "2019-02-23 15:40:09",
`timelastmodif` = "2019-02-23 15:40:09",
`afficheecranvitrinebien` = "1",
`nbvisitesdetailbien` = "6",
`categoriebien` = "",
`id_propertyclass` = "73",
`sscategoriebien` = "",
`id_propertyunderclass` = "",
`typebien` = "",
`id_propertytype` = "130",
`idtypebien` = "",
`coupcoeurbien` = "",
`statutbien` = "",
`id_propertystatus` = "125",
`agenceinter` = "",
`datemandatbien` = "",
`typemandatbien` = "",
`id_propertymandatetype` = "",
`id_propertymandatestatus` = "",
`numeromandatbien` = "",
`commentbien` = "",
`numeroclebien` = "",
`adressebien` = "rue de Grenelle",
`batimentbien` = "",
`portebien` = "",
`codebien` = "",
`transportbien` = "",
`prochetransports` = "",
`codepostalbien` = "75007",
`villebien` = "Paris ",
`paysbien` = "",
`idarea` = "",
`refpropriobien` = "-1",
`etagebien` = "-20",
`dernieretagebien` = "",
`prixnetbien` = "",
`prixorderby` = "6950000",
`loyerhebdomadaire` = "",
`loyerjournalier` = "",
`commissionbien` = "",
`honorairesbien` = "",
`honorairechargevendeur` = "1",
`datedisponibilitebien` = "",
`nousconsulterbien` = "",
`chargesbien` = "",
`taxefoncierebien` = "",
`superficiecarrezbien` = "261",
`superficieausolbien` = "314",
`superficieterrainbien` = "",
`nbpiecesbien` = "-1",
`hauteurssplafondbien` = "",
`locationchargescomprisesbien` = "",
`locationcourtedureebien` = "",
`titrebien` = "Rue de Grenelle ",
`descriptifbien` = "
Près de la rue de Bellechasse, dans un magnifique hôtel particulier XVIIIème donnant sur une vaste cour d’honneur paysagée, un triplex de 261 m² Carrez (314 m² au sol), au calme et ensoleillé.
", `descriptifsup` = "Rez-de-chaussée :
Salle à manger
Bureau
Cuisine
1er étage :
2 salons
Chambre de maître avec salle de bains et dressing
Dressings
2ème étage :
3 chambres
Salle d’eau
Sous-sol :
Buanderie
2 parkings dans l’immeuble
Triple exposition
Climatisation
", `descriptifsupen` = "", `ascenseurbien` = "", `prochecommercesbien` = "", `typefacadebien` = "-1", `anneeconstructbien` = "XVIII", `nbetagesimmeublebien` = "-1", `interphonebien` = "1", `digicodebien` = "", `gardienbien` = "1", `parquetbien` = "1", `mouluresbien` = "1", `poutresbien` = "1", `chemineebien` = "1", `tomettesbien` = "", `colombagesbien` = "", `pierresbien` = "", `boiseriesbien` = "", `etatbien` = "-1", `id_propertystate` = "", `cuisinebien` = "-1", `id_kitchentype` = "61", `amenageecuisinebien` = "", `equipeecuisine` = "", `nbchambresbien` = "-1", `nbbureauxbien` = "-1", `nbsdbsbien` = "-1", `nbsallesdeaubien` = "-1", `nbwcsbien` = "-1", `dressingbien` = "", `mezzaninebien` = "", `doublevitragebien` = "", `verrierebien` = "", `veluxbien` = "", `envirsonorebien` = "", `id_soundscape` = "248", `etatpartiescommunes` = "", `id_commonpartsstate` = "", `chauffagebien` = "-1", `typechaufbien` = "-1", `codechauffagebien` = "", `id_heatingcode` = "109", `typechauffagebien` = "-1", `orientationsejour` = "-1", `id_livingguidance` = "", `vuesejour` = "", `visavis` = "", `id_livingsight` = "", `orientationchambreprincipale` = "", `id_masterbedroomguidance` = "", `vuechambreprincipale` = "", `id_masterbedroomsight` = "", `expodiffusionbien` = "", `luminositebien` = "-1", `id_brightness` = "226", `vuedegageebien` = "", `jardinprivatifbien` = "", `balconbien` = "", `terrassebien` = "", `cavebien` = "", `nbparkingbien` = "-1", `nbboxesbien` = "-1", `chambreservicebien` = "", `comblesbien` = "", `nblitsdoublesbien` = "-1", `nblitssimplesbien` = "-1", `cabletvbien` = "", `climatisationbien` = "1", `congelateurbien` = "", `fourbien` = "", `lavevaissellebien` = "", `microondesbien` = "", `nbplacardsbien` = "-1", `telephonebien` = "", `internetbien` = "", `acceshandicapes` = "", `plombbien` = "", `amiantebien` = "", `termitesbien` = "", `acticommercialebien` = "", `longueurfacadebien` = "", `chiffreaffairesbien` = "", `p1bien` = "", `p2bien` = "", `p3bien` = "", `p4bien` = "", `p5bien` = "", `p6bien` = "", `p7bien` = "", `p8bien` = "", `p1zoombien` = "", `p2zoombien` = "", `p3zoombien` = "", `p4zoombien` = "", `p5zoombien` = "", `p6zoombien` = "", `p7zoombien` = "", `p8zoombien` = "", `p1altbien` = "", `p2altbien` = "", `p3altbien` = "", `p4altbien` = "", `p5altbien` = "", `p6altbien` = "", `p7altbien` = "", `p8altbien` = "", `urlvisitevirtuellebien` = "", `descriptionplanbien` = "", `planbien` = "", `annexefilebien` = "", `selogerdiffusion` = "", `sitediffusion` = "", `showroomdiffusion` = "", `polirispublications` = "SL,IS,SN", `supportpressepoliris` = "", `descriptifenbien` = "", `titreenbien` = "", `agenceidbien` = "74", `negoidbien` = "", `negociateurpoliris` = "", `vendeuridbien` = "", `syncphotospoliris` = "1", `rentcalendarid` = "", `recent` = "", `duplex` = "", `id_floor` = "163", `id_nbparts` = "183", `id_facadetype` = "", `id_buildingnbfloors` = "", `id_nbbedrooms` = "232", `id_nbbathrooms` = "234", `id_nbwaterrooms` = "238", `id_nbwcs` = "", `id_nboffices` = "244", `id_nbboxes` = "", `id_nbparkingsoutside` = "", `id_nbsinglebeds` = "", `id_nbdoublebeds` = "", `id_nbcupboards` = "", `panneaubien` = "1", `depotgarantiebien` = "", `taxehabitationbien` = "", `piscinebien` = "", `id_nbmursmitoyens` = "", `soussolbien` = "1", `id_nbparkingsinside` = "879", `id_usage` = "1084", `id_bailtype` = "", `objetbail` = "", `prixpasdeporte` = "", `prixcession` = "", `idcedant` = "", `idinteragence` = "252", `brightnessdiffusionbien` = "", `id_dpe` = "", `id_nbindependentwcs` = "", `id_activity` = "", `caution` = "", `id_indexation` = "", `datedebutbail` = "", `id_rentperiodicity` = "", `numerovoie` = "102", `cuisineavecextraction` = "", `superficiesoussolbien` = "", `superficierdcbien` = "", `superficiepremieretage` = "", `chiffreaffairesbien_n_moins2` = "", `ironcurtain` = "", `loyermensuel` = "", `rideaudefer` = "", `dateeffetbail` = "", `hascaution` = "", `latlong` = "", `idcompanieOLD` = "", `superficieterrassebien` = "", `idintercontact` = "7519", `superficiejardinbien` = "", `facedestatebien` = "", `retrocession` = "", `colocation` = "", `triplex` = "1", `id_nbbedrooms_calme` = "1463", `studioservicesbien` = "", `appartementservicesbien` = "", `combles_non_recuperes` = "", `chargeslocativesbien` = "", `loyermensuelcc` = "", `prixpresentationbien` = "6950000", `prixcommissioncomprisebien` = "6950000", `pourcentagecommissionbien` = "", `datefinmandatbien` = "", `idsystemstatus` = "1", `a_contacter_pour_visite` = "", `superficieannonceebien` = "261", `reprise` = "", `moquette` = "", `id_nbdressings` = "1524", `dpe` = "", `idvendeurcompany` = "", `idusersaisie` = "105", `iduserlastmodif` = "105", `id_ges` = "", `ges` = "", `honorairespercentbien` = "", `retrocessionpercentbien` = "", `loyersoumistva` = "", `taxefoncierechargeloc` = "", `caution_bancaire` = "", `descfondcommerce` = "", `isfondecommerce` = "", `dureebailrestant` = "", `id_propertytype2` = "", `id_propertytype3` = "", `descriptionpresseprodefrancefr` = "", `descriptionpresseprodefranceen` = "", `descriptionpressefigaromagfr` = "", `descriptionpressefigaromagen` = "", `descriptionpressefigaroquotidienfr` = "", `nbbedroomspossibilities` = "1710", `vendeurrepresentedby` = "", `onoffbuttonpromo` = "", `onoffbuttonfavorite` = "", `onoffbuttonlastminute` = "", `clespresentesenagence` = "", `precisions_pour_visite` = "", `dishwasherbien` = "", `isoccupe` = "", `occupantcontact` = "", `occupantsociete` = "", `magpressesup` = "", `magpressesupcontent` = "", `occupantsocieterepresentedby` = "", `echeancebail` = "", `id_propertycommercialtype` = "", `id_propertycommercialtypebis` = "", `mursetfonds` = "", `idbailtypehabitation` = "", `superficie_cour` = "", `dureedubai` = "", `bailrenouvelable` = "", `refrigeratorwithfreezer` = "", `superficie_balcon` = "", `parquetversailles` = "", `carrelage` = "", `pierre` = "", `marbre` = "", `indicateur` = "", `ciment` = "", `beton` = "", `cour` = "", `titreesbien` = "", `descriptifesbien` = "", `descriptifsupes` = "", `syndic` = "", `id_propertymandatstatus` = "", `commentchiffres` = "", `commentdescription` = "", `commentlocalisation` = "", `nbbedroomspossibilitiestocheck` = "", `alias-fr` = "PARIS-75007-Appartement-Vente", `alias-en` = "", `ancienalias-fr` = "", `ancienalias-en` = "", `superficie_patio` = "", `patiobien` = "", `pourcentagehonorairesht` = "", `honorairesht` = "", `loyerdonneht` = "", `honorairesbailleurht` = "", `honorairesbailleurttc` = "", `alerte_auto` = "1", `honorairesttcOLD` = "", `aliasautolastdatetime_fr` = "2016-05-24 10:44:00", `aliasautolastdatetime_en` = "", `pourcentagettchonorairesacquereurs` = "", `nblots` = "", `syndicatcoproprietairesenprocedure` = "", `detailsproceduresyndicatcoproprietaires` = "", `chargesannuellescopropriete` = "", `notinnewproductspage` = "", `referent` = "", `biendeprestige` = "1", `videoiframe` = "", `datepromesse` = "", `prixdeventerealise` = "" WHERE `refbien` = "3815"