select * from tour_full where site_id = 123 and (flag&1)>0 and class = 3 and type=32 order by length(COALESCE(alt_details,''))* length(COALESCE(photo,'') ) desc,type=7 asc, length(COALESCE(alt_details,'')) desc Showcasing the best Hotels in Alberta

Places to stay in Alberta - Hotels

The Fairmont Banff Springs
Listed in Banff

The Fairmont Banff Springs- Canada*s *Castle in the Rockies* - is located on the banks of the scenic Bow and Spray Rivers. Cradled by the surrounding majestic Rocky Mountains- in the heart of Banff National Park.

(+001) 403-762-2211

Best Western Grande Prairie Hotel & Suites
Listed in Grande Prairie

Choose this pet-friendly Grand Prairie, Alberta hotel located close to the Evergreen Park-Stampede, Grand Prairie Regional College and a variety of local shopping. Welcome to the BEST WESTERN Grand Prairie Hotel & Suites, a full-service hotel located in the heart of Grand Prairie, Alberta. This .....

(+001) 780-402-2378

The Fairmont Chateau Lake Louise
Listed in Lake Louise

Located in the heart of pristine Banff National Park- and within a UNESCO World Heritage Site- The Fairmont Chateau Lake Louise is recognized globally for progressive environmental stewardship and responsible tourism- values at the heart of this historic resort. The journey to this treasured .....

(+001) 403-522-3511

Best Western Denham Inn & Suites
Listed in Leduc

This deluxe, full-service hotel in Leduc, Alberta offers special extras including free internet and a free shuttle to Edmonton International Airport (YEG). The BEST WESTERN PLUS Denham Inn & Suites takes great pride in offering attentive customer care to every guest traveling for business or .....

(+001) 780-986-2241

Best Western Regency Inn
Listed in Airdrie

Discover this 100% non-smoking full-service Airdrie, Alberta hotel offering guests comfortable accommodations convenient to Calgary International Airport, Airdrie Pro Rodeo and Banff. Whether traveling for business or for pleasure, the BEST WESTERN Regency Inn has everything to make each stay a .....

(+001) 403-948-3838

Charlton's Cedar Court
Listed in Banff

Charltons Cedar Court has undergone extensive renovations We invite you to check out our new look in the same great location in downtown Banff close to the shopping and entertainment district The atmosphere is casual and comfortable a great place for families to unwind after a busy day of mountain .....

(+001) 403-762-4485

Best Western Wayside Inn
Listed in Wetaskiwin

The BEST WESTERN Wayside Inn is conveniently located on Wetaskiwin's Auto Mile. We are just one kilometer east of the Reynolds Alberta Museum and Canada's Aviation Hall of Fame. Enjoy challenging golf at one of two scenic golf courses just three kilometers north. In the city center revisit the past .....

(+001) 780-352-6681

Hampton Inn
Listed in Fort Saskatchewan

The Hampton Inn By Hilton Fort Saskatchewan is ideally located for travelers to the Edmonton suburb of For Saskatchewan. Fort Saskatchewan represents one of the leading centres for the Petro-Chemical industry in Canada. It is only 30 minutes away from the City of Edmonton and 30 minutes away from .....

(+001) 780-997-1001

Ramada Inn
Listed in Red Deer

Red Deer is the nerve center of Alberta parkland, and the fastest growing region in Canada. Calling Ramada Red Deer Hotel and Suites home puts you within seconds of highway QE2 and Highway 11 corridors leading to Canada National Parks and ski resorts. Located at the intersection of these two major .....

(+001) 403-342-4445

The Fairmont Jasper Park Lodge
Listed in Jasper

Nestled in between captivating mountains and enchanting lakes- The Fairmont Jasper Park Lodge welcomes you to the Grand Rocky Mountain Lodge Experience. Situated in the magnificent Canadian Rockies in a UNESCO World Heritage Site- The Fairmont Jasper Park Lodge resort invites you to experience the .....

(+001) 780-852-3301

Merit Hotel
Listed in Fort Mcmurray

Merit Hotel and Suites (formally Holiday Inn), Fort McMurray's full service hotel and your choice for business or pleasure travel. The Hotel is conveniently located downtown close to shopping, tourist attractions and the business sector. Following Highway 63 north, exit right onto King Street. The .....

(+001) 780-714-9444

Best Western Cold Lake Inn
Listed in Cold Lake

(+001) 780-594-4888

Nuvo Hotel Suites
Listed in Calgary

Nuvo Hotel Suites offers the utmost luxury in furnished and executive suites in downtown Calgary Alberta. Located in downtown Calgary the hotel is within convenient distance to many diverse entertainment and business options available in Calgary. The furnished suites offer a trendy yet classic .....

(+001) 403-453-8375

Best Western Freeport Inn & Suites
Listed in Calgary

Discover all there is to see and do in Calgary from the comfort of this stylish BEST WESTERN hotel near the Calgary Airport, Calgary Stampede and more! Located three kilometers from the Calgary International Airport, the BEST WESTERN PREMIER Freeport Inn & Suites makes it easy to experience all .....

(+001) 623-780-6877

North Edmonton Inn and Suites
Listed in Edmonton

