0.0003 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0096 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-11-21' AND `url` = 'https://www.maineventtravel.com/news/article/The-Lowdown-on-Vegas-Hotels' ORDER BY `views` DESC

0.0112 SECONDS:
UPDATE `page_views` SET views = views + 1 WHERE `date` = '2024-11-21' AND `url` = 'https://www.maineventtravel.com/news/article/The-Lowdown-on-Vegas-Hotels'

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.0004 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.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.0037 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.0037 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.0087 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.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.0042 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.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.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.0040 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.0010 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.0046 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.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.0008 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.0070 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.0046 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.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.0040 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.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.0041 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.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.0034 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.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.0070 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.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.0050 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.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.0018 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` = 'The-Lowdown-on-Vegas-Hotels'

0.0006 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-11-21' AND `news_articles`.`active` = '1' ORDER BY `DATE` DESC, `id` DESC LIMIT 5

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.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` = '827'

0.0001 SECONDS:
SELECT * FROM `banners` WHERE `banner_locations` LIKE '%article%'

English
Wednesday 24th May, 2023

The Lowdown on Vegas Hotels!

By Mad Harper

It’s said that there are more hotel rooms in Las Vegas than in any other city in the world –130,000 and counting – so you’ll be spoilt for choice when you head to Sin City. On our travel booking pages for Las Vegas, you can check out a vast range of hotels from super-budget options like the Strat and Rio right up to the ultra-modern luxury of ARIA or the tranquil elegance of the Four Seasons. Our hotel search function is super-useful for Vegas, giving you the ability to search by price or location.

NEAR THE VENUE

If you want to stay near the WSOP’s new home on the Strip at the Horseshoe Casino (pictured above), then obviously staying AT the Horseshoe property itself is the way to go! MainEventTravel.com has rooms here from £1,652 for ten nights July 4-14. That’ll see you through from Day 1b of the Main Event down to the final nine players AND give you the shortest walk to the tables.

Other nearby properties include Paris Las Vegas, the Cromwell Hotel and Casino, the Flamingo, Planet Hollywood and Caesars. The Linq Hotel, Bellagio, Harrah’s and Aria are all also a relatively easy walk from the Horseshoe ie less than half a mile. Check out our competitive rates on our Vegas Travel Pages.

LUXURY HOTELS

Aria

ARIA (pictured below) is one of the best hotels in Vegas and a comfortable walk from the Horseshoe. This luxury resort on the Strip showcases breath-taking panoramic views from every room. The hotel, which won awards for its environmental design and has a five-star rating from Forbes Travel Guide, features two curvilinear glass towers rising up to 50 storeys, and has more than 4,000 rooms and suites. Bringing the concept of an ultra-modern skyscraper to Las Vegas, this is a beautiful contemporary resort with modern architecture, a unique design and floor-to-ceiling windows in every room. The rooms are high-tech with plush furnishings and a range of amenities including keyless locks, automated heating, light, music and curtains. Rooms are non-smoking, with a $500 cleaning fee for Standard Rooms if you flaunt the rules.

Four Seasons

Located adjacent to Mandalay Resort & Casino, the Four Seasons (pictured below) is one of the only non-gaming and non-smoking hotels on the Las Vegas Strip. That makes it a tranquil oasis when you want a break from the ubiquitous clatter of casino slot machines. With a Forbes Five-Star Spa and secluded quiet pool with guest-only private cabanas, this is a deluxe option for your Vegas trip. The rooms are enormous and the signature marble bathrooms are totally luxurious. We also recommend Veranda, the inside-outside Italian restaurant that’s actually one of the best places in Vegas for a power breakfast.

Nobu Hotel at Caesars Palace

The world's first-ever Nobu Hotel (pictured below) is a delight ... a boutique hotel with a distinct air of quiet luxury. Situated on the Las Vegas Strip, the hotel features an outdoor swimming pool, spa and sauna, casino and restaurant. The Japanese-inspired rooms have free Wi-Fi, 55-inch flat-screen TV, iPod docking station and Natura Bisse toiletries in the en suite bathroom. Crafted by Robert DeNiro and Chef Nobu, the property has a number of high-end shops on site. Pamper options include in-room massage along with various treatments in the spa. Nobu Hotel emanates style and sophistication – no wonder it was named Best Boutique Hotel by Vegas Seven.

