Norfolk » Services » Attractions

 

Most highly rated Attractions in Norfolk

Order by:


Holkham Bay
An enormous whiite sandy beach. Wonderful birdlife and big blue skies make this a magical place. ...
Beaches | North Norfolk Coast | User rating (1 reviews)
Wells Beach
Wonderful views and fish and chips make this a popular family spot. Cross over at low tide and escape the masses. It is like being on your own desert island. The colourful beach huts are well photogr...
Beaches | North Norfolk Coast | Not yet rated
Hunstanton Beach
The classification of Hunstanton as "east coast" makes the town unique in that it is the only east coast seaside resort in England where the sun can be seen to set over the sea. Hunstanton is also wel...
Beaches | Hunstanton | Not yet rated
Sea Palling Beach
Sea Palling is one of Norfolks premier beaches, having been awarded the blue flag it is also one of Norfolks cleanist. Situated just south of Happisburgh Sea Palling is an unspoilt beach with miles of...
Beaches | North Walsham | Not yet rated
Bure Valley Railway
Take a trip on an old fashioned steam train! There are numerous activities and events going on throughout the year....
Activities | Aylsham | Not yet rated
Norfolk Shire Horse Centre
A unique collection of the many breeds and varieties of shire horse. Let them take you on a buggy ride!...
Activities | Cromer | Not yet rated
Hippodrome Circus
...
Activities | Great Yarmouth | Not yet rated
Great Yarmouth Potteries
A selection of amazing hand-made artworks are on offer as well as a museum that takes you back to a time when Yarmouth had a fishing fleet of world renown....
Activities | Great Yarmouth | Not yet rated
Louis Tussauds House of Wax
If you love kitsch then you'd better buy your ticket straight away. A famously horrendously poorly executed waxworks, complete with a chamber of horrors....
Activities | Great Yarmouth | Not yet rated
Norfolk Lavender at Caley Mill
Norfolk is famous for its lavender and this is the largest distillation opertaion in the country. Take the tour, experience the National Collection of Lavenders (there are over 100 different varities ...
Activities | Hunstanton | Not yet rated

Page: 1 2 3 4  more»


2.15 seconds / 52 queries
time: 0SELECT * FROM place WHERE parent_id = 1
time: 0SELECT text FROM meta_tags WHERE location=1 AND type='keywords' AND page='services'
time: 0SELECT text FROM meta_tags WHERE location=1 AND type='description' AND page='services'
time: 0SELECT text FROM meta_tags WHERE location=1 AND type='title' AND page='services'
time: 0SELECT name FROM place WHERE id = 1
time: 0SELECT * FROM place WHERE parent_id = 1
time: 0SELECT parent_id FROM place WHERE id = 1
time: 0SELECT name FROM place WHERE id = 1
time: 0SELECT * FROM place WHERE parent_id = 1 ORDER BY name
time: 0.19SELECT SQL_CALC_FOUND_ROWS global.*, posting.*, place.name AS place_name, ROUND(ROUND(AVG(ratings.rating)*2,0)/2,1) AS score, MAX(ratings.date_posted) AS review_date, COUNT(ratings.posting_id) AS reviews FROM global INNER JOIN posting ON posting.id = global.g_tid LEFT JOIN ratings ON ratings.posting_id = posting.id LEFT JOIN place ON posting.place_id = place.id WHERE posting.category_id IN (0,661,660,662,663,664,665,666,667,668,669,670,671,659) AND global.g_type = 5 AND global.g_is_comment = 0 AND g_place_id IN (2,3,4,5,6,7,8,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,136,1) GROUP BY g_id ORDER BY score DESC, reviews, review_date LIMIT 0, 10
time: 0SELECT FOUND_ROWS()
time: 0.17SELECT global.*, posting.*, service.*, place.name AS place_name, category.name AS category_name, ROUND(ROUND(AVG(ratings.rating)*2,0)/2,1) AS score, MAX(ratings.date_posted) AS review_date, COUNT(ratings.posting_id) AS reviews FROM global INNER JOIN posting ON posting.id = g_tid INNER JOIN service ON service.posting_id = g_tid INNER JOIN category ON category.id = posting.category_id INNER JOIN place ON place.id = posting.place_id LEFT JOIN ratings ON ratings.posting_id = posting.id WHERE posting.id = '101519' GROUP BY g_id
time: 0SELECT ratings.*,ROUND(ROUND(rating*2,0)/2,1) AS rating, ROUND(ROUND(rating1*2,0)/2,1) AS rating1, ROUND(ROUND(rating2*2,0)/2,1) AS rating2, ROUND(ROUND(rating3*2,0)/2,1) AS rating3, members.member_name, members.myicon_fname FROM ratings INNER JOIN members ON members.id = ratings.member_id WHERE posting_id = 101519
time: 0SELECT ROUND(ROUND(AVG(rating)*2,0)/2,1) AS rating, ROUND(ROUND(AVG(rating1)*2,0)/2,1) AS rating1, ROUND(ROUND(AVG(rating2)*2,0)/2,1) AS rating2, ROUND(ROUND(AVG(rating3)*2,0)/2,1) AS rating3 FROM ratings WHERE posting_id = 101519 GROUP BY posting_id
time: 0SELECT * FROM global_image WHERE g_id = 3042
time: 0.17SELECT global.*, posting.*, service.*, place.name AS place_name, category.name AS category_name, ROUND(ROUND(AVG(ratings.rating)*2,0)/2,1) AS score, MAX(ratings.date_posted) AS review_date, COUNT(ratings.posting_id) AS reviews FROM global INNER JOIN posting ON posting.id = g_tid INNER JOIN service ON service.posting_id = g_tid INNER JOIN category ON category.id = posting.category_id INNER JOIN place ON place.id = posting.place_id LEFT JOIN ratings ON ratings.posting_id = posting.id WHERE posting.id = '101520' GROUP BY g_id
time: 0SELECT ratings.*,ROUND(ROUND(rating*2,0)/2,1) AS rating, ROUND(ROUND(rating1*2,0)/2,1) AS rating1, ROUND(ROUND(rating2*2,0)/2,1) AS rating2, ROUND(ROUND(rating3*2,0)/2,1) AS rating3, members.member_name, members.myicon_fname FROM ratings INNER JOIN members ON members.id = ratings.member_id WHERE posting_id = 101520
time: 0SELECT ROUND(ROUND(AVG(rating)*2,0)/2,1) AS rating, ROUND(ROUND(AVG(rating1)*2,0)/2,1) AS rating1, ROUND(ROUND(AVG(rating2)*2,0)/2,1) AS rating2, ROUND(ROUND(AVG(rating3)*2,0)/2,1) AS rating3 FROM ratings WHERE posting_id = 101520 GROUP BY posting_id
time: 0SELECT * FROM global_image WHERE g_id = 3043
time: 0.17SELECT global.*, posting.*, service.*, place.name AS place_name, category.name AS category_name, ROUND(ROUND(AVG(ratings.rating)*2,0)/2,1) AS score, MAX(ratings.date_posted) AS review_date, COUNT(ratings.posting_id) AS reviews FROM global INNER JOIN posting ON posting.id = g_tid INNER JOIN service ON service.posting_id = g_tid INNER JOIN category ON category.id = posting.category_id INNER JOIN place ON place.id = posting.place_id LEFT JOIN ratings ON ratings.posting_id = posting.id WHERE posting.id = '101521' GROUP BY g_id
time: 0SELECT ratings.*,ROUND(ROUND(rating*2,0)/2,1) AS rating, ROUND(ROUND(rating1*2,0)/2,1) AS rating1, ROUND(ROUND(rating2*2,0)/2,1) AS rating2, ROUND(ROUND(rating3*2,0)/2,1) AS rating3, members.member_name, members.myicon_fname FROM ratings INNER JOIN members ON members.id = ratings.member_id WHERE posting_id = 101521
time: 0SELECT ROUND(ROUND(AVG(rating)*2,0)/2,1) AS rating, ROUND(ROUND(AVG(rating1)*2,0)/2,1) AS rating1, ROUND(ROUND(AVG(rating2)*2,0)/2,1) AS rating2, ROUND(ROUND(AVG(rating3)*2,0)/2,1) AS rating3 FROM ratings WHERE posting_id = 101521 GROUP BY posting_id
time: 0SELECT * FROM global_image WHERE g_id = 3044
time: 0.17SELECT global.*, posting.*, service.*, place.name AS place_name, category.name AS category_name, ROUND(ROUND(AVG(ratings.rating)*2,0)/2,1) AS score, MAX(ratings.date_posted) AS review_date, COUNT(ratings.posting_id) AS reviews FROM global INNER JOIN posting ON posting.id = g_tid INNER JOIN service ON service.posting_id = g_tid INNER JOIN category ON category.id = posting.category_id INNER JOIN place ON place.id = posting.place_id LEFT JOIN ratings ON ratings.posting_id = posting.id WHERE posting.id = '101522' GROUP BY g_id
time: 0SELECT ratings.*,ROUND(ROUND(rating*2,0)/2,1) AS rating, ROUND(ROUND(rating1*2,0)/2,1) AS rating1, ROUND(ROUND(rating2*2,0)/2,1) AS rating2, ROUND(ROUND(rating3*2,0)/2,1) AS rating3, members.member_name, members.myicon_fname FROM ratings INNER JOIN members ON members.id = ratings.member_id WHERE posting_id = 101522
time: 0SELECT ROUND(ROUND(AVG(rating)*2,0)/2,1) AS rating, ROUND(ROUND(AVG(rating1)*2,0)/2,1) AS rating1, ROUND(ROUND(AVG(rating2)*2,0)/2,1) AS rating2, ROUND(ROUND(AVG(rating3)*2,0)/2,1) AS rating3 FROM ratings WHERE posting_id = 101522 GROUP BY posting_id
time: 0SELECT * FROM global_image WHERE g_id = 3045
time: 0.17SELECT global.*, posting.*, service.*, place.name AS place_name, category.name AS category_name, ROUND(ROUND(AVG(ratings.rating)*2,0)/2,1) AS score, MAX(ratings.date_posted) AS review_date, COUNT(ratings.posting_id) AS reviews FROM global INNER JOIN posting ON posting.id = g_tid INNER JOIN service ON service.posting_id = g_tid INNER JOIN category ON category.id = posting.category_id INNER JOIN place ON place.id = posting.place_id LEFT JOIN ratings ON ratings.posting_id = posting.id WHERE posting.id = '101523' GROUP BY g_id
time: 0SELECT ratings.*,ROUND(ROUND(rating*2,0)/2,1) AS rating, ROUND(ROUND(rating1*2,0)/2,1) AS rating1, ROUND(ROUND(rating2*2,0)/2,1) AS rating2, ROUND(ROUND(rating3*2,0)/2,1) AS rating3, members.member_name, members.myicon_fname FROM ratings INNER JOIN members ON members.id = ratings.member_id WHERE posting_id = 101523
time: 0SELECT ROUND(ROUND(AVG(rating)*2,0)/2,1) AS rating, ROUND(ROUND(AVG(rating1)*2,0)/2,1) AS rating1, ROUND(ROUND(AVG(rating2)*2,0)/2,1) AS rating2, ROUND(ROUND(AVG(rating3)*2,0)/2,1) AS rating3 FROM ratings WHERE posting_id = 101523 GROUP BY posting_id
time: 0SELECT * FROM global_image WHERE g_id = 3046
time: 0.17SELECT global.*, posting.*, service.*, place.name AS place_name, category.name AS category_name, ROUND(ROUND(AVG(ratings.rating)*2,0)/2,1) AS score, MAX(ratings.date_posted) AS review_date, COUNT(ratings.posting_id) AS reviews FROM global INNER JOIN posting ON posting.id = g_tid INNER JOIN service ON service.posting_id = g_tid INNER JOIN category ON category.id = posting.category_id INNER JOIN place ON place.id = posting.place_id LEFT JOIN ratings ON ratings.posting_id = posting.id WHERE posting.id = '101524' GROUP BY g_id
time: 0SELECT ratings.*,ROUND(ROUND(rating*2,0)/2,1) AS rating, ROUND(ROUND(rating1*2,0)/2,1) AS rating1, ROUND(ROUND(rating2*2,0)/2,1) AS rating2, ROUND(ROUND(rating3*2,0)/2,1) AS rating3, members.member_name, members.myicon_fname FROM ratings INNER JOIN members ON members.id = ratings.member_id WHERE posting_id = 101524
time: 0SELECT ROUND(ROUND(AVG(rating)*2,0)/2,1) AS rating, ROUND(ROUND(AVG(rating1)*2,0)/2,1) AS rating1, ROUND(ROUND(AVG(rating2)*2,0)/2,1) AS rating2, ROUND(ROUND(AVG(rating3)*2,0)/2,1) AS rating3 FROM ratings WHERE posting_id = 101524 GROUP BY posting_id
time: 0SELECT * FROM global_image WHERE g_id = 3047
time: 0.17SELECT global.*, posting.*, service.*, place.name AS place_name, category.name AS category_name, ROUND(ROUND(AVG(ratings.rating)*2,0)/2,1) AS score, MAX(ratings.date_posted) AS review_date, COUNT(ratings.posting_id) AS reviews FROM global INNER JOIN posting ON posting.id = g_tid INNER JOIN service ON service.posting_id = g_tid INNER JOIN category ON category.id = posting.category_id INNER JOIN place ON place.id = posting.place_id LEFT JOIN ratings ON ratings.posting_id = posting.id WHERE posting.id = '101525' GROUP BY g_id
time: 0SELECT ratings.*,ROUND(ROUND(rating*2,0)/2,1) AS rating, ROUND(ROUND(rating1*2,0)/2,1) AS rating1, ROUND(ROUND(rating2*2,0)/2,1) AS rating2, ROUND(ROUND(rating3*2,0)/2,1) AS rating3, members.member_name, members.myicon_fname FROM ratings INNER JOIN members ON members.id = ratings.member_id WHERE posting_id = 101525
time: 0SELECT ROUND(ROUND(AVG(rating)*2,0)/2,1) AS rating, ROUND(ROUND(AVG(rating1)*2,0)/2,1) AS rating1, ROUND(ROUND(AVG(rating2)*2,0)/2,1) AS rating2, ROUND(ROUND(AVG(rating3)*2,0)/2,1) AS rating3 FROM ratings WHERE posting_id = 101525 GROUP BY posting_id
time: 0SELECT * FROM global_image WHERE g_id = 3048
time: 0.17SELECT global.*, posting.*, service.*, place.name AS place_name, category.name AS category_name, ROUND(ROUND(AVG(ratings.rating)*2,0)/2,1) AS score, MAX(ratings.date_posted) AS review_date, COUNT(ratings.posting_id) AS reviews FROM global INNER JOIN posting ON posting.id = g_tid INNER JOIN service ON service.posting_id = g_tid INNER JOIN category ON category.id = posting.category_id INNER JOIN place ON place.id = posting.place_id LEFT JOIN ratings ON ratings.posting_id = posting.id WHERE posting.id = '101526' GROUP BY g_id
time: 0SELECT ratings.*,ROUND(ROUND(rating*2,0)/2,1) AS rating, ROUND(ROUND(rating1*2,0)/2,1) AS rating1, ROUND(ROUND(rating2*2,0)/2,1) AS rating2, ROUND(ROUND(rating3*2,0)/2,1) AS rating3, members.member_name, members.myicon_fname FROM ratings INNER JOIN members ON members.id = ratings.member_id WHERE posting_id = 101526
time: 0SELECT ROUND(ROUND(AVG(rating)*2,0)/2,1) AS rating, ROUND(ROUND(AVG(rating1)*2,0)/2,1) AS rating1, ROUND(ROUND(AVG(rating2)*2,0)/2,1) AS rating2, ROUND(ROUND(AVG(rating3)*2,0)/2,1) AS rating3 FROM ratings WHERE posting_id = 101526 GROUP BY posting_id
time: 0SELECT * FROM global_image WHERE g_id = 3049
time: 0.17SELECT global.*, posting.*, service.*, place.name AS place_name, category.name AS category_name, ROUND(ROUND(AVG(ratings.rating)*2,0)/2,1) AS score, MAX(ratings.date_posted) AS review_date, COUNT(ratings.posting_id) AS reviews FROM global INNER JOIN posting ON posting.id = g_tid INNER JOIN service ON service.posting_id = g_tid INNER JOIN category ON category.id = posting.category_id INNER JOIN place ON place.id = posting.place_id LEFT JOIN ratings ON ratings.posting_id = posting.id WHERE posting.id = '101527' GROUP BY g_id
time: 0SELECT ratings.*,ROUND(ROUND(rating*2,0)/2,1) AS rating, ROUND(ROUND(rating1*2,0)/2,1) AS rating1, ROUND(ROUND(rating2*2,0)/2,1) AS rating2, ROUND(ROUND(rating3*2,0)/2,1) AS rating3, members.member_name, members.myicon_fname FROM ratings INNER JOIN members ON members.id = ratings.member_id WHERE posting_id = 101527
time: 0SELECT ROUND(ROUND(AVG(rating)*2,0)/2,1) AS rating, ROUND(ROUND(AVG(rating1)*2,0)/2,1) AS rating1, ROUND(ROUND(AVG(rating2)*2,0)/2,1) AS rating2, ROUND(ROUND(AVG(rating3)*2,0)/2,1) AS rating3 FROM ratings WHERE posting_id = 101527 GROUP BY posting_id
time: 0SELECT * FROM global_image WHERE g_id = 3050
time: 0.17SELECT global.*, posting.*, service.*, place.name AS place_name, category.name AS category_name, ROUND(ROUND(AVG(ratings.rating)*2,0)/2,1) AS score, MAX(ratings.date_posted) AS review_date, COUNT(ratings.posting_id) AS reviews FROM global INNER JOIN posting ON posting.id = g_tid INNER JOIN service ON service.posting_id = g_tid INNER JOIN category ON category.id = posting.category_id INNER JOIN place ON place.id = posting.place_id LEFT JOIN ratings ON ratings.posting_id = posting.id WHERE posting.id = '101528' GROUP BY g_id
time: 0SELECT ratings.*,ROUND(ROUND(rating*2,0)/2,1) AS rating, ROUND(ROUND(rating1*2,0)/2,1) AS rating1, ROUND(ROUND(rating2*2,0)/2,1) AS rating2, ROUND(ROUND(rating3*2,0)/2,1) AS rating3, members.member_name, members.myicon_fname FROM ratings INNER JOIN members ON members.id = ratings.member_id WHERE posting_id = 101528
time: 0SELECT ROUND(ROUND(AVG(rating)*2,0)/2,1) AS rating, ROUND(ROUND(AVG(rating1)*2,0)/2,1) AS rating1, ROUND(ROUND(AVG(rating2)*2,0)/2,1) AS rating2, ROUND(ROUND(AVG(rating3)*2,0)/2,1) AS rating3 FROM ratings WHERE posting_id = 101528 GROUP BY posting_id
time: 0SELECT * FROM global_image WHERE g_id = 3051
time: 0SELECT name FROM category WHERE id = 659