get_row("SELECT ID,AttractionType,Name,Town,County,Country,subregion,Latitude,Longitude,OurURL FROM attractions WHERE ID = '$place' LIMIT 1")) { $location = "$domain/index.htm"; header("HTTP/1.1 301 Moved Permanently"); header("Location: $location"); exit(); } $Country = $attraction->Country; $County = $attraction->County; $subregion = $attraction->subregion; $Name = $attraction->Name; $AttractionType = $attraction->AttractionType; $firstTown = $attraction->Town; $Town = preg_replace('/[^a-zA-Z0-9\- ]+/', '', $firstTown); $id = $attraction->ID; $lng = $attraction->Longitude; $lat = $attraction->Latitude; // if(isset($_GET["page"])) { $page = $_GET["page"]; } else { $page = ""; } include("DisplayResultAttractionType.php"); $Limit = 10; If($page == "") $page=1; //If no page number is set, the default page is 1 //Get the number of results $miles = 300; $SearchResult=mysql_query("SELECT BEid,ID,Name,Town,County,Country,Source,SourceID,LowPrice,hotel_dir,HeritageRating,Rating,(((acos(sin(($lat*pi()/180)) * sin((Latitude*pi()/180)) + cos(($lat*pi()/180)) * cos((Latitude*pi()/180)) * cos((($lng - Longitude)*pi()/180))))*180/pi())*60*1.1515) as distance FROM accommodation WHERE AccommodationType = 'Hotel' GROUP BY BEid HAVING distance <= $miles ORDER BY distance ASC LIMIT 30") or die(mysql_error()); $NumberOfResults=mysql_num_rows($SearchResult); //Get the number of pages $NumberOfPages=ceil($NumberOfResults/$Limit); if($NumberOfPages < $page) { $location = "$domain/nearest-bed-breakfast.htm?attraction=$id"; header("HTTP/1.1 301 Moved Permanently"); header("Location: $location"); exit(); } $miles = 300; $query = $db->get_results("SELECT BEid,ID,Name,Town,County,Country,Source,SourceID,LowPrice,hotel_dir,HeritageRating,Latitude,Longitude,Rating,(((acos(sin(($lat*pi()/180)) * sin((Latitude*pi()/180)) + cos(($lat*pi()/180)) * cos((Latitude*pi()/180)) * cos((($lng - Longitude)*pi()/180))))*180/pi())*60*1.1515) as distance FROM accommodation WHERE AccommodationType = 'Hotel' AND Source <> 'SB' GROUP BY BEid HAVING distance <= $miles ORDER BY distance ASC LIMIT " . ($page-1)*$Limit . ",$Limit"); $count = 0; foreach($query AS $HeritageCount) { if($HeritageCount->HeritageRating == '3' OR $HeritageCount->HeritageRating == '4' OR $HeritageCount->HeritageRating == '5') { $count++; } $TotalHeritage = $count; } function create_breadcrumb($breadcrumb_titles,$breadcrumb_urls) { $ParentIDString = ltrim($breadcrumb_titles, "@@"); $ParentIDPieces = explode("@@", $ParentIDString, -1); $ParentNameString = ltrim($breadcrumb_urls, "@@"); $ParentNamePieces = explode("@@", $ParentNameString, -1); $breadcrumb_array = array_combine($ParentNamePieces,$ParentIDPieces); return $breadcrumb_array; } include_once("DisplayResultAttractionType.php"); ?> Hotels near <?php echo $attraction->Name; ?>, <?php if($attraction->County == 'Cumbria') { echo 'Lake District'; } elseif($attraction->County == 'Greater London') { echo 'London'; } else { echo $attraction->County; } ?> Travel Guide<?php if($page > 1) { $cleanpage = htmlspecialchars($page); echo ", page $cleanpage"; } ?> . We also offer self catering and bed and breakfast accommodation in the Name; ?> area, plus travel, attractions, and heritage information. Part of the Historic County; ?> Travel Guide."> " /> . We also offer self catering and bed and breakfast accommodation in the Name; ?> area, plus travel, attractions, and heritage information. Part of the Historic County; ?> Travel Guide."> 1) { $prev = $page - 1; ?> 1) { ?> Country == 'England') { $countrypage = '/counties/index.htm'; } elseif ($content->Country == 'Scotland') { $countrypage = '/scotland/index.htm'; } elseif ($content->Country == 'Wales') { $countrypage = '/wales/index.htm'; } elseif ($content->Country == 'Isle of Man') { $countrypage = '/counties/man/index.htm'; } elseif ($content->Country == 'Channel Islands') { $countrypage = '/counties/channel/index.htm'; } $Country = $SearchResult[0]->Country; ?>

Hotels near Name; ?>, County == 'Cumbria') { echo 'Lake District'; } elseif($attraction->County == 'Greater London') { echo 'London'; } else { echo $attraction->County; } ?>

Showing results 0) { ?>, including Historic Hotel 1) { echo 's'; } ?>

OurURL <> '') { ?>About Name); ?>About Name; ?>

