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

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
Paris
75007
Avenue de la Bourdonnais
147 m²
3 328 000 € FAI
Vue-View
Paris
75008
An apartment overlooking the Saint-Philippe-du-Roule church
194 m²
3 200 000 € FAI
Paris
75002
Un bel appartement rénové, près de la place des Victoires
217 m²
2 990 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
75001
An apartment overlooking Place du Marché Saint-Honoré
148 m²
2 490 000 € FAI
Paris
75005
A peaceful haven removed from sight
150 m²
2 400 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
75006
Saint-Sulpice : an ideal, top floor pied-à-terre
82 m²
2 190 000 € FAI
Paris
75001
Un appartement ensoleillé rue Saint-Honoré
151 m²
2 100 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
75006
Rue de Seine : un pied-à-terre entre deux cours
93 m²
1 630 000 € FAI
Paris
75004
Comme une maison dans l'Île Saint-Louis
100 m²
1 390 000 € FAI
Paris
75006
Un appartement lumineux et rénové rue de Seine
66 m²
1 260 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
75004
Un appartement de charme dans le Marais
76 m²
1 075 000 € FAI
Paris
75006
Un deux-pièces en face du lycée Fénelon
58 m²
945 000 € FAI
Paris
75006
A charming apartment a stone’s throw from Saint-Sulpice
44 m²
840 000 € FAI
Paris
75009
Un pied-à-terre idéal à deux pas de la place de la Madeleine
68 m²
820 000 € FAI