0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0069 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2024-12-22'
AND `url` = 'https://www.maineventtravel.com/news/article/Get-5-Back-WhenYou-Book-Irish-Open-Accommodation-'
ORDER BY `views` DESC

0.0060 SECONDS: 
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/news/article/Get-5-Back-WhenYou-Book-Irish-Open-Accommodation-', 1, '2024-12-22')

0.0003 SECONDS: 
SELECT *
FROM `settings`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `settings`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'

0.0002 SECONDS: 
SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0

0.0003 SECONDS: 
SELECT `tours`.*
FROM `tours`
WHERE `active` = 1
AND `venue` = '0'
AND `festival` = '0'
ORDER BY `order` ASC

0.0003 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'

0.0002 SECONDS: 
SELECT *
FROM `tours`
WHERE `active` = '1'
AND `festival` = '1'
ORDER BY `order` ASC

0.0003 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'tour'

0.0001 SECONDS: 
SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`

0.0004 SECONDS: 
SELECT `pages`.*, `parents`.`url_name` as `parent_url_name`
FROM `pages`
LEFT JOIN `pages` as `parents` ON `parents`.`id` = `pages`.`parent_page_id`
WHERE `pages`.`active` = '1'

0.0002 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'page'

0.0033 SECONDS: 
SELECT `venues`.*, (select COUNT(*) from tour_stops where tour_stops.venue_id=venues.id AND tour_stops.end_date > curdate() AND tour_stops.active = 1) tour_stop_count
FROM `venues`
WHERE `display_in_navigation` = '1'
 LIMIT 30

0.0035 SECONDS: 
SELECT `news_categories`.*, Count(news_article_categories.news_article_id) as article_count, MAX(news_articles.date) as recent_date
FROM `news_categories`
JOIN `news_article_categories` ON `news_article_categories`.`news_category_id` = `news_categories`.`id`
JOIN `news_articles` ON `news_article_categories`.`news_article_id` = `news_articles`.`id`
GROUP BY `news_categories`.`id`

0.0089 SECONDS: 
SELECT `news_articles`.*
FROM `news_articles`
LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id`
WHERE `news_article_categories`.`news_category_id` = '11'
AND `news_articles`.`active` = 1
ORDER BY `date` DESC

0.0006 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'news'

0.0005 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
WHERE `white_label_version_id` = 0
AND `white_label_inclusions`.`entity_type` = 'news'

0.0028 SECONDS: 
SELECT `news_articles`.*
FROM `news_articles`
LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id`
WHERE `news_article_categories`.`news_category_id` = '16'
AND `news_articles`.`active` = 1
ORDER BY `date` DESC

0.0006 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'news'

0.0006 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
WHERE `white_label_version_id` = 0
AND `white_label_inclusions`.`entity_type` = 'news'

0.0030 SECONDS: 
SELECT `news_articles`.*
FROM `news_articles`
LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id`
WHERE `news_article_categories`.`news_category_id` = '18'
AND `news_articles`.`active` = 1
ORDER BY `date` DESC

0.0008 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'news'

0.0005 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
WHERE `white_label_version_id` = 0
AND `white_label_inclusions`.`entity_type` = 'news'

0.0032 SECONDS: 
SELECT `news_articles`.*
FROM `news_articles`
LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id`
WHERE `news_article_categories`.`news_category_id` = '19'
AND `news_articles`.`active` = 1
ORDER BY `date` DESC

0.0006 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'news'

0.0004 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
WHERE `white_label_version_id` = 0
AND `white_label_inclusions`.`entity_type` = 'news'

0.0056 SECONDS: 
SELECT `news_articles`.*
FROM `news_articles`
LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id`
WHERE `news_article_categories`.`news_category_id` = '22'
AND `news_articles`.`active` = 1
ORDER BY `date` DESC

0.0006 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'news'

0.0005 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
WHERE `white_label_version_id` = 0
AND `white_label_inclusions`.`entity_type` = 'news'

