0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0069 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2025-03-31'
AND `url` = 'https://www.maineventtravel.com/destination/articles/dublin-destination-guide/Top-Hotels-Near-the-RDS-Arena-for-the-Irish-Open'
ORDER BY `views` DESC

0.0161 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2025-03-31'
AND `url` = 'https://www.maineventtravel.com/destination/articles/dublin-destination-guide/Top-Hotels-Near-the-RDS-Arena-for-the-Irish-Open'

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.0003 SECONDS: 
SELECT *
FROM `settings`
WHERE `white_label_version_id` = 0

0.0005 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.0042 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.0003 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.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` = 'page'

0.0002 SECONDS: 
SELECT destinations.*, uapi_airports.name as airport_name
FROM `destinations`
LEFT JOIN `uapi_airports` ON `destinations`.`uapi_code` = `uapi_airports`.`airport_code`
WHERE `url` = 'dublin-destination-guide'

0.0015 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` = 'Top-Hotels-Near-the-RDS-Arena-for-the-Irish-Open'

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` = '1084'

0.0039 SECONDS: 
SELECT DISTINCT tour_stops.*, tours.name as tour_name, ((ACOS(SIN(53.3498053 * PI() / 180) * SIN(venues.map_latitude * PI() / 180) + COS(53.3498053 * PI() / 180) * COS(venues.map_latitude * PI() / 180) * COS((-6.2603097 - venues.map_longitude) * PI() / 180)) * 180 / PI()) * 60 * 1.1515) AS distance, venues.name as venue_name, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, tours.logo as tour_logo, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo
FROM `venues`
LEFT JOIN `tour_stops` ON `tour_stops`.`venue_id` = `venues`.`id`
JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
WHERE `tour_stops`.`active` = '1'
AND tour_stops.end_date > CURDATE()
HAVING `distance` <= 10
ORDER BY `tour_stops`.`start_date` ASC

0.0002 SECONDS: 
SELECT `news_articles`.`url_name`, `news_articles`.`main_image`, `news_articles`.`meta_description`, `news_articles`.`title`
FROM `news_article_destinations`
JOIN `news_articles` ON `news_article_destinations`.`news_article_id` = `news_articles`.`id`
WHERE `news_articles`.`active` = 1
AND `destination_id` = 6
ORDER BY `news_article_destinations`.`display_order`
English
  1. Home
  2. Destination Guide - Dublin
  3. Top Hotels Near the RDS Arena for the Irish Open
Monday 24th March, 2025

Top Hotels Near the RDS Arena for the Irish Open

By Antonia Shepherd
Travel Tips News

The Irish Open is one of Europe’s most prestigious poker tournaments, bringing players and fans from across the globe to Dublin’s RDS Arena. If you’re planning to attend, securing the right accommodation is key to a smooth and enjoyable experience. To help with your travel plans, we’ve handpicked five top hotels near the venue—offering comfort, convenience, and great amenities.

And the best part? You can book your stay easily with Main Event Travel—your one-stop shop for poker travel, ensuring you get the best rates and hassle-free reservations.

1. Clayton Hotel Ballsbridge

A 4-star hotel located just minutes from the RDS Arena, Clayton Hotel Ballsbridge is perfect for players who want a mix of elegance and convenience. Housed in a stunning 19th-century building, it offers spacious rooms, a restaurant, and an inviting bar area. Plus, with on-site parking and excellent transport links, getting to and from the venue is effortless.

Book Clayton Hotel Ballsbridge now with Main Event Travel!

2. Herbert Park Hotel & Park Residence

For those seeking a more peaceful retreat, the Herbert Park Hotel is a fantastic option. Overlooking the beautiful Herbert Park and just a three-minute walk from the RDS, this hotel boasts modern rooms, a fitness centre, and an elegant restaurant—ideal for unwinding after an intense poker session.

Secure your stay at Herbert Park Hotel with Main Event Travel!

3. Sandymount Hotel

A family-run 4-star hotel known for its friendly atmosphere and fantastic service. Just ten minutes from the RDS, Sandymount Hotel provides complimentary Wi-Fi, free parking (subject to availability), and a relaxed bar & restaurant. It’s a great choice for poker players looking for a welcoming, comfortable stay close to the action.

Book Sandymount Hotel now through Main Event Travel!

4. Grand Canal Hotel

A mid-range option with a great balance of price and quality, the Grand Canal Hotel offers secure parking, an inviting bar, and comfortable, modern rooms. Some rooms even include balconies—offering a scenic view of Dublin. It's just a short distance from the RDS, making it a convenient choice for Irish Open attendees.

Reserve your room at Grand Canal Hotel with Main Event Travel!

5. InterContinental Dublin

If you're looking for luxury and top-tier service, the InterContinental Dublin is the ultimate five-star experience. With spacious, elegantly designed rooms, a fitness centre, fine dining options, and exceptional service, this is the place to stay if you want to attend the Irish Open in style.

Book the InterContinental Dublin now with Main Event Travel!

Why Book with Main Event Travel?

Main Event Travel offers the best rates and exclusive deals, making it the go-to choice for poker players looking for stress-free travel planning. With a seamless and secure booking process, you can find the perfect accommodation without the hassle. Whether you’re a player or a spectator, booking through Main Event Travel ensures that you’ll be staying at a poker-friendly hotel, conveniently located near the action.

Don’t wait—hotels near the RDS are selling out fast.
Book your hotel now with Main Event Travel and secure your perfect stay for the Irish Open!

What's Hot in Dublin

Irish Poker Open 2025: Europe’s Longest-Running Poker Festival Returns The highly anticipated Irish Poker Open 2025 is set to take place from 10th to 21st April at the Royal Dublin Society (RDS), Dublin. Renowned for its vibrant atmosphere and prestigious history, the event is expected to draw poker enthusiasts from around the globe, all vying for their share of fame and fortune.
Top Hotels Near the RDS Arena for the Irish Open The Irish Open is one of Europe’s most prestigious poker tournaments, bringing players and fans from across the globe to Dublin’s RDS Arena. If you’re planning to attend, securing the right accommodation is key to a smooth and enjoyable experience. To help with your travel plans, we’ve handpicked five top hotels near the venue—offering comfort, convenience, and great amenities.
Sightseeing in Dublin Dublin is an ideal destination for a city break – there is tons to do and your main problem will be how to cram it all in! However, Dublin is a very manageable city and it’s easy to get around on foot, or you can get a day ticket for the hop-on hop-off buses which pass by most of the main attractions.

Events

Travel Search

Travel Search

Search for
Dates
From
To
Flying to Dublin Arpt (DUB)
Departing from
Passengers
Adults
Children
Staying in Dublin
Rooms
Guests
Adults
Children
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.