Notice (8): Undefined offset: 1 [APP/controllers/allproperties_controller.php, line 6642]
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]
Latest properties sale in Languedoc-Roussillon (Occitanie) - 671 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
Notice (8): Undefined index: sort [APP/views/allproperties/property_results.ctp, line 5]
Notice (8): Undefined index: direction [APP/views/allproperties/property_results.ctp, line 5]

Latest properties sale in Languedoc-Roussillon (Occitanie) - 671 French properties found

Open criteria

icone-info-rayon The search radius is only applicable around a town

min. / max. en €
min. / max.
min. / max.

Parution Date

Location

Other Features

Accessibility

icon more criteria open moreclose criteria
min. / max. in €
min. / max.
min. / max.

icone-info-rayon The search radius is only applicable around a town



Parution Date

Location

Other Features

Accessibility

icon more criteria openclose criteria
671 properties

page 9 / 12 - sort by :

Approximate location icon close map

icon top scroll
(default) 21 queries took 398 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `allproperties`1701707
2DESCRIBE `users`38384
3DESCRIBE `departments`665
4DESCRIBE `regions`775
5DESCRIBE `departments_users`334
6DESCRIBE `primarypropertytypes`334
7DESCRIBE `groups`445
8DESCRIBE `proptypes`774
9DESCRIBE `groups_proptypes`333
10DESCRIBE `codepostals`13133
11DESCRIBE `soldproperties`19193
12DESCRIBE `powcategories`994
13DESCRIBE `pows`11113
14SELECT `Primarypropertytype`.`id`, `Primarypropertytype`.`name` FROM `primarypropertytypes` AS `Primarypropertytype` WHERE 1 = 1 ORDER BY `id` ASC 13132
15SELECT `Region`.`id`, `Region`.`name` FROM `regions` AS `Region` WHERE `Region`.`id` = '91' LIMIT 1113
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`.`region_id` = ('91')) AND (`Allproperty`.`region_id` = '91')) AND `Allproperty`.`isinvisible` != 1 1159
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`.`region_id` = ('91')) AND (`Allproperty`.`region_id` = '91')) AND `Allproperty`.`isinvisible` != 1 ORDER BY `Allproperty`.`date_made_live` desc LIMIT 480, 606060239
18SELECT 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`.`region_id` = ('91')) AND (`Allproperty`.`region_id` = '91'))) AND (`Allproperty`.`is_exclusive` = 1)) AND `Allproperty`.`is_exclusive` = 1 AND `Allproperty`.`isinvisible` != 1 1133
19SELECT `Region`.`id`, `Region`.`name` FROM `regions` AS `Region` WHERE `Region`.`id` = '91' LIMIT 1113
20SELECT `Primarypropertytype`.`id`, `Primarypropertytype`.`name` FROM `primarypropertytypes` AS `Primarypropertytype` WHERE 1 = 1 ORDER BY `id` ASC 13133
21SELECT `Primarypropertytype`.`id`, `Primarypropertytype`.`name` FROM `primarypropertytypes` AS `Primarypropertytype` WHERE 1 = 1 ORDER BY `id` ASC 13132
(legitnew) 1 query took 4 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `testimonials`12124