UPDATE `bien` SET `refsoftbien` = "", `id_address` = "", `timesaisiebien` = "2016-03-05 12:18:00", `timelastmodifbien` = "2019-02-23 16:05:16", `timelastmodif` = "2019-02-23 16:05:16", `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"

ERREUR DIAPORAMA, BIEN SANS BANNIERE - desactivation auto 3815
SELECT * FROM `bien` WHERE `bien`.`idsystemstatus` = "1" AND `bien`.`id_propertystatus` = "125" AND `bien`.`coupcoeurbien` = "1" AND `bien`.`idsystemstatus` <= "1" ORDER BY RAND() DESC LIMIT 0,3 BUY - REAL ESTATE PARIS, FRANCE - FINE PROPERTIES - APARTMENTS & HOUSES

A work of art opening onto the Champ-de-mars park

Ref. 440575007 Paris 7 rooms 992 m²Price on request

Saint-Germain : a beautifully renovated apartment

Ref. 496675006 Paris 3 rooms 151 m²3 990 000 € FAI

Paris
75007
An exquisite townhouse close to Place du Palais-Bourbon
152 m²
4 900 000 € FAI
Paris
75006
An exceptional duplex in a historic house, overlooking the river
170 m²
3 950 000 € FAI
Paris
75001
An unobstructed view on the Tuileries gardens and the Eiffel Tower
176 m²
5 750 000 € FAI
Paris
75008
An apartment overlooking gardens close to the Élysée Palace
192 m²
4 950 000 € FAI
Vue-View
Paris
75008
An apartment overlooking the Saint-Philippe-du-Roule church
194 m²
3 200 000 € FAI
Paris
75008
A magnificent, renovated apartment close to Avenue Montaigne
195 m²
3 950 000 € FAI
Paris
75007
Rue de Solférino
211 m²
5 320 000 € FAI
Paris
75002
Un bel appartement rénové, près de la place des Victoires
217 m²
2 990 000 € FAI
Paris
75007
A most elegant apartment close to Saint-Thomas-d'Aquin church
240 m²
5 450 000 € FAI
Ramatuelle
83350
Une ravissante maison à deux pas des plages de Pampelonne
246 m²
7 000 000 € FAI
Paris
75018
In Montmartre, a terrace with a spectacular view
249 m²
7 800 000 € FAI
Paris
75007
A townhouse in an exceptional location
252 m²
4 700 000 € FAI
Paris
75008
Un appartement ensoleillé près de la Madeleine
262 m²
3 690 000 € FAI
Paris
75007
Un duplex exceptionnel directement sur le Champ-de-Mars
300 m²
Price on request
Paris
75007
A magnificent apartment with vast reception areas overlooking a park
306 m²
Price on request
Sole agent
Paris
75116
Un hôtel particulier atypique boulevard Flandrin
320 m²
4 725 000 € FAI
Paris
75007
A fabulous apartment with garden and pool close to Invalides
367 m²
23 175 000 € FAI
Paris
75007
Rue Saint-Dominique
370 m²
8 950 000 € FAI
Paris
75016
A spectacular apartment near Trocadero
385 m²
5 750 000 € FAI
Paris
75116
A collector's piece overlooking the Bois de Boulogne
450 m²
8 400 000 € FAI