Notice (8): Undefined index: listdesc [APP/models/department.php, line 45]
Notice (8): Undefined index: is_exclusive [APP/controllers/allproperties_controller.php, line 4403]
Warning (2): array_key_exists() expects parameter 2 to be array, boolean given [APP/models/allproperty.php, line 788]
Notice (8): Undefined offset: 0 [APP/models/allproperty.php, line 794]
Notice (8): Undefined index: Allproperty [APP/models/allproperty.php, line 351]
Notice (8): Undefined index: Allproperty [APP/models/allproperty.php, line 456]
Notice (8): Undefined index: Allproperty [APP/models/allproperty.php, line 462]
Notice (8): Undefined index: Allproperty [APP/models/allproperty.php, line 469]
Notice (8): Undefined index: Allproperty [APP/models/allproperty.php, line 470]
Notice (8): Undefined index: Allproperty [APP/models/allproperty.php, line 474]
Notice (8): Undefined index: Allproperty [APP/models/allproperty.php, line 479]
Notice (8): Undefined index: is_exclusive [APP/models/allproperty.php, line 483]
François CLERGEAU's selection of French property for sale
My properties red circle favorite
Notice (8): Undefined variable: countFav [APP/views/elements/new/header-desktop-top-menu.ctp, line 67]
avatar support
9-18h - Mon. to Sat. +33 (0)5 53 60 84 88 International
avatar support
click for phone number
9-18h - Mon. to Sat.
+33 (0)5 53 60 84 88
My properties red circle favorite
Notice (8): Undefined variable: countFav [APP/views/elements/new/header-desktop-top-menu.ctp, line 168]
Search icon close icon navigation
Notice (8): Undefined index: sort [APP/views/allproperties/agent.ctp, line 4]
Notice (8): Undefined index: direction [APP/views/allproperties/agent.ctp, line 4]

Selection of French properties for sale by François CLERGEAU

Selection
of French properties for sale
by François CLERGEAU

Independent Sales Agent
SIREN: 512247222

agent photo - françois clergeau
agent photo - françois clergeau

François CLERGEAU
Independent Sales Agent
SIREN: 512247222
Regions
Brittany

About me

Born in Paris, but having worked and lived in London and Yorkshire for 12 years and having bought and sold a house over there, I can understand and explain the many differences between the French and the British systems, whether you are buying or selling a property. I was self employed for 7 years before joining Leggett, upgrading properties in order to sell them or to let them quickly. Before that, I worked in estate agencies for 6 years. I’ve been known to lose at pétanque, seen climbing up... read more

About my area

In the region of Morlaix, North Finistère, variety is the spice of life : the weather, the scenery and even pe ople’s moods can change within a few miles.So do house prices! It usually starts in historic Roscoff which gives you access to numerous sandy beaches, eastbound and westbound, as well as to the centre of Brittany with its magnificent peaks and landscapes. Morlaix itself is a good port of call with its marina, food market, shopping malls and the essential local authorities. Travelling... read more
Born in Paris, but having worked and lived in London and Yorkshire for 12 years and having bought and sold a house over there, I can understand and explain the many differences between the French and the British systems, whether you are buying or selling a property. I was self employed for 7 years before joining Leggett, upgrading properties in order to sell them or to let them quickly. Before that, I worked in estate agencies for 6 years. I’ve been known to lose at pétanque, seen climbing up some rocks in both wet and dry weather (unable to climb back down though) and I’ll go for a stroll on the beach as soon as I find a decent dog or a decent horse. close
In the region of Morlaix, North Finistère, variety is the spice of life : the weather, the scenery and even pe ople’s moods can change within a few miles.So do house prices! It usually starts in historic Roscoff which gives you access to numerous sandy beaches, eastbound and westbound, as well as to the centre of Brittany with its magnificent peaks and landscapes. Morlaix itself is a good port of call with its marina, food market, shopping malls and the essential local authorities. Travelling is made easy using planes, trains or automobiles to the rest of Brittany, France and Europe, but more often than not, you won’t feel the need to stretch out this far. close
Warning (2): array_key_exists() expects parameter 2 to be array, string given [APP/models/allproperty.php, line 788]
Warning (512): SQL Error: 1055: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'frenchestateagents.Allproperty.postcode' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [CORE/cake/libs/model/datasources/dbo_source.php, line 526]

