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" => "5", "department_id" => "13", "price" => "m", "arrival" => "day", "region_id" => "25", "primary_id" => "8" ), "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" => 0, "alternate" => "https://www.leggett-immo.com/acheter-vendre-une-maison/reduced", "selectedCriteria" => array( "page" => "5", "department_id" => "13", "price" => "m", "arrival" => "day", "region_id" => "25", "primary_id" => "8" ), "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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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 = 1761128328 SessionHelper::$sessionTime = 1761140328 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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" => "5", "department_id" => "13", "price" => "m", "arrival" => "day", "region_id" => "25", "primary_id" => "8" ) $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 = 0 $alternate = "https://www.leggett-immo.com/acheter-vendre-une-maison/reduced" $selectedCriteria = array( "page" => "5", "department_id" => "13", "price" => "m", "arrival" => "day", "region_id" => "25", "primary_id" => "8" ) $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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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 = 1761128328 SessionHelper::$sessionTime = 1761140328 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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" => "5", "department_id" => "13", "price" => "m", "arrival" => "day", "region_id" => "25", "primary_id" => "8" ), "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" => 0, "alternate" => "https://www.leggett-immo.com/acheter-vendre-une-maison/reduced", "selectedCriteria" => array( "page" => "5", "department_id" => "13", "price" => "m", "arrival" => "day", "region_id" => "25", "primary_id" => "8" ), "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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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 = 1761128328 SessionHelper::$sessionTime = 1761140328 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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 = 1761128328 SessionHelper::$sessionTime = 1761140328 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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" => "5", "department_id" => "13", "price" => "m", "arrival" => "day", "region_id" => "25", "primary_id" => "8" ) $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 = 0 $alternate = "https://www.leggett-immo.com/acheter-vendre-une-maison/reduced" $selectedCriteria = array( "page" => "5", "department_id" => "13", "price" => "m", "arrival" => "day", "region_id" => "25", "primary_id" => "8" ) $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:5/department_id:13/price:m/arrival:day/region_id:25/primary_id:8" 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" => "49727", "propref" => "A31865CAS27", "primarypropertytype_name" => "Lakes", "pubtown" => "Fontaine-l'Abbé", "properpubtown" => "Fontaine-l'Abbé", "image_0" => "https://cdn.hestia.immo/image/TEN3XPNC/2024-09/DOC3HZN0Z4WN.jpeg", "status" => "sale", "isunderoffer" => "0", "is_exclusive" => "0", "date_made_live" => "2025-06-23 02:22:57", "nrbedrooms" => "2", "nrbathrooms" => "1", "habitable_m2" => "88", "land_m2" => "58537", "issold" => "0", "poa" => "0", "bestdeals" => "1", "price" => "401850", "prevprice" => "441000", "propname" => "Chalet/bungalow with fishing lake set in plot of 58000m² surrounded by fields and woods", "shortdesc" => "Bungalow with 2 bedrooms, an office, lounge and polyvalent additional living space. Large fishing lake (1ha 7) with several access points and camping space. Large piece of land, no other properties within view.", "floorplan" => "0", "tour" => "0", "youtube_url" => "", "rhinov_url" => null, "region_id" => "23", "lat" => "49.0913", "lon" => "0.689676", "postcode" => "27470", "attributes" => "a:14:{i:0;a:3:{s:2:"id";s:1:"4";s:4:"name";s:14:"Other Drainage";s:7:"name_fr";s:25:"Assainissement individuel";}i:1;a:3:{s:2:"id";s:1:"5";s:4:"name";s:4:"Lake";s:7:"name_fr";s:3:"Lac";}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:"10";s:4:"name";s:20:"Barns - outbuildings";s:7:"name_fr";s:22:"Granges - dépendances";}i:4;a:3:{s:2:"id";s:2:"12";s:4:"name";s:4:"Well";s:7:"name_fr";s:10:"une source";}i:5;a:3:{s:2:"id";s:2:"13";s:4:"name";s:8:"Detached";s:7:"name_fr";s:13:"Non mitoyenne";}i:6;a:3:{s:2:"id";s:2:"14";s:4:"name";s:13:"Water on site";s:7:"name_fr";s:27:"Raccordé à l'eau courante";}i:7;a:3:{s:2:"id";s:2:"15";s:4:"name";s:19:"Electricity on site";s:7:"name_fr";s:28:"Raccordé à l'électricité";}i:8;a:3:{s:2:"id";s:2:"22";s:4:"name";s:13:"Single storey";s:7:"name_fr";s:10:"Plain pied";}i:9;a:3:{s:2:"id";s:2:"30";s:4:"name";s:18:"Business potential";s:7:"name_fr";s:20:"Potentiel commercial";}i:10;a:3:{s:2:"id";s:2:"37";s:4:"name";s:15:"Panoramic views";s:7:"name_fr";s:17:"Vues panoramiques";}i:11;a:3:{s:2:"id";s:2:"42";s:4:"name";s:19:"Suitable for horses";s:7:"name_fr";s:19:"Adapté aux chevaux";}i:12;a:3:{s:2:"id";s:2:"45";s:4:"name";s:6:"Garden";s:7:"name_fr";s:6:"Jardin";}i:13;a:3:{s:2:"id";s:2:"46";s:4:"name";s:7:"Terrace";s:7:"name_fr";s:8:"Terrasse";}}", "mandatetype_id" => "1", "department_name" => "Eure", "department_id" => "27", "created" => "2024-09-12 08:06:45", "sort_date" => "2025-06-23 02:22:57", "Image" => array(), "nb-photo" => 1 ), "Department" => array( "listdesc" => "Eure", "name" => "Eure" ), "Region" => array( "name" => "Higher_Normandy", "content" => "Higher Normandy" ), "Attribute" => array( array(), 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

