0.0004 SECONDS: 
SHOW TABLES FROM `maineven_met-base`

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

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

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.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.0002 SECONDS: 
SELECT `id`, `name`, `url`
FROM `destinations`
WHERE `active` = 1
ORDER BY `display_order`

0.0047 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.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.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-g200'

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

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

0.0015 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` = '195'
ORDER BY `tour_stops`.`start_date` DESC

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

Grosvenor G200


New to 2026: a £175+£25 Buy-in with a £50,000 Guarantee.

Get even more value with the G200 in 2026. Heading to at least 13 venues nationwide, check the schedule and find one near you.

Upcoming Tour Stops

Tuesday 1st - Sunday 6th December, 2026

Round 15 - Sheffield

Grosvenor Casino Sheffield, 87 Duchess Road, Sheffield, S2 4BG

New to 2026: a £175+£25 Buy-in with a £50,000 Guarantee.

Get even more value with the G200 in 2026. Heading to at least 13 venues nationwide, check the schedule and find one near you.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 1st - Sunday 6th December, 2026

Round 15 - Glasgow MC

Grosvenor Casino Glasgow, Merchant City, 16/18 Glassford Street, Glasgow, G1 1UL

New to 2026: a £175+£25 Buy-in with a £50,000 Guarantee.

Get even more value with the G200 in 2026. Heading to at least 13 venues nationwide, check the schedule and find one near you.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 10th - Sunday 15th November, 2026

Round 14 - Bolton

Grosvenor Casino Bolton, Ormrod Street, Bolton, BL3 5DJ

New to 2026: a £175+£25 Buy-in with a £50,000 Guarantee.

Get even more value with the G200 in 2026. Heading to at least 13 venues nationwide, check the schedule and find one near you.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 10th - Sunday 15th November, 2026

Round 14 - Edinburgh

Grosvenor Casino Edinburgh, 1 - 5 South Maybury, Edinburgh, EH12 8NE

New to 2026: a £175+£25 Buy-in with a £50,000 Guarantee.

Get even more value with the G200 in 2026. Heading to at least 13 venues nationwide, check the schedule and find one near you.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 20th - Sunday 25th October, 2026

Round 13 - Newcastle

Grosvenor Casino Newcastle, 100 St James Boulevard, Newcastle Upon Tyne, NE1 4BN

New to 2026: a £175+£25 Buy-in with a £50,000 Guarantee.

Get even more value with the G200 in 2026. Heading to at least 13 venues nationwide, check the schedule and find one near you.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 20th - Sunday 25th October, 2026

Round 13 - Portsmouth

Grosvenor Casino Portsmouth, Gunwharf Quays, Portsmouth, PO1 3TZ

New to 2026: a £175+£25 Buy-in with a £50,000 Guarantee.

Get even more value with the G200 in 2026. Heading to at least 13 venues nationwide, check the schedule and find one near you.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 15th - Sunday 20th September, 2026

Round 12 - Birmingham Hill St

Grosvenor Casino Birmingham, 84 Hill Street, Birmingham, B5 4AH

New to 2026: a £175+£25 Buy-in with a £50,000 Guarantee.

Get even more value with the G200 in 2026. Heading to at least 13 venues nationwide, check the schedule and find one near you.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 15th - Sunday 20th September, 2026

Round 12 - Stockton

Grosvenor Casino Stockton, 4 Chandlers Wharf, Stockton-on-Tees, TS18 3BA

New to 2026: a £175+£25 Buy-in with a £50,000 Guarantee.

Get even more value with the G200 in 2026. Heading to at least 13 venues nationwide, check the schedule and find one near you.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 14th - Sunday 19th July, 2026

Round 11 - Newcastle

Grosvenor Casino Newcastle, 100 St James Boulevard, Newcastle Upon Tyne, NE1 4BN

New to 2026: a £175+£25 Buy-in with a £50,000 Guarantee.

Get even more value with the G200 in 2026. Heading to at least 13 venues nationwide, check the schedule and find one near you.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 14th - Sunday 19th July, 2026

Round 11 - Blackpool

Grosvenor Casino Blackpool, The Sandcastle, Promenade, Blackpool, FY4 1BB

New to 2026: a £175+£25 Buy-in with a £50,000 Guarantee.

Get even more value with the G200 in 2026. Heading to at least 13 venues nationwide, check the schedule and find one near you.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 14th - Sunday 19th July, 2026

Round 11 - Walsall

Grosvenor Casino Walsall, Bentley Mill Way, Walsall, West Midlands WS2 0LE

New to 2026: a £175+£25 Buy-in with a £50,000 Guarantee.

Get even more value with the G200 in 2026. Heading to at least 13 venues nationwide, check the schedule and find one near you.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 26th May - Monday 1st June, 2026

Round 10 - Bolton

Grosvenor Casino Bolton, Ormrod Street, Bolton, BL3 5DJ

New to 2026: a £175+£25 Buy-in with a £50,000 Guarantee.

Get even more value with the G200 in 2026. Heading to at least 13 venues nationwide, check the schedule and find one near you.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 26th May - Monday 1st June, 2026

Round 10 - Reading South

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

New to 2026: a £175+£25 Buy-in with a £50,000 Guarantee.

Get even more value with the G200 in 2026. Heading to at least 13 venues nationwide, check the schedule and find one near you.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 26th May - Monday 1st June, 2026

Round 10 - Walsall

Grosvenor Casino Walsall, Bentley Mill Way, Walsall, West Midlands WS2 0LE

New to 2026: a £175+£25 Buy-in with a £50,000 Guarantee.

Get even more value with the G200 in 2026. Heading to at least 13 venues nationwide, check the schedule and find one near you.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 5th - Sunday 10th May, 2026

Round 9 - Glasgow MC

Grosvenor Casino Glasgow, Merchant City, 16/18 Glassford Street, Glasgow, G1 1UL

New to 2026: a £175+£25 Buy-in with a £50,000 Guarantee.

Get even more value with the G200 in 2026. Heading to at least 13 venues nationwide, check the schedule and find one near you.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 28th April - Sunday 3rd May, 2026

Round 8 - Edinburgh

Grosvenor Casino Edinburgh, 1 - 5 South Maybury, Edinburgh, EH12 8NE

New to 2026: a £175+£25 Buy-in with a £50,000 Guarantee.

Get even more value with the G200 in 2026. Heading to at least 13 venues nationwide, check the schedule and find one near you.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 21st - Sunday 26th April, 2026

Round 7 - Bolton

Grosvenor Casino Bolton, Ormrod Street, Bolton, BL3 5DJ

New to 2026: a £175+£25 Buy-in with a £50,000 Guarantee.

Get even more value with the G200 in 2026. Heading to at least 13 venues nationwide, check the schedule and find one near you.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 21st - Sunday 26th April, 2026

Round 7 - Stockton

Grosvenor Casino Stockton, 4 Chandlers Wharf, Stockton-on-Tees, TS18 3BA

New to 2026: a £175+£25 Buy-in with a £50,000 Guarantee.

Get even more value with the G200 in 2026. Heading to at least 13 venues nationwide, check the schedule and find one near you.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 17th - Sunday 22nd March, 2026

Round 5 - Sheffield

Grosvenor Casino Sheffield, 87 Duchess Road, Sheffield, S2 4BG

New to 2026: a £175+£25 Buy-in with a £50,000 Guarantee.

Get even more value with the G200 in 2026. Heading to at least 13 venues nationwide, check the schedule and find one near you.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 17th - Sunday 22nd March, 2026

Round 5 - Blackpool

Grosvenor Casino Blackpool, The Sandcastle, Promenade, Blackpool, FY4 1BB

New to 2026: a £175+£25 Buy-in with a £50,000 Guarantee.

Get even more value with the G200 in 2026. Heading to at least 13 venues nationwide, check the schedule and find one near you.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 17th - Sunday 22nd March, 2026

Round 5 - Coventry

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

New to 2026: a £175+£25 Buy-in with a £50,000 Guarantee.

Get even more value with the G200 in 2026. Heading to at least 13 venues nationwide, check the schedule and find one near you.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 10th - Sunday 15th March, 2026

Round 4 - Portsmouth

Grosvenor Casino Portsmouth, Gunwharf Quays, Portsmouth, PO1 3TZ

New to 2026: a £175+£25 Buy-in with a £50,000 Guarantee.

Get even more value with the G200 in 2026. Heading to at least 13 venues nationwide, check the schedule and find one near you.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 10th - Sunday 15th March, 2026

Round 4 - Birmingham Hill St

Grosvenor Casino Birmingham, 84 Hill Street, Birmingham, B5 4AH

New to 2026: a £175+£25 Buy-in with a £50,000 Guarantee.

Get even more value with the G200 in 2026. Heading to at least 13 venues nationwide, check the schedule and find one near you.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 17th - Sunday 22nd February, 2026

Round 3 - Edinburgh

Grosvenor Casino Edinburgh, 1 - 5 South Maybury, Edinburgh, EH12 8NE

New to 2026: a £175+£25 Buy-in with a £50,000 Guarantee.

Get even more value with the G200 in 2026. Heading to at least 13 venues nationwide, check the schedule and find one near you.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 17th - Sunday 22nd February, 2026

Round 3 - Bolton

Grosvenor Casino Bolton, Ormrod Street, Bolton, BL3 5DJ

New to 2026: a £175+£25 Buy-in with a £50,000 Guarantee.

Get even more value with the G200 in 2026. Heading to at least 13 venues nationwide, check the schedule and find one near you.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 27th January - Sunday 1st February, 2026

Round 2 - Newcastle

Grosvenor Casino Newcastle, 100 St James Boulevard, Newcastle Upon Tyne, NE1 4BN

New to 2026: a £175+£25 Buy-in with a £50,000 Guarantee.

Get even more value with the G200 in 2026. Heading to at least 13 venues nationwide, check the schedule and find one near you.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 27th January - Sunday 1st February, 2026

Round 2 - Blackpool

Grosvenor Casino Blackpool, The Sandcastle, Promenade, Blackpool, FY4 1BB

New to 2026: a £175+£25 Buy-in with a £50,000 Guarantee.

Get even more value with the G200 in 2026. Heading to at least 13 venues nationwide, check the schedule and find one near you.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 20th - Sunday 25th January, 2026

Round 1 - Leeds

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

New to 2026: a £175+£25 Buy-in with a £50,000 Guarantee.

Get even more value with the G200 in 2026. Heading to at least 13 venues nationwide, check the schedule and find one near you.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 20th - Sunday 25th January, 2026

Round 1 - Walsall

Grosvenor Casino Walsall, Bentley Mill Way, Walsall, West Midlands WS2 0LE

New to 2026: a £175+£25 Buy-in with a £50,000 Guarantee.

Get even more value with the G200 in 2026. Heading to at least 13 venues nationwide, check the schedule and find one near you.
    Find Hotels, Flights & More       View Complete Schedule  
Tuesday 20th - Sunday 25th January, 2026

Round 1 - Glasgow MC

Grosvenor Casino Glasgow, Merchant City, 16/18 Glassford Street, Glasgow, G1 1UL

New to 2026: a £175+£25 Buy-in with a £50,000 Guarantee.

Get even more value with the G200 in 2026. Heading to at least 13 venues nationwide, check the schedule and find one near you.
    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.