Popular Features
Sleeps
Sleeps
Destinations
Our Cottages
North Cornwall Cottages With Hot Tubs
Popular Features
Sleeps
Close
romantic: pool: wifi: nearBeach: allowsPets:
region: England
county: Cornwall
sleeps:
bedrooms:
romantic:
Local table: UKTravelFeeds.cottages
This is a countySearch
Main sql2: SELECT df.*, sup.shortDesc
FROM UKTravelFeeds.cottages df
INNER JOIN miniSitesSupplemental.northcornwallcottageswithhottubs sup ON df.siteCode = sup.siteCode
WHERE df.county = 'Cornwall'2 Cottages Found
Pagination running in TEST MODE
baseURL: /
totalRows: 2
page: 1
numberOfPages: (totalRows / 15) = 1
Refine by counts
Counts SQL
SELECT SUM(wifi) AS wifiCount, SUM(nearPub) AS nearPubCount, SUM(fishing) AS fishingCount, SUM(pool) AS poolCount, SUM(golf) AS golfCount, SUM(allowsPets) AS allowsPetsCount, SUM(nearBeach) AS nearBeachCount, SUM(garden) AS gardenCount, SUM(openFire) AS openFireCount, SUM(romantic) AS romanticCount, SUM(CASE WHEN sleeps BETWEEN 2 AND 4 THEN 1 ELSE 0 END) AS sleeps2_4Count, SUM(CASE WHEN sleeps BETWEEN 5 AND 6 THEN 1 ELSE 0 END) AS sleeps5_6Count, SUM(CASE WHEN sleeps BETWEEN 7 AND 8 THEN 1 ELSE 0 END) AS sleeps7_8Count, SUM(CASE WHEN sleeps >= 9 THEN 1 ELSE 0 END) AS sleeps9Count FROM UKTravelFeeds.cottages WHERE county = 'Cornwall' AND siteCode IN ( SELECT siteCode FROM miniSitesSupplemental.northcornwallcottageswithhottubs )
counts array
Array ( [wifiCount] => 1 [nearPubCount] => 0 [fishingCount] => 1 [poolCount] => 0 [golfCount] => 0 [allowsPetsCount] => 2 [nearBeachCount] => 2 [gardenCount] => 1 [openFireCount] => 0 [romanticCount] => 1 [sleeps2_4Count] => 2 [sleeps5_6Count] => 0 [sleeps7_8Count] => 0 [sleeps9Count] => 0 )
sortBy: bestMatch$page: 1
orderBy: ORDER BY county='Cornwall' DESC, siteName ASC
$from: 1
$showAtTime: 15
$from: 1
sql: SELECT df.*, sup.shortDesc
FROM UKTravelFeeds.cottages df
INNER JOIN miniSitesSupplemental.northcornwallcottageswithhottubs sup ON df.siteCode = sup.siteCode
WHERE df.county = 'Cornwall'AND page != '.html' GROUP BY page ORDER BY county='Cornwall' DESC, siteName ASC LIMIT 0, 20 page: argus-cottage.html
region: 'South West of England'
county: Cornwall
cottageLink: /cottages/argus-cottage.html
imagesTable: ruralRetreats.images
photosFolder: rural-retreats-photos
sql3: SELECT image, alt_text,cacheID FROM ruralRetreats.images WHERE productId = '104219' GROUP BY image ORDER BY image ASC LIMIT 20
siteCode: RR104219 - sql3: SELECT image, alt_text,cacheID FROM ruralRetreats.images WHERE productId = '104219' GROUP BY image ORDER BY image ASC LIMIT 20
- Lighthouse location with mesmerizing views
- Spotlessly clean and well-maintained
- Wildlife watching from your doorstep
- Peaceful coastal retreat
- Perfect stargazing opportunities
View Cottage
[+] To Favourites
page: brook-cottage.html
region: 'South West of England'
county: Cornwall
cottageLink: /cottages/brook-cottage.html
imagesTable: ruralRetreats.images
photosFolder: rural-retreats-photos
sql3: SELECT image, alt_text,cacheID FROM ruralRetreats.images WHERE productId = '104345' GROUP BY image ORDER BY image ASC LIMIT 20
siteCode: RR104345 - sql3: SELECT image, alt_text,cacheID FROM ruralRetreats.images WHERE productId = '104345' GROUP BY image ORDER BY image ASC LIMIT 20
- Sea views from both bedrooms
- Lighthouse location
- Close to beautiful beaches
- Welcome hamper included
- Fully equipped kitchen
View Cottage
[+] To Favourites