Lakes in Eure

2 bed | 1 bath | Floor 88m² | Ext 58,537 m²

€401,850 €441,000

Chalet/bungalow with fishing lake set in plot of 58000m² surrounded by fields and woods

Bungalow with 2 bedrooms, an office, lounge and polyvalent additional living space. Large fishing lake (1ha 7) with several access points and camping space. Large piece of land, no other properties within view.

(default) 15 queries took 685 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `groups`	4	4	10
2	DESCRIBE `proptypes`	7	7	7
3	DESCRIBE `groups_proptypes`	3	3	50
4	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` IN ('25', '23') AND `Allproperty`.`primarypropertytype_id` = 8 AND `Allproperty`.`bestdeals` = 1 AND `Allproperty`.`prevprice` != 0 AND `Allproperty`.`isinvisible` != 1	1	1	87
5	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` IN ('25', '23') AND `Allproperty`.`primarypropertytype_id` = 8 AND `Allproperty`.`bestdeals` = 1 AND `Allproperty`.`prevprice` != 0 AND `Allproperty`.`isinvisible` != 1 ORDER BY `Allproperty`.`date_made_live` desc LIMIT 60	1	1	341
6	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` IN ('25', '23')) AND (`Allproperty`.`primarypropertytype_id` = 8) AND (`Allproperty`.`bestdeals` = 1) AND (`Allproperty`.`prevprice` != 0))) AND (`Allproperty`.`is_exclusive` = 1)) AND `Allproperty`.`is_exclusive` = 1 AND `Allproperty`.`isinvisible` != 1	1	1	42
7	SELECT `Group`.`id`, `Group`.`name` FROM `groups` AS `Group` WHERE 1 = 1	9	9	46
8	SELECT `Primarypropertytype`.`id`, `Primarypropertytype`.`name` FROM `primarypropertytypes` AS `Primarypropertytype` WHERE 1 = 1	13	13	7
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	5
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	68
11	SELECT `Primarypropertytype`.`id`, `Primarypropertytype`.`name` FROM `primarypropertytypes` AS `Primarypropertytype` WHERE 1 = 1 ORDER BY `id` ASC	13	13	6
12	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
13	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	4
14	SELECT `Primarypropertytype`.`id`, `Primarypropertytype`.`name` FROM `primarypropertytypes` AS `Primarypropertytype` WHERE 1 = 1 ORDER BY `id` ASC	13	13	2
15	SELECT `Primarypropertytype`.`id`, `Primarypropertytype`.`name` FROM `primarypropertytypes` AS `Primarypropertytype` WHERE 1 = 1 ORDER BY `id` ASC	13	13	4

(default) 15 queries took 685 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `groups`

DESCRIBE `proptypes`

DESCRIBE `groups_proptypes`

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` IN ('25', '23') AND `Allproperty`.`primarypropertytype_id` = 8 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` IN ('25', '23') AND `Allproperty`.`primarypropertytype_id` = 8 AND `Allproperty`.`bestdeals` = 1 AND `Allproperty`.`prevprice` != 0 AND `Allproperty`.`isinvisible` != 1 ORDER BY `Allproperty`.`date_made_live` desc LIMIT 60

341

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` IN ('25', '23')) AND (`Allproperty`.`primarypropertytype_id` = 8) 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