$___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(), "pageUrl" => array( "primary" => "building", "region" => "nord-pas-de-calais" ), "groups" => array( "All", "Houses", "Commercial", "Prestige", "Lakes", "Apartments", "Income-Business", "Land-Woodland", "Ski", "Equestrian" ), "selected" => array( "notSold" => false ), "selectedCriteria" => array( "primary" => "building", "region_name" => "nord_pas_de_calais" ), "countExclusif" => 0, "alternate" => "https://www.leggett-immo.com/building/nord-pas-de-calais", "cache" => CacheHelper CacheHelper::$__replace = array CacheHelper::$__match = array CacheHelper::$cacheAction = NULL CacheHelper::$helpers = NULL CacheHelper::$base = "" CacheHelper::$webroot = "/" CacheHelper::$themeWeb = NULL CacheHelper::$here = "/building/nord-pas-de-calais" CacheHelper::$params = array CacheHelper::$action = "drill" 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 = "/building/nord-pas-de-calais" HtmlHelper::$params = array HtmlHelper::$action = "drill" 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 = "/building/nord-pas-de-calais" FormHelper::$params = array FormHelper::$action = "drill" 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 = "/building/nord-pas-de-calais" TextHelper::$params = array TextHelper::$action = "drill" 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 = "/building/nord-pas-de-calais" NumberHelper::$params = array NumberHelper::$action = "drill" 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 = "/building/nord-pas-de-calais" JavascriptHelper::$params = array JavascriptHelper::$action = "drill" 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 = "/building/nord-pas-de-calais" TagcloudHelper::$params = array TagcloudHelper::$action = "drill" 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 = "/building/nord-pas-de-calais" CustomHelper::$params = array CustomHelper::$action = "drill" 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 = "/building/nord-pas-de-calais" TimeHelper::$params = array TimeHelper::$action = "drill" 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 = "/building/nord-pas-de-calais" FormVariablesPaginatorHelper::$params = array FormVariablesPaginatorHelper::$action = "drill" 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 = "/building/nord-pas-de-calais" AjaxHelper::$params = array AjaxHelper::$action = "drill" 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 = "/building/nord-pas-de-calais" IconHelper::$params = array IconHelper::$action = "drill" 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 = "/building/nord-pas-de-calais" DrillHelper::$params = array DrillHelper::$action = "drill" 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 = 1761130527 SessionHelper::$sessionTime = 1761142527 SessionHelper::$watchKeys = array SessionHelper::$id = NULL SessionHelper::$_started = false SessionHelper::$host = NULL SessionHelper::$_log = NULL SessionHelper::$cookieLifeTime = 604800 SessionHelper::$base = "" SessionHelper::$webroot = "/" SessionHelper::$here = "/building/nord-pas-de-calais" SessionHelper::$params = array SessionHelper::$action = "drill" 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 = "/building/nord-pas-de-calais" PaginatorHelper::$params = array PaginatorHelper::$action = "drill" 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() $pageUrl = array( "primary" => "building", "region" => "nord-pas-de-calais" ) $groups = array( "All", "Houses", "Commercial", "Prestige", "Lakes", "Apartments", "Income-Business", "Land-Woodland", "Ski", "Equestrian" ) $selected = array( "notSold" => false ) $selectedCriteria = array( "primary" => "building", "region_name" => "nord_pas_de_calais" ) $countExclusif = 0 $alternate = "https://www.leggett-immo.com/building/nord-pas-de-calais" $cache = CacheHelper CacheHelper::$__replace = array CacheHelper::$__match = array CacheHelper::$cacheAction = NULL CacheHelper::$helpers = NULL CacheHelper::$base = "" CacheHelper::$webroot = "/" CacheHelper::$themeWeb = NULL CacheHelper::$here = "/building/nord-pas-de-calais" CacheHelper::$params = array CacheHelper::$action = "drill" 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 = "/building/nord-pas-de-calais" HtmlHelper::$params = array HtmlHelper::$action = "drill" 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 = "/building/nord-pas-de-calais" FormHelper::$params = array FormHelper::$action = "drill" 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 = "/building/nord-pas-de-calais" TextHelper::$params = array TextHelper::$action = "drill" 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 = "/building/nord-pas-de-calais" NumberHelper::$params = array NumberHelper::$action = "drill" 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 = "/building/nord-pas-de-calais" JavascriptHelper::$params = array JavascriptHelper::$action = "drill" 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 = "/building/nord-pas-de-calais" TagcloudHelper::$params = array TagcloudHelper::$action = "drill" 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 = "/building/nord-pas-de-calais" CustomHelper::$params = array CustomHelper::$action = "drill" 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 = "/building/nord-pas-de-calais" TimeHelper::$params = array TimeHelper::$action = "drill" 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 = "/building/nord-pas-de-calais" FormVariablesPaginatorHelper::$params = array FormVariablesPaginatorHelper::$action = "drill" 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 = "/building/nord-pas-de-calais" AjaxHelper::$params = array AjaxHelper::$action = "drill" 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 = "/building/nord-pas-de-calais" IconHelper::$params = array IconHelper::$action = "drill" 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 = "/building/nord-pas-de-calais" DrillHelper::$params = array DrillHelper::$action = "drill" 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 = 1761130527 SessionHelper::$sessionTime = 1761142527 SessionHelper::$watchKeys = array SessionHelper::$id = NULL SessionHelper::$_started = false SessionHelper::$host = NULL SessionHelper::$_log = NULL SessionHelper::$cookieLifeTime = 604800 SessionHelper::$base = "" SessionHelper::$webroot = "/" SessionHelper::$here = "/building/nord-pas-de-calais" SessionHelper::$params = array SessionHelper::$action = "drill" 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 = "/building/nord-pas-de-calais" PaginatorHelper::$params = array PaginatorHelper::$action = "drill" 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::drill() - APP/controllers/allproperties_controller.php, line 4784 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::drill() - APP/controllers/allproperties_controller.php, line 4784 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