Query: SELECT `Allproperty`.`properpubtown`, `Allproperty`.`postcode`, count(*) as count FROM `allproperties` AS `Allproperty` LEFT JOIN `users` AS `User` ON (`Allproperty`.`user_id` = `User`.`id`) LEFT JOIN `regions` AS `Region` ON (`Allproperty`.`region_id` = `Region`.`id`) LEFT JOIN `departments` AS `Department` ON (`Allproperty`.`department_id` = `Department`.`id`) LEFT JOIN `primarypropertytypes` AS `Primarypropertytype` ON (`Allproperty`.`primarypropertytype_id` = `Primarypropertytype`.`id`) WHERE `user_id` = 13914 AND `Allproperty`.`isinvisible` != 1 GROUP BY properpubtown ORDER BY `properpubtown` ASC, `postcode` ASC

Warning (2): Invalid argument supplied for foreach() [APP/models/allproperty.php, line 350]
Warning (2): Invalid argument supplied for foreach() [APP/models/allproperty.php, line 513]
87 properties

page 2 / 2 - sort by :

Approximate location icon close map

icon top scroll
(default) 11 queries took 407 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `User`.`id`, `User`.`role`, `User`.`name`, `User`.`first_name`, `User`.`surname`, `User`.`email`, `User`.`primary_email`, `User`.`created`, `User`.`modified`, `User`.`team_id`, `User`.`statute`, `User`.`persinfo`, `User`.`persinfo_fr`, `User`.`locinfo`, `User`.`locinfo_fr`, `User`.`location`, `User`.`areas`, `User`.`isdeleted`, `User`.`active`, `User`.`statute_fr`, `User`.`address1`, `User`.`commune`, `User`.`postcode`, `User`.`initials`, `User`.`depts`, `User`.`cp`, `User`.`kbis`, `User`.`siret`, `User`.`trusted`, `User`.`allowed_area`, `User`.`lat`, `User`.`lon`, `User`.`notgeo`, `User`.`picture`, `User`.`hestia_id`, `User`.`phone_number`, `User`.`request_contact_details_fr`, `User`.`request_contact_details_en` FROM `users` AS `User` WHERE `User`.`id` = 13914 LIMIT 1117
2SELECT `Department`.`id`, `Department`.`listcode`, `Department`.`listdesc`, `Department`.`region_id`, `Department`.`dbfield`, `Department`.`text`, `DepartmentsUser`.`id`, `DepartmentsUser`.`user_id`, `DepartmentsUser`.`department_id` FROM `departments` AS `Department` JOIN `departments_users` AS `DepartmentsUser` ON (`DepartmentsUser`.`user_id` = 13914 AND `DepartmentsUser`.`department_id` = `Department`.`id`) 004
3SELECT `Codepostal`.`id`, `Codepostal`.`name`, `Codepostal`.`postcode`, `Codepostal`.`department_id` FROM `codepostals` AS `Codepostal` WHERE `Codepostal`.`postcode` = 29270 LIMIT 11111
4SELECT `Department`.`id`, `Department`.`listdesc`, `Department`.`region_id` FROM `departments` AS `Department` WHERE `Department`.`id` = '29' LIMIT 1117
5SELECT `Region`.`id`, `Region`.`name` FROM `regions` AS `Region` WHERE `Region`.`id` = '53' LIMIT 1114
6SELECT COUNT(*) AS `count` FROM `allproperties` AS `Allproperty` LEFT JOIN `users` AS `User` ON (`Allproperty`.`user_id` = `User`.`id`) LEFT JOIN `regions` AS `Region` ON (`Allproperty`.`region_id` = `Region`.`id`) LEFT JOIN `departments` AS `Department` ON (`Allproperty`.`department_id` = `Department`.`id`) LEFT JOIN `primarypropertytypes` AS `Primarypropertytype` ON (`Allproperty`.`primarypropertytype_id` = `Primarypropertytype`.`id`) WHERE `Allproperty`.`user_id` IN (13914, 13637, 15457, 13386, 14775, 15542, 15609, 15648, 15635) AND `Allproperty`.`isinvisible` != 1 1161
7SELECT `Allproperty`.`id`, `Allproperty`.`propref`, `Allproperty`.`primarypropertytype_name`, `Allproperty`.`pubtown`, `Allproperty`.`properpubtown`, `Department`.`listdesc`, `Region`.`name`, `Allproperty`.`image_0`, `Allproperty`.`status`, `Allproperty`.`isunderoffer`, `Allproperty`.`is_exclusive`, `Allproperty`.`date_made_live`, `Allproperty`.`nrbedrooms`, `Allproperty`.`nrbathrooms`, `Allproperty`.`habitable_m2`, `Allproperty`.`land_m2`, `Allproperty`.`issold`, `Allproperty`.`poa`, `Allproperty`.`bestdeals`, `Allproperty`.`price`, `Allproperty`.`prevprice`, `Allproperty`.`propname`, `Allproperty`.`shortdesc`, `Allproperty`.`floorplan`, `Allproperty`.`tour`, `Allproperty`.`youtube_url`, `Allproperty`.`rhinov_url`, `Allproperty`.`region_id`, `Allproperty`.`lat`, `Allproperty`.`lon`, `Allproperty`.`postcode`, `Allproperty`.`attributes`, `Allproperty`.`mandatetype_id`, `Allproperty`.`department_name`, `Allproperty`.`department_id`, `Allproperty`.`created` FROM `allproperties` AS `Allproperty` LEFT JOIN `users` AS `User` ON (`Allproperty`.`user_id` = `User`.`id`) LEFT JOIN `regions` AS `Region` ON (`Allproperty`.`region_id` = `Region`.`id`) LEFT JOIN `departments` AS `Department` ON (`Allproperty`.`department_id` = `Department`.`id`) LEFT JOIN `primarypropertytypes` AS `Primarypropertytype` ON (`Allproperty`.`primarypropertytype_id` = `Primarypropertytype`.`id`) WHERE `Allproperty`.`user_id` IN (13914, 13637, 15457, 13386, 14775, 15542, 15609, 15648, 15635) AND `Allproperty`.`isinvisible` != 1 ORDER BY `Allproperty`.`price` DESC, `Allproperty`.`id` DESC LIMIT 48, 483939255
8SELECT COUNT(*) AS `count` FROM `allproperties` AS `Allproperty` LEFT JOIN `users` AS `User` ON (`Allproperty`.`user_id` = `User`.`id`) LEFT JOIN `regions` AS `Region` ON (`Allproperty`.`region_id` = `Region`.`id`) LEFT JOIN `departments` AS `Department` ON (`Allproperty`.`department_id` = `Department`.`id`) LEFT JOIN `primarypropertytypes` AS `Primarypropertytype` ON (`Allproperty`.`primarypropertytype_id` = `Primarypropertytype`.`id`) WHERE ((`Allproperty`.`user_id` IN (13914, 13637, 15457, 13386, 14775, 15542, 15609, 15648, 15635)) AND (`Allproperty`.`is_exclusive` = 1)) AND `Allproperty`.`is_exclusive` = 1 AND `Allproperty`.`isinvisible` != 1 1148
9SELECT `Allproperty`.`properpubtown`, `Allproperty`.`postcode`, count(*) as count FROM `allproperties` AS `Allproperty` LEFT JOIN `users` AS `User` ON (`Allproperty`.`user_id` = `User`.`id`) LEFT JOIN `regions` AS `Region` ON (`Allproperty`.`region_id` = `Region`.`id`) LEFT JOIN `departments` AS `Department` ON (`Allproperty`.`department_id` = `Department`.`id`) LEFT JOIN `primarypropertytypes` AS `Primarypropertytype` ON (`Allproperty`.`primarypropertytype_id` = `Primarypropertytype`.`id`) WHERE `user_id` = 13914 AND `Allproperty`.`isinvisible` != 1 GROUP BY properpubtown ORDER BY `properpubtown` ASC, `postcode` ASC 1055: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'frenchestateagents.Allproperty.postcode' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by2
10SELECT `Primarypropertytype`.`id`, `Primarypropertytype`.`name` FROM `primarypropertytypes` AS `Primarypropertytype` WHERE 1 = 1 ORDER BY `id` ASC 13135
11SELECT `Primarypropertytype`.`id`, `Primarypropertytype`.`name` FROM `primarypropertytypes` AS `Primarypropertytype` WHERE 1 = 1 ORDER BY `id` ASC 13133
(legitnew) 0 query took ms
NrQueryErrorAffectedNum. rowsTook (ms)