0.0003 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

0.0116 SECONDS: 
SELECT *
FROM `page_views`
WHERE `date` = '2026-01-07'
AND `url` = 'https://www.maineventtravel.com/tour/grosvenor-g300'
ORDER BY `views` DESC

0.0158 SECONDS: 
UPDATE `page_views` SET views = views + 1
WHERE `date` = '2026-01-07'
AND `url` = 'https://www.maineventtravel.com/tour/grosvenor-g300'

0.0004 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.0004 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.0004 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.0046 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.0001 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = 'grosvenor-g300'

0.0002 SECONDS: 
SELECT *
FROM `tours`
WHERE `page_url` = 'grosvenor-g300'

0.0002 SECONDS: 
SELECT *
FROM `tours`
WHERE `id` = '196'

0.0019 SECONDS: 
SELECT tour_stops.*, CASE
                        WHEN tour_stops.logo IS NULL or tour_stops.logo = ''
                        THEN tours.logo
                        ELSE tour_stops.logo
                    END AS logo, tours.name as tour_name, tours.logo as tour_logo, venues.name as venue_name, venues.location as venue_location, venues.map_latitude as venue_latitude, venues.map_longitude as venue_longitude, venues.image as venue_image
FROM `tour_stops`
LEFT JOIN `tours` ON `tours`.`id` = `tour_stops`.`tour_id`
LEFT JOIN `venues` ON `venues`.`id` = `tour_stops`.`venue_id`
WHERE tour_stops.end_date > CURDATE()
AND tour_stops.active =  1
AND `tour_id` = '196'
ORDER BY `tour_stops`.`start_date` DESC

0.0147 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 `news_articles`.`active` = '1'
ORDER BY `news_articles`.`date` DESC

0.0012 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.0007 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.0003 SECONDS: 
SELECT *
FROM `banners`
WHERE `banner_locations` LIKE '%individual-tour-stop%'
English
  1. Home
  2. Events
  3. Grosvenor G300

Grosvenor G300


New to 2026: a £260+£40 Buy-in with a £100,000 Guarantee. It's the G300.

The G300 isn’t just about value. Expect a better structure and a first-class poker experience at one of our top cardrooms.

Upcoming Tour Stops

Tuesday 1st - Sunday 6th December, 2026

Round 12 - Luton

Grosvenor Casino Luton, 35 Park Street West, Luton, LU1 3BE

New to 2026: a £260+£40 Buy-in with a £100,000 Guarantee. It's the G300.

The G300 isn’t just about value. Expect a better structure and a first-class poker experience at one of our top cardrooms.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 10th - Sunday 15th November, 2026

Round 11 - Leeds

Grosvenor Casino Leeds Westgate, Wellington Bridge Street, Leeds, LS3 1LW

New to 2026: a £260+£40 Buy-in with a £100,000 Guarantee. It's the G300.

The G300 isn’t just about value. Expect a better structure and a first-class poker experience at one of our top cardrooms.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 20th - Sunday 25th October, 2026

Round 10 - Manchester BNR

Grosvenor Casino Manchester, Bury New Road, 2 Ramsgate Street, Manchester, M8 9SG

New to 2026: a £260+£40 Buy-in with a £100,000 Guarantee. It's the G300.

The G300 isn’t just about value. Expect a better structure and a first-class poker experience at one of our top cardrooms.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 15th - Sunday 20th September, 2026

Round 9 - The Victoria: London

The Poker Room, The Grosvenor Victoria Casino London, 150 Edgware Road, London, W2 2DT

New to 2026: a £260+£40 Buy-in with a £100,000 Guarantee. It's the G300.

The G300 isn’t just about value. Expect a better structure and a first-class poker experience at one of our top cardrooms.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 5th - Sunday 10th May, 2026

Round 8 - The Victoria: London

The Poker Room, The Grosvenor Victoria Casino London, 150 Edgware Road, London, W2 2DT

New to 2026: a £260+£40 Buy-in with a £100,000 Guarantee. It's the G300.

The G300 isn’t just about value. Expect a better structure and a first-class poker experience at one of our top cardrooms.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 28th April - Sunday 3rd May, 2026

Round 7 - Luton

Grosvenor Casino Luton, 35 Park Street West, Luton, LU1 3BE

New to 2026: a £260+£40 Buy-in with a £100,000 Guarantee. It's the G300.

The G300 isn’t just about value. Expect a better structure and a first-class poker experience at one of our top cardrooms.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 21st - Sunday 26th April, 2026

Round 6 - Coventry

Grosvenor Casino Coventry, Coventry Building Society Arena, Phoenix Way, Coventry, CV6 6GE

New to 2026: a £260+£40 Buy-in with a £100,000 Guarantee. It's the G300.

The G300 isn’t just about value. Expect a better structure and a first-class poker experience at one of our top cardrooms.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 24th - Sunday 29th March, 2026

Round 5 - Manchester BNR

Grosvenor Casino Manchester, Bury New Road, 2 Ramsgate Street, Manchester, M8 9SG

New to 2026: a £260+£40 Buy-in with a £100,000 Guarantee. It's the G300.

The G300 isn’t just about value. Expect a better structure and a first-class poker experience at one of our top cardrooms.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 17th - Sunday 22nd March, 2026

Round 4 - Luton

Grosvenor Casino Luton, 35 Park Street West, Luton, LU1 3BE

New to 2026: a £260+£40 Buy-in with a £100,000 Guarantee. It's the G300.

The G300 isn’t just about value. Expect a better structure and a first-class poker experience at one of our top cardrooms.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 10th - Sunday 15th March, 2026

Round 2 - Leeds

Grosvenor Casino Leeds Westgate, Wellington Bridge Street, Leeds, LS3 1LW

New to 2026: a £260+£40 Buy-in with a £100,000 Guarantee. It's the G300.

The G300 isn’t just about value. Expect a better structure and a first-class poker experience at one of our top cardrooms.
    Find Hotels, Flights & More       Full Schedule Coming Soon  
Tuesday 10th - Sunday 15th March, 2026

Round 3 - The Victoria: London

The Poker Room, The Grosvenor Victoria Casino London, 150 Edgware Road, London, W2 2DT

New to 2026: a £260+£40 Buy-in with a £100,000 Guarantee. It's the G300.

The G300 isn’t just about value. Expect a better structure and a first-class poker experience at one of our top cardrooms.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 27th January - Sunday 1st February, 2026

Round 1 - Reading South

Grosvenor Casino Reading South, Rose Kiln Lane, Reading, RG2 0SN

New to 2026: a £260+£40 Buy-in with a £100,000 Guarantee. It's the G300.

The G300 isn’t just about value. Expect a better structure and a first-class poker experience at one of our top cardrooms.
    Find Hotels, Flights & More       View Complete Schedule  
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.