Reduced Property for Sale in France

$___viewFn = "/app/src/views/elements/new/header-desktop-top-menu.ctp" $___dataForView = array( "primarypropertytypes" => array( "All", "House", "Apartment", "Land", "Chalet", "Chateau", "Commercial", "Lakes", "Mill", "Barn", "Building", "Houseboat", "Parking" ), "properties" => array( array() ), "pageUrl" => array( "page" => "4", "department_id" => "80", "arrival" => "day", "region_id" => "82", "primary_id" => "3", "price" => "h" ), "groups" => array( "Houses", "Commercial", "Prestige", "Lakes", "Apartments", "Income-Business", "Land-Woodland", "Ski", "Equestrian" ), "firstCrumb" => array( "name" => "Reduced Property", "url" => "french-property-for-sale/reduced" ), "selected" => array( "notSold" => false ), "isCustomPage" => true, "countExclusif" => 1, "alternate" => "https://www.leggett-immo.com/acheter-vendre-une-maison/reduced", "selectedCriteria" => array( "page" => "4", "department_id" => "80", "arrival" => "day", "region_id" => "82", "primary_id" => "3", "price" => "h" ), "cache" => CacheHelper CacheHelper::$__replace = array CacheHelper::$__match = array CacheHelper::$cacheAction = NULL CacheHelper::$helpers = NULL CacheHelper::$base = "" CacheHelper::$webroot = "/" CacheHelper::$themeWeb = NULL CacheHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" CacheHelper::$params = array CacheHelper::$action = "reduced" CacheHelper::$plugin = NULL CacheHelper::$data = NULL CacheHelper::$namedArgs = NULL CacheHelper::$argSeparator = NULL CacheHelper::$validationErrors = NULL CacheHelper::$tags = array CacheHelper::$__tainted = NULL CacheHelper::$__cleaned = NULL CacheHelper::$_log = NULL, "html" => HtmlHelper HtmlHelper::$tags = array HtmlHelper::$base = "" HtmlHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" HtmlHelper::$params = array HtmlHelper::$action = "reduced" HtmlHelper::$data = NULL HtmlHelper::$_crumbs = array HtmlHelper::$__docTypes = array HtmlHelper::$helpers = NULL HtmlHelper::$webroot = "/" HtmlHelper::$themeWeb = NULL HtmlHelper::$plugin = NULL HtmlHelper::$namedArgs = NULL HtmlHelper::$argSeparator = NULL HtmlHelper::$validationErrors = NULL HtmlHelper::$__tainted = NULL HtmlHelper::$__cleaned = NULL HtmlHelper::$_log = NULL, "form" => FormHelper FormHelper::$helpers = array FormHelper::$fieldset = array FormHelper::$__options = array FormHelper::$fields = array FormHelper::$requestType = NULL FormHelper::$base = "" FormHelper::$webroot = "/" FormHelper::$themeWeb = NULL FormHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" FormHelper::$params = array FormHelper::$action = "reduced" FormHelper::$plugin = NULL FormHelper::$data = NULL FormHelper::$namedArgs = NULL FormHelper::$argSeparator = NULL FormHelper::$validationErrors = NULL FormHelper::$tags = array FormHelper::$__tainted = NULL FormHelper::$__cleaned = NULL FormHelper::$_log = NULL FormHelper::$Html = HtmlHelper object, "text" => TextHelper TextHelper::$helpers = NULL TextHelper::$base = "" TextHelper::$webroot = "/" TextHelper::$themeWeb = NULL TextHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" TextHelper::$params = array TextHelper::$action = "reduced" TextHelper::$plugin = NULL TextHelper::$data = NULL TextHelper::$namedArgs = NULL TextHelper::$argSeparator = NULL TextHelper::$validationErrors = NULL TextHelper::$tags = array TextHelper::$__tainted = NULL TextHelper::$__cleaned = NULL TextHelper::$_log = NULL, "number" => NumberHelper NumberHelper::$helpers = NULL NumberHelper::$base = "" NumberHelper::$webroot = "/" NumberHelper::$themeWeb = NULL NumberHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" NumberHelper::$params = array NumberHelper::$action = "reduced" NumberHelper::$plugin = NULL NumberHelper::$data = NULL NumberHelper::$namedArgs = NULL NumberHelper::$argSeparator = NULL NumberHelper::$validationErrors = NULL NumberHelper::$tags = array NumberHelper::$__tainted = NULL NumberHelper::$__cleaned = NULL NumberHelper::$_log = NULL, "javascript" => JavascriptHelper JavascriptHelper::$useNative = true JavascriptHelper::$enabled = true JavascriptHelper::$safe = false JavascriptHelper::$tags = array JavascriptHelper::$_blockOptions = array JavascriptHelper::$_cachedEvents = array JavascriptHelper::$_cacheEvents = false JavascriptHelper::$_cacheToFile = false JavascriptHelper::$_cacheAll = false JavascriptHelper::$_rules = array JavascriptHelper::$__scriptBuffer = NULL JavascriptHelper::$helpers = NULL JavascriptHelper::$base = "" JavascriptHelper::$webroot = "/" JavascriptHelper::$themeWeb = NULL JavascriptHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" JavascriptHelper::$params = array JavascriptHelper::$action = "reduced" JavascriptHelper::$plugin = NULL JavascriptHelper::$data = NULL JavascriptHelper::$namedArgs = NULL JavascriptHelper::$argSeparator = NULL JavascriptHelper::$validationErrors = NULL JavascriptHelper::$__tainted = NULL JavascriptHelper::$__cleaned = NULL JavascriptHelper::$_log = NULL, "tagcloud" => TagcloudHelper TagcloudHelper::$helpers = NULL TagcloudHelper::$base = "" TagcloudHelper::$webroot = "/" TagcloudHelper::$themeWeb = NULL TagcloudHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" TagcloudHelper::$params = array TagcloudHelper::$action = "reduced" TagcloudHelper::$plugin = NULL TagcloudHelper::$data = NULL TagcloudHelper::$namedArgs = NULL TagcloudHelper::$argSeparator = NULL TagcloudHelper::$validationErrors = NULL TagcloudHelper::$tags = array TagcloudHelper::$__tainted = NULL TagcloudHelper::$__cleaned = NULL TagcloudHelper::$_log = NULL, "custom" => CustomHelper CustomHelper::$tags = array CustomHelper::$base = "" CustomHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" CustomHelper::$params = array CustomHelper::$action = "reduced" CustomHelper::$data = NULL CustomHelper::$_crumbs = array CustomHelper::$__docTypes = array CustomHelper::$helpers = NULL CustomHelper::$webroot = "/" CustomHelper::$themeWeb = NULL CustomHelper::$plugin = NULL CustomHelper::$namedArgs = NULL CustomHelper::$argSeparator = NULL CustomHelper::$validationErrors = NULL CustomHelper::$__tainted = NULL CustomHelper::$__cleaned = NULL CustomHelper::$_log = NULL, "time" => TimeHelper TimeHelper::$helpers = NULL TimeHelper::$base = "" TimeHelper::$webroot = "/" TimeHelper::$themeWeb = NULL TimeHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" TimeHelper::$params = array TimeHelper::$action = "reduced" TimeHelper::$plugin = NULL TimeHelper::$data = NULL TimeHelper::$namedArgs = NULL TimeHelper::$argSeparator = NULL TimeHelper::$validationErrors = NULL TimeHelper::$tags = array TimeHelper::$__tainted = NULL TimeHelper::$__cleaned = NULL TimeHelper::$_log = NULL, "formVariablesPaginator" => FormVariablesPaginatorHelper FormVariablesPaginatorHelper::$helpers = array FormVariablesPaginatorHelper::$__defaultModel = NULL FormVariablesPaginatorHelper::$options = array FormVariablesPaginatorHelper::$base = "" FormVariablesPaginatorHelper::$webroot = "/" FormVariablesPaginatorHelper::$themeWeb = NULL FormVariablesPaginatorHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" FormVariablesPaginatorHelper::$params = array FormVariablesPaginatorHelper::$action = "reduced" FormVariablesPaginatorHelper::$plugin = NULL FormVariablesPaginatorHelper::$data = NULL FormVariablesPaginatorHelper::$namedArgs = NULL FormVariablesPaginatorHelper::$argSeparator = NULL FormVariablesPaginatorHelper::$validationErrors = NULL FormVariablesPaginatorHelper::$tags = array FormVariablesPaginatorHelper::$__tainted = NULL FormVariablesPaginatorHelper::$__cleaned = NULL FormVariablesPaginatorHelper::$_log = NULL FormVariablesPaginatorHelper::$Html = HtmlHelper object FormVariablesPaginatorHelper::$Ajax = AjaxHelper object, "ajax" => AjaxHelper AjaxHelper::$helpers = array AjaxHelper::$Html = HtmlHelper object AjaxHelper::$Javascript = JavascriptHelper object AjaxHelper::$callbacks = array AjaxHelper::$ajaxOptions = array AjaxHelper::$dragOptions = array AjaxHelper::$dropOptions = array AjaxHelper::$sortOptions = array AjaxHelper::$sliderOptions = array AjaxHelper::$editorOptions = array AjaxHelper::$autoCompleteOptions = array AjaxHelper::$__ajaxBuffer = array AjaxHelper::$base = "" AjaxHelper::$webroot = "/" AjaxHelper::$themeWeb = NULL AjaxHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" AjaxHelper::$params = array AjaxHelper::$action = "reduced" AjaxHelper::$plugin = NULL AjaxHelper::$data = NULL AjaxHelper::$namedArgs = NULL AjaxHelper::$argSeparator = NULL AjaxHelper::$validationErrors = NULL AjaxHelper::$tags = array AjaxHelper::$__tainted = NULL AjaxHelper::$__cleaned = NULL AjaxHelper::$_log = NULL AjaxHelper::$Form = FormHelper object, "icon" => IconHelper IconHelper::$tags = array IconHelper::$base = "" IconHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" IconHelper::$params = array IconHelper::$action = "reduced" IconHelper::$data = NULL IconHelper::$_crumbs = array IconHelper::$__docTypes = array IconHelper::$helpers = NULL IconHelper::$webroot = "/" IconHelper::$themeWeb = NULL IconHelper::$plugin = NULL IconHelper::$namedArgs = NULL IconHelper::$argSeparator = NULL IconHelper::$validationErrors = NULL IconHelper::$__tainted = NULL IconHelper::$__cleaned = NULL IconHelper::$_log = NULL, "drill" => DrillHelper DrillHelper::$tags = array DrillHelper::$base = "" DrillHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" DrillHelper::$params = array DrillHelper::$action = "reduced" DrillHelper::$data = NULL DrillHelper::$_crumbs = array DrillHelper::$__docTypes = array DrillHelper::$helpers = NULL DrillHelper::$webroot = "/" DrillHelper::$themeWeb = NULL DrillHelper::$plugin = NULL DrillHelper::$namedArgs = NULL DrillHelper::$argSeparator = NULL DrillHelper::$validationErrors = NULL DrillHelper::$__tainted = NULL DrillHelper::$__cleaned = NULL DrillHelper::$_log = NULL, "session" => SessionHelper SessionHelper::$helpers = NULL SessionHelper::$__active = true SessionHelper::$valid = false SessionHelper::$error = false SessionHelper::$_userAgent = "a7d63c274f73bb410efb05168d3d225f" SessionHelper::$path = "/" SessionHelper::$lastError = NULL SessionHelper::$security = "medium" SessionHelper::$time = 1761128281 SessionHelper::$sessionTime = 1761140281 SessionHelper::$watchKeys = array SessionHelper::$id = NULL SessionHelper::$_started = false SessionHelper::$host = NULL SessionHelper::$_log = NULL SessionHelper::$cookieLifeTime = 604800 SessionHelper::$base = "" SessionHelper::$webroot = "/" SessionHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" SessionHelper::$params = array SessionHelper::$action = "reduced" SessionHelper::$data = NULL SessionHelper::$themeWeb = NULL SessionHelper::$plugin = NULL, "paginator" => PaginatorHelper PaginatorHelper::$helpers = array PaginatorHelper::$__defaultModel = "Allproperty" PaginatorHelper::$options = array PaginatorHelper::$base = "" PaginatorHelper::$webroot = "/" PaginatorHelper::$themeWeb = NULL PaginatorHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" PaginatorHelper::$params = array PaginatorHelper::$action = "reduced" PaginatorHelper::$plugin = NULL PaginatorHelper::$data = NULL PaginatorHelper::$namedArgs = NULL PaginatorHelper::$argSeparator = NULL PaginatorHelper::$validationErrors = NULL PaginatorHelper::$tags = array PaginatorHelper::$__tainted = NULL PaginatorHelper::$__cleaned = NULL PaginatorHelper::$_log = NULL PaginatorHelper::$Html = HtmlHelper object PaginatorHelper::$Ajax = AjaxHelper object ) $loadHelpers = false $cached = false $loadedHelpers = array() $primarypropertytypes = array( "All", "House", "Apartment", "Land", "Chalet", "Chateau", "Commercial", "Lakes", "Mill", "Barn", "Building", "Houseboat", "Parking" ) $properties = array( array( "Allproperty" => array(), "Department" => array(), "Region" => array(), "Attribute" => array() ) ) $pageUrl = array( "page" => "4", "department_id" => "80", "arrival" => "day", "region_id" => "82", "primary_id" => "3", "price" => "h" ) $groups = array( "Houses", "Commercial", "Prestige", "Lakes", "Apartments", "Income-Business", "Land-Woodland", "Ski", "Equestrian" ) $firstCrumb = array( "name" => "Reduced Property", "url" => "french-property-for-sale/reduced" ) $selected = array( "notSold" => false ) $isCustomPage = true $countExclusif = 1 $alternate = "https://www.leggett-immo.com/acheter-vendre-une-maison/reduced" $selectedCriteria = array( "page" => "4", "department_id" => "80", "arrival" => "day", "region_id" => "82", "primary_id" => "3", "price" => "h" ) $cache = CacheHelper CacheHelper::$__replace = array CacheHelper::$__match = array CacheHelper::$cacheAction = NULL CacheHelper::$helpers = NULL CacheHelper::$base = "" CacheHelper::$webroot = "/" CacheHelper::$themeWeb = NULL CacheHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" CacheHelper::$params = array CacheHelper::$action = "reduced" CacheHelper::$plugin = NULL CacheHelper::$data = NULL CacheHelper::$namedArgs = NULL CacheHelper::$argSeparator = NULL CacheHelper::$validationErrors = NULL CacheHelper::$tags = array CacheHelper::$__tainted = NULL CacheHelper::$__cleaned = NULL CacheHelper::$_log = NULL $html = HtmlHelper HtmlHelper::$tags = array HtmlHelper::$base = "" HtmlHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" HtmlHelper::$params = array HtmlHelper::$action = "reduced" HtmlHelper::$data = NULL HtmlHelper::$_crumbs = array HtmlHelper::$__docTypes = array HtmlHelper::$helpers = NULL HtmlHelper::$webroot = "/" HtmlHelper::$themeWeb = NULL HtmlHelper::$plugin = NULL HtmlHelper::$namedArgs = NULL HtmlHelper::$argSeparator = NULL HtmlHelper::$validationErrors = NULL HtmlHelper::$__tainted = NULL HtmlHelper::$__cleaned = NULL HtmlHelper::$_log = NULL $form = FormHelper FormHelper::$helpers = array FormHelper::$fieldset = array FormHelper::$__options = array FormHelper::$fields = array FormHelper::$requestType = NULL FormHelper::$base = "" FormHelper::$webroot = "/" FormHelper::$themeWeb = NULL FormHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" FormHelper::$params = array FormHelper::$action = "reduced" FormHelper::$plugin = NULL FormHelper::$data = NULL FormHelper::$namedArgs = NULL FormHelper::$argSeparator = NULL FormHelper::$validationErrors = NULL FormHelper::$tags = array FormHelper::$__tainted = NULL FormHelper::$__cleaned = NULL FormHelper::$_log = NULL FormHelper::$Html = HtmlHelper object $text = TextHelper TextHelper::$helpers = NULL TextHelper::$base = "" TextHelper::$webroot = "/" TextHelper::$themeWeb = NULL TextHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" TextHelper::$params = array TextHelper::$action = "reduced" TextHelper::$plugin = NULL TextHelper::$data = NULL TextHelper::$namedArgs = NULL TextHelper::$argSeparator = NULL TextHelper::$validationErrors = NULL TextHelper::$tags = array TextHelper::$__tainted = NULL TextHelper::$__cleaned = NULL TextHelper::$_log = NULL $number = NumberHelper NumberHelper::$helpers = NULL NumberHelper::$base = "" NumberHelper::$webroot = "/" NumberHelper::$themeWeb = NULL NumberHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" NumberHelper::$params = array NumberHelper::$action = "reduced" NumberHelper::$plugin = NULL NumberHelper::$data = NULL NumberHelper::$namedArgs = NULL NumberHelper::$argSeparator = NULL NumberHelper::$validationErrors = NULL NumberHelper::$tags = array NumberHelper::$__tainted = NULL NumberHelper::$__cleaned = NULL NumberHelper::$_log = NULL $javascript = JavascriptHelper JavascriptHelper::$useNative = true JavascriptHelper::$enabled = true JavascriptHelper::$safe = false JavascriptHelper::$tags = array JavascriptHelper::$_blockOptions = array JavascriptHelper::$_cachedEvents = array JavascriptHelper::$_cacheEvents = false JavascriptHelper::$_cacheToFile = false JavascriptHelper::$_cacheAll = false JavascriptHelper::$_rules = array JavascriptHelper::$__scriptBuffer = NULL JavascriptHelper::$helpers = NULL JavascriptHelper::$base = "" JavascriptHelper::$webroot = "/" JavascriptHelper::$themeWeb = NULL JavascriptHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" JavascriptHelper::$params = array JavascriptHelper::$action = "reduced" JavascriptHelper::$plugin = NULL JavascriptHelper::$data = NULL JavascriptHelper::$namedArgs = NULL JavascriptHelper::$argSeparator = NULL JavascriptHelper::$validationErrors = NULL JavascriptHelper::$__tainted = NULL JavascriptHelper::$__cleaned = NULL JavascriptHelper::$_log = NULL $tagcloud = TagcloudHelper TagcloudHelper::$helpers = NULL TagcloudHelper::$base = "" TagcloudHelper::$webroot = "/" TagcloudHelper::$themeWeb = NULL TagcloudHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" TagcloudHelper::$params = array TagcloudHelper::$action = "reduced" TagcloudHelper::$plugin = NULL TagcloudHelper::$data = NULL TagcloudHelper::$namedArgs = NULL TagcloudHelper::$argSeparator = NULL TagcloudHelper::$validationErrors = NULL TagcloudHelper::$tags = array TagcloudHelper::$__tainted = NULL TagcloudHelper::$__cleaned = NULL TagcloudHelper::$_log = NULL $custom = CustomHelper CustomHelper::$tags = array CustomHelper::$base = "" CustomHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" CustomHelper::$params = array CustomHelper::$action = "reduced" CustomHelper::$data = NULL CustomHelper::$_crumbs = array CustomHelper::$__docTypes = array CustomHelper::$helpers = NULL CustomHelper::$webroot = "/" CustomHelper::$themeWeb = NULL CustomHelper::$plugin = NULL CustomHelper::$namedArgs = NULL CustomHelper::$argSeparator = NULL CustomHelper::$validationErrors = NULL CustomHelper::$__tainted = NULL CustomHelper::$__cleaned = NULL CustomHelper::$_log = NULL $time = TimeHelper TimeHelper::$helpers = NULL TimeHelper::$base = "" TimeHelper::$webroot = "/" TimeHelper::$themeWeb = NULL TimeHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" TimeHelper::$params = array TimeHelper::$action = "reduced" TimeHelper::$plugin = NULL TimeHelper::$data = NULL TimeHelper::$namedArgs = NULL TimeHelper::$argSeparator = NULL TimeHelper::$validationErrors = NULL TimeHelper::$tags = array TimeHelper::$__tainted = NULL TimeHelper::$__cleaned = NULL TimeHelper::$_log = NULL $formVariablesPaginator = FormVariablesPaginatorHelper FormVariablesPaginatorHelper::$helpers = array FormVariablesPaginatorHelper::$__defaultModel = NULL FormVariablesPaginatorHelper::$options = array FormVariablesPaginatorHelper::$base = "" FormVariablesPaginatorHelper::$webroot = "/" FormVariablesPaginatorHelper::$themeWeb = NULL FormVariablesPaginatorHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" FormVariablesPaginatorHelper::$params = array FormVariablesPaginatorHelper::$action = "reduced" FormVariablesPaginatorHelper::$plugin = NULL FormVariablesPaginatorHelper::$data = NULL FormVariablesPaginatorHelper::$namedArgs = NULL FormVariablesPaginatorHelper::$argSeparator = NULL FormVariablesPaginatorHelper::$validationErrors = NULL FormVariablesPaginatorHelper::$tags = array FormVariablesPaginatorHelper::$__tainted = NULL FormVariablesPaginatorHelper::$__cleaned = NULL FormVariablesPaginatorHelper::$_log = NULL FormVariablesPaginatorHelper::$Html = HtmlHelper object FormVariablesPaginatorHelper::$Ajax = AjaxHelper object $ajax = AjaxHelper AjaxHelper::$helpers = array AjaxHelper::$Html = HtmlHelper object AjaxHelper::$Javascript = JavascriptHelper object AjaxHelper::$callbacks = array AjaxHelper::$ajaxOptions = array AjaxHelper::$dragOptions = array AjaxHelper::$dropOptions = array AjaxHelper::$sortOptions = array AjaxHelper::$sliderOptions = array AjaxHelper::$editorOptions = array AjaxHelper::$autoCompleteOptions = array AjaxHelper::$__ajaxBuffer = array AjaxHelper::$base = "" AjaxHelper::$webroot = "/" AjaxHelper::$themeWeb = NULL AjaxHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" AjaxHelper::$params = array AjaxHelper::$action = "reduced" AjaxHelper::$plugin = NULL AjaxHelper::$data = NULL AjaxHelper::$namedArgs = NULL AjaxHelper::$argSeparator = NULL AjaxHelper::$validationErrors = NULL AjaxHelper::$tags = array AjaxHelper::$__tainted = NULL AjaxHelper::$__cleaned = NULL AjaxHelper::$_log = NULL AjaxHelper::$Form = FormHelper object $icon = IconHelper IconHelper::$tags = array IconHelper::$base = "" IconHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" IconHelper::$params = array IconHelper::$action = "reduced" IconHelper::$data = NULL IconHelper::$_crumbs = array IconHelper::$__docTypes = array IconHelper::$helpers = NULL IconHelper::$webroot = "/" IconHelper::$themeWeb = NULL IconHelper::$plugin = NULL IconHelper::$namedArgs = NULL IconHelper::$argSeparator = NULL IconHelper::$validationErrors = NULL IconHelper::$__tainted = NULL IconHelper::$__cleaned = NULL IconHelper::$_log = NULL $drill = DrillHelper DrillHelper::$tags = array DrillHelper::$base = "" DrillHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" DrillHelper::$params = array DrillHelper::$action = "reduced" DrillHelper::$data = NULL DrillHelper::$_crumbs = array DrillHelper::$__docTypes = array DrillHelper::$helpers = NULL DrillHelper::$webroot = "/" DrillHelper::$themeWeb = NULL DrillHelper::$plugin = NULL DrillHelper::$namedArgs = NULL DrillHelper::$argSeparator = NULL DrillHelper::$validationErrors = NULL DrillHelper::$__tainted = NULL DrillHelper::$__cleaned = NULL DrillHelper::$_log = NULL $session = SessionHelper SessionHelper::$helpers = NULL SessionHelper::$__active = true SessionHelper::$valid = false SessionHelper::$error = false SessionHelper::$_userAgent = "a7d63c274f73bb410efb05168d3d225f" SessionHelper::$path = "/" SessionHelper::$lastError = NULL SessionHelper::$security = "medium" SessionHelper::$time = 1761128281 SessionHelper::$sessionTime = 1761140281 SessionHelper::$watchKeys = array SessionHelper::$id = NULL SessionHelper::$_started = false SessionHelper::$host = NULL SessionHelper::$_log = NULL SessionHelper::$cookieLifeTime = 604800 SessionHelper::$base = "" SessionHelper::$webroot = "/" SessionHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" SessionHelper::$params = array SessionHelper::$action = "reduced" SessionHelper::$data = NULL SessionHelper::$themeWeb = NULL SessionHelper::$plugin = NULL $paginator = PaginatorHelper PaginatorHelper::$helpers = array PaginatorHelper::$__defaultModel = "Allproperty" PaginatorHelper::$options = array PaginatorHelper::$base = "" PaginatorHelper::$webroot = "/" PaginatorHelper::$themeWeb = NULL PaginatorHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" PaginatorHelper::$params = array PaginatorHelper::$action = "reduced" PaginatorHelper::$plugin = NULL PaginatorHelper::$data = NULL PaginatorHelper::$namedArgs = NULL PaginatorHelper::$argSeparator = NULL PaginatorHelper::$validationErrors = NULL PaginatorHelper::$tags = array PaginatorHelper::$__tainted = NULL PaginatorHelper::$__cleaned = NULL PaginatorHelper::$_log = NULL PaginatorHelper::$Html = HtmlHelper object PaginatorHelper::$Ajax = AjaxHelper object

include - APP/views/elements/new/header-desktop-top-menu.ctp, line 67 View::_render() - CORE/cake/libs/view/view.php, line 665 View::element() - CORE/cake/libs/view/view.php, line 342 include - APP/views/elements/new/header.ctp, line 16 View::_render() - CORE/cake/libs/view/view.php, line 665 View::element() - CORE/cake/libs/view/view.php, line 342 include - APP/views/layouts/list.ctp, line 105 View::_render() - CORE/cake/libs/view/view.php, line 665 View::renderLayout() - CORE/cake/libs/view/view.php, line 453 View::render() - CORE/cake/libs/view/view.php, line 387 Controller::render() - CORE/cake/libs/controller/controller.php, line 815 AllpropertiesController::reduced() - APP/controllers/allproperties_controller.php, line 3969 Object::dispatchMethod() - CORE/cake/libs/object.php, line 115 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 226 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 193 [main] - APP/webroot/index.php, line 88

include - APP/views/elements/new/header-desktop-top-menu.ctp, line 168 View::_render() - CORE/cake/libs/view/view.php, line 665 View::element() - CORE/cake/libs/view/view.php, line 342 include - APP/views/elements/new/header.ctp, line 16 View::_render() - CORE/cake/libs/view/view.php, line 665 View::element() - CORE/cake/libs/view/view.php, line 342 include - APP/views/layouts/list.ctp, line 105 View::_render() - CORE/cake/libs/view/view.php, line 665 View::renderLayout() - CORE/cake/libs/view/view.php, line 453 View::render() - CORE/cake/libs/view/view.php, line 387 Controller::render() - CORE/cake/libs/controller/controller.php, line 815 AllpropertiesController::reduced() - APP/controllers/allproperties_controller.php, line 3969 Object::dispatchMethod() - CORE/cake/libs/object.php, line 115 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 226 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 193 [main] - APP/webroot/index.php, line 88

$___viewFn = "/app/src/views/allproperties/property_results_with_bar.ctp" $___dataForView = array( "primarypropertytypes" => array( "All", "House", "Apartment", "Land", "Chalet", "Chateau", "Commercial", "Lakes", "Mill", "Barn", "Building", "Houseboat", "Parking" ), "properties" => array( array() ), "pageUrl" => array( "page" => "4", "department_id" => "80", "arrival" => "day", "region_id" => "82", "primary_id" => "3", "price" => "h" ), "groups" => array( "Houses", "Commercial", "Prestige", "Lakes", "Apartments", "Income-Business", "Land-Woodland", "Ski", "Equestrian" ), "firstCrumb" => array( "name" => "Reduced Property", "url" => "french-property-for-sale/reduced" ), "selected" => array( "notSold" => false ), "isCustomPage" => true, "countExclusif" => 1, "alternate" => "https://www.leggett-immo.com/acheter-vendre-une-maison/reduced", "selectedCriteria" => array( "page" => "4", "department_id" => "80", "arrival" => "day", "region_id" => "82", "primary_id" => "3", "price" => "h" ), "cakeDebug" => AllpropertiesController AllpropertiesController::$name = "Allproperties" AllpropertiesController::$helpers = array AllpropertiesController::$components = array AllpropertiesController::$uses = array AllpropertiesController::$shortfields = array AllpropertiesController::$shortfieldView = array AllpropertiesController::$shortfieldList = array AllpropertiesController::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" AllpropertiesController::$webroot = "/" AllpropertiesController::$action = "reduced" AllpropertiesController::$params = array AllpropertiesController::$data = NULL AllpropertiesController::$paginate = array AllpropertiesController::$viewPath = "allproperties" AllpropertiesController::$layoutPath = NULL AllpropertiesController::$viewVars = array AllpropertiesController::$pageTitle = "Reduced Property for Sale in France" AllpropertiesController::$modelNames = array AllpropertiesController::$base = "" AllpropertiesController::$layout = "list" AllpropertiesController::$autoRender = false AllpropertiesController::$autoLayout = true AllpropertiesController::$Component = Component object AllpropertiesController::$view = "View" AllpropertiesController::$ext = ".ctp" AllpropertiesController::$output = NULL AllpropertiesController::$plugin = NULL AllpropertiesController::$cacheAction = false AllpropertiesController::$persistModel = false AllpropertiesController::$passedArgs = array AllpropertiesController::$scaffold = false AllpropertiesController::$methods = array AllpropertiesController::$modelClass = "Allproperty" AllpropertiesController::$modelKey = "allproperty" AllpropertiesController::$validationErrors = NULL AllpropertiesController::$_log = NULL AllpropertiesController::$Session = SessionComponent object AllpropertiesController::$Cookie = CookieComponent object AllpropertiesController::$RequestHandler = RequestHandlerComponent object AllpropertiesController::$Currency = CurrencyComponent object AllpropertiesController::$PaginateFormVariables = PaginateFormVariablesComponent object AllpropertiesController::$UrlShortener = UrlShortenerComponent object AllpropertiesController::$Prg = PrgComponent object AllpropertiesController::$Allproperty = Allproperty object AllpropertiesController::$Region = Region object AllpropertiesController::$Department = Department object AllpropertiesController::$User = User object AllpropertiesController::$Group = Group object AllpropertiesController::$Codepostal = Codepostal object AllpropertiesController::$Proptype = Proptype object AllpropertiesController::$Primarypropertytype = Primarypropertytype object AllpropertiesController::$Soldproperty = Soldproperty object AllpropertiesController::$Soldallproperty = Soldallproperty object AllpropertiesController::$Testimonial = Testimonial object AllpropertiesController::$Powcategory = Powcategory object ) $loadHelpers = true $cached = false $loadedHelpers = array( "Cache" => CacheHelper CacheHelper::$__replace = array CacheHelper::$__match = array CacheHelper::$cacheAction = NULL CacheHelper::$helpers = NULL CacheHelper::$base = "" CacheHelper::$webroot = "/" CacheHelper::$themeWeb = NULL CacheHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" CacheHelper::$params = array CacheHelper::$action = "reduced" CacheHelper::$plugin = NULL CacheHelper::$data = NULL CacheHelper::$namedArgs = NULL CacheHelper::$argSeparator = NULL CacheHelper::$validationErrors = NULL CacheHelper::$tags = array CacheHelper::$__tainted = NULL CacheHelper::$__cleaned = NULL CacheHelper::$_log = NULL, "Html" => HtmlHelper HtmlHelper::$tags = array HtmlHelper::$base = "" HtmlHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" HtmlHelper::$params = array HtmlHelper::$action = "reduced" HtmlHelper::$data = NULL HtmlHelper::$_crumbs = array HtmlHelper::$__docTypes = array HtmlHelper::$helpers = NULL HtmlHelper::$webroot = "/" HtmlHelper::$themeWeb = NULL HtmlHelper::$plugin = NULL HtmlHelper::$namedArgs = NULL HtmlHelper::$argSeparator = NULL HtmlHelper::$validationErrors = NULL HtmlHelper::$__tainted = NULL HtmlHelper::$__cleaned = NULL HtmlHelper::$_log = NULL, "Form" => FormHelper FormHelper::$helpers = array FormHelper::$fieldset = array FormHelper::$__options = array FormHelper::$fields = array FormHelper::$requestType = NULL FormHelper::$base = "" FormHelper::$webroot = "/" FormHelper::$themeWeb = NULL FormHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" FormHelper::$params = array FormHelper::$action = "reduced" FormHelper::$plugin = NULL FormHelper::$data = NULL FormHelper::$namedArgs = NULL FormHelper::$argSeparator = NULL FormHelper::$validationErrors = NULL FormHelper::$tags = array FormHelper::$__tainted = NULL FormHelper::$__cleaned = NULL FormHelper::$_log = NULL FormHelper::$Html = HtmlHelper object, "Text" => TextHelper TextHelper::$helpers = NULL TextHelper::$base = "" TextHelper::$webroot = "/" TextHelper::$themeWeb = NULL TextHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" TextHelper::$params = array TextHelper::$action = "reduced" TextHelper::$plugin = NULL TextHelper::$data = NULL TextHelper::$namedArgs = NULL TextHelper::$argSeparator = NULL TextHelper::$validationErrors = NULL TextHelper::$tags = array TextHelper::$__tainted = NULL TextHelper::$__cleaned = NULL TextHelper::$_log = NULL, "Number" => NumberHelper NumberHelper::$helpers = NULL NumberHelper::$base = "" NumberHelper::$webroot = "/" NumberHelper::$themeWeb = NULL NumberHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" NumberHelper::$params = array NumberHelper::$action = "reduced" NumberHelper::$plugin = NULL NumberHelper::$data = NULL NumberHelper::$namedArgs = NULL NumberHelper::$argSeparator = NULL NumberHelper::$validationErrors = NULL NumberHelper::$tags = array NumberHelper::$__tainted = NULL NumberHelper::$__cleaned = NULL NumberHelper::$_log = NULL, "Javascript" => JavascriptHelper JavascriptHelper::$useNative = true JavascriptHelper::$enabled = true JavascriptHelper::$safe = false JavascriptHelper::$tags = array JavascriptHelper::$_blockOptions = array JavascriptHelper::$_cachedEvents = array JavascriptHelper::$_cacheEvents = false JavascriptHelper::$_cacheToFile = false JavascriptHelper::$_cacheAll = false JavascriptHelper::$_rules = array JavascriptHelper::$__scriptBuffer = NULL JavascriptHelper::$helpers = NULL JavascriptHelper::$base = "" JavascriptHelper::$webroot = "/" JavascriptHelper::$themeWeb = NULL JavascriptHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" JavascriptHelper::$params = array JavascriptHelper::$action = "reduced" JavascriptHelper::$plugin = NULL JavascriptHelper::$data = NULL JavascriptHelper::$namedArgs = NULL JavascriptHelper::$argSeparator = NULL JavascriptHelper::$validationErrors = NULL JavascriptHelper::$__tainted = NULL JavascriptHelper::$__cleaned = NULL JavascriptHelper::$_log = NULL, "Tagcloud" => TagcloudHelper TagcloudHelper::$helpers = NULL TagcloudHelper::$base = "" TagcloudHelper::$webroot = "/" TagcloudHelper::$themeWeb = NULL TagcloudHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" TagcloudHelper::$params = array TagcloudHelper::$action = "reduced" TagcloudHelper::$plugin = NULL TagcloudHelper::$data = NULL TagcloudHelper::$namedArgs = NULL TagcloudHelper::$argSeparator = NULL TagcloudHelper::$validationErrors = NULL TagcloudHelper::$tags = array TagcloudHelper::$__tainted = NULL TagcloudHelper::$__cleaned = NULL TagcloudHelper::$_log = NULL, "Custom" => CustomHelper CustomHelper::$tags = array CustomHelper::$base = "" CustomHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" CustomHelper::$params = array CustomHelper::$action = "reduced" CustomHelper::$data = NULL CustomHelper::$_crumbs = array CustomHelper::$__docTypes = array CustomHelper::$helpers = NULL CustomHelper::$webroot = "/" CustomHelper::$themeWeb = NULL CustomHelper::$plugin = NULL CustomHelper::$namedArgs = NULL CustomHelper::$argSeparator = NULL CustomHelper::$validationErrors = NULL CustomHelper::$__tainted = NULL CustomHelper::$__cleaned = NULL CustomHelper::$_log = NULL, "Time" => TimeHelper TimeHelper::$helpers = NULL TimeHelper::$base = "" TimeHelper::$webroot = "/" TimeHelper::$themeWeb = NULL TimeHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" TimeHelper::$params = array TimeHelper::$action = "reduced" TimeHelper::$plugin = NULL TimeHelper::$data = NULL TimeHelper::$namedArgs = NULL TimeHelper::$argSeparator = NULL TimeHelper::$validationErrors = NULL TimeHelper::$tags = array TimeHelper::$__tainted = NULL TimeHelper::$__cleaned = NULL TimeHelper::$_log = NULL, "FormVariablesPaginator" => FormVariablesPaginatorHelper FormVariablesPaginatorHelper::$helpers = array FormVariablesPaginatorHelper::$__defaultModel = NULL FormVariablesPaginatorHelper::$options = array FormVariablesPaginatorHelper::$base = "" FormVariablesPaginatorHelper::$webroot = "/" FormVariablesPaginatorHelper::$themeWeb = NULL FormVariablesPaginatorHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" FormVariablesPaginatorHelper::$params = array FormVariablesPaginatorHelper::$action = "reduced" FormVariablesPaginatorHelper::$plugin = NULL FormVariablesPaginatorHelper::$data = NULL FormVariablesPaginatorHelper::$namedArgs = NULL FormVariablesPaginatorHelper::$argSeparator = NULL FormVariablesPaginatorHelper::$validationErrors = NULL FormVariablesPaginatorHelper::$tags = array FormVariablesPaginatorHelper::$__tainted = NULL FormVariablesPaginatorHelper::$__cleaned = NULL FormVariablesPaginatorHelper::$_log = NULL FormVariablesPaginatorHelper::$Html = HtmlHelper object FormVariablesPaginatorHelper::$Ajax = AjaxHelper object, "Ajax" => AjaxHelper AjaxHelper::$helpers = array AjaxHelper::$Html = HtmlHelper object AjaxHelper::$Javascript = JavascriptHelper object AjaxHelper::$callbacks = array AjaxHelper::$ajaxOptions = array AjaxHelper::$dragOptions = array AjaxHelper::$dropOptions = array AjaxHelper::$sortOptions = array AjaxHelper::$sliderOptions = array AjaxHelper::$editorOptions = array AjaxHelper::$autoCompleteOptions = array AjaxHelper::$__ajaxBuffer = array AjaxHelper::$base = "" AjaxHelper::$webroot = "/" AjaxHelper::$themeWeb = NULL AjaxHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" AjaxHelper::$params = array AjaxHelper::$action = "reduced" AjaxHelper::$plugin = NULL AjaxHelper::$data = NULL AjaxHelper::$namedArgs = NULL AjaxHelper::$argSeparator = NULL AjaxHelper::$validationErrors = NULL AjaxHelper::$tags = array AjaxHelper::$__tainted = NULL AjaxHelper::$__cleaned = NULL AjaxHelper::$_log = NULL AjaxHelper::$Form = FormHelper object, "Icon" => IconHelper IconHelper::$tags = array IconHelper::$base = "" IconHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" IconHelper::$params = array IconHelper::$action = "reduced" IconHelper::$data = NULL IconHelper::$_crumbs = array IconHelper::$__docTypes = array IconHelper::$helpers = NULL IconHelper::$webroot = "/" IconHelper::$themeWeb = NULL IconHelper::$plugin = NULL IconHelper::$namedArgs = NULL IconHelper::$argSeparator = NULL IconHelper::$validationErrors = NULL IconHelper::$__tainted = NULL IconHelper::$__cleaned = NULL IconHelper::$_log = NULL, "Drill" => DrillHelper DrillHelper::$tags = array DrillHelper::$base = "" DrillHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" DrillHelper::$params = array DrillHelper::$action = "reduced" DrillHelper::$data = NULL DrillHelper::$_crumbs = array DrillHelper::$__docTypes = array DrillHelper::$helpers = NULL DrillHelper::$webroot = "/" DrillHelper::$themeWeb = NULL DrillHelper::$plugin = NULL DrillHelper::$namedArgs = NULL DrillHelper::$argSeparator = NULL DrillHelper::$validationErrors = NULL DrillHelper::$__tainted = NULL DrillHelper::$__cleaned = NULL DrillHelper::$_log = NULL, "Session" => SessionHelper SessionHelper::$helpers = NULL SessionHelper::$__active = true SessionHelper::$valid = false SessionHelper::$error = false SessionHelper::$_userAgent = "a7d63c274f73bb410efb05168d3d225f" SessionHelper::$path = "/" SessionHelper::$lastError = NULL SessionHelper::$security = "medium" SessionHelper::$time = 1761128281 SessionHelper::$sessionTime = 1761140281 SessionHelper::$watchKeys = array SessionHelper::$id = NULL SessionHelper::$_started = false SessionHelper::$host = NULL SessionHelper::$_log = NULL SessionHelper::$cookieLifeTime = 604800 SessionHelper::$base = "" SessionHelper::$webroot = "/" SessionHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" SessionHelper::$params = array SessionHelper::$action = "reduced" SessionHelper::$data = NULL SessionHelper::$themeWeb = NULL SessionHelper::$plugin = NULL, "Paginator" => PaginatorHelper PaginatorHelper::$helpers = array PaginatorHelper::$__defaultModel = "Allproperty" PaginatorHelper::$options = array PaginatorHelper::$base = "" PaginatorHelper::$webroot = "/" PaginatorHelper::$themeWeb = NULL PaginatorHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" PaginatorHelper::$params = array PaginatorHelper::$action = "reduced" PaginatorHelper::$plugin = NULL PaginatorHelper::$data = NULL PaginatorHelper::$namedArgs = NULL PaginatorHelper::$argSeparator = NULL PaginatorHelper::$validationErrors = NULL PaginatorHelper::$tags = array PaginatorHelper::$__tainted = NULL PaginatorHelper::$__cleaned = NULL PaginatorHelper::$_log = NULL PaginatorHelper::$Html = HtmlHelper object PaginatorHelper::$Ajax = AjaxHelper object ) $helper = "Paginator" $camelBackedHelper = "paginator" $cache = CacheHelper CacheHelper::$__replace = array CacheHelper::$__match = array CacheHelper::$cacheAction = NULL CacheHelper::$helpers = NULL CacheHelper::$base = "" CacheHelper::$webroot = "/" CacheHelper::$themeWeb = NULL CacheHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" CacheHelper::$params = array CacheHelper::$action = "reduced" CacheHelper::$plugin = NULL CacheHelper::$data = NULL CacheHelper::$namedArgs = NULL CacheHelper::$argSeparator = NULL CacheHelper::$validationErrors = NULL CacheHelper::$tags = array CacheHelper::$__tainted = NULL CacheHelper::$__cleaned = NULL CacheHelper::$_log = NULL $html = HtmlHelper HtmlHelper::$tags = array HtmlHelper::$base = "" HtmlHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" HtmlHelper::$params = array HtmlHelper::$action = "reduced" HtmlHelper::$data = NULL HtmlHelper::$_crumbs = array HtmlHelper::$__docTypes = array HtmlHelper::$helpers = NULL HtmlHelper::$webroot = "/" HtmlHelper::$themeWeb = NULL HtmlHelper::$plugin = NULL HtmlHelper::$namedArgs = NULL HtmlHelper::$argSeparator = NULL HtmlHelper::$validationErrors = NULL HtmlHelper::$__tainted = NULL HtmlHelper::$__cleaned = NULL HtmlHelper::$_log = NULL $form = FormHelper FormHelper::$helpers = array FormHelper::$fieldset = array FormHelper::$__options = array FormHelper::$fields = array FormHelper::$requestType = NULL FormHelper::$base = "" FormHelper::$webroot = "/" FormHelper::$themeWeb = NULL FormHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" FormHelper::$params = array FormHelper::$action = "reduced" FormHelper::$plugin = NULL FormHelper::$data = NULL FormHelper::$namedArgs = NULL FormHelper::$argSeparator = NULL FormHelper::$validationErrors = NULL FormHelper::$tags = array FormHelper::$__tainted = NULL FormHelper::$__cleaned = NULL FormHelper::$_log = NULL FormHelper::$Html = HtmlHelper object $text = TextHelper TextHelper::$helpers = NULL TextHelper::$base = "" TextHelper::$webroot = "/" TextHelper::$themeWeb = NULL TextHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" TextHelper::$params = array TextHelper::$action = "reduced" TextHelper::$plugin = NULL TextHelper::$data = NULL TextHelper::$namedArgs = NULL TextHelper::$argSeparator = NULL TextHelper::$validationErrors = NULL TextHelper::$tags = array TextHelper::$__tainted = NULL TextHelper::$__cleaned = NULL TextHelper::$_log = NULL $number = NumberHelper NumberHelper::$helpers = NULL NumberHelper::$base = "" NumberHelper::$webroot = "/" NumberHelper::$themeWeb = NULL NumberHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" NumberHelper::$params = array NumberHelper::$action = "reduced" NumberHelper::$plugin = NULL NumberHelper::$data = NULL NumberHelper::$namedArgs = NULL NumberHelper::$argSeparator = NULL NumberHelper::$validationErrors = NULL NumberHelper::$tags = array NumberHelper::$__tainted = NULL NumberHelper::$__cleaned = NULL NumberHelper::$_log = NULL $javascript = JavascriptHelper JavascriptHelper::$useNative = true JavascriptHelper::$enabled = true JavascriptHelper::$safe = false JavascriptHelper::$tags = array JavascriptHelper::$_blockOptions = array JavascriptHelper::$_cachedEvents = array JavascriptHelper::$_cacheEvents = false JavascriptHelper::$_cacheToFile = false JavascriptHelper::$_cacheAll = false JavascriptHelper::$_rules = array JavascriptHelper::$__scriptBuffer = NULL JavascriptHelper::$helpers = NULL JavascriptHelper::$base = "" JavascriptHelper::$webroot = "/" JavascriptHelper::$themeWeb = NULL JavascriptHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" JavascriptHelper::$params = array JavascriptHelper::$action = "reduced" JavascriptHelper::$plugin = NULL JavascriptHelper::$data = NULL JavascriptHelper::$namedArgs = NULL JavascriptHelper::$argSeparator = NULL JavascriptHelper::$validationErrors = NULL JavascriptHelper::$__tainted = NULL JavascriptHelper::$__cleaned = NULL JavascriptHelper::$_log = NULL $tagcloud = TagcloudHelper TagcloudHelper::$helpers = NULL TagcloudHelper::$base = "" TagcloudHelper::$webroot = "/" TagcloudHelper::$themeWeb = NULL TagcloudHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" TagcloudHelper::$params = array TagcloudHelper::$action = "reduced" TagcloudHelper::$plugin = NULL TagcloudHelper::$data = NULL TagcloudHelper::$namedArgs = NULL TagcloudHelper::$argSeparator = NULL TagcloudHelper::$validationErrors = NULL TagcloudHelper::$tags = array TagcloudHelper::$__tainted = NULL TagcloudHelper::$__cleaned = NULL TagcloudHelper::$_log = NULL $custom = CustomHelper CustomHelper::$tags = array CustomHelper::$base = "" CustomHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" CustomHelper::$params = array CustomHelper::$action = "reduced" CustomHelper::$data = NULL CustomHelper::$_crumbs = array CustomHelper::$__docTypes = array CustomHelper::$helpers = NULL CustomHelper::$webroot = "/" CustomHelper::$themeWeb = NULL CustomHelper::$plugin = NULL CustomHelper::$namedArgs = NULL CustomHelper::$argSeparator = NULL CustomHelper::$validationErrors = NULL CustomHelper::$__tainted = NULL CustomHelper::$__cleaned = NULL CustomHelper::$_log = NULL $time = TimeHelper TimeHelper::$helpers = NULL TimeHelper::$base = "" TimeHelper::$webroot = "/" TimeHelper::$themeWeb = NULL TimeHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" TimeHelper::$params = array TimeHelper::$action = "reduced" TimeHelper::$plugin = NULL TimeHelper::$data = NULL TimeHelper::$namedArgs = NULL TimeHelper::$argSeparator = NULL TimeHelper::$validationErrors = NULL TimeHelper::$tags = array TimeHelper::$__tainted = NULL TimeHelper::$__cleaned = NULL TimeHelper::$_log = NULL $formVariablesPaginator = FormVariablesPaginatorHelper FormVariablesPaginatorHelper::$helpers = array FormVariablesPaginatorHelper::$__defaultModel = NULL FormVariablesPaginatorHelper::$options = array FormVariablesPaginatorHelper::$base = "" FormVariablesPaginatorHelper::$webroot = "/" FormVariablesPaginatorHelper::$themeWeb = NULL FormVariablesPaginatorHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" FormVariablesPaginatorHelper::$params = array FormVariablesPaginatorHelper::$action = "reduced" FormVariablesPaginatorHelper::$plugin = NULL FormVariablesPaginatorHelper::$data = NULL FormVariablesPaginatorHelper::$namedArgs = NULL FormVariablesPaginatorHelper::$argSeparator = NULL FormVariablesPaginatorHelper::$validationErrors = NULL FormVariablesPaginatorHelper::$tags = array FormVariablesPaginatorHelper::$__tainted = NULL FormVariablesPaginatorHelper::$__cleaned = NULL FormVariablesPaginatorHelper::$_log = NULL FormVariablesPaginatorHelper::$Html = HtmlHelper object FormVariablesPaginatorHelper::$Ajax = AjaxHelper object $ajax = AjaxHelper AjaxHelper::$helpers = array AjaxHelper::$Html = HtmlHelper object AjaxHelper::$Javascript = JavascriptHelper object AjaxHelper::$callbacks = array AjaxHelper::$ajaxOptions = array AjaxHelper::$dragOptions = array AjaxHelper::$dropOptions = array AjaxHelper::$sortOptions = array AjaxHelper::$sliderOptions = array AjaxHelper::$editorOptions = array AjaxHelper::$autoCompleteOptions = array AjaxHelper::$__ajaxBuffer = array AjaxHelper::$base = "" AjaxHelper::$webroot = "/" AjaxHelper::$themeWeb = NULL AjaxHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" AjaxHelper::$params = array AjaxHelper::$action = "reduced" AjaxHelper::$plugin = NULL AjaxHelper::$data = NULL AjaxHelper::$namedArgs = NULL AjaxHelper::$argSeparator = NULL AjaxHelper::$validationErrors = NULL AjaxHelper::$tags = array AjaxHelper::$__tainted = NULL AjaxHelper::$__cleaned = NULL AjaxHelper::$_log = NULL AjaxHelper::$Form = FormHelper object $icon = IconHelper IconHelper::$tags = array IconHelper::$base = "" IconHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" IconHelper::$params = array IconHelper::$action = "reduced" IconHelper::$data = NULL IconHelper::$_crumbs = array IconHelper::$__docTypes = array IconHelper::$helpers = NULL IconHelper::$webroot = "/" IconHelper::$themeWeb = NULL IconHelper::$plugin = NULL IconHelper::$namedArgs = NULL IconHelper::$argSeparator = NULL IconHelper::$validationErrors = NULL IconHelper::$__tainted = NULL IconHelper::$__cleaned = NULL IconHelper::$_log = NULL $drill = DrillHelper DrillHelper::$tags = array DrillHelper::$base = "" DrillHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" DrillHelper::$params = array DrillHelper::$action = "reduced" DrillHelper::$data = NULL DrillHelper::$_crumbs = array DrillHelper::$__docTypes = array DrillHelper::$helpers = NULL DrillHelper::$webroot = "/" DrillHelper::$themeWeb = NULL DrillHelper::$plugin = NULL DrillHelper::$namedArgs = NULL DrillHelper::$argSeparator = NULL DrillHelper::$validationErrors = NULL DrillHelper::$__tainted = NULL DrillHelper::$__cleaned = NULL DrillHelper::$_log = NULL $session = SessionHelper SessionHelper::$helpers = NULL SessionHelper::$__active = true SessionHelper::$valid = false SessionHelper::$error = false SessionHelper::$_userAgent = "a7d63c274f73bb410efb05168d3d225f" SessionHelper::$path = "/" SessionHelper::$lastError = NULL SessionHelper::$security = "medium" SessionHelper::$time = 1761128281 SessionHelper::$sessionTime = 1761140281 SessionHelper::$watchKeys = array SessionHelper::$id = NULL SessionHelper::$_started = false SessionHelper::$host = NULL SessionHelper::$_log = NULL SessionHelper::$cookieLifeTime = 604800 SessionHelper::$base = "" SessionHelper::$webroot = "/" SessionHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" SessionHelper::$params = array SessionHelper::$action = "reduced" SessionHelper::$data = NULL SessionHelper::$themeWeb = NULL SessionHelper::$plugin = NULL $paginator = PaginatorHelper PaginatorHelper::$helpers = array PaginatorHelper::$__defaultModel = "Allproperty" PaginatorHelper::$options = array PaginatorHelper::$base = "" PaginatorHelper::$webroot = "/" PaginatorHelper::$themeWeb = NULL PaginatorHelper::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" PaginatorHelper::$params = array PaginatorHelper::$action = "reduced" PaginatorHelper::$plugin = NULL PaginatorHelper::$data = NULL PaginatorHelper::$namedArgs = NULL PaginatorHelper::$argSeparator = NULL PaginatorHelper::$validationErrors = NULL PaginatorHelper::$tags = array PaginatorHelper::$__tainted = NULL PaginatorHelper::$__cleaned = NULL PaginatorHelper::$_log = NULL PaginatorHelper::$Html = HtmlHelper object PaginatorHelper::$Ajax = AjaxHelper object $primarypropertytypes = array( "All", "House", "Apartment", "Land", "Chalet", "Chateau", "Commercial", "Lakes", "Mill", "Barn", "Building", "Houseboat", "Parking" ) $properties = array( array( "Allproperty" => array(), "Department" => array(), "Region" => array(), "Attribute" => array() ) ) $pageUrl = array( "page" => "4", "department_id" => "80", "arrival" => "day", "region_id" => "82", "primary_id" => "3", "price" => "h" ) $groups = array( "Houses", "Commercial", "Prestige", "Lakes", "Apartments", "Income-Business", "Land-Woodland", "Ski", "Equestrian" ) $firstCrumb = array( "name" => "Reduced Property", "url" => "french-property-for-sale/reduced" ) $selected = array( "notSold" => false ) $isCustomPage = true $countExclusif = 1 $alternate = "https://www.leggett-immo.com/acheter-vendre-une-maison/reduced" $selectedCriteria = array( "page" => "4", "department_id" => "80", "arrival" => "day", "region_id" => "82", "primary_id" => "3", "price" => "h" ) $cakeDebug = AllpropertiesController AllpropertiesController::$name = "Allproperties" AllpropertiesController::$helpers = array AllpropertiesController::$components = array AllpropertiesController::$uses = array AllpropertiesController::$shortfields = array AllpropertiesController::$shortfieldView = array AllpropertiesController::$shortfieldList = array AllpropertiesController::$here = "/french-property-for-sale/reduced/page:4/department_id:80/arrival:day/region_id:82/primary_id:3/price:h" AllpropertiesController::$webroot = "/" AllpropertiesController::$action = "reduced" AllpropertiesController::$params = array AllpropertiesController::$data = NULL AllpropertiesController::$paginate = array AllpropertiesController::$viewPath = "allproperties" AllpropertiesController::$layoutPath = NULL AllpropertiesController::$viewVars = array AllpropertiesController::$pageTitle = "Reduced Property for Sale in France" AllpropertiesController::$modelNames = array AllpropertiesController::$base = "" AllpropertiesController::$layout = "list" AllpropertiesController::$autoRender = false AllpropertiesController::$autoLayout = true AllpropertiesController::$Component = Component object AllpropertiesController::$view = "View" AllpropertiesController::$ext = ".ctp" AllpropertiesController::$output = NULL AllpropertiesController::$plugin = NULL AllpropertiesController::$cacheAction = false AllpropertiesController::$persistModel = false AllpropertiesController::$passedArgs = array AllpropertiesController::$scaffold = false AllpropertiesController::$methods = array AllpropertiesController::$modelClass = "Allproperty" AllpropertiesController::$modelKey = "allproperty" AllpropertiesController::$validationErrors = NULL AllpropertiesController::$_log = NULL AllpropertiesController::$Session = SessionComponent object AllpropertiesController::$Cookie = CookieComponent object AllpropertiesController::$RequestHandler = RequestHandlerComponent object AllpropertiesController::$Currency = CurrencyComponent object AllpropertiesController::$PaginateFormVariables = PaginateFormVariablesComponent object AllpropertiesController::$UrlShortener = UrlShortenerComponent object AllpropertiesController::$Prg = PrgComponent object AllpropertiesController::$Allproperty = Allproperty object AllpropertiesController::$Region = Region object AllpropertiesController::$Department = Department object AllpropertiesController::$User = User object AllpropertiesController::$Group = Group object AllpropertiesController::$Codepostal = Codepostal object AllpropertiesController::$Proptype = Proptype object AllpropertiesController::$Primarypropertytype = Primarypropertytype object AllpropertiesController::$Soldproperty = Soldproperty object AllpropertiesController::$Soldallproperty = Soldallproperty object AllpropertiesController::$Testimonial = Testimonial object AllpropertiesController::$Powcategory = Powcategory object $sort = array( "Allproperty.date_made_live" => "desc" ) $property = array( "Allproperty" => array( "id" => "52238", "propref" => "A33464JST74", "primarypropertytype_name" => "Chalet", "pubtown" => "Verchaix", "properpubtown" => "Verchaix", "image_0" => "https://cdn.hestia.immo/image/TEN3XPNC/2025-05/DOCG2Q0GBG0A.jpg", "status" => "offer", "isunderoffer" => "1", "is_exclusive" => "1", "date_made_live" => "2025-03-20 03:04:28", "nrbedrooms" => "3", "nrbathrooms" => "2", "habitable_m2" => "86", "land_m2" => "866", "issold" => "0", "poa" => "0", "bestdeals" => "1", "price" => "465000", "prevprice" => "480000", "propname" => "Conveniently located, 3 bedroom chalet with large garden near Lac Bleu. Easy access to the Grand Massif", "shortdesc" => "*NB offer recently accepted Situated on a spacious and sunny, level plot with a large garden, the property provides a rare opportunity in a sought-after location within easy walking distance of Lac Bleu in Morillon and the ski bus stop for access to the Grand Massif ski domain. This classic-style chalet offers approximately 65 m² of habitable space, complemented by additional areas including 21 m² in the attic (under 1.8 m in height) and a 14 m² garage. Garden Level (22 m² plus 14 m² garage):  • Bunk bed sleeping area  • Double bedroom  • Shower room with WC  • Garage First Level (~43 m²):  • Open-plan living room with wood-burning stove, dining area and kitchen  • Double bedroom  • Shower room with WC  • Terrace and balcony Second Level (~21 m², mostly <1.8 m in height):  • Bedroom/office area  • Additional storage Plus, exterior parking for two cars *Option to extend. The chalet is in good condition but refreshment is required, including improvements to the insulation.", "floorplan" => "1", "tour" => "0", "youtube_url" => "", "rhinov_url" => null, "region_id" => "82", "lat" => "46.1214", "lon" => "6.69114", "postcode" => "74440", "attributes" => "a:12:{i:0;a:3:{s:2:"id";s:1:"2";s:4:"name";s:12:"Mains Drains";s:7:"name_fr";s:16:"Tout à l'égout";}i:1;a:3:{s:2:"id";s:1:"8";s:4:"name";s:6:"Garage";s:7:"name_fr";s:6:"Garage";}i:2;a:3:{s:2:"id";s:1:"9";s:4:"name";s:15:"Private parking";s:7:"name_fr";s:14:"Parking privé";}i:3;a:3:{s:2:"id";s:2:"13";s:4:"name";s:8:"Detached";s:7:"name_fr";s:13:"Non mitoyenne";}i:4;a:3:{s:2:"id";s:2:"18";s:4:"name";s:19:"Close to ski resort";s:7:"name_fr";s:32:"Près d'une station de ski";}i:5;a:3:{s:2:"id";s:2:"23";s:4:"name";s:13:"Mountain view";s:7:"name_fr";s:21:"Vue sur les Montagnes";}i:6;a:3:{s:2:"id";s:2:"37";s:4:"name";s:15:"Panoramic views";s:7:"name_fr";s:17:"Vues panoramiques";}i:7;a:3:{s:2:"id";s:2:"44";s:4:"name";s:13:"Woodburner(s)";s:7:"name_fr";s:23:"Insert - poêle à bois";}i:8;a:3:{s:2:"id";s:2:"45";s:4:"name";s:6:"Garden";s:7:"name_fr";s:6:"Jardin";}i:9;a:3:{s:2:"id";s:2:"46";s:4:"name";s:7:"Terrace";s:7:"name_fr";s:8:"Terrasse";}i:10;a:3:{s:2:"id";s:2:"50";s:4:"name";s:29:"5 minutes drive to ski resort";s:7:"name_fr";s:25:"A 5 minutes de la station";}i:11;a:3:{s:2:"id";s:2:"55";s:4:"name";s:43:"Less than five minutes walk to free ski bus";s:7:"name_fr";s:34:"A moins de 5 minutes d'une navette";}}", "mandatetype_id" => "12", "department_name" => "Haute-Savoie", "department_id" => "74", "created" => "2025-02-18 11:04:52", "sort_date" => "2025-03-20 03:04:28", "Image" => array(), "nb-photo" => 1 ), "Department" => array( "listdesc" => "Haute-Savoie", "name" => "Haute-Savoie" ), "Region" => array( "name" => "French_Alps", "content" => "French Alps (Auvergne-Rhône-Alpes)" ), "Attribute" => array( array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array(), array() ) ) $key = 0

include - APP/views/allproperties/property_results_with_bar.ctp, line 72 View::_render() - CORE/cake/libs/view/view.php, line 665 View::render() - CORE/cake/libs/view/view.php, line 375 Controller::render() - CORE/cake/libs/controller/controller.php, line 815 AllpropertiesController::reduced() - APP/controllers/allproperties_controller.php, line 3969 Object::dispatchMethod() - CORE/cake/libs/object.php, line 115 Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 226 Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 193 [main] - APP/webroot/index.php, line 88

Chalet in Haute-Savoie

3 bed | 2 bath | Floor 86m² | Ext 866 m²

€465,000 €480,000

Conveniently located, 3 bedroom chalet with large garden near Lac Bleu. Easy access to the Grand Massif

*NB offer recently accepted Situated on a spacious and sunny, level plot with a large garden, the property provides a rare opportunity in a sought-after location within easy walking distance of Lac Bleu in Morillon and the ski bus stop for access to . . .

(default) 12 queries took 383 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT 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` = '82' AND NOT (`Allproperty`.`department_id` IN ('01', '07', '26', '42', '69')) AND `Allproperty`.`primarypropertytype_id` = 3 AND `Allproperty`.`price` BETWEEN 285000.95 and 630000 AND `Allproperty`.`bestdeals` = 1 AND `Allproperty`.`prevprice` != 0 AND `Allproperty`.`isinvisible` != 1	1	1	50
2	SELECT `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` = '82' AND NOT (`Allproperty`.`department_id` IN ('01', '07', '26', '42', '69')) AND `Allproperty`.`primarypropertytype_id` = 3 AND `Allproperty`.`price` BETWEEN 285000.95 and 630000 AND `Allproperty`.`bestdeals` = 1 AND `Allproperty`.`prevprice` != 0 AND `Allproperty`.`isinvisible` != 1 ORDER BY `Allproperty`.`date_made_live` desc LIMIT 60	1	1	264
3	SELECT 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` = '82') AND (NOT (`Allproperty`.`department_id` IN ('01', '07', '26', '42', '69'))) AND (`Allproperty`.`primarypropertytype_id` = 3) AND (`Allproperty`.`price` BETWEEN 285000.95 and 630000) AND (`Allproperty`.`bestdeals` = 1) AND (`Allproperty`.`prevprice` != 0))) AND (`Allproperty`.`is_exclusive` = 1)) AND `Allproperty`.`is_exclusive` = 1 AND `Allproperty`.`isinvisible` != 1	1	1	39
4	SELECT `Group`.`id`, `Group`.`name` FROM `groups` AS `Group` WHERE 1 = 1	9	9	3
5	SELECT `Primarypropertytype`.`id`, `Primarypropertytype`.`name` FROM `primarypropertytypes` AS `Primarypropertytype` WHERE 1 = 1	13	13	4
6	SELECT `Region`.`name`, `Region`.`id` FROM `regions` AS `Region` WHERE `Region`.`id` NOT IN ('01', '02', '03', '04', '05') ORDER BY `Region`.`name` ASC	22	22	4
7	SELECT `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')	95	95	3
8	SELECT `Primarypropertytype`.`id`, `Primarypropertytype`.`name` FROM `primarypropertytypes` AS `Primarypropertytype` WHERE 1 = 1 ORDER BY `id` ASC	13	13	2
9	SELECT `Region`.`name`, `Region`.`id` FROM `regions` AS `Region` WHERE `Region`.`id` NOT IN ('01', '02', '03', '04', '05') ORDER BY `Region`.`name` ASC	22	22	6
10	SELECT `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')	95	95	3
11	SELECT `Primarypropertytype`.`id`, `Primarypropertytype`.`name` FROM `primarypropertytypes` AS `Primarypropertytype` WHERE 1 = 1 ORDER BY `id` ASC	13	13	2
12	SELECT `Primarypropertytype`.`id`, `Primarypropertytype`.`name` FROM `primarypropertytypes` AS `Primarypropertytype` WHERE 1 = 1 ORDER BY `id` ASC	13	13	3

