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"

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

In Montmartre, a terrace with a spectacular view

Ref. 460475018 Paris 6 and more rooms 249 m²7 800 000 € FAI

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

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

FOR A SPECIFIC SEARCH CREATE AN ALERT
Refine your search:
PARISAROUND PARISFRANCENEW LISTINGSLATEST DEALS
For reasons of confidentiality, we are not permitted to publish all our listings on this website. Please contact us.
Sort by priceSort by size
Seine et Marne
77000
An 18th-century estate close to the château of Vaux-le-Vicomte
1600 m²
Price on request
Paris
75007
Quai Voltaire : an exceptional view on the Louvre and the river
132 m²
Price on request
Paris
75007
A magnificent apartment with vast reception areas overlooking a park
306 m²
Price on request
Sole agent
Paris
75007
Un duplex exceptionnel directement sur le Champ-de-Mars
300 m²
Price on request
Paris
75007
A work of art opening onto the Champ-de-mars park
992 m²
Price on request
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
75116
A collector's piece overlooking the Bois de Boulogne
450 m²
8 400 000 € FAI
Paris
75018
In Montmartre, a terrace with a spectacular view
249 m²
7 800 000 € FAI
Ramatuelle
83350
Une ravissante maison à deux pas des plages de Pampelonne
246 m²
7 000 000 € FAI
Paris
75016
A spectacular apartment near Trocadero
385 m²
5 750 000 € FAI
Paris
75001
An unobstructed view on the Tuileries gardens and the Eiffel Tower
176 m²
5 750 000 € FAI
Paris
75007
A most elegant apartment close to Saint-Thomas-d'Aquin church
240 m²
5 450 000 € FAI
Paris
75007
Rue de Solférino
211 m²
5 320 000 € FAI
Paris
75008
An apartment overlooking gardens close to the Élysée Palace
192 m²
4 950 000 € FAI
Paris
75007
An exquisite townhouse close to Place du Palais-Bourbon
152 m²
4 900 000 € FAI
Paris
75116
Un hôtel particulier atypique boulevard Flandrin
320 m²
4 725 000 € FAI
Paris
75007
A townhouse in an exceptional location
252 m²
4 700 000 € FAI
Paris
75006
Saint-Germain : a beautifully renovated apartment
151 m²
3 990 000 € FAI
Paris
75008
A magnificent, renovated apartment close to Avenue Montaigne
195 m²
3 950 000 € FAI