Notice (8): Undefined index: group [APP/controllers/allproperties_controller.php, line 4651]
Notice (8): Undefined index: group [APP/controllers/allproperties_controller.php, line 4660]
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]
Warning (2): array_key_exists() expects parameter 2 to be array, string given [APP/models/allproperty.php, line 788]
Notice (8): Undefined index: sort [APP/controllers/allproperties_controller.php, line 4694]
Notice (8): Undefined index: region [APP/controllers/allproperties_controller.php, line 4773]
Chalet for sale in Creuse - 0 French properties found
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

Chalet for sale in Creuse - 0 French properties found

Filter with more criteria

“Some properties are not listed on the site, so please let us know what you're looking for so that we can show you around. Please note that we work in partnership with many other real estate professionals and we can also search for your property for you.”

0 properties

page 0 / 0 - sort by :

Approximate location icon close map

icon top scroll
(default) 24 queries took 732 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `allproperties`1701706
2DESCRIBE `users`38389
3DESCRIBE `departments`664
4DESCRIBE `regions`773
5DESCRIBE `departments_users`333
6DESCRIBE `primarypropertytypes`333
7DESCRIBE `groups`443
8DESCRIBE `proptypes`775
9DESCRIBE `groups_proptypes`333
10DESCRIBE `codepostals`13133
11DESCRIBE `soldproperties`19195
12DESCRIBE `powcategories`993
13DESCRIBE `pows`11113
14SELECT `Primarypropertytype`.`name`, `Primarypropertytype`.`id` FROM `primarypropertytypes` AS `Primarypropertytype` WHERE `name` = 'chalet' LIMIT 1112
15SELECT `Department`.`listdesc`, `Department`.`id` FROM `departments` AS `Department` WHERE `listdesc` = 'creuse' LIMIT 1112
16SELECT 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`.`primarypropertytype_id` = 3 AND `Allproperty`.`department_id` = '23' AND `Allproperty`.`isinvisible` != 1 1157
17SELECT `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`.`primarypropertytype_id` = 3 AND `Allproperty`.`department_id` = '23' AND `Allproperty`.`isinvisible` != 1 ORDER BY `Allproperty`.`date_made_live` desc LIMIT 6000242
18SELECT `Group`.`id`, `Group`.`name` FROM `groups` AS `Group` WHERE 1 = 1 99213
19SELECT `Primarypropertytype`.`id`, `Primarypropertytype`.`name` FROM `primarypropertytypes` AS `Primarypropertytype` WHERE 1 = 1 13134
20SELECT 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`.`primarypropertytype_id` = 3) AND (`Allproperty`.`department_id` = '23'))) AND (`Allproperty`.`is_exclusive` = 1)) AND `Allproperty`.`is_exclusive` = 1 AND `Allproperty`.`isinvisible` != 1 1159
21SELECT `Region`.`name`, `Region`.`id` FROM `regions` AS `Region` WHERE `Region`.`id` NOT IN ('01', '02', '03', '04', '05') ORDER BY `Region`.`name` ASC 222212
22SELECT `Department`.`listdesc`, `Department`.`id`, `Department`.`region_id` FROM `departments` AS `Department` WHERE `Department`.`region_id` IN ('42', '72', '83', '53', '26', '24', '21', '94', '43', '82', '23', '91', '74', '41', '73', '31', '25', '11', '52', '22', '54', '93') 95955
23SELECT `Primarypropertytype`.`id`, `Primarypropertytype`.`name` FROM `primarypropertytypes` AS `Primarypropertytype` WHERE 1 = 1 ORDER BY `id` ASC 131374
24SELECT `Primarypropertytype`.`id`, `Primarypropertytype`.`name` FROM `primarypropertytypes` AS `Primarypropertytype` WHERE 1 = 1 ORDER BY `id` ASC 13139
(legitnew) 1 query took 2 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `testimonials`12122