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

Places to stay in Alberta - Motels

Best Western Harvest Country Inn
Listed in Cochrane

Discover this Cochrane hotel offering cozy accommodations and personalized service all nestled among the Alberta Rocky Mountains. Whether traveling for business or pleasure, the BEST WESTERN Harvest Country Inn has it all! Nestled in the foothills of Alberta's Rocky Mountains, this hotel features .....

(+001) 403-932-1410

Wingate by Wyndham
Listed in Calgary

Recipient Of The 2012 Trip Advisor Certificate of Excellence Award Calgary is a beautiful and vibrant city located on the banks of the Bow River and close to the majestic Canadian Rockies. The Wingate by Wyndham Calgary Hotel offers both leisure and business ready accommodations. We are .....

(+001) 403-514-0099

Holiday Inn Express ( Airport )
Listed in Nisku

Our Holiday Inn Express & Suites, Nisku Hotel Location is the Best near Edmonton Airport Looking for Edmonton Airport hotels? Look no further than the Holiday Inn Express Hotel Edmonton International Airport, located in Nisku. Complimentary Shuttle Service to and from the Edmonton International .....

(+001) 780-955-1000

Lakeview Inns & Suites East
Listed in Edson

Casual, warm and friendly - Lakeview Inn and Suites Edson East offers travelers the perfect blend of comfort and convenience. Our well-trained dedicated team delivers professional, genuinely friendly service to keep guests coming back time and again. Start your morning off right with a free .....

(+001) 780-723-2500

Bear Mountain Motel
Listed in Waterton Park

You're coming to Waterton Lakes National Park! A magnificent country awaits you. We at the Bear Mountain Motel look forward to welcoming you and helping to make your visit all that it can be. The Bear Mountain Motel, offers simple, clean, affordable motel accommodation within the Park. From single .....

(+001) 403-859-2366

Centro Motel
Listed in Calgary

Centro Motel is a boutique Calgary motel offering rooms that are clean, close and connected. Located on the TransCanada highway, Centro is conveniently placed nearby many amenities and attractions, including the Foothills and Childrens Hospitals, the University of Calgary, McMahon Stadium, .....

(+001) 403-288-6658

Super 8
Listed in St. Paul

(+001) 780-645-5581

Super 8
Listed in Red Deer

Whether your travels are overnight or extended stay, we at the Super 8 Red Deer pride ourselves on friendly customer service - comfortable accommodations and reasonable rates. Complimentary amenities include High Speed Wireless Internet - Continental Breakfast - Parking - Local Calls and Casino .....

(+001) 403-343-1102

Super 8
Listed in Cochrane

Pool, hot tub and waterslide will be closed from April 4 to 30, 2011 for scheduled repairs The Super 8 Cochrane/Calgary West is nestled between Calgary and Banff on Highway 22, folks can enjoy the comfort country living without the hassle of big city traffic. Just 20 minutes from Calgary and 45 .....

(+001) 403-932-6355

Super 8
Listed in High River

(+001) 403-652-4448

Charlton's Cedar Court Resort
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

Mountaineer Lodge
Listed in Lake Louise

Are you having difficulty finding a good value in hotel accommodation for your visit to Banff National Park and the Canadian Rockies? The Mountaineer Lodge, open from May through mid-October each year, is one of the best and most affordable places to stay in the Lake Louise area of Canada's Rocky .....

(+001) 403-522-3844

Super 8
Listed in Leduc

Welcome to the Award Winning Edmonton Airport Super 8. This conveniently located Super 8 is just minutes away from the Edmonton International Airport, restaurants, and shopping. We offer shuttle service to and from the airport with advance notice needed in the morning. All rooms offer free high .....

(+001) 780-986-8898

Sahara Motor Inn & Suites
Listed in High Level

If you're looking for value, nothing in High Level will compare to the Econo Lodge Inn & Suites. The Econo Lodge Inn & Suites are ideal for families and for long term stays. Rates at the Econo Lodge Inn & Suites include a free continental breakfast in our Oasis Social Room, gym facilities, guest .....

(+001) 780-841-0234

Frontier Motor Inn
Listed in High Level

A timeless property unique from any other in High Level. A favorite for those who appreciate a quiet cozy atmosphere with a little Western flare. the large country style bar hosts 17 video lottery terminals and is High Levels Hot Spot for those trying their luck. Billiards, darts, table tennis, big .....

(+001) 780-926-5005

Super 8
Listed in Vermilion

Welcome to the Super 8 Vermilion. We are conveniently located off highway 41 near restaurants, shopping , and area attractions. We offer an on site Pool/Waterslide/Hot tub and fitness room. All rooms offer high speed internet, in room coffee, microwave, fridge, and hair dryers. In the morning we .....

(+001) 780-853-4741

Super 8
Listed in Athabasca