0.0033 SECONDS: 
SELECT `news_articles`.*
FROM `news_articles`
LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id`
WHERE `news_article_categories`.`news_category_id` = '23'
AND `news_articles`.`active` = 1
ORDER BY `date` DESC

0.0005 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'news'

0.0005 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
WHERE `white_label_version_id` = 0
AND `white_label_inclusions`.`entity_type` = 'news'

0.0033 SECONDS: 
SELECT `news_articles`.*
FROM `news_articles`
LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id`
WHERE `news_article_categories`.`news_category_id` = '27'
AND `news_articles`.`active` = 1
ORDER BY `date` DESC

0.0005 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'news'

0.0004 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
WHERE `white_label_version_id` = 0
AND `white_label_inclusions`.`entity_type` = 'news'

0.0033 SECONDS: 
SELECT `news_articles`.*
FROM `news_articles`
LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id`
WHERE `news_article_categories`.`news_category_id` = '28'
AND `news_articles`.`active` = 1
ORDER BY `date` DESC

0.0006 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'news'

0.0004 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
WHERE `white_label_version_id` = 0
AND `white_label_inclusions`.`entity_type` = 'news'

0.0027 SECONDS: 
SELECT `news_articles`.*
FROM `news_articles`
LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id`
WHERE `news_article_categories`.`news_category_id` = '29'
AND `news_articles`.`active` = 1
ORDER BY `date` DESC

0.0005 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'news'

0.0005 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
WHERE `white_label_version_id` = 0
AND `white_label_inclusions`.`entity_type` = 'news'

