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]
Michele ROUXELIN'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 Michele ROUXELIN

Selection
of French properties for sale
by Michele ROUXELIN

Independent Sales Agent
SIREN: 807405329

agent photo - michele rouxelin
agent photo - michele rouxelin

Michele ROUXELIN
Independent Sales Agent
SIREN: 807405329
Regions
Normandy

About me

I strongly love my region and I m happy to be able to help you discover it through my profession. I have worked as an estate agent for several years and am married with 2... read more

About my area

It is good to live in Normandy, particularly in Pays d’Auge where you can enjoy the sweet variety of the beautiful Norman landscapes located between the coast and its rural heart. It is easy to alternate between land and sea and always feel in contact with nature. Pays d’Auge also offers you an easy proximity to England and it’s really not far from Pairs just 2 hours drive. This region has also a remarkable gastronomy, pronounced flavours and recognized savoir-faire in art. Come to live in Pays... read more
I strongly love my region and I m happy to be able to help you discover it through my profession. I have worked as an estate agent for several years and am married with 2 children. close
It is good to live in Normandy, particularly in Pays d’Auge where you can enjoy the sweet variety of the beautiful Norman landscapes located between the coast and its rural heart. It is easy to alternate between land and sea and always feel in contact with nature. Pays d’Auge also offers you an easy proximity to England and it’s really not far from Pairs just 2 hours drive. This region has also a remarkable gastronomy, pronounced flavours and recognized savoir-faire in art. Come to live in Pays d’Auge , you will not be disappointed. 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` = 14208 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]
59 properties

page 1 / 2 - sort by :

Approximate location icon close map

icon top scroll
(default) 11 queries took 490 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` = 14208 LIMIT 11112
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` = 14208 AND `DepartmentsUser`.`department_id` = `Department`.`id`) 0053
3SELECT `Codepostal`.`id`, `Codepostal`.`name`, `Codepostal`.`postcode`, `Codepostal`.`department_id` FROM `codepostals` AS `Codepostal` WHERE `Codepostal`.`postcode` = 14130 LIMIT 1118
4SELECT `Department`.`id`, `Department`.`listdesc`, `Department`.`region_id` FROM `departments` AS `Department` WHERE `Department`.`id` = '14' LIMIT 1113
5SELECT `Region`.`id`, `Region`.`name` FROM `regions` AS `Region` WHERE `Region`.`id` = '25' LIMIT 11111
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 (14208, 15237, 14511, 15455) AND `Allproperty`.`isinvisible` != 1 1142
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 (14208, 15237, 14511, 15455) AND `Allproperty`.`isinvisible` != 1 ORDER BY `Allproperty`.`price` DESC, `Allproperty`.`id` DESC LIMIT 484848300
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 (14208, 15237, 14511, 15455)) AND (`Allproperty`.`is_exclusive` = 1)) AND `Allproperty`.`is_exclusive` = 1 AND `Allproperty`.`isinvisible` != 1 1144
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` = 14208 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_by10
10SELECT `Primarypropertytype`.`id`, `Primarypropertytype`.`name` FROM `primarypropertytypes` AS `Primarypropertytype` WHERE 1 = 1 ORDER BY `id` ASC 13134
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)