select [type] from [customtable_price_data] where NodeID='14207' order by january;select [January],[Feburary],[March],[April],[May],[June],[July],[August],[September],[October],[November],[December] from [customtable_price_data] where NodeID='14207' order by january;
*average daily rates based on 7 day rental, search for todays best prices.
Useful things to know about Coleraine
- The name Coleraine means ‘nook of the ferns’.
- It’s found at the lowest bridgeable part of the River Bann.
- The city is 55 miles from Belfast.
- Coleraine has been regularly commended for its cleanliness.
- The first settlement here was on nearby Mount Sandel dating from 8,000 years ago.
Coleraine Mini Guide
Northern Ireland is an Unusual Destination for a Holiday Isn’t it?
Well yes, but it’s becoming increasingly popular with people taking city breaks or longer holidays. The scenery is fantastic, the people friendly and welcoming and the food and drink excellent. The Ulster Tourist Board has tried very hard and successfully to promote the attractions of the area and Coleraine is a great example of a destination with a lot to see and do in its vicinity.
How do I get to Coleraine?
There are two airports that you can fly into - City of Derry and Belfast Airports. City of Derry
is about forty miles away whilst Belfast
is sixty. Many regional carriers from the UK
fly to both airports as well as budget airlines. Once there, you have the choice of two ways of getting to Coleraine. The train goes directly from Belfast to Derry with Coleraine station being on the route. Alternatively you could take the Goldliner bus from Belfast and travel up the World Heritage recognised stunning Antrim Coast to the city. Taxis are also available at the airport but could be costly whilst hire car is a good and cheap alternative.
What Should be on my List of Things to do and see?
There’s so much there you’ll need a week to see and do it all. Hopefully you’ll have arrived there after travelling along the wonderful scenery of the Antrim Coast. From the city, head out to the Giant’s Causeway – one of the UK’s most easily recognised geographical features. Then take a tour of the Bushmills Irish Whiskey Distillery where you’ll be treated to a sample of the golden liquor after an informative journey through the development of the spirit! You should also spend a day at the beautiful coastal resorts of Portrush and Portstewart, Ireland’s leading seaside towns.
Latest Update from Coleraine:
Talks have been held in Coleraine to develop tourism for 2017 in Northern Ireland. An extensive tourism programme has been put together, with the aim of attracting visitors from around the world.
From the 28th of June until the 1st of July, Northern Ireland's premier golfing tournament, the Irish Open, will be staged in Portrush. All the top names from the world of golf will be there contesting a pot worth over £500,000.