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]
Properties for sale in Haute-loire - 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

Properties for sale in Haute-loire - 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) 16 queries took 627 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `allproperties`17017010
2DESCRIBE `users`38387
3DESCRIBE `departments`665
4DESCRIBE `regions`7768
5DESCRIBE `soldproperties`191973
6SELECT `Primarypropertytype`.`name`, `Primarypropertytype`.`id` FROM `primarypropertytypes` AS `Primarypropertytype` WHERE `name` = 'all' LIMIT 11111
7SELECT `Department`.`listdesc`, `Department`.`id` FROM `departments` AS `Department` WHERE `listdesc` = 'haute_loire' LIMIT 1115
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`.`department_id` = '43' AND `Allproperty`.`price` BETWEEN 2850000.95 and 105000000 AND `Allproperty`.`isinvisible` != 1 1188
9SELECT `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` = '43' AND `Allproperty`.`price` BETWEEN 2850000.95 and 105000000 AND `Allproperty`.`isinvisible` != 1 ORDER BY `Allproperty`.`date_made_live` desc LIMIT 6000250
10SELECT `Group`.`id`, `Group`.`name` FROM `groups` AS `Group` WHERE 1 = 1 998
11SELECT `Primarypropertytype`.`id`, `Primarypropertytype`.`name` FROM `primarypropertytypes` AS `Primarypropertytype` WHERE 1 = 1 13134
12SELECT 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` = 10) AND (`Allproperty`.`department_id` = '43') AND (`Allproperty`.`price` BETWEEN 2850000.95 and 105000000))) AND (`Allproperty`.`is_exclusive` = 1)) AND `Allproperty`.`is_exclusive` = 1 AND `Allproperty`.`isinvisible` != 1 1172
13SELECT `Region`.`name`, `Region`.`id` FROM `regions` AS `Region` WHERE `Region`.`id` NOT IN ('01', '02', '03', '04', '05') ORDER BY `Region`.`name` ASC 22226
14SELECT `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') 959512
15SELECT `Primarypropertytype`.`id`, `Primarypropertytype`.`name` FROM `primarypropertytypes` AS `Primarypropertytype` WHERE 1 = 1 ORDER BY `id` ASC 13135
16SELECT `Primarypropertytype`.`id`, `Primarypropertytype`.`name` FROM `primarypropertytypes` AS `Primarypropertytype` WHERE 1 = 1 ORDER BY `id` ASC 13133
(legitnew) 0 query took ms
NrQueryErrorAffectedNum. rowsTook (ms)