'') { ?>

    ACCOMMODATION MAP Accommodation map

See also: nearest self catering - nearest Bed and Breakfast

HeritageRating == '5' || $HotelPage->HeritageRating == '4' || $HotelPage->HeritageRating == '3') { $HeritageValue = 'Y'; } else { $HeritageValue = 'N'; } ?>
<?php echo $HotelPage->Name; ?> <?php echo $HotelPage->Town; ?><?php echo $HotelPage->Name; echo $HotelPage->Town; ?>

Name; ?>

Address1)) { echo $HotelPage->Address1; } else { echo $HotelPage->Town; } ?> - '3647') { $miles = $HotelPage->distance; echo round($miles,1); ?> miles from Name; } else { ?>near Hadrian's Wall

Stay From: LowPrice == '' || $HotelPage->LowPrice == '0.00') { ?> Check availability for current prices £LowPrice; } ?>

Rating); if(!empty($Rating) && is_numeric($Rating[0])) { ?> <?php echo $Rating[0]; ?> star rating    Not rated

Heritage Rating: HeritageRating == '1' || $HotelPage->HeritageRating == '2' || $HotelPage->HeritageRating == '3' || $HotelPage->HeritageRating == '4' || $HotelPage->HeritageRating == '5') { $RatingExists = 'Y'; ?> Heritage Rating not yet rated

HeritageRating == '5' || $HotelPage->HeritageRating == '4' || $HotelPage->HeritageRating == '3') { ?>

HISTORIC ACCOMMODATION

 

No hotels are nearby. Browse all hotels >>


Map is approximate and should only be used to get a rough idea of the location of cottages near . Please see individual cottage details for more precise location information.
Attraction search
in
Town"); $townfile = ($_SERVER['DOCUMENT_ROOT'] ."/includes/$townname-left-nav-2.htm"); $countryname = preg_replace('/[^a-zA-Z0-9]+/', '-', "$attraction->Country"); $countryfile = ($_SERVER['DOCUMENT_ROOT'] ."/includes/$countryname-left-nav-2.htm"); $regionname = str_replace("'", '', $subregion); $regionname = preg_replace('/[^a-zA-Z0-9]+/', '-', "$regionname"); $regionfile = ($_SERVER['DOCUMENT_ROOT'] ."/includes/$regionname-left-nav-2.htm"); $countyname = preg_replace('/[^a-zA-Z0-9]+/', '-', "$attraction->County"); $countyfile = ($_SERVER['DOCUMENT_ROOT'] ."/includes/$countyname-left-nav-2.htm"); if (file_exists($townfile)) { include ("$townfile"); } elseif (file_exists($regionfile)) { include ("$regionfile"); } elseif (file_exists($countyfile)) { include ("$countyfile"); } elseif (file_exists($countryfile)) { include ("$countryfile"); } else { include("Main-left-nav-2.htm"); } ?>

Attractions

'' AND $placeslon <> '') { $miles = 200; $getattractions = $db->get_results("SELECT ID,Name,OurURL,AttractionType,(((acos(sin(($placeslat*pi()/180)) * sin((Latitude*pi()/180)) + cos(($placeslat*pi()/180)) * cos((Latitude*pi()/180)) * cos((($placeslon - Longitude)*pi()/180))))*180/pi())*60*1.1515) as howfar FROM attractions WHERE Name <> '$AttractionName' AND Publication_Date <= '$current_date' AND (AttractionType != 'Town' AND AttractionType != 'Village') AND status = 'Live' HAVING howfar <= $miles ORDER BY howfar ASC LIMIT 7"); $gettowns = $db->get_results("SELECT ID,Name,OurURL,AttractionType,(((acos(sin(($placeslat*pi()/180)) * sin((Latitude*pi()/180)) + cos(($placeslat*pi()/180)) * cos((Latitude*pi()/180)) * cos((($placeslon - Longitude)*pi()/180))))*180/pi())*60*1.1515) as distance FROM attractions WHERE Publication_Date <= '$current_date' AND (AttractionType = 'Town' OR AttractionType = 'Village') AND Name <> '$AttractionTown' AND status = 'Live' HAVING distance <= $miles ORDER BY distance ASC LIMIT 7"); if($getattractions <> '') { ?>

Nearest attractions
howfar; $shortdistance = round($distanceto,1); ?>

OurURL <> '') { ?>Name); ?>Name; ?>
miles - (AttractionType); echo $DisplayAttractionType; ?>)

'') { ?>
Tourism - Towns & Villages

OurURL <> '') { ?>Name); ?>Name; ?> (distance; echo round($far,1); ?> miles)

get_results("SELECT * FROM attractions WHERE County = '$County' AND (AttractionType = 'Town' OR AttractionType = 'Village') AND ID <> '$id' AND status = 'Live' ORDER BY Name ASC LIMIT 6")) { echo ("

Top $County Destinations
"); foreach ($nearbycounty as $navcounty) { echo ("ID\" class=\"form-text-link\">$navcounty->Name
"); } } } ?>