Come and join our satisfied customers and enjoy a stay in one of our 48 Superior Rooms. Which we offer a variety from traditional to Executive Suites, and our ever popular Jacuzzi Suites. Children under 17 stay free . Our meeting room is the perfect place to gather. Fax and copy services are .....

(+001) 780-675-8888

Lakeview Inns & Suites
Listed in Hinton

Lakeview Inn and Suites Hinton is located on the east end of Hinton and 45 minutes from the town of Jasper. Hinton is the gateway to the Canadian Rockies and we offer our visitors a unique blend of urban amenities and lots of charm! We welcome both the corporate and leisure travelers. When .....

(+001) 780-865-2575

Econo Lodge
Listed in Calgary

Spacious renovated rooms and beautifully appointed suites all in a convenient location. At Econo Lodge Motel Village, you will spend a night (not a fortune) Only steps to Calgary, Foothills Hospital, McMahon stadium, LRT station, restaurants and shopping. Minutes from downtown, the Red Mile, .....

(+001) 403-289-2561

Service Plus Inns & Suites
Listed in Drayton Valley

All rooms in our facility offer queen or king size beds 27 inch LCD tvs in room coffee fridge microwaves hairdryers bath robes iron and ironing boards business desk high speed wireless internet free local calls complimentary movie channels and an extensive continental breakfast available to all .....

(+001) 780-542-4348

Ramada Limited
Listed in Calgary

Ramada Limited Calgary is centrally located in Calgary motel village close to downtown, University of Calgary, SAIT - Southern Alberta Institute of Technology and the Jubilee Auditorium. This Ramada hotel is close to the many area health facilities including Foothills Hospital, Alberta Childrens .....

(+001) 403-289-5571

Super 8
Listed in Fort Saskatchewan

The Super 8 Fort Saskatchewan is located on highway 21 in Fort Saskatchewan. The Super 8 Fort Saskatchewan is located adjacent to the Dow Centennial Centre and minutes away from shopping and restaurants. Other attractions include Fort Saskatchewan Golf and Curling Club, Fox Run Golf Club, Elk .....

(+001) 780-998-2898

Comfort Inn
Listed in Red Deer

Comfort Inn and Suites Red Deer offers exceptional value, friendly service and spacious, comfortable accommodations. All guests enjoy FREE high speed Internet access, daily deluxe continental breakfast, morning coffee and a weekday newspaper. For fun, frolic and fitness, our hotel includes an .....

(+001) 403-348-0025

Parkland Motel I
Listed in Lac La Biche

Located on the east end of Lac La Biche, the Parkland I is a few minutes walk from downtown, and across the street from the curling rink, Jubilee Hall, baseball diamonds and the Lac La Biche ice arena. A short 5 minute drive brings you to Sir Winston Churchill Provincial Park, the Lac La Biche Golf .....

(+001) 780-623-4424

Western Budget Motel
Listed in Whitecourt

Executive room Fully equipped kitchen units in selected rooms Air conditioning Superchannel Plug-in for the colder winters Coffee in rooms Handicap rooms available Fireplaces in every room Jacuzzi in selected rooms Guest coin laundry Internet access/private phone .....

(+001) 780-706-2030

Red Coat Inn Motel
Listed in Fort Macleod

The Red Coat Inn Motel offers comfortable motel accommodations for your family, group or personal needs. Our parking lot has lots of room for oversized vehicles. The indoor swimming pool, sauna and hottub give hours of fun and relaxation for the whole family both winter and summer. We have .....

(+001) 403-553-4434

Days Inn
Listed in Red Deer

Chairmans Award Property Awarded the Certificate of Excellence by Trip Advisor Indoor Pool with Waterslide Complimentary Daybreak Deluxe Continental Breakfast Brand new hotel in 2005 Free high speed internet in all rooms Fridges, Microwave and coffeemakers in all rooms Secured-Access corporate .....

(+001) 403-340-3297

Taber Motel
Listed in Taber

Taber Motel offers its customers the best service and accommodation, along with warm and friendly atmosphere. Here at TABER MOTEL we look forward to making you feel at home, whether you are on a family vacation or a business trip. We offer comfortable rooms that are equipped with high speed .....

(+001) 403-223-4411

Super 8 ( West )
Listed in Edmonton

Welcome to Edmonton! Conveniently located in West Edmonton, Easily accessible from Yellowhead Trail (Hwy 16) or from Calgary Trail North (Hwy 2) to the Whitemud Freeway and North on 170th Street. The Super 8 is also located 5 minutes to West Edmonton Mall which has entertainment and shopping .....

(+001) 780-455-1111

Bow Valley Motel
Listed in Canmore

The Bow Valley Motel is scenically situated away from the highway and railway tracks in the town proper. Come across the creek bridge when you turn down Main (8th) Street. It is a short 20 minute drive west to Banff town site, 50 minutes to Lake Louise, 2 and a half hours to the Athabasca Glacier .....

(+001) 403-678-5085