Notice (8): Undefined index: listdesc [APP/models/department.php, line 45]

Code | Context

$data	=	array(
	array(
	"Department" => array()
)
)
$key	=	0
$department	=	array(
	"Department" => array(
	array(),
	array()
)
)

            foreach($data as $key => $department){

                $department['Department']['listdesc'] = str_replace('_', '-',$department['Department']['listdesc']);

Department::afterFind() - APP/models/department.php, line 45
DboSource::__filterResults() - CORE/cake/libs/model/datasources/dbo_source.php, line 718
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php, line 685
Model::find() - CORE/cake/libs/model/model.php, line 2040
RegionsController::getRegionsMenu() - APP/controllers/regions_controller.php, line 150
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
Object::requestAction() - CORE/cake/libs/object.php, line 100
include - APP/views/elements/drill_side_menu_areas.ctp, line 1
View::_render() - CORE/cake/libs/view/view.php, line 665
View::element() - CORE/cake/libs/view/view.php, line 342
include - APP/views/allproperties/property_results_with_bar.ctp, line 31
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::drill() - APP/controllers/allproperties_controller.php, line 4784
Object::dispatchMethod() - CORE/cake/libs/object.php, line 115

Notice (8): Undefined index: group [APP/views/elements/drill_side_menu_ppt.ctp, line 13]

Code | Context

$___viewFn	=	"/app/src/views/elements/drill_side_menu_ppt.ctp"
$___dataForView	=	array(
	"primarypropertytypes" => array(
	"All",
	"House",
	"Apartment",
	"Land",
	"Chalet",
	"Chateau",
	"Commercial",
	"Lakes",
	"Mill",
	"Barn",
	"Building",
	"Houseboat",
	"Parking"
),
	"properties" => array(),
	"pageUrl" => array(
	"primary" => "building",
	"region" => "nord-pas-de-calais"
),
	"groups" => array(
	"All",
	"Houses",
	"Commercial",
	"Prestige",
	"Lakes",
	"Apartments",
	"Income-Business",
	"Land-Woodland",
	"Ski",
	"Equestrian"
),
	"selected" => array(
	"notSold" => false
),
	"selectedCriteria" => array(
	"primary" => "building",
	"region_name" => "nord_pas_de_calais"
),
	"countExclusif" => 0,
	"alternate" => "https://www.leggett-immo.com/building/nord-pas-de-calais",
	"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 = "/building/nord-pas-de-calais"
AllpropertiesController::$webroot = "/"
AllpropertiesController::$action = "drill"
AllpropertiesController::$params = array
AllpropertiesController::$data = NULL
AllpropertiesController::$paginate = array
AllpropertiesController::$viewPath = "allproperties"
AllpropertiesController::$layoutPath = NULL
AllpropertiesController::$viewVars = array
AllpropertiesController::$pageTitle = "Building for sale in Nord-pas-de-calais - 0 French properties found "
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,
	"cache" => CacheHelper
CacheHelper::$__replace = array
CacheHelper::$__match = array
CacheHelper::$cacheAction = NULL
CacheHelper::$helpers = NULL
CacheHelper::$base = ""
CacheHelper::$webroot = "/"
CacheHelper::$themeWeb = NULL
CacheHelper::$here = "/building/nord-pas-de-calais"
CacheHelper::$params = array
CacheHelper::$action = "drill"
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 = "/building/nord-pas-de-calais"
HtmlHelper::$params = array
HtmlHelper::$action = "drill"
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 = "/building/nord-pas-de-calais"
FormHelper::$params = array
FormHelper::$action = "drill"
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 = "/building/nord-pas-de-calais"
TextHelper::$params = array
TextHelper::$action = "drill"
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 = "/building/nord-pas-de-calais"
NumberHelper::$params = array
NumberHelper::$action = "drill"
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 = "/building/nord-pas-de-calais"
JavascriptHelper::$params = array
JavascriptHelper::$action = "drill"
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 = "/building/nord-pas-de-calais"
TagcloudHelper::$params = array
TagcloudHelper::$action = "drill"
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 = "/building/nord-pas-de-calais"
CustomHelper::$params = array
CustomHelper::$action = "drill"
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 = "/building/nord-pas-de-calais"
TimeHelper::$params = array
TimeHelper::$action = "drill"
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 = "/building/nord-pas-de-calais"
FormVariablesPaginatorHelper::$params = array
FormVariablesPaginatorHelper::$action = "drill"
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 = "/building/nord-pas-de-calais"
AjaxHelper::$params = array
AjaxHelper::$action = "drill"
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 = "/building/nord-pas-de-calais"
IconHelper::$params = array
IconHelper::$action = "drill"
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 = "/building/nord-pas-de-calais"
DrillHelper::$params = array
DrillHelper::$action = "drill"
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 = 1761130527
SessionHelper::$sessionTime = 1761142527
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_started = false
SessionHelper::$host = NULL
SessionHelper::$_log = NULL
SessionHelper::$cookieLifeTime = 604800
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/building/nord-pas-de-calais"
SessionHelper::$params = array
SessionHelper::$action = "drill"
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 = "/building/nord-pas-de-calais"
PaginatorHelper::$params = array
PaginatorHelper::$action = "drill"
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()
$pageUrl	=	array(
	"primary" => "building",
	"region" => "nord-pas-de-calais"
)
$groups	=	array(
	"All",
	"Houses",
	"Commercial",
	"Prestige",
	"Lakes",
	"Apartments",
	"Income-Business",
	"Land-Woodland",
	"Ski",
	"Equestrian"
)
$selected	=	array(
	"notSold" => false
)
$selectedCriteria	=	array(
	"primary" => "building",
	"region_name" => "nord_pas_de_calais"
)
$countExclusif	=	0
$alternate	=	"https://www.leggett-immo.com/building/nord-pas-de-calais"
$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 = "/building/nord-pas-de-calais"
AllpropertiesController::$webroot = "/"
AllpropertiesController::$action = "drill"
AllpropertiesController::$params = array
AllpropertiesController::$data = NULL
AllpropertiesController::$paginate = array
AllpropertiesController::$viewPath = "allproperties"
AllpropertiesController::$layoutPath = NULL
AllpropertiesController::$viewVars = array
AllpropertiesController::$pageTitle = "Building for sale in Nord-pas-de-calais - 0 French properties found "
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
$cache	=	CacheHelper
CacheHelper::$__replace = array
CacheHelper::$__match = array
CacheHelper::$cacheAction = NULL
CacheHelper::$helpers = NULL
CacheHelper::$base = ""
CacheHelper::$webroot = "/"
CacheHelper::$themeWeb = NULL
CacheHelper::$here = "/building/nord-pas-de-calais"
CacheHelper::$params = array
CacheHelper::$action = "drill"
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 = "/building/nord-pas-de-calais"
HtmlHelper::$params = array
HtmlHelper::$action = "drill"
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 = "/building/nord-pas-de-calais"
FormHelper::$params = array
FormHelper::$action = "drill"
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 = "/building/nord-pas-de-calais"
TextHelper::$params = array
TextHelper::$action = "drill"
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 = "/building/nord-pas-de-calais"
NumberHelper::$params = array
NumberHelper::$action = "drill"
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 = "/building/nord-pas-de-calais"
JavascriptHelper::$params = array
JavascriptHelper::$action = "drill"
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 = "/building/nord-pas-de-calais"
TagcloudHelper::$params = array
TagcloudHelper::$action = "drill"
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 = "/building/nord-pas-de-calais"
CustomHelper::$params = array
CustomHelper::$action = "drill"
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 = "/building/nord-pas-de-calais"
TimeHelper::$params = array
TimeHelper::$action = "drill"
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 = "/building/nord-pas-de-calais"
FormVariablesPaginatorHelper::$params = array
FormVariablesPaginatorHelper::$action = "drill"
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 = "/building/nord-pas-de-calais"
AjaxHelper::$params = array
AjaxHelper::$action = "drill"
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 = "/building/nord-pas-de-calais"
IconHelper::$params = array
IconHelper::$action = "drill"
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 = "/building/nord-pas-de-calais"
DrillHelper::$params = array
DrillHelper::$action = "drill"
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 = 1761130527
SessionHelper::$sessionTime = 1761142527
SessionHelper::$watchKeys = array
SessionHelper::$id = NULL
SessionHelper::$_started = false
SessionHelper::$host = NULL
SessionHelper::$_log = NULL
SessionHelper::$cookieLifeTime = 604800
SessionHelper::$base = ""
SessionHelper::$webroot = "/"
SessionHelper::$here = "/building/nord-pas-de-calais"
SessionHelper::$params = array
SessionHelper::$action = "drill"
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 = "/building/nord-pas-de-calais"
PaginatorHelper::$params = array
PaginatorHelper::$action = "drill"
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
$primarypropertytype	=	"Parking"
$ind	=	13

    <?php endif;?>

    <?php if($this->params['group'] == 'équestre'):?>

include - APP/views/elements/drill_side_menu_ppt.ctp, line 13
View::_render() - CORE/cake/libs/view/view.php, line 665
View::element() - CORE/cake/libs/view/view.php, line 342
include - APP/views/allproperties/property_results_with_bar.ctp, line 32
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::drill() - APP/controllers/allproperties_controller.php, line 4784
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

Building for sale in Nord-pas-de-calais - 0 French properties found

Filter with more criteria

“Some properties are not listed on the site, so please let us know what you're looking for so that we can show you around. Please note that we work in partnership with many other real estate professionals and we can also search for your property for you.”

0 properties

hide sold properties

page 0 / 0 - sort by :

Notice (8): Undefined index: first [APP/views/helpers/paginator.php, line 567]

Code | Context

$options	=	array(
	"modulus" => 3,
	"last" => 1
)

                'model' => $this->defaultModel(),
                'modulus' => '8', 'separator' => '',
                'first' => $options['first'],

PaginatorHelper::numbers() - APP/views/helpers/paginator.php, line 567
include - APP/views/allproperties/property_results_with_bar.ctp, line 84
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::drill() - APP/controllers/allproperties_controller.php, line 4784
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

(default) 11 queries took 413 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `Primarypropertytype`.`name`, `Primarypropertytype`.`id` FROM `primarypropertytypes` AS `Primarypropertytype` WHERE `name` = 'building' LIMIT 1	1	1	7
2	SELECT `Region`.`name`, `Region`.`id` FROM `regions` AS `Region` WHERE `name` = 'nord_pas_de_calais' LIMIT 1	1	1	24
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`.`primarypropertytype_id` = 11 AND `Allproperty`.`region_id` = '31' AND `Allproperty`.`isinvisible` != 1	1	1	60
4	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`.`primarypropertytype_id` = 11 AND `Allproperty`.`region_id` = '31' AND `Allproperty`.`isinvisible` != 1 ORDER BY `Allproperty`.`date_made_live` desc LIMIT 60	0	0	245
5	SELECT `Group`.`id`, `Group`.`name` FROM `groups` AS `Group` WHERE 1 = 1	9	9	7
6	SELECT `Primarypropertytype`.`id`, `Primarypropertytype`.`name` FROM `primarypropertytypes` AS `Primarypropertytype` WHERE 1 = 1	13	13	7
7	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`.`primarypropertytype_id` = 11) AND (`Allproperty`.`region_id` = '31'))) AND (`Allproperty`.`is_exclusive` = 1)) AND `Allproperty`.`is_exclusive` = 1 AND `Allproperty`.`isinvisible` != 1	1	1	36
8	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	11
9	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
10	SELECT `Primarypropertytype`.`id`, `Primarypropertytype`.`name` FROM `primarypropertytypes` AS `Primarypropertytype` WHERE 1 = 1 ORDER BY `id` ASC	13	13	3
11	SELECT `Primarypropertytype`.`id`, `Primarypropertytype`.`name` FROM `primarypropertytypes` AS `Primarypropertytype` WHERE 1 = 1 ORDER BY `id` ASC	13	13	9

(default) 11 queries took 413 ms

Query

Error

Affected

Num. rows

Took (ms)

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

SELECT `Region`.`name`, `Region`.`id` FROM `regions` AS `Region` WHERE `name` = 'nord_pas_de_calais' LIMIT 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`.`primarypropertytype_id` = 11 AND `Allproperty`.`region_id` = '31' 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`.`primarypropertytype_id` = 11 AND `Allproperty`.`region_id` = '31' AND `Allproperty`.`isinvisible` != 1 ORDER BY `Allproperty`.`date_made_live` desc LIMIT 60

245

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 COUNT(*) AS `count` FROM `allproperties` AS `Allproperty` LEFT JOIN `users` AS `User` ON (`Allproperty`.`user_id` = `User`.`id`) LEFT JOIN `regions` AS `Region` ON (`Allproperty`.`region_id` = `Region`.`id`) LEFT JOIN `departments` AS `Department` ON (`Allproperty`.`department_id` = `Department`.`id`) LEFT JOIN `primarypropertytypes` AS `Primarypropertytype` ON (`Allproperty`.`primarypropertytype_id` = `Primarypropertytype`.`id`) WHERE ((((`Allproperty`.`primarypropertytype_id` = 11) AND (`Allproperty`.`region_id` = '31'))) AND (`Allproperty`.`is_exclusive` = 1)) AND `Allproperty`.`is_exclusive` = 1 AND `Allproperty`.`isinvisible` != 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