MID-RANGE HOTEL OPTIONS

The Mirage

The Mirage (pictured below) is a gorgeous property in a prime location on the Strip. Now owned and operated by the Hard Rock chain, this elegant hotel is a tropical refuge in the centre of Las Vegas. It is famed for its Polynesian-themed décor, unique dolphin and wild animal habitat, gorgeous pools, spa and full-service casino. The rooms are stylish and spacious with modern furnishings including a 42-inch flat-screen cable TV, Bluetooth speakers, USB sockets and free high-speed internet. The pools at the Mirage are fantastic, with large, natural-form pools, waterfalls, a private oasis, and a 21+ top-optional pool called Bare. There’s a large variety of dining options, including fine dining at Tom Colicchio Heritage Steak and the Osteria Costa Restaurant. One of the hotel’s main attractions is a replica lava-flowing volcano which erupts nightly – on the hour, every hour – providing free entertainment right in front of the resort.

New York New York

Boasting a 150-foot replica of the Statue of Liberty and an adrenaline-pumping roller coaster, New York New York (pictured below) is close to all the action on the Strip and an exhilarating place to stay for your Vegas trip. There’s a state-of-the-art casino, seasonal outdoor pool with private cabanas, live entertainment such as the adults-only “Zumanity” Cirque de Soleil show and numerous restaurants – including a buffet steakhouse, piano bar and an Irish pub. The Nine Fine Irishman is an authentic hostelry which was built in Ireland and then shipped to the resort. The spacious, modern rooms come equipped with a flat-screen cable TV, granite bathrooms and a work desk.

 Luxor

This Ancient-Egypt-themed resort is a real landmark on the Las Vegas Strip. The black glass and steel, 30-storey pyramid-shaped building is around 75% of the scale of the Great Pyramid of Giza and is one of the most iconic sights in Sin City. At night, the Sky Beam shines out from the tip of the pyramid with a light so powerful it’s allegedly visible from aircraft flying out of Los Angeles. Inside, the giant Sphinx is even taller than its antique counterpart in Egypt. Luxor (pictured below) is located right on the Strip and features a huge casino along with live entertainment, a full-service spa, four large pools and the largest atrium in the world. The comfortable rooms have multiple charging and power outlets, sitting areas and safes. The Nurture Spa and Salon offers an assortment of beauty treatments and 24-hour fitness centre. A steam bath, dry sauna and hot tubs are available at the spa. The 120,000 square feet casino has a poker room along with sportsbook betting area with plasma TVs.

 BUDGET OPTIONS

 The Strat 

Marked out by its distinctive 1,149-foot SkyPod and only 15 minutes from Harry Reid International Airport, the STRAT (pictured below) is a great option if you’re on a budget and has a ton of amenities that will give you the full Vegas hotel experience including two swimming pools (the 15,000 square foot, resort-style Elation Pool and the Wet24 Adult Pool & Bar), multiple dining options, a fitness centre and an 80,000 square foot casino where there is live DJ entertainment every night. The modern rooms include a flat-screen cable TV with pay-per-view channels with seating area, work desk and free toiletries in the ensuite bathrooms. The SkyPod, with its Observation Decks, thrill rides and even a chapel for sky-high weddings, and Top of the World restaurant, is a destination in itself.

Rio All-Suite Hotel and Casino 

The former home of the WSOP is another great budget option located close to the Strip (pictured below). With 2,522 air-conditioned rooms, there’s also a full-service spa and salon, four outdoor swimming pools, six restaurants, 10,000 square metre casino and – of course – a gargantuan conference centre. Each spacious suite at the Rio offers panoramic views along with mini-bar and an in-suite safe with separate dressing area.

The Golden Gate Hotel

The Golden Gate Hotel (pictured below) is located downtown and is the oldest hotel in Vegas with a history dating back to 1906. Staying here puts you at the heart of the Fremont Street Experience and is a short stroll from any number of downtown restaurants, bars and clubs. There’s no poker room at the Golden Gate but the large casino has no shortage of gaming options including blackjack, craps, roulette and slots. The rooms are modern, blending traditional style with amenities such as 32-inch flat-screen TV, computer ports and free toiletries in the ensuite bathrooms. While there is no pool or gym on site, guests are free to use facilities at the Golden Gate’s sister hotel – the D – located just five minutes’ walk away. 

Photo Credit: Las Vegas

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.