North Edmonton Inn Suites is a 100pct non-smoking property. We offer convenient access to Rexall Palace- Northlands Park- Commonwealth Stadium- a variety of shopping centers and is walking distance to the LRT subway station. North Edmonton Inn Suites is situated off of Manning Freeway- the gateway .....

(+001) 780-476-9898

Days Inn
Listed in Calgary

The Days Inn - Calgary South, located just south of Downtown Calgary on Macleod Trail welcomes you to Calgary! The Days Inn hotel is convenient to Stampede Park, home of the Calgary Stampede, BMO Centre, Stampede Corral, Boyce Theatre, Big Four Building, Rotary House and Ag Building. The Days Inn .....

(+001) 403-243-5531

Hampton Edmonton/South
Listed in Edmonton

Welcome to the Hampton Inn by Hilton South Edmonton. Located off Hwy 2 and just minutes from Edmonton International Airport and the Edmonton South Commons Shopping dining and entertainment the hotel has something to offer to all visitors. West Edmonton Mall Canada*s largest shopping centre is a .....

(+001) 780-485-2849

Hotel Arts
Listed in Calgary

Luxury, comfort and chic design come together in this understated, yet elegant boutique hotel. Calgary¿s Hotel Arts promises the ultimate in luxury without pretense. Located in the core of Calgary, Hotel Arts is the perfect balance of urban style and chic elegance. Opened in the summer of 2005, .....

(+001) 403-266-4611

Best Western Port O'Call Hotel
Listed in Calgary

The BEST WESTERN PLUS Port O'Call Hotel is located in the heart of the Calgary business district and features a brand new water park, convention facilities and room service. Business travelers will appreciate the BEST WESTERN PLUS Port O'Call Hotel's close proximity to the area's business district .....

(+001) 403-291-4600

Four Points by Sheraton ( Airport )
Listed in Calgary

A Great Location. Welcome to the Four Points by Sheraton Calgary Airport. Were centrally located between Calgary International Airport (YYC) and vibrant downtown Calgary. The Saddledome, Calgary Tower, Calgary Zoo, and other popular city attractions are just minutes from our front door. Plus, the .....

(+001) 403-202-4405

Quality Inn
Listed in Whitecourt

Scenic river front location. Downtown shopping 1km. Excellent fishing, hunting, cross-country skiing, snowmobiling. 24 hour restaurant, fine dining. Renovated rooms 12-96.

(+001) 780-778-5477

Red Deer Lodge Hotel and Conference Center
Listed in Red Deer


(+001) 403-346-8841

Best Western Siding 29 Lodge
Listed in Banff

In the fall of 1883, work gangs of the Canadian Pacific Railway quickly pushed the rail line westward through the valley of the Bow River, establishing among others, a small work camp, "Siding 29". In time, Siding 29 unfolded to the town of "Banff", in Canada's first National Park. Situated at .....

(+001) 403-762-5575

Ramada Inn
Listed in Lloydminster

Ramada Lloydminster hotel is the 2011 recipient of the Canada Select Best Housekeeping Award. The hotel is conveniently located on Highway 16 halfway between Saskatoon, SK and Edmonton, AB and is close to shopping, business, exhibition, recreation, and industrial areas. The finest hospitality in .....

(+001) 780-871-6940

Waterton Lakes Lodge
Listed in Waterton Park

The splendour of Waterton's natural beauty extends into the design of the lodges 80 environmentally themed guest rooms in the cozy comfort of a country-style Inn.The full service, seasonal resort offers beautifully decorated and comfortable rooms, kitchenettes and 17 deluxe suites with fireplaces .....

(+001) 403-859-2150

The Fairmont Hotel Macdonald
Listed in Edmonton

The Historic, Fairmont Hotel Macdonald is Edmontons only Four Diamond-rated luxury hotel. The Chateau on the River distinctive guestrooms are well-appointed with state-of-the-art amenities. The elegant meeting rooms offer the perfect venue for large or small groups. Stroll through the splendid .....

(+001) 780-424-5181

Resort at Canmore Banff
Listed in Canmore

Banff National Park is approximately 7.5 miles from your resort, and world-famous Lake Louise is a little over an hour away. Canmore gained notoriety during the 1988 Winter Olympic Games, and it has been booming ever since as a recreational hot spot. The Resort at Canmore-Banff is well appointed .....

(+001) 403-678-6788

Hilton Garden Inn Calgary Airport
Listed in Calgary

POOL AND HOT TUB CLOSED JUNE 10 - JULY 1 Discover a restful stay in a comfortable Guest Room or upgrade to a spacious Suite with a separate living area offering a pull-out sofa bed and two LCD TVs. Enjoy a choice of facilities for your convenience and support including a refrigerator. Stay .....

(+001) 403-717-1999

International Hotel
Listed in Calgary

The International Hotel Calgary is a full service hotel centrally located downtown in the heart of Calgarys Business district with easy access to transit – shopping – attractions – fine restaurants and lounges. With 35 floors of the largest suites in Calgary – ranging from 559 to 850 .....

(+001) 403-265-9600

Stonebridge Hotel Grande Prairie
Listed in Grande Prairie

Welcome to the Stonebridge Hotel Grande Prairie. Our long standing experience in hotel accommodations has labelled our hotel a true Grande Prairie landmark. The Stonebridge Hotel sits proudly nestled in the heart of the Grande Prairie. With business; shopping; a casino and government offices .....

(+001) 780-539-5561