Real estate ownership from data.gouv.fr (Nov. 2021), Geocoded data from Koumoul.com, UBO data from inpi.fr. Enter name of country, person, company, siren number, street, city, etc… Click on the number in the results to see the full record. Click on the person or company name to see all the records for this person/company. You can also do partial searches with the * joker. Example: @Nom_Patronymique *ov @realestates yes | @parcels yes returns the people having family names ending at OV, who are linked to companies who owns premisses or land plots in France. The Geotag search locates the land plots, but not the real estate like flats. A list of persons of interest with questionable wealth has been established by investigative journalists team and can be seen here.
Persons: Free text search by name, company, institution, place, etc. The search can be limited to include only the available fields Ex: @name Ivan will search for Ivan only in the field name. For exact phrases search include the text in quotes ex: "Ivan Ivanov" Available fields: @Nom_Greffe @Numero_Gestion @Siren @Type @Nom_Patronymique @Nom_Usage @Pseudonyme @Prenoms @Denomination @Forme_Juridique @Adresse_Ligne1 @Adresse_Ligne2 @Adresse_Ligne3 @Ville @Code_Commune @Pays @Date_Naissance @Ville_Naissance @Pays_Naissance @Nationalite @Qualite @Rep_Perm_Nom @Rep_Perm_Nom_Usage @Rep_Perm_Prénoms @Rep_Perm_Date_Naissance @Rep_Perm_Ville_Naissance @Rep_Perm_Pays_Naissance @Rep_Perm_Nationalité @Rep_Perm_Adr_Ligne1 @Rep_Perm_Adr_Ligne2 @Rep_Perm_Adr_Ligne3 @Rep_Perm_Ville @Rep_Perm_Pays @date_greffe @Libelle_Evt @filename @department @rep_date @realestates @parcels @ubo @poi @vip
Premisses: Free text search by name, company, institution, place, etc. The search can be limited to include only the available fields Ex: @name Ivan will search for Ivan only in the field name. For exact phrases search include the text in quotes ex: "Ivan Ivanov" Available fields: @filename @departement_champ_geographique @code_direction_champ_geographique @code_commune_champ_geographique @nom_commune_champ_geographique @prefixe_references_cadastrales @section_references_cadastrales @ndeg_plan_references_cadastrales @batiment_identification_du_local @entree_identification_du_local @niveau_identification_du_local @porte_identification_du_local @ndeg_voirie_adresse_du_local @indice_de_repetition_adresse_du_local @code_voie_majic_adresse_du_local @code_voie_rivoli_adresse_du_local @nature_voie_adresse_du_local @nom_voie_adresse_du_local @code_droit_proprietaires_du_local @ndeg_majic_proprietaires_du_local @ndeg_siren_proprietaires_du_local @groupe_personne_proprietaires_du_local @forme_juridique_proprietaires_du_local @forme_juridique_abregee_proprietaires_du_local @denomination_proprietaires_du_local @poi @vip
Parcels: Free text search by name, company, institution, place, etc. The search can be limited to include only the available fields Ex: @name Ivan will search for Ivan only in the field name. For exact phrases search include the text in quotes ex: "Ivan Ivanov" Available fields: @filename @departement_champ_geographique @code_direction_champ_geographique @code_commune_champ_geographique @nom_commune_champ_geographique @prefixe_references_cadastrales @section_references_cadastrales @ndeg_plan_references_cadastrales @ndeg_de_voirie_adresse_parcelle @indice_de_repetition_adresse_parcelle @code_voie_majic_adresse_parcelle @code_voie_rivoli_adresse_parcelle @nature_voie_adresse_parcelle @nom_voie_adresse_parcelle @contenance_caracteristiques_parcelle @suf_evaluation_suf @nature_culture_evaluation_suf @contenance_evaluation_suf @code_droit_proprietaires_parcelle @ndeg_majic_proprietaires_parcelle @ndeg_siren_proprietaires_parcelle @groupe_personne_proprietaires_parcelle @forme_juridique_proprietaires_parcelle @forme_juridique_abregee_proprietaires_parcelle @denomination_proprietaires_parcelle @realestates @parcels @vip
Geoloc: Free text search by name, company, institution, place, etc. The search can be limited to include only the available fields Ex: @name Ivan will search for Ivan only in the field name. For exact phrases search include the text in quotes ex: "Ivan Ivanov" Available fields: @Departement @Code Commune @Nom Commune @Adresse @Code parcelle @Code voie rivoli @SUF @Nature culture @Code droit @NMAJIC @NSIREN @Groupe personne @Forme juridique abregee @Denomination @vip
Premisses: Free text search by name, company, institution, place, etc. The search can be limited to include only the available fields Ex: @name Ivan will search for Ivan only in the field name. For exact phrases search include the text in quotes ex: "Ivan Ivanov" Available fields: @filename @departement_champ_geographique @code_direction_champ_geographique @code_commune_champ_geographique @nom_commune_champ_geographique @prefixe_references_cadastrales @section_references_cadastrales @ndeg_plan_references_cadastrales @batiment_identification_du_local @entree_identification_du_local @niveau_identification_du_local @porte_identification_du_local @ndeg_voirie_adresse_du_local @indice_de_repetition_adresse_du_local @code_voie_majic_adresse_du_local @code_voie_rivoli_adresse_du_local @nature_voie_adresse_du_local @nom_voie_adresse_du_local @code_droit_proprietaires_du_local @ndeg_majic_proprietaires_du_local @ndeg_siren_proprietaires_du_local @groupe_personne_proprietaires_du_local @forme_juridique_proprietaires_du_local @forme_juridique_abregee_proprietaires_du_local @denomination_proprietaires_du_local @poi @vip
Parcels: Free text search by name, company, institution, place, etc. The search can be limited to include only the available fields Ex: @name Ivan will search for Ivan only in the field name. For exact phrases search include the text in quotes ex: "Ivan Ivanov" Available fields: @filename @departement_champ_geographique @code_direction_champ_geographique @code_commune_champ_geographique @nom_commune_champ_geographique @prefixe_references_cadastrales @section_references_cadastrales @ndeg_plan_references_cadastrales @ndeg_de_voirie_adresse_parcelle @indice_de_repetition_adresse_parcelle @code_voie_majic_adresse_parcelle @code_voie_rivoli_adresse_parcelle @nature_voie_adresse_parcelle @nom_voie_adresse_parcelle @contenance_caracteristiques_parcelle @suf_evaluation_suf @nature_culture_evaluation_suf @contenance_evaluation_suf @code_droit_proprietaires_parcelle @ndeg_majic_proprietaires_parcelle @ndeg_siren_proprietaires_parcelle @groupe_personne_proprietaires_parcelle @forme_juridique_proprietaires_parcelle @forme_juridique_abregee_proprietaires_parcelle @denomination_proprietaires_parcelle @realestates @parcels @vip
Geoloc: Free text search by name, company, institution, place, etc. The search can be limited to include only the available fields Ex: @name Ivan will search for Ivan only in the field name. For exact phrases search include the text in quotes ex: "Ivan Ivanov" Available fields: @Departement @Code Commune @Nom Commune @Adresse @Code parcelle @Code voie rivoli @SUF @Nature culture @Code droit @NMAJIC @NSIREN @Groupe personne @Forme juridique abregee @Denomination @vip
Countries:
UBO Citizenships: -AFGHANEALBANAISEALGERIENNEALLEMANDALLEMANDEAMERICAINEAMERICAINE (ETATS UNIS)ANDORRANEANGLAISANGLAISEAPATRIDEARGENTINEARMENIENNEAUSTRALIENNEAUTRICHIENNEAZERBAIDJANAISEBAHREINIENNEBELGEBENINOISEBIELORUSSEBosniaqueBRESILIENNEBRITANIQUEBRITANNIQUEBULGARECAMBODGIENNECAMEROUNAISECANADIENNECentrafricaineChilienneChinoiseCHYPRIOTECOLOMBIENNECOMORIENNECONGOLAISECoreenneCOSTARICAINECroateDANOISEdes Émirats arabes unisdu BruneiEGYPTIENNEEMIRIENNEEQUATORIENNEESPAGNOLEESTONIENNEFFANCAISEFinlandaiseFRAFRANCAISFRANCAISEFRANCAISE ET SUISSEFRANCAISE/BRITANNIQUEGRECQUEHAITIENNEHOLLANDAISEHONG KONGHong-KongHONGROISEIndienneINDONESIENNEIRANIENNEIRLANDAISEIslandaiseISRAELIENNEITALIENNEIVOIRIENNEJaponaiseJORDANIENNEKazakheKOWEITIENNELIBANAISELibyenneLITUANIENNELUXLUXEMBOURGEOISEMALAISIENNEMalgacheMALIENNEMALTAISEMAROCAINEMAURICIENNEMEXICAINEMOLDAVEMonégasqueMONGOLENEERLANDAISNEERLANDAISEnéo ZélandaiseNEW-ZELANDAISNORVEGIENNEPAKISTANAISEPANAMEENNEPHILIPPINEPOLONAISEPortugaiseQATARIENNEROUMAINERusseSAOUDIENNESénégalaiseSERBESINGAPOURIENNESIUSSESLOVAQUESRI-LANKAISESud-AfricaineSUD-COREENNESUEDOISESUISSESyrienneTADJIKETAIWANAISTBCTCHEQUETHAILANDAISETOGOLAISETrinidadienneTUNISIENNETURQUEUKRAINIENNEVENEZUELIENNEVietnamienneYéméniteYOUGOSLAVE
The search MEDRANO 1981-12-07 found 9 results
| # | Siren | Name | Address | Locaux/Premisses | Parcelles/Land Plots |
|---|---|---|---|---|---|
| 2350109 | 377550967 @Company @Persons @UBO @INPI |
Desrousseaux de Medrano Alexandre Marie Régis DoB: 1981-07-10 PoB: 75112 Paris 12 FRANCE P.Physique Quality: Associé @OCCRP Alef @WC |
31 rue Kléber 68000 Colmar France | yes @Cadastre @Geotag |
|
| 7828753 | 827485665 @Company @Persons @UBO @INPI |
MEDRANO Nicolas DoB: 1981-12-07 PoB: 78646 Versailles (78) FRANCE P.Physique Quality: Gérant @OCCRP Alef @WC |
22 Rue du Franc Sergent 78160 Marly-le-Roi FRANCE | ||
| 7875657 | 502969256 @Company @Persons @UBO @INPI |
MEDRANO Nicolas DoB: 1981-12-07 PoB: 78646 Versailles (78) FRANCE P.Physique Quality: Gérant @OCCRP Alef @WC |
4 ter Square de Versailles 78160 Marly-le-Roi FRANCE | ||
| 7955738 | 814438131 @Company @Persons @UBO @INPI |
MEDRANO Nicolas DoB: 1981-12-07 PoB: 78646 Versailles (78) FRANCE P.Physique Quality: Gérant @OCCRP Alef @WC |
22 Rue du Franc Sergent 78160 Marly-le-Roi FRANCE | ||
| 7955739 | 814438131 @Company @Persons @UBO @INPI |
MEDRANO Nicolas DoB: 1981-12-07 PoB: 78646 Versailles (78) FRANCE P.Physique Quality: Associé @OCCRP Alef @WC |
22 Rue du Franc Sergent 78160 Marly-le-Roi FRANCE | ||
| 10659171 | 334396470 @Company @Persons @UBO @INPI |
DESROUSSEAUX DE MEDRANO Alexandre, Marie, Régis DoB: 1981-07-10 PoB: 75112 Paris 12 FRANCE P.Physique Quality: Gérant @OCCRP Alef @WC |
31 rue Kleber 68000 Colmar FRANCE | ||
| 10659172 | 334396470 @Company @Persons @UBO @INPI |
DESROUSSEAUX DE MEDRANO Alexandre, Marie, Régis DoB: 1981-07-10 PoB: 75112 Paris 12 FRANCE P.Physique Quality: Associé @OCCRP Alef @WC |
31 rue Kleber 68000 Colmar FRANCE | ||
| 10663945 | 334172244 @Company @Persons @UBO @INPI |
DESROUSSEAUX DE MEDRANO Alexandre, Marie, Régis DoB: 1981-07-10 PoB: 75112 PARIS 12 FRANCE P.Physique Quality: Gérant @OCCRP Alef @WC |
31 rue Kleber 68000 Colmar FRANCE | yes @Cadastre @Geotag |
|
| 10663946 | 334172244 @Company @Persons @UBO @INPI |
DESROUSSEAUX DE MEDRANO Alexandre, Marie, Régis DoB: 1981-07-10 PoB: 75112 PARIS 12 FRANCE P.Physique Quality: Associé @OCCRP Alef @WC |
31 rue Kleber 68000 Colmar FRANCE | yes @Cadastre @Geotag |
Financial support for this project is provided by Transborder Corruption Archives TBCArchives.org and OCCRP
Investigations using this database:
International:
OCCRP and partners:
Russia:
Ukraine:
ФІРТАШ МАЄ ВИНОРОБНИЙ БІЗНЕС У ФРАНЦІЇ ЗА 7,6 МІЛЬЙОНІВ ЄВРО
Bulgaria:
Бившият шеф на енергетиката Милко Ковачев с имот в Биариц
Howto: Find the real estate owned by a French company
- Do a search by person or UBO or company and locate the persons tagged with Land plots or Premisses. The search operator @realestates yes | @parcels yes in the Persons search will limit the search to those having a land plot or premisses.
- Click on @Geotag to locate the land plots on the map. Detailed cadastral information is available in @Locaux/Premises or @Parcelles/Land Plots.
- Locate the Department (two digits) the Place, the two letters Section and the four digits Parcel N°. Exemple: AA 0011. This information is also available in the Parcel Code in Geotag. The first 5 digits of the Parcel Code are the post code and the last letters/digits are the Section and Parcel N° (ex: 302580000D0143 means post code 30258 ST GILLES CAVALES and last 5 symbols are the Section D and the parcel N° 143).
- Go to https://www.cadastre.gouv.fr/scpc/accueil.do, Select English and click on “Search by cadastral reference instead”.
- Fill the place, the post code, select the department number from the drop down menu, fill the Section and the Parcel N° with the three last digits only. Click on Search
- If there is a result the system will give a link to show the parcel on the map. You can zoom on the map and match it with Google Maps.