(default) 12 queries took 383 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT 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` = '82' AND NOT (`Allproperty`.`department_id` IN ('01', '07', '26', '42', '69')) AND `Allproperty`.`primarypropertytype_id` = 3 AND `Allproperty`.`price` BETWEEN 285000.95 and 630000 AND `Allproperty`.`bestdeals` = 1 AND `Allproperty`.`prevprice` != 0 AND `Allproperty`.`isinvisible` != 1

SELECT `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` = '82' AND NOT (`Allproperty`.`department_id` IN ('01', '07', '26', '42', '69')) AND `Allproperty`.`primarypropertytype_id` = 3 AND `Allproperty`.`price` BETWEEN 285000.95 and 630000 AND `Allproperty`.`bestdeals` = 1 AND `Allproperty`.`prevprice` != 0 AND `Allproperty`.`isinvisible` != 1 ORDER BY `Allproperty`.`date_made_live` desc LIMIT 60

264

SELECT 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` = '82') AND (NOT (`Allproperty`.`department_id` IN ('01', '07', '26', '42', '69'))) AND (`Allproperty`.`primarypropertytype_id` = 3) AND (`Allproperty`.`price` BETWEEN 285000.95 and 630000) AND (`Allproperty`.`bestdeals` = 1) AND (`Allproperty`.`prevprice` != 0))) AND (`Allproperty`.`is_exclusive` = 1)) AND `Allproperty`.`is_exclusive` = 1 AND `Allproperty`.`isinvisible` != 1

SELECT `Group`.`id`, `Group`.`name` FROM `groups` AS `Group` WHERE 1 = 1

SELECT `Primarypropertytype`.`id`, `Primarypropertytype`.`name` FROM `primarypropertytypes` AS `Primarypropertytype` WHERE 1 = 1

SELECT `Region`.`name`, `Region`.`id` FROM `regions` AS `Region` WHERE `Region`.`id` NOT IN ('01', '02', '03', '04', '05') ORDER BY `Region`.`name` ASC

SELECT `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')

SELECT `Primarypropertytype`.`id`, `Primarypropertytype`.`name` FROM `primarypropertytypes` AS `Primarypropertytype` WHERE 1 = 1 ORDER BY `id` ASC

SELECT `Region`.`name`, `Region`.`id` FROM `regions` AS `Region` WHERE `Region`.`id` NOT IN ('01', '02', '03', '04', '05') ORDER BY `Region`.`name` ASC

SELECT `Primarypropertytype`.`id`, `Primarypropertytype`.`name` FROM `primarypropertytypes` AS `Primarypropertytype` WHERE 1 = 1 ORDER BY `id` ASC