UPDATE `bien` SET `refsoftbien` = "", `id_address` = "", `timesaisiebien` = "2016-03-05 12:18:00", `timelastmodifbien` = "2019-02-23 16:37:05", `timelastmodif` = "2019-02-23 16:37:05", `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 magnificent apartment with vast reception areas overlooking a park

Ref. 469075007 Paris 8 rooms 306 m²Price on request

An unobstructed view on the Tuileries gardens and the Eiffel Tower

Ref. 496075001 Paris 5 rooms 176 m²5 750 000 € FAI

Saint-Brieuc
22000
Un emplacement exceptionnel
680 000 € FAI
Paris
75009
Un pied-à-terre idéal à deux pas de la place de la Madeleine
68 m²
820 000 € FAI
Paris
75006
A charming apartment a stone’s throw from Saint-Sulpice
44 m²
840 000 € FAI
Paris
75006
Un deux-pièces en face du lycée Fénelon
58 m²
945 000 € FAI
Paris
75004
Un appartement de charme dans le Marais
76 m²
1 075 000 € FAI
Paris
75004
An apartment with the feel of a house in the heart of the Marais
84 m²
1 200 000 € FAI
Paris
75006
Un appartement lumineux et rénové rue de Seine
66 m²
1 260 000 € FAI
Paris
75004
Comme une maison dans l'Île Saint-Louis
100 m²
1 390 000 € FAI
Pierrefonds
60350
Pierrefonds
650 m²
1 470 000 € FAI
Paris
75006
Rue de Seine : un pied-à-terre entre deux cours
93 m²
1 630 000 € FAI
Paris
75016
Un appartement lumineux à deux pas de la Seine et du Musée d’Art Moderne
129 m²
1 680 000 € FAI
Paris
75001
Un appartement ensoleillé rue Saint-Honoré
151 m²
2 100 000 € FAI
Paris
75006
Saint-Sulpice : an ideal, top floor pied-à-terre
82 m²
2 190 000 € FAI
Paris
75006
A sunlit apartment with a view on the Saint-Germain-des-Prés church
106 m²
2 310 000 € FAI
Paris
75005
A peaceful haven removed from sight
150 m²
2 400 000 € FAI
Paris
75001
An apartment overlooking Place du Marché Saint-Honoré
148 m²
2 490 000 € FAI
Paris
75007
Rue du Bac : un appartement lumineux
96 m²
2 495 000 € FAI
Paris
75007
Un appartement magnifiquement rénové près de la rue du Bac
84 m²
2 495 000 € FAI
Paris
75002
Un bel appartement rénové, près de la place des Victoires
217 m²
2 990 000 € FAI
Faverolles
28210
Une magnifique propriété à 1 heure de Paris
900 m²
3 000 000 € FAI