SELECT h.* ,(case country when 'US' then country else countryname end ) country FROM hotels h , categorytoproperty c WHERE enabled_status=1 and h.original_id = c.HotelID AND c.CategoryID=217 ORDER BY star_rating desc ,name asc LIMIT 0,5
The contemporary architecture of the ARIA tower is complemented by the resort's lavish accommodations. Guestroom corridors streaming with natural light open to areas of enclosed glass, delivering spectacular city or mountain views. Within ARIA's 4,004 Guest Rooms, including 568 suites, panoramic floor-to-ceiling windows offer magnificent views of Las Vegas' striking skyline. ARIA's tower is uniquely designed to deliver corner-window views from every guestroom.
Juicy Details
Amenties
24 Hour Front Desk
24 Hour Security
A-V Equipment Rental
Air Conditioned/Climate Control
ATM/Bank on Property
Barber/Hair Stylist
Bath: Bathtub
Bath: Jacuzzi/Whirlpool in Bathroom
Bath: Separate Bathtub and Shower
Bedding: Fine Linens
Bedrooms: 1 Bedroom
Beds: 2 King Beds
Beds: 2 Queen Beds
Beds: Rooms with King Beds
Beds: Rooms with Two Beds
Blackout Drapes/Curtains
Bus/RV Parking
Business Center
Cable/Satellite TV
Car Rental
Casino
Complimentary Breakfast
Computer Use Available
Concierge Services
Cribs Available
Currency Exchange
Desk
Elevators
Fitness Center
Game Room
Golf Course on Property
Hairdryer
Hot Tub/Jacuzzi:Outdoor (Shared/On Property)
In Room Movies
Internet: Available
Internet: Broadband Access in Guest Rooms
Internet: Free Wireless
Internet: High Speed Outlet in Room
Internet: Is Free
Internet: WiFi in the Guest Rooms
Iron/Ironing Board
Jogging Track
Maid Service
Meeting Facilities
Mini Bar
News Stand
Non-Smoking Room
Photocopy Service
Pool
Pool - Outdoor
Restaurant On Property
Rollaway Beds Available
Room Service (24 Hours)
Room Service (Limited)
Safe Deposit Box
Safe in Room (Laptop Fits)
Safe: In-Room Safe
Sauna on Property
Separate Sitting Area
Slippers
Smoke Alarm in Rooms
Sprinkler in Rooms
Telephone in Room
Turndown Service
Uniformed Security on Site
View: Rooms with City Views
Wake-up Service
Located in the heart of the exciting Las Vegas strip, the Bellagio overlooks a Mediterranean-blue lake where fountains perform an aquatic ballet choreographed to music and lights. Award-winning restaurants, gallery of fine art, exquisite gardens, shopping promenade, casino, and Cirque du Soleil? s breathtaking performance of "O" are designed to delight the senses. The Bellagio Gallery of Fine Art is open and no closures are schedule through April of 2010.
Juicy Tidbits Travel + Leisure says..."Mid-Strip extravaganza with a palatial 55,000-square-foot spa, 14 restaurants, botanical gardens, and dancing fountains." -From Travel + LeisureConde Nast Traveler says..."Expect giant choreographed fountains out front, and a conservatory and gardens filled with "beautiful colorful flower arrangements inside this Strip resort. Guest rooms are "warm and up-to-date with contemporary furnishings, Italian-marble bathrooms, and "a feeling of openness." More than a dozen dining options include Jasmine's, serving Cantonese, Szechwan, and Hunan. "Staff are attentive to every needafrom bellhop to room service." A night at the Petrossian Bar includes music from a Steinway grand and views of the casino from the velvet couches. " -From Conde Nast Traveler
Juicy Details
Amenties
24 Hour Front Desk
24 Hour Security
A-V Equipment Rental
Air Conditioned/Climate Control
ATM/Bank on Property
Barber/Hair Stylist
Bathrooms: 2 Bathrooms
Bedding: Down Comforter
Bedding: Fine Linens
Bedrooms: 1 Bedroom
Beds: 2 Queen Beds
Beds: Rooms with King Beds
Beds: Rooms with Two Beds
Blackout Drapes/Curtains
Business Center
Cable/Satellite TV
Car Rental
Casino
Complimentary Breakfast
Computer Use Available
Concierge Services
Currency Exchange
Desk
Dining Area in the Room
Elevators
Fitness Center
Game Room
Golf Course on Property
Hairdryer
Hot Tub/Jacuzzi:Outdoor (Shared/On Property)
In Room Movies
Internet: Available
Internet: Broadband Access in Guest Rooms
Internet: WiFi in the Guest Rooms
Iron/Ironing Board
Kitchen: Coffee Maker
Kitchen: Refrigerator
Maid Service
Meeting Facilities
Mini Bar
News Stand
Non-Smoking Room
Photocopy Service
Pool
Restaurant On Property
Rollaway Beds Available
Room Service (24 Hours)
Room Service (Limited)
Safe Deposit Box
Safe in Room (Laptop Fits)
Safe: In-Room Safe
Sauna on Property
Smoke Alarm in Rooms
Sprinkler in Rooms
Telephone in Room
Turndown Service
View: Rooms with Lake View
View: Rooms wtih Water Views
Views: Rooms with Panoramic Views
Wake-up Service
Activities
Casino
Hotel Types/Categories
Best Spa Hotels
Conde Nast Traveler Gold List Hotels
Conde Nast Traveler Top Spas
Hotels with Cool Pools
Las Vegas
Travel and Leisure Top 500 Hotels
Upon arriving at this spectacular all-suite five-diamond resort it is clear you are in for an unmatched experience. Faithful replications of the Doges Palace-the Bridge of Sighs-the Campanile Tower-St Marks Square and gondola rides down the Grand Canal transport you to the glory of Venice. Suites start at 650 square feet nearly twice the size of a typical Las Vegas hotel room with easy access to The Grand Canal Shoppes an opulent casino featuring table games and slots a five-acre pool deck. Shows including Blue Man Group- Phantom - the Las Vegas Spectacular and Wayne Brady and menus by world-famous chefs Emeril Lagasse-Wolfgang Puck- David Burke-Thomas Keller and Mario Batali. A 15 dollar daily resort fee gives entry to the famed Canyon Ranch SpaClub a newspaper Internet access and unlimited local calls from your suite. The Palazzo is steps away and offers guests more amenities and features to enjoy.
Juicy Tidbits Travel + Leisure says..."The most painstakingly detailed of the themed casino resorts, the Venetian is a condensed version of its namesake city and features some of the largest rooms on the Strip, averaging 700 square feet with sunken living rooms and marble baths. Like Wynn and Caesars nearby, the Venetian is in full expansion mode, with a new 50-floor, 3,068-room sister property that opened in January 2008. Rooms in the all-suite 3,014-room main tower (which opened in 1999) have traded their gilded, faux-Venetian dAcor for a more modern style (backlit onyx walls, clean-lined, natural-hued couches and chairs, remote-controlled Roman shades), and each now has three LCD or plasma televisions (including one TV in the bath), wireless Internet, and a sectional sofa for guests. And just outside, of course, is a Piazza San Marco entrance (just like the real thing, minus the pigeons), in- and outdoor canals plied by gondoliers, and reproductions of famous frescoes on the soaring ceilings within." -From Travel + Leisure
Juicy Details
Amenties
24 Hour Front Desk
24 Hour Security
A-V Equipment Rental
Air Conditioned/Climate Control
ATM/Bank on Property
Barber/Hair Stylist
Bath: Bathtub
Bath: Jacuzzi/Whirlpool in Bathroom
Beds: 2 Queen Beds
Beds: Rooms with King Beds
Beds: Rooms with Two Beds
Beds: Sofa Bed in Room
Bus/RV Parking
Business Center
Cable/Satellite TV
Car Rental
Casino
Concierge Services
Desk
Elevators
Fax Machine Available For Guests
Fitness Center
Hairdryer
Hot Tub/Jacuzzi:Outdoor (Shared/On Property)
In Room Movies
Internet: Available
Internet: Broadband Access in Guest Rooms
Iron/Ironing Board
Kids Programs/Club
Kitchen: Coffee Maker
Maid Service
Meeting Facilities
Mini Bar
News Stand
Non-Smoking Room
Pool - Outdoor
Private Deck/Patio/Terrace
Restaurant On Property
Room Service (24 Hours)
Safe: In-Room Safe
Separate Sitting Area
Sprinkler in Rooms
Telephone in Room
Turndown Service
Wake-up Service
Wheelchair Friendly Public Areas
Imagine a resort designed to ensure that everything you need is always closer than you think. Where every room inspires you with views of cascading waterfalls or an 18-hole championship golf course. And where every detail invites you to relax in an exclusive sanctuary right in the middle of the most exciting city on earth. Encore, the new signature resort in the Wynn collection, will be unveiled in early 2009. Encore complements Wynn Las Vegas repertoire of accommodations, culinary offerings and leisure activities.
Juicy Tidbits Travel + Leisure says..."With a casino floor flooded with natural light, a botanical theme, and a collection of restaurants with rising celebrity chefs like Alex Stratta and David Walzog, Wynn Las Vegas has single-handedly redefined the standard of luxury in the Las Vegas casino hotel. Elements borrowed from the natural worldaincluding a 140-foot forested mountain and wall of waterahave been manufactured to sequester the hotel away from the Strip and conceal the spaceship-shaped Fashion Show Mall across the street. The smallest rooms are a capacious 620 square feet; the six enormous villas scattered along the golf course and the pool top out at 7,000 square feet. If guests grow tired of their private pool cabana, there's always the Louis Vuitton, Manolo Blahnik, Cartier, and Chanel boutiques in the shopping esplanade." -From Travel + LeisureConde Nast Traveler says..."This black-and-gold tower with floral motifs has an 18-hole course jointly designed by owner Steve Wynn and golf legend Tom Fazio. Rooms bring the outdoors indoors through wall-to-wall windows that enable "eye-popping views of the Strip." Fifteen restaurantsatwo right off the casino floorarange from a classic steakhouse (Country Club) to Japanese (Okada)." -From Conde Nast Traveler
Juicy Details
Amenties
24 Hour Front Desk
24 Hour Security
A-V Equipment Rental
Air Conditioned/Climate Control
Balcony
Barber/Hair Stylist
Bath: Bathtub
Bath: Separate Bathtub and Shower
Bedding: Fine Linens
Beds: Rooms with King Beds
Beds: Rooms with Two Beds
Beds: Sofa Bed in Room
Blackout Drapes/Curtains
Boutique Shops
Bus/RV Parking
Business Center
Cable/Satellite TV
Car Rental
Casino
Complimentary Newspaper
Cribs Available
Desk
Elevators
Fax Machine Available For Guests
Fireplace to Enjoy
Fitness Center
Gift Shop
Golf Course on Property
Hairdryer
Hot Tub/Jacuzzi:Outdoor (Shared/On Property)
In Room Movies
Internet: Available
Iron/Ironing Board
Kitchen: Coffee Maker
Kitchen: Full Kitchen in the Unit
Kitchen: Kitchenette
Kitchen: Refrigerator
Laundry Room Available
Laundry/ Dry Cleaning Service
Maid Service
Meeting Facilities
Microwave
Mini Bar
News Stand
Non-Smoking Room
Pool
Pool - Outdoor
Restaurant On Property
Rollaway Beds Available
Room Service (24 Hours)
Room Service (Limited)
Safe Deposit Box
Safe: In-Room Safe
Smoke Alarm in Rooms
Sprinkler in Rooms
Telephone in Room
Turndown Service
VCR/VCP
Views: Rooms with Panoramic Views
Wake-up Service
Wheelchair Friendly Public Areas
Activities
Casino
Hotel Types/Categories
Best Budget Friendly Hotels
Best Spa Hotels
Conde Nast Traveler Top Spas
Las Vegas
Travel and Leisure It List
Travel and Leisure Top 500 Hotels
Caesars Palace glitters at the heart of the Las Vegas Strip. Rome in a resort/casino that has become synonymous with luxury and excitement. Caesars Palace you will know you have arrived at the most prestigious resort in the world. Impeccable service. Luxury. details that make the difference between an ordinary visit and a spectacular experience are yours. evoking the decadence of ancient Rome where impeccable service reigns supreme luxury beckons at every turn. 2008 Bette Midler will take the stage at the Colosseum. Guests will enjoy the finest in accommodations dining and shopping. Caesars Palace is home to the Garden of the Gods a 4. 5-acre pool complex and world class Qua Spa. extraordinary collection of exquisite stores and restaurants and family entertainment set in an ancient Roman marketplace.
Juicy Details
Amenties
24 Hour Front Desk
Air Conditioned/Climate Control
Babysitting or Child Care
Barber/Hair Stylist
Bath: Bathtub
Bath: Jacuzzi/Whirlpool in Bathroom
Bath: Separate Bathtub and Shower
Bath: Walk in Shower
Beds: 2 Queen Beds
Beds: Rooms with King Beds
Beds: Rooms with Two Beds
Blackout Drapes/Curtains
Business Center
Casino
Concierge Services
Fitness Center
Hairdryer
Internet: Available
iPod Docking Station
Kitchen: Coffee Maker
Laundry Room Available
Non-Smoking Room
Pool
Restaurant On Property
Safe Deposit Box
Safe in Room (Laptop Fits)
Safe: In-Room Safe
Separate Sitting Area
Telephone in Room
Wheelchair Accessible Rooms