0.0005 SECONDS:
SHOW TABLES FROM `maineven_met-base`

0.0111 SECONDS:
SELECT * FROM `page_views` WHERE `date` = '2024-04-19' AND `url` = 'https://www.maineventtravel.com/destination/articles/las-vegas-guide/day-trips-from-Vegas' ORDER BY `views` DESC

0.0013 SECONDS:
INSERT INTO `page_views` (`url`, `views`, `date`) VALUES ('https://www.maineventtravel.com/destination/articles/las-vegas-guide/day-trips-from-Vegas', 1, '2024-04-19')

0.0006 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.0009 SECONDS:
SELECT `tours`.* FROM `tours` WHERE `active` = 1 AND `venue` = '0' AND `festival` = '0' ORDER BY `order` ASC

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

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

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

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

0.0121 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.0015 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.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` = 'page'

0.0004 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` = 'las-vegas-guide'

0.0036 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` = 'day-trips-from-Vegas'

0.0003 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` = '521'

0.0072 SECONDS:
SELECT DISTINCT tour_stops.*, tours.name as tour_name, ((ACOS(SIN(36.11532281210326 * PI() / 180) * SIN(venues.map_latitude * PI() / 180) + COS(36.11532281210326 * PI() / 180) * COS(venues.map_latitude * PI() / 180) * COS((-115.17587848916014 - 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.0004 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` = 2 ORDER BY `news_article_destinations`.`display_order`

English
Monday 1st January, 2024

Beyond the Strip – day trips from Vegas

By Mad Harper

With so much to do in Las Vegas itself, it can be hard to find time to explore beyond the city’s borders. However, even if you only have an afternoon spare, it’s well worth renting a car and heading out of town. Las Vegas is surrounded by stunning scenery and places like Lake Mead, Hoover Dam and Red Rock Canyon are within easy driving distance.

Red Rock Canyon

More and more poker players are discovering Red Rock Canyon, a stunning national park only 25 miles from the Strip. You can rent a car or arrange a shuttle trip with local tour operators. The Red Rock scenic loop is 13 miles long and there are more than 10 easy hikes around the amazing natural rock formations. You can even gamble on your way there or back - at Red Rock Casino.

Grand Canyon

Measuring approximately 277 miles long, up to 18 miles wide and a mile deep, the Grand Canyon has been six million years in the making and is definitely one of the most spectacular sights on earth. Although visiting the Grand Canyon by car would make for a very long day trip (it’s about 2.5 hours to the West Rim and five hours to the South Rim) there are dozens of tour operators in Vegas offering helicopter rides which take about four hours door-to-door from your hotel. Longer trips include stops at Lake Mead and Hoover Dam as well, along with boat trips down the Colorado River.

Lake Mead 

Lake Mead is one of the biggest man-made lakes in the world, and lies about 30-45 minutes’ drive from the Strip. It’s a perfect place to chill out after a hard few days at the poker tables, with a ton of activities on offer including swimming, boating, fishing, jet skiing and hiking. With 820 miles of shoreline, there are plenty of beach areas for lounging around and picnicking.  Lake Mead became a National Recreation Area back when the Hoover Dam was created and although it has been subject to drought in recent years, it is now making a recovery and is a fabulous place to visit.

Hoover Dam 

Hoover Dam is located in Black Canyon, just 30-40 minutes outside of Las Vegas and you can easily combine a trip to Lake Mead with a visit to this National Historic Landmark. The enormous, 726 feet high curved wall is an amazing feat of engineering which took five years to build – from 1931 to 1936. It was the largest dam of its kind at the time and is still the highest concrete dam in the Western Hemisphere.

Valley of Fire

Valley of Fire is about an hour northeast of the Strip and Nevada’s oldest and largest state park. This epic landscape is world-renowned – for its 40,000 acres of bright red Aztec sandstone outcrops, ancient, petrified trees and petroglyphs dating back more than 2,000 years. The trip there and back is spectacular, taking you through the heart of the Nevada desert.

Clark County Wetlands Park

Clark County Wetlands Park spans 2,900 acres on the eastern edge of the Las Vegas Valley, just a half hour drive from the Strip. With a 210-acre Nature Preserve and five trailheads, the Park is a gorgeous wildlife habitat that’s open daily during daylight hours. 



What's Hot in Las Vegas


Events

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.