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]
Jérôme LAFAY'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 Jérôme LAFAY

Selection
of French properties for sale
by Jérôme LAFAY

Independent Sales Agent
SIREN: 420 126 955

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` = 15663 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]
14 properties

page 1 / 1 - sort by :

Approximate location icon close map

icon top scroll
(default) 11 queries took 427 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` = 15663 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` = 15663 AND `DepartmentsUser`.`department_id` = `Department`.`id`) 003
3SELECT `Codepostal`.`id`, `Codepostal`.`name`, `Codepostal`.`postcode`, `Codepostal`.`department_id` FROM `codepostals` AS `Codepostal` WHERE `Codepostal`.`postcode` = 47260 LIMIT 11113
4SELECT `Department`.`id`, `Department`.`listdesc`, `Department`.`region_id` FROM `departments` AS `Department` WHERE `Department`.`id` = '47' LIMIT 1112
5SELECT `Region`.`id`, `Region`.`name` FROM `regions` AS `Region` WHERE `Region`.`id` = '72' 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` = (15663) AND `Allproperty`.`isinvisible` != 1 1164
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` = (15663) AND `Allproperty`.`isinvisible` != 1 ORDER BY `Allproperty`.`price` DESC, `Allproperty`.`id` DESC LIMIT 481414249
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` = (15663)) AND (`Allproperty`.`is_exclusive` = 1)) AND `Allproperty`.`is_exclusive` = 1 AND `Allproperty`.`isinvisible` != 1 1172
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` = 15663 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_by14
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 13133
(legitnew) 0 query took ms
NrQueryErrorAffectedNum. rowsTook (ms)