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]
Sally PITCHER'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 Sally PITCHER

Selection
of French properties for sale
by Sally PITCHER

Independent Sales Agent
SIREN: 484065065

avatar
avatar

Sally PITCHER
Independent Sales Agent
SIREN: 484065065
Regions
Brittany

About me

My husband and I quit the UK in 2005. 18 years later we gained French citizenship. I launched my activity as an independent agent with Leggett in 2007. I was the very first agent in the North West. Our children were then born & raised in the Morbihan so we are very much here to stay.... read more

About my area

My area encompasses the departements of the Morbihan & Loire-Atlantique. The "petite cité de caractère" of La Roche Bernard is at the heart of the area I cover. I also cover more inland areas offering lower cost property as well as the highly sought after Gulf of Morbihan & Côte d'Amour where prestigious, high value properties are to be found. The rugged Atlantic coast offers fine beaches, both tourist hotspots and secluded bays. Inland, there are sleepy villages, and bustling market towns.... read more
My husband and I quit the UK in 2005. 18 years later we gained French citizenship. I launched my activity as an independent agent with Leggett in 2007. I was the very first agent in the North West. Our children were then born & raised in the Morbihan so we are very much here to stay. close
My area encompasses the departements of the Morbihan & Loire-Atlantique. The "petite cité de caractère" of La Roche Bernard is at the heart of the area I cover. I also cover more inland areas offering lower cost property as well as the highly sought after Gulf of Morbihan & Côte d'Amour where prestigious, high value properties are to be found. The rugged Atlantic coast offers fine beaches, both tourist hotspots and secluded bays. Inland, there are sleepy villages, and bustling market towns. Southern Brittany enjoys a warm micro-climate. Brittany is not just a French holiday destination, but an area with a distinct character of its own which is steeped in tradition. It has its own culture and language, both with Celtic roots. 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` = 12416 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]
89 properties

page 1 / 2 - sort by :

Approximate location icon close map

icon top scroll
(default) 11 queries took 390 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` = 12416 LIMIT 1112
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` = 12416 AND `DepartmentsUser`.`department_id` = `Department`.`id`) 333
3SELECT `Codepostal`.`id`, `Codepostal`.`name`, `Codepostal`.`postcode`, `Codepostal`.`department_id` FROM `codepostals` AS `Codepostal` WHERE `Codepostal`.`postcode` = 56130 LIMIT 11136
4SELECT `Department`.`id`, `Department`.`listdesc`, `Department`.`region_id` FROM `departments` AS `Department` WHERE `Department`.`id` = '56' LIMIT 1114
5SELECT `Region`.`id`, `Region`.`name` FROM `regions` AS `Region` WHERE `Region`.`id` = '53' LIMIT 1112
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 (12416, 13035, 13860, 13633, 15180, 14402, 14663, 15128) AND `Allproperty`.`isinvisible` != 1 1160
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 (12416, 13035, 13860, 13633, 15180, 14402, 14663, 15128) AND `Allproperty`.`isinvisible` != 1 ORDER BY `Allproperty`.`price` DESC, `Allproperty`.`id` DESC LIMIT 484848238
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 (12416, 13035, 13860, 13633, 15180, 14402, 14663, 15128)) AND (`Allproperty`.`is_exclusive` = 1)) AND `Allproperty`.`is_exclusive` = 1 AND `Allproperty`.`isinvisible` != 1 1135
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` = 12416 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_by3
10SELECT `Primarypropertytype`.`id`, `Primarypropertytype`.`name` FROM `primarypropertytypes` AS `Primarypropertytype` WHERE 1 = 1 ORDER BY `id` ASC 13133
11SELECT `Primarypropertytype`.`id`, `Primarypropertytype`.`name` FROM `primarypropertytypes` AS `Primarypropertytype` WHERE 1 = 1 ORDER BY `id` ASC 13134
(legitnew) 0 query took ms
NrQueryErrorAffectedNum. rowsTook (ms)