0.0079 SECONDS: 
SELECT `news_articles`.*
FROM `news_articles`
LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id`
WHERE `news_article_categories`.`news_category_id` = '30'
AND `news_articles`.`active` = 1
ORDER BY `date` DESC

0.0007 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'news'

0.0004 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
WHERE `white_label_version_id` = 0
AND `white_label_inclusions`.`entity_type` = 'news'

0.0057 SECONDS: 
SELECT `news_articles`.*
FROM `news_articles`
LEFT JOIN `news_article_categories` ON `news_article_categories`.`news_article_id` = `news_articles`.`id`
WHERE `news_article_categories`.`news_category_id` = '31'
AND `news_articles`.`active` = 1
ORDER BY `date` DESC

0.0006 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'news'

0.0005 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
WHERE `white_label_version_id` = 0
AND `white_label_inclusions`.`entity_type` = 'news'

0.0016 SECONDS: 
SELECT `news_articles`.*, `users`.`full_name` as `author`, `users`.`twitter_name` as `twitter_name`
FROM `news_articles`
LEFT JOIN `users` ON `users`.`id` = `news_articles`.`user_id`
WHERE `url_name` = 'Get-5-Back-WhenYou-Book-Irish-Open-Accommodation-'

0.0009 SECONDS: 
SELECT `news_articles`.*, `users`.`full_name` as `author`, `users`.`twitter_name` as `twitter_name`
FROM `news_articles`
LEFT JOIN `users` ON `users`.`id` = `news_articles`.`user_id`
WHERE `date` <= '2024-12-22'
AND `news_articles`.`active` = '1'
ORDER BY `DATE` DESC, `id` DESC
 LIMIT 5

0.0007 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
JOIN `white_label_versions` ON `white_label_versions`.`id` = `white_label_inclusions`.`white_label_version_id`
WHERE `white_label_versions`.`url` = 'maineventtravel.com'
AND `white_label_inclusions`.`entity_type` = 'news'

0.0006 SECONDS: 
SELECT `white_label_inclusions`.`entity_id`
FROM `white_label_inclusions`
WHERE `white_label_version_id` = 0
AND `white_label_inclusions`.`entity_type` = 'news'

0.0002 SECONDS: 
SELECT `news_categories`.*
FROM `news_article_categories`
LEFT JOIN `news_categories` ON `news_article_categories`.`news_category_id` = `news_categories`.`id`
WHERE `news_article_categories`.`news_article_id` = '968'

0.0001 SECONDS: 
SELECT *
FROM `banners`
WHERE `banner_locations` LIKE '%article%'
English
  1. Home
  2. News & Blogs
  3. Get 5% Back When You Book Irish Open Accommodation
Friday 1st March, 2024

Get 5% Back When You Book Irish Open Accommodation

By Kelly Saxby
Live Events Main Event Travel News

If you're gearing up for the Irish Open this month and still need to secure accommodations, look no further!

Whether you crave proximity to the Dublin party scene, seek respite from bad beat stories off the felt, prefer budget-friendly options, or you never make it to breakfast anyway so there’s no sense paying for it, MET has great offers for you on Hotels near RDS and throughout Dublin!

Visit MET’s Irish open Event page and search using Pay Now Hotels. You’ll find nightly rates that are better than most other online travel agencies AND you can snag a Bonus Travel Credit!

Below are some of the handpicked hotels scattered across Dublin that we recommend you consider. And don’t forget MET’s exclusive added value #FinalTableFreeroll promotion, where you can win back up to 100% of your Tournament travel costs booked with MET!

Butlers Townhouse – 4 Star – 0.45miles from RDS – From €175 per night

Butlers Townhouse is an elegant boutique hotel located in the heart of Ballsbridge. The 20-bedroom Victorian townhouse has been tastefully restored to its former glory. The boutique hotel offers a cozy and intimate atmosphere, featuring individually designed bedrooms giving the guest a unique taste of Victorian life.

Hilton Dublin – 4 Star – 1.22miles from RDS – From €187 per night

Nestled in the heart of Ireland's vibrant capital city, Hilton Dublin stands as a beacon of modern luxury and sophistication. This contemporary hotel seamlessly blends timeless elegance with cutting-edge design, offering a haven for poker travellers. Boasting stylishly appointed rooms and suites, each with stunning views of the city or the Grand Canal, guests are treated to a truly immersive experience. Whether you're getting involved in all the action at the RDS Arena, or simply unwinding in the hotel's leisure facilities after a couple of busy days on the felt, Hilton Dublin promises an unforgettable stay where Irish hospitality meets global excellence.

Marlin Hotel Stephen Green – 4 Star – 1.68miles from RDS – From €180 per night

The contemporary 300–room Marlin Hotel Stephen Green is situated in an unbeatable location. Located overlooking the iconic St. Stephen's Green, the hotel offers a prime location for poker players looking for the excitement of the Irish Poker Open. From cosy rooms to lounge-inspired spaces to work and socialise including their outdoor terrace, the Marlin Hotel offers a perfect place to work, rest and play. 

Clayton Hotel Burlington Road – 4 Star - 0.85miles from RDS – From €153 per night

The hotel is located just a short distance away from the many attractions that this historical city has to offer. The RDS Arena is within walking distance of the hotel or take advantage of the transport links close to the hotel. This wonderful hotel enjoys a charming architectural design, blending effortlessly with its culturally rich surroundings. The guest rooms are beautifully designed, offering a cocoon in which to escape the bustle of the city that lies just outside. The hotel features 2 wonderful restaurants, where delectable dining is just waiting to be enjoyed.

Clayton Hotel Leopardstown – 4 Star – 4miles from RDS - €138 per night

As part of the Clayton Hotels group, this establishment offers modern simplicity with a traditional twist. The spacious and superbly appointed en-suite rooms include satellite TV, a safe, and tea and coffee making facilities, ensuring a blend of modern amenities and traditional hospitality. With the great transport links that Dublin has to offer, it will make travel to and from the excitement of the Irish Poker Open easily accessible!


Clayton Hotel Liffey Valley – 4 Star – 7.38miles from RDS - €134 per night

This charming and elegant hotel is situated in the suburbs of Dublin, with good public transport and road links to the city centre and the RDS Arena. Guest rooms are tastefully appointed and take care of the utmost details. They are individually decorated and exude an elegant and enchanting atmosphere that guarantees poker travellers will enjoy a pleasant stay.

Russell Court – 3 Star – 1.54miles from RDS - €139 per night 

Behind the traditional exterior of the Russell Court Hotel lies a labyrinth of bars, nightclubs, private function rooms, and Dublin’s award-winning best beer garden. The hotel has 40 beautifully styled guest bedrooms and has been able to retain all its stunning Georgian charm whilst incorporating Dublin’s trendiest nightlife experience. The hotel is home to the infamous Dicey’s Garden but also is home to two nightclubs – Krystle Nightclub and the over 30’s Bond! Russell Court Hotel is very much made for guests looking to enjoy all the opportunities of the Irish Poker Open whilst enjoying the bustling nightlife that Dublin has to offer.

Harcourt Hotel – 3 Star – 1.48miles from RDS - €148 per night

Formerly the home of George Bernard Shaw, the hotel is situated off the southwest of St. Stephen’s Green. Located on the lively Harcourt Street, this boutique hotel seamlessly blends historic charm with modern comfort. Harcourt Hotel is not just a place to rest; it's a destination with a lively atmosphere. With a variety of bars, including the renowned DTWO Bar, Garden and Club, the hotel is a hotspot for entertainment, ensuring a memorable nightlife experience. Just steps away from Dublin's cultural landmarks and nightlife attractions, Harcourt Hotel invites any poker travellers to discover the rich tapestry of the city while enjoying the distinctive warmth of Irish hospitality.

Crowne Plaza Dublin Blanchardstown – 4 Star – 8.01miles from RDS - €131 per night

Discover contemporary luxury at Crowne Plaza Dublin Blanchardstown, a sophisticated haven in the heart of Dublin's thriving business and leisure district. This modern hotel seamlessly combines upscale comfort with cutting-edge design, catering to the needs of discerning travelers. Stylishly appointed rooms and suites provide a serene retreat, complemented by state-of-the-art amenities.

Crowne Plaza Dublin Airport - 4 Star – 5.34miles from RDS - €124 per night

Situated close to Dublin International Airport, this hotel is a fantastic option for anyone who is flying into Dublin to be close to the action of the Irish Poker Open. From the hotel, it is only a 15 minute drive into the city centre and to all the excitement on the felt. Overlooking the 85-acre Santry Demesne, the hotel is in the perfect spot away from the hustle and bustle of the city centre, and can enjoy the first glimpses of spring.

Hilton Dublin Airport – 4 Star – 5.61miles from RDS - €144 per night 

Hilton Dublin Airport is a contemporary 4-star hotel just 20 minutes from Dublin city centre with convenient access to Dublin Airport. The hotel offers a relaxing atmosphere for guests to unwind whilst delivering all of the required business facilities for a top-class experience. Choose from a variety of guest rooms, including upgraded deluxe rooms, family rooms, and suites. Large soundproof windows offer plenty of light without any noise and a choice of thoughtful amenities are available, including WiFi access, a work desk, a laptop safe, and a large flat-screen TV. 

 

Pembrooke Townhouse – 4 Star – 0.5miles from RDS - €195 per night

Included in the Michelin Guide and chosen as ‘One of the top 100 places to stay in Ireland’, this boutique townhouse offers a unique blend of historical elegance and contemporary comfort. Individually designed rooms and suites provide a cozy retreat, featuring a harmonious mix of modern amenities and classic decor. Pembrooke Townhouse's central location invites poker travellers to explore Dublin's iconic attractions, cultural landmarks, and vibrant neighborhoods on foot.

 

Grand Canal – 4 Star – 0.81miles from RDS – From €192 per night

Located in the heart of the city centre and next to the Grand Canal, the hotel offers an ideal base for exploring all that Dublin has to offer. Situated close to the RDS arena, it is within walking distance of all the excitement of the Irish poker open. the hotel boasts a prime location to great transport links making it easy to get around the city. The hotel has spacious and modern bedrooms that cater to all needs. 

Book your 4 night+ Hotel stay during Irish Open before midnight on March 5th using Luxon Pay at checkout, and we’ll give you 5% back in future travel credit.

Ts & Cs apply. 

Featured Articles
UK: +44 (0) 1770 280000
US: +1 (702) 500-1333
Browse
News Tours Festivals Venues Offers & Packagess
Useful Links
My Account Terms & Conditions Privacy Policy About Us Enquiry Form
Your search results are valid for . More Info
Travel search results are valid for a period of 20 minutes. If you do not book by this time, items in your cart may change in price or become unavailable.