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]
Notice (8): Undefined index: sort [APP/controllers/allproperties_controller.php, line 3936]
Reduced Property for Sale in France
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

Reduced Property for Sale in France

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) 19 queries took 176 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `regions`774
2DESCRIBE `departments_users`333
3DESCRIBE `primarypropertytypes`333
4DESCRIBE `groups`445
5DESCRIBE `proptypes`773
6DESCRIBE `groups_proptypes`334
7DESCRIBE `codepostals`131359
8DESCRIBE `soldproperties`191910
9DESCRIBE `powcategories`995
10DESCRIBE `pows`11114
11SELECT 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`.`department_id` = '17' AND `Allproperty`.`date_made_live` > '2025-09-22' AND `Allproperty`.`primarypropertytype_id` = 13 AND `Allproperty`.`region_id` = '23' AND `Allproperty`.`bestdeals` = 1 AND `Allproperty`.`prevprice` != 0 AND `Allproperty`.`isinvisible` != 1 119
12SELECT `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`.`department_id` = '17' AND `Allproperty`.`date_made_live` > '2025-09-22' AND `Allproperty`.`primarypropertytype_id` = 13 AND `Allproperty`.`region_id` = '23' AND `Allproperty`.`bestdeals` = 1 AND `Allproperty`.`prevprice` != 0 AND `Allproperty`.`isinvisible` != 1 ORDER BY `Allproperty`.`date_made_live` desc LIMIT 600042
13SELECT 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`.`department_id` = '17') AND (`Allproperty`.`date_made_live` > '2025-09-22') AND (`Allproperty`.`primarypropertytype_id` = 13) AND (`Allproperty`.`region_id` = '23') AND (`Allproperty`.`bestdeals` = 1) AND (`Allproperty`.`prevprice` != 0))) AND (`Allproperty`.`is_exclusive` = 1)) AND `Allproperty`.`is_exclusive` = 1 AND `Allproperty`.`isinvisible` != 1 118
14SELECT `Group`.`id`, `Group`.`name` FROM `groups` AS `Group` WHERE 1 = 1 993
15SELECT `Primarypropertytype`.`id`, `Primarypropertytype`.`name` FROM `primarypropertytypes` AS `Primarypropertytype` WHERE 1 = 1 13132
16SELECT `Region`.`name`, `Region`.`id` FROM `regions` AS `Region` WHERE `Region`.`id` NOT IN ('01', '02', '03', '04', '05') ORDER BY `Region`.`name` ASC 22223
17SELECT `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') 95953
18SELECT `Primarypropertytype`.`id`, `Primarypropertytype`.`name` FROM `primarypropertytypes` AS `Primarypropertytype` WHERE 1 = 1 ORDER BY `id` ASC 13132
19SELECT `Primarypropertytype`.`id`, `Primarypropertytype`.`name` FROM `primarypropertytypes` AS `Primarypropertytype` WHERE 1 = 1 ORDER BY `id` ASC 13134
(legitnew) 1 query took 5 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `testimonials`12125