= $minSize"); } if ($maxSize != '10000000') { array_push($searchFilters,"AP_Prop_Min_Size_Web <= $maxSize"); } if ($keyword != '') { array_push($searchFilters,"AP_Prop_Description LIKE '%$keyword%' OR AP_Prop_Full_Address LIKE '%$keyword%'"); } #ACTIVE PROPERTIES ONLY? if ((isset($_GET['active']) && ($_GET['active'] == '1'))) { array_push($searchFilters,"(AP_Prop_Market_Status = '8' OR AP_Prop_Market_Status = '14')"); } else { #array_push($searchFilters,"((AP_Prop_Market_Status = '8' OR AP_Prop_Market_Status = '14') OR ((AP_Prop_Market_Status = '4' OR AP_Prop_Market_Status = '5') AND AP_Prop_LAST_UNAVAILABLE_DATE > NOW() - INTERVAL 60 DAY))"); array_push($searchFilters,"(AP_Prop_Market_Status = '8' OR AP_Prop_Market_Status = '14' OR AP_Prop_Market_Status = '4' OR AP_Prop_Market_Status = '5')"); } if (count($searchFilters) > 0) { $searchQuery .= " WHERE "; foreach ($searchFilters as $searchFilter) { $searchQuery .= $searchFilter.' AND '; } $searchQuery = preg_replace('/ AND $/', '', $searchQuery); } $searchQuery .= " ORDER BY AP_Prop_Max_Size_Web DESC"; /* TOTAL RECORDS */ $noRecordsQuery = $dbConnection->prepare("$searchQuery"); $noRecordsQuery->execute(); $totalRecords = $noRecordsQuery->rowCount(); /* END TOTAL RECORDS */ $searchQuery .= " LIMIT $propNoStart, $propPerPage"; #REBUILD URL $newURL = strtolower('/commercial-properties/'.str_replace(' ','-',$tenure).'/'); if ((isset($_GET['location']))&&($_GET['location'] != 'Any')) { $newURL.= $_GET['location'].'/'; } #META DATA $classDefault = 'commercial property'; $locationDefault = 'North West England'; if ($class != 'Any') { switch ($class) { case 'Industrial Development Land': $h1HeaderString = 'Industrial Development Land'; $classDefault = strtolower($class); break; case 'Investment - Land': $h1HeaderString = 'Investment Land'; $classDefault = strtolower($class); break; case 'Land': $h1HeaderString = 'Land'; $classDefault = 'Industrial Development Land'; $classDefault = strtolower($class); break; case 'Nursery': $h1HeaderString = 'Nurseries'; $classDefault = strtolower($class); break; case 'Office': $h1HeaderString = 'Offices'; $classDefault = strtolower($class); break; case 'Public House': $h1HeaderString = 'Public Houses'; $classDefault = strtolower($class); break; case 'Residential Development Land': $h1HeaderString = 'Residential Development Land'; $classDefault = strtolower($class); break; default: $h1HeaderString = $class.' Properties'; $classDefault = strtolower($class); } } else { $h1HeaderString = "Commercial Properties"; } if ($tenure != 'Any') { $h1HeaderString .= ' '.$tenure; } if ($location != 'Any') { $h1HeaderString .= " in ".$location; $locationDefault = $location; } else { $h1HeaderString .= ", ".$locationDefault; } $description = "At Nolan Redshaw, our commercial property team specialise in all aspects of $classDefault work from disposals and acquisitions to lettings and management in and around the $locationDefault. We have extensive experience acting on behalf of a wide range clients and dealing with a broad spectrum of $classDefault property throughtout the $locationDefault."; #DIMENSIONS QUERY $dimensionQuery = $dbConnection->prepare("SELECT * FROM dimensions"); $dimensionQuery->execute(); $dimensionRecords = $dimensionQuery->fetchAll(); ?> <? print $h1HeaderString; ?>
Nolan Redshaw Commercial Property Specialists

prepare("$searchQuery"); $propertyQuery->execute(); if ($propertyQuery->rowCount() == 0) { $dbConnection = null; print '

Unfortunately we do not currently have any properties that match your requirements.

'; print '

Please try broadening your search criteria or get in touch with us and let us know what you are looking for.

'; } else { $propertyRecords = $propertyQuery->fetchAll(); print ''; /* PAGES */ #Rebuild URL without Page Number $urlParameters = ''; $parameters = explode("&", $_SERVER['QUERY_STRING']); foreach ($parameters as $parameter) { $temp = explode("=", $parameter); if (($temp[0] != 'page') && ($temp[0] != 'search')) { $urlParameters .= $parameter . "&"; } } #End of Rebuild $totalPages = ceil($totalRecords / $propPerPage); print '
    '; if ($page == 1) { print ''; } else { $prevPage = $page - 1; print ''; } for ($x = 1; $x <= $totalPages; $x++) { if ($page == $x) { print '
  • '.$x.'
  • '; } else { print '
  • '.$x.'
  • '; } } if ($page == $totalPages) { print ''; } else { $nextPage = $page + 1; print ''; } print '
'; } ?>

Contact Nolan Redshaw

WORKING IN PARTNERSHIP

getExtension(), $extensions)) { $pictureTemp = $fileinfo->getPathname(); if (file_exists($pictureTemp)) { $pictureTemp = str_replace($_SERVER['DOCUMENT_ROOT'],'',$pictureTemp); array_push($pictureArray,$pictureTemp); } } } shuffle($pictureArray); } ?>
'; } ?>

Nolan Redshaw, Haweswater House, Waterfold Business Park, Bury, BL9 7BR
info@nolanredshaw.co.uk

Recruitment | Properties For Sale | Properties To Let

Web Site Design by Burnley Computers

Copyright © Nolan Redshaw