Database Overview
58
Total Tables
Online
Connection Status
canaccom
Database Name
Available Tables
backup_restore_log
block_booking_emails
block_booking_files
block_booking_hotels
block_booking_rooms
block_bookings
booking_commissions
booking_communications
booking_documents
booking_emails
booking_files
booking_hotel_additional_costs
booking_hotel_amenities
booking_hotel_room_quantities
booking_hotel_room_types
booking_hotel_taxes
booking_hotels
booking_reminder_settings
booking_rooms
bookings
bookings_backup_2025_11_07_19_36_10
clients
communication_attachments
communication_templates
contact_change_history
contact_change_requests
contact_validation_rules
email_templates
event_facilities
event_files
events
file_storage_config
hotel_confirmations
hotel_images
hotels
invoice_emails
invoice_items
invoices
organizations
quote_request_emails
quote_request_hotels
quote_requests
room_guests
rooming_card_access_tokens
rooming_card_audit_log
rooming_cards
rooming_list_requests
stay_confirmation_files
stay_confirmation_rooms
survey_questions
survey_response_answers
survey_responses
survey_sends
surveys
team_card_profiles
team_emails
teams
users
Table: hotels
605 rowsStructure
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int | NO | PRI | NULL | auto_increment |
| google_place_id | varchar(255) | YES | MUL | NULL | |
| name | varchar(100) | NO | MUL | NULL | |
| description | text | YES | NULL | ||
| address | text | NO | NULL | ||
| city | varchar(50) | NO | MUL | NULL | |
| country | varchar(50) | NO | MUL | NULL | |
| province | varchar(50) | YES | NULL | ||
| postal_code | varchar(20) | YES | NULL | ||
| contact_name_1 | varchar(100) | YES | NULL | ||
| contact_email_1 | varchar(100) | YES | MUL | NULL | |
| contact_phone_1 | varchar(20) | YES | NULL | ||
| contact_name_2 | varchar(100) | YES | NULL | ||
| contact_email_2 | varchar(100) | YES | NULL | ||
| contact_phone_2 | varchar(20) | YES | NULL | ||
| contact_name_3 | varchar(100) | YES | NULL | ||
| contact_email_3 | varchar(100) | YES | NULL | ||
| contact_phone_3 | varchar(20) | YES | NULL | ||
| phone | varchar(20) | YES | NULL | ||
| varchar(100) | YES | NULL | |||
| website | varchar(255) | YES | NULL | ||
| check_in_time | time | YES | 16:00:00 | ||
| check_out_time | time | YES | 12:00:00 | ||
| stars | tinyint | NO | MUL | 3 | |
| hotel_class | varchar(50) | YES | MUL | Mid-Range | |
| status | enum('active','inactive','maintenance') | NO | MUL | active | |
| commission_rate | decimal(5,2) | YES | 10.00 | ||
| payment_terms | varchar(100) | YES | NULL | ||
| contract_requirements | text | YES | NULL | ||
| latitude | decimal(10,8) | YES | MUL | NULL | |
| longitude | decimal(11,8) | YES | NULL | ||
| airport_distance | decimal(5,2) | YES | NULL | ||
| airport_name | varchar(100) | YES | NULL | ||
| total_rooms | int | YES | NULL | ||
| meeting_rooms | int | YES | 0 | ||
| restaurant_count | int | YES | 0 | ||
| parking_spaces | int | YES | NULL | ||
| amenities | json | YES | NULL | ||
| nearby_attractions | json | YES | NULL | ||
| hotel_facilities | json | YES | NULL | ||
| property_highlights | json | YES | NULL | ||
| breakfast_included | tinyint(1) | YES | MUL | 0 | |
| pets_allowed | tinyint(1) | NO | 0 | ||
| cots | tinyint(1) | NO | 0 | ||
| equipment_storage | tinyint(1) | NO | 0 | ||
| meeting_room | tinyint(1) | NO | 0 | ||
| pets_fee | decimal(10,2) | YES | NULL | ||
| cots_fee | decimal(10,2) | YES | NULL | ||
| equipment_storage_fee | decimal(10,2) | YES | NULL | ||
| meeting_room_fee | decimal(10,2) | YES | NULL | ||
| gst | tinyint(1) | NO | 0 | ||
| tourism_levy | tinyint(1) | NO | 0 | ||
| prt | tinyint(1) | NO | 0 | ||
| dmf | tinyint(1) | NO | 0 | ||
| gst_percentage | decimal(5,2) | YES | NULL | ||
| tourism_levy_percentage | decimal(5,2) | YES | NULL | ||
| prt_percentage | decimal(5,2) | YES | NULL | ||
| dmf_percentage | decimal(5,2) | YES | NULL | ||
| logo_url | varchar(255) | YES | NULL | ||
| featured_image_url | varchar(255) | YES | NULL | ||
| cancellation_policy | text | YES | NULL | ||
| created_at | timestamp | YES | CURRENT_TIMESTAMP | DEFAULT_GENERATED | |
| updated_at | timestamp | YES | CURRENT_TIMESTAMP | DEFAULT_GENERATED on update CURRENT_TIMESTAMP | |
| created_by | int | YES | NULL | ||
| notes | text | YES | NULL | ||
| canaccom_rank | int | YES | MUL | NULL | |
| internal_info | text | YES | NULL | ||
| contact_job_title_1 | varchar(255) | YES | NULL | ||
| contact_job_title_2 | varchar(255) | YES | NULL | ||
| contact_job_title_3 | varchar(255) | YES | NULL |
Sample Data (First 20 rows)
| id | google_place_id | name | description | address | city | country | province | postal_code | contact_name_1 | contact_email_1 | contact_phone_1 | contact_name_2 | contact_email_2 | contact_phone_2 | contact_name_3 | contact_email_3 | contact_phone_3 | phone | website | check_in_time | check_out_time | stars | hotel_class | status | commission_rate | payment_terms | contract_requirements | latitude | longitude | airport_distance | airport_name | total_rooms | meeting_rooms | restaurant_count | parking_spaces | amenities | nearby_attractions | hotel_facilities | property_highlights | breakfast_included | pets_allowed | cots | equipment_storage | meeting_room | pets_fee | cots_fee | equipment_storage_fee | meeting_room_fee | gst | tourism_levy | prt | dmf | gst_percentage | tourism_levy_percentage | prt_percentage | dmf_percentage | logo_url | featured_image_url | cancellation_policy | created_at | updated_at | created_by | notes | canaccom_rank | internal_info | contact_job_title_1 | contact_job_title_2 | contact_job_title_3 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19 | NULL | Holiday Inn & Suites Red Deer South by IHG | This modern lodging is 3.2 km from Sunnybrook Farm Museum and 5.2 km from Heritage Ranch. The straightforward rooms come with desks, flat-screen TVs and kitchenettes. There's also free WiFi and high-pressure showerheads in the bathrooms, and kids 19 and under stay free with an adult. Suites add separate living spaces; some provide a separate in-room kids' area with bunk beds, while others feature whirlpool tubs and fireplaces. Amenities include an on-site upscale restaurant and lounge (where kids 12 and under eat free), indoor pool with a waterslide and a whirlpool. There's also a sauna and exercise room, as well as free parking. | 33 Petrolia Drive, Gasoline Alley, Red Deer County, AB T4E 1B3, Canada | Red Deer | Canada | AB | T4E 1B3 | (403) 348-8485 | https://www.ihg.com/holidayinn/hotels/us/en/red-deer/yrdws/hoteldetail?cm_mmc=GoogleMaps-_-HI-_-CA-_-YRDWS | 16:00:00 | 11:00:00 | 5 | Luxury | inactive | 10.00 | NULL | NULL | 52.21374580 | -113.81169890 | NULL | NULL | NULL | 0 | 0 | NULL | ["Air conditioning", "Coffee maker", "Microwave", "Smoke-free property", "Bathtub", "Private bathroom", "Bar", "Bar / lounge", "Breakfast (extra charge)", "On-site restaurant", "Restaurant", "Room service", "Elliptical machine", "Fitness center (free)", "Free weights", "Treadmill", "Hot tub", "Indoor pool", "Water slide", "24-hour front desk", "Currency exchange", "Elevator", "Full-service laundry", "Housekeeping (daily)", "Wake-up calls", "Business center", "Free Wi-Fi", "Meeting rooms", "Parking (free)", "Activities for kids", "Kid friendly", "Accessible", "Accessible parking"] | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2025-07-30 21:12:38 | 2025-08-02 20:17:21 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | ||||||||||
| 22 | ChIJUdNSA4QtE1MRqhWamtDxq7w | Holiday Inn Express & Suites Medicine Hat Transcanada Hwy 1 by IHG | Off of Trans-Canada Highway 1, this contemporary lodging is a 13-minute walk from the Casino by Vanshaw and 6.7 km from the Esplanade Arts & Heritage Centre. The straightforward rooms come with desks and flat-screen TVs, plus minifridges, microwaves and coffeemakers; some have kitchenettes. There's also free WiFi and high-pressure showerheads in the bathrooms, while kids 19 and under stay free with an adult. Some suites add separate living spaces; others have whirlpool tubs and/or fireplaces. Family suites provide Xboxes. Amenities include a free breakfast bar, an indoor pool with a waterslide, a whirlpool and an exercise room, plus parking. | 9 Strachan Bay SE, Medicine Hat, AB T1B 4Y2, Canada | Medicine Hat | Canada | AB | T1B 3Z4 | (403) 504-5151 | https://www.ihg.com/holidayinnexpress/hotels/us/en/medicine-hat/yxhsr/hoteldetail?cm_mmc=GoogleMaps-_-EX-_-CA-_-YXHSR | 15:00:00 | 11:00:00 | 4 | Upscale | active | 10.00 | NULL | NULL | 49.99803800 | -110.64255250 | NULL | NULL | NULL | 0 | 0 | NULL | ["Smoke-free property", "Breakfast (free)", "Breakfast buffet", "Restaurant", "Vending machines", "Elliptical machine", "Fitness center (free)", "Free weights", "Treadmill", "Hot tub", "Indoor pool", "Water slide", "24-hour front desk", "Elevator", "Gift shop", "Housekeeping (daily)", "Self-service laundry", "Wake-up calls", "Business center", "Free Wi-Fi", "Meeting rooms", "Parking (free)", "Kid friendly", "Accessible", "Accessible parking"] | NULL | NULL | NULL | 1 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2025-07-30 21:57:19 | 2026-03-11 18:50:36 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | ||||||||||
| 23 | ChIJ9YnN3tV2hlQRotFi49nAxQ0 | Accent Inns Burnaby | An 8-minute walk from Gilmore SkyTrain station, this straightforward hotel is 4 km from sports and concerts at the Pacific Coliseum, and 5 km from the Metropolis at Metrotown mall. The laid-back rooms come with free Wi-Fi and flat-screen TVs, plus minifridges and coffeemakers. Upgraded rooms add sofabeds and/or kitchenettes. Suites feature separate living rooms with sofas. Parking and an area shuttle are complimentary. There's a casual, country-style restaurant, a hot tub and a gym, plus a coin-operated laundry. | 3777 Henning Dr, Burnaby, BC V5C 6N5, Canada | Burnaby | Canada | BC | V5C 6M2 | (604) 473-5000 | http://www.accentinns.com/burnaby | 16:00:00 | 11:00:00 | 4 | Upscale | active | 10.00 | NULL | NULL | 49.26414310 | -123.02220920 | NULL | NULL | NULL | 0 | 0 | NULL | ["Air conditioning", "Kitchen in some rooms", "Fitness center (free)", "Hot tub", "24-hour front desk", "Free Wi-Fi", "Bicycle rental (free)", "Parking (free)", "Kid friendly", "Pet friendly", "Accessible"] | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2025-07-30 22:13:47 | 2026-03-11 18:50:43 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | ||||||||||
| 25 | ChIJ_XvK32dUdFMRAT27xK9F-2k | Holiday Inn Express Red Deer North by IHG | Set 1 km from Highway 2, this casual hotel in a commercial plaza with relaxed eateries is also 3 km from Bower Ponds park and 7 km from Bower Place mall. Straightforward rooms have sitting areas, free Wi-Fi and flat-screen TVs, plus microwaves, minifridges and coffeemakers. Kids age 19 and under stay at no extra charge with a parent. A breakfast buffet and parking are complimentary. Other amenities include an indoor pool, a waterslide and a hot tub, along with a 24/7 fitness room. | 6433 Orr Dr, Red Deer, AB T4P 3C8, Canada | Red Deer | Canada | AB | T4P 3V8 | (587) 457-7829 | https://www.ihg.com/holidayinnexpress/hotels/us/en/red-deer/yqfes/hoteldetail?cm_mmc=GoogleMaps-_-EX-_-CA-_-YQFES | 16:00:00 | 11:00:00 | 5 | Luxury | active | 10.00 | NULL | NULL | 52.28605640 | -113.84996890 | NULL | NULL | NULL | 0 | 0 | NULL | ["Air conditioning", "Coffee maker", "Fridge", "Microwave", "Smoke-free property", "Private bathroom", "Breakfast (free)", "Breakfast buffet", "Restaurant", "Vending machines", "Hot tub", "Indoor pool", "24-hour front desk", "Baggage storage", "Elevator", "Full-service laundry", "Housekeeping (daily)", "Wake-up calls", "Business center", "Free Wi-Fi", "Meeting rooms", "Airport shuttle (extra charge)", "Parking (free)", "Private car service (extra charge)", "Valet parking (extra charge)", "Activities for kids", "Kid friendly", "No pets", "Accessible", "Accessible parking"] | NULL | NULL | NULL | 1 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2025-07-31 03:30:56 | 2026-03-11 18:50:49 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | ||||||||||
| 26 | ChIJyQ8jee4goFMRwSx3fTIMzkg | Four Points by Sheraton Edmonton West | Adjacent to a shopping plaza, this informal hotel off State Highway 216 is 4 km from West Edmonton Mall and 7 km from the TELUS World of Science centre. Straightforward rooms, some with sofabeds, provide flat-screen TVs, microwaves and minifridges, in addition to coffeemakers and complimentary Wi-Fi. Room service is available. Breakfast is served in an unfussy restaurant. Other amenities include an indoor pool, a hot tub and a gym, as well as a bar and meeting space. Parking is available. | 18540 100 Ave NW, Edmonton, AB T5S 0K6, Canada | Edmonton | Canada | AB | T5S 0C2 | Alexis Smith | [email protected] | (204) 594-2200 | Maria Guidoccio | [email protected] | (780) 784-8108 | (780) 244-8355 | https://www.marriott.com/en-us/hotels/yegfw-four-points-edmonton-west/overview/?scid=f2ae0541-1279-4f24-b197-a979c79310b0 | 15:00:00 | 12:00:00 | 4 | Economy | active | 10.00 | NULL | NULL | 53.53779950 | -113.64503740 | NULL | NULL | NULL | 0 | 0 | NULL | ["Air conditioning", "Coffee maker", "Microwave", "Smoke-free property", "Bar / lounge", "Breakfast (extra charge)", "On-site restaurant", "Table service", "Vending machines", "24-hour front desk", "Baggage storage", "Elevator", "Housekeeping (daily)", "Self-service laundry (extra charge)", "Wake-up calls", "Business center", "Free Wi-Fi", "Meeting rooms", "Public internet workstation", "Wi-Fi in public areas", "EV charger (free)", "Parking (free)", "Self parking", "No pets", "Accessible parking"] | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2025-07-31 05:48:15 | 2026-03-11 18:50:54 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | ||||
| 27 | ChIJP8w-7yceoFMRkGUY3_Vg6ak | Holiday Inn Express & Suites Edmonton SW – Windermere | From the moment you enter the impressive lobby of Edmonton's newest Holiday Inn Express, with its vaulted ceilings and stylish design, you know you are going to be treated right! Whether you are here for business or pleasure, we offer everything you need to make your stay comfortable and convenient. Our spacious rooms are available with queen, king and double queen beds, and larger suites accommodating up to eight people, complete with free high-speed internet, microwave and fridge. Start your day with our delicious complimentary breakfast. Work out in our fitness room or take a refreshing swim before heading out. Or take advantage of our meeting room for your professional needs. Just off the major Anthony Henday Freeway, we are conveniently located close to the airport, West Edmonton Mall, and downtown. Edmonton is a vibrant arts and entertainment community, with fine dining and numerous festivals and events all year round. From Candy Cane Lane and the Boardwalk Ice on Whyte in winter to the Fringe Theatre, Heritage and Folk Festivals in the summer, there is always something exciting happening here. We are home to the Edmonton Eskimos football and Edmonton Oilers hockey teams. When the Oilers are not playing in their state-of-the-art arena, you will find a variety of concerts and events year-round for your entertainment pleasure. Once back at the hotel, wind down with a relaxing jacuzzi or your favorite TV program before settling in for a restful night's sleep. | 6125 Andrews Loop SW, Edmonton, AB T6W 3G9, Canada | Edmonton | Canada | AB | T6W 3G9 | Martin Chan DOS | [email protected] | (780) 249-9600 | (780) 249-9600 | https://www.ihg.com/holidayinnexpress/hotels/us/en/edmonton/yegwm/hoteldetail?cm_mmc=GoogleMaps-_-EX-_-CA-_-YEGWM | 15:00:00 | 11:00:00 | 4 | Upscale | active | 10.00 | NULL | NULL | 53.43093000 | -113.58836000 | NULL | NULL | NULL | 0 | 0 | NULL | ["Air conditioning", "Coffee maker", "Fridge", "Microwave", "Minibar (extra charge)", "Smoke-free property", "Breakfast (free)", "Breakfast buffet", "Elliptical machine", "Fitness center (free)", "Free weights", "Treadmill", "Weight machines", "Hot tub", "Indoor pool", "24-hour front desk", "Housekeeping (daily)", "Self-service laundry", "Free Wi-Fi", "Meeting rooms", "Parking (free)", "Kid friendly", "No pets", "Accessible", "Accessible parking"] | NULL | NULL | NULL | 1 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2025-07-31 09:34:08 | 2026-03-11 18:51:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |||||||
| 28 | ChIJ345X8_1vcVMRCdHUg-1f-nE | Calgary Marriott Downtown Hotel | This upscale high-rise hotel is next to the Calgary Tower and less than a mile from Fort Calgary. The contemporary rooms with city views have desks, flat-screen TVs with premium cable channels, minifridges and coffeemakers. Wi-Fi is available. Some rooms have access to a lounge with free continental breakfast and evening appetizers. Suites add separate living areas with sofas. There's an American restaurant and a Starbucks coffee shop, as well as a fitness center, 16 meeting rooms and a business center. | 110 9 Ave SE, Calgary, AB T2G 0P5, Canada | Calgary | Canada | AB | T2G 0P5 | Jason Johnson | [email protected] | (403) 266-7331 | https://www.marriott.com/en-us/hotels/yycdt-calgary-marriott-downtown-hotel/overview/?scid=f2ae0541-1279-4f24-b197-a979c79310b0 | 15:00:00 | 12:00:00 | 4 | Mid-Range | active | 10.00 | NULL | NULL | 51.04483750 | -114.06260090 | NULL | NULL | NULL | 0 | 0 | NULL | ["Air conditioning", "Coffee maker", "Room service (extra charge)", "Smoke-free property", "Bar / lounge", "On-site restaurant", "Table service", "Elliptical machine", "Fitness center (free)", "Free weights", "Treadmill", "Weight machines", "24-hour front desk", "Baggage storage", "Daily housekeeping", "Elevator", "Laundry service (extra charge)", "Wake-up calls", "Business center", "Meeting rooms", "EV charger (free)", "Parking (extra charge)", "Valet parking (extra charge)", "Dogs allowed", "Pet friendly", "Accessible"] | [] | [""] | [""] | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 5.00 | 4.00 | 4.00 | 3.00 | NULL | NULL | NULL | 2025-08-02 10:48:09 | 2026-03-12 07:53:24 | NULL | NULL | NULL | ||||||||||||
| 29 | ChIJOTZUPf9vcVMRgc7zoqhfHqQ | Delta Hotels Calgary Downtown | Set a 7-minute walk from Glenbow Museum, this modern, upscale hotel is also 1 km from Calgary Tower. The stylish rooms come with tea and coffeemaking facilities, and minifridges, plus flat-screen TVs and free Wi-Fi. Upgraded rooms add iPod docks and walk-in showers; in-room spa services are also available (fee). Continental breakfast is free (upgraded rooms only). Other amenities consist of an on-site bistro, a lobby lounge and bar, and a Starbucks. There's also a heated indoor pool and a sun deck. Meeting facilities are also offered. | 209 4 Ave SE, Calgary, AB T2G 0C6, Canada | Calgary | Canada | AB | T2G 0C6 | Keshvi Radia | [email protected] | (403) 888-8584 | (403) 266-1980 | https://www.marriott.com/en-us/hotels/yycbv-delta-hotels-calgary-downtown/overview/?scid=f2ae0541-1279-4f24-b197-a979c79310b0 | 15:00:00 | 12:00:00 | 4 | Mid-Range | active | 10.00 | NULL | NULL | 51.04887610 | -114.05962810 | NULL | NULL | NULL | 0 | 0 | NULL | ["Air conditioning", "Coffee maker", "Smoke-free property", "Elliptical machine", "Free weights", "Sauna", "Treadmill", "Hot tub", "Indoor pool", "24-hour front desk", "Baggage storage", "Elevator", "Housekeeping (daily)", "Laundry service (extra charge)", "Wake-up calls", "Free Wi-Fi", "Public internet workstation", "Wi-Fi in public areas", "EV charger (free)", "Parking (extra charge)", "Activities for kids", "Kid friendly", "Dogs allowed", "Pet friendly", "Accessible", "Accessible elevator", "Accessible parking", "Accessible pool", "Fitness Centre"] | [] | [""] | [""] | 1 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2025-08-02 10:52:09 | 2026-03-11 18:51:09 | NULL | NULL | NULL | |||||||||||
| 30 | ChIJi-YsETBxcVMRxSXTZsmIhdQ | Delta Hotels Calgary South | Set near the McLeod Trail, this unassuming, modern hotel is a 9-minute walk from the nearest light rail station, and 1.6 km from the Southcentre Mall. The casual rooms have flat-screen TVs, microwaves and minifridges, plus coffeemakers and free WiFi. Uprgraded rooms add access to a lounge with complimentary craft beer, afternoon snacks and a breakfast buffet. Amenities include an on-site gastropub, a cafe and a ballroom, as well as meeting facilities, an indoor pool with a water slide, and a fitness centre. | 135 Southland Dr SE, Calgary, AB T2J 5X5, Canada | Calgary | Canada | AB | T2J 5X5 | Paige Dairon | [email protected] | (403) 225-8626 | (403) 278-5050 | https://www.marriott.com/en-us/hotels/yycdc-delta-hotels-calgary-south/overview/?scid=f2ae0541-1279-4f24-b197-a979c79310b0 | 15:00:00 | 11:00:00 | 4 | Mid-Range | active | 10.00 | NULL | NULL | 50.96435300 | -114.06914060 | NULL | NULL | NULL | 0 | 0 | NULL | ["Air conditioning", "Coffee maker", "Fridge", "Microwave", "Smoke-free property", "Bar / lounge", "Breakfast (extra charge)", "On-site restaurant", "Vending machines", "Elliptical machine", "Fitness center (free)", "Free weights", "Treadmill", "Weight machines", "24-hour front desk", "Baggage storage", "Concierge service", "Daily housekeeping", "Elevator", "Laundry service (extra charge)", "Wake-up calls", "Free Wi-Fi", "Public internet workstation", "Wi-Fi in public areas", "Parking (free)", "Self parking", "Dogs allowed", "Pet friendly", "Accessible", "Accessible parking"] | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2025-08-02 11:00:49 | 2026-03-11 18:51:14 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |||||||
| 31 | ChIJm-9h-9xwcVMR5aJdufBWn6A | Holiday Inn & Suites Calgary South - Conference Ctr by IHG | Set off of Highway 2, this relaxed conference hotel is 4 km from Heritage Park Historical Village. Carburn Park is 7 km away. The modern rooms feature free Wi-Fi, flat-screen TVs and microwaves, in addition to minifridges. Kids age 18 and under stay at no charge with an adult. Parking is free. Other amenities include an indoor pool with a waterslide, as well as a gym and a casual restaurant. There are also conference facilities. | 8360 Blackfoot Trl SE, Calgary, AB T2J 7E1, Canada | Calgary | Canada | AB | T2J 7E1 | Jamie Wright | [email protected] | (403) 930-8602 | Stella Miranda | [email protected] | (403) 930-8602 | (403) 475-8561 | https://www.ihg.com/holidayinn/hotels/us/en/calgary/yycdm/hoteldetail?cm_mmc=GoogleMaps-_-HI-_-CA-_-YYCDM | 15:00:00 | 11:00:00 | 5 | Mid-Range | active | 10.00 | NULL | NULL | 50.97917520 | -114.04717470 | NULL | NULL | NULL | 0 | 0 | NULL | ["Air conditioning", "Coffee maker", "Microwave", "Smoke-free property", "Bar / lounge", "Breakfast (extra charge)", "On-site restaurant", "Vending machines", "Elliptical machine", "Fitness center (free)", "Free weights", "Treadmill", "Hot tub", "Indoor pool", "Water slide", "24-hour front desk", "Baggage storage", "Currency exchange", "Elevator", "Laundry service (extra charge)", "Wake-up calls", "Business center", "Free Wi-Fi", "Meeting rooms", "Wi-Fi in public areas", "EV charger (free)", "Local shuttle (free)", "Parking (free)", "Activities for kids", "Kid friendly", "Cats allowed", "Dogs allowed", "Pet friendly", "Accessible", "Accessible parking"] | [] | [""] | [""] | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2025-08-02 11:39:08 | 2026-03-11 18:51:19 | NULL | NULL | NULL | Director of Sales | |||||||
| 32 | ChIJHY542f1vcVMRG7nq4Ni9kZQ | Hyatt Regency Calgary | A 4-minute walk from the Arts Commons and the Calgary TELUS Convention Centre, this polished high-rise hotel is 5.8 km from shopping at the Chinook Centre. Refined rooms feature free Wi-Fi and flat-screen TVs, as well as Keurig coffeemakers and ergonomic work space; some provide city views. Room service is available 24/7. An indoor pool and a 24-hour exercise room provide city views. There's a spa and an modern restaurant & bar, plus a business center and 33,000 sq ft of event space. | 700 Centre St S, Calgary, AB T2G 5P6, Canada | Calgary | Canada | AB | T2G 5P6 | (403) 717-1234 | https://www.hyatt.com/hyatt-regency/en-US/calrc-hyatt-regency-calgary?src=corp_lclb_google_seo_calrc&utm_source=google&utm_medium=organic&utm_campaign=lmr | 15:00:00 | 12:00:00 | 5 | Mid-Range | active | 10.00 | NULL | NULL | 51.04607230 | -114.06263990 | NULL | NULL | NULL | 0 | 0 | NULL | ["Air conditioning", "Coffee maker", "Fridge", "Smoke-free property", "Bathtub", "Private bathroom", "Bar", "Breakfast (extra charge)", "Restaurant", "Room service", "Table service", "Vending machines", "Elliptical machine", "Fitness center (free)", "Free weights", "Massage (extra charge)", "Sauna", "Spa", "Treadmill", "24-hour front desk", "Baggage storage", "Concierge service", "Currency exchange", "Elevator", "Full-service laundry", "Gift shop", "Housekeeping (daily)", "Turndown service", "Wake-up calls", "Business center", "Free Wi-Fi", "Meeting rooms", "Public internet workstation", "Wi-Fi in public areas", "Bicycle rental (free)", "EV charger (extra charge)", "Parking (extra charge)", "Private car service (extra charge)", "Dogs allowed (extra charge)", "Pet friendly", "Accessible", "Accessible elevator", "Accessible parking", "Accessible pool"] | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2025-08-02 11:43:07 | 2026-03-11 18:51:25 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | ||||||||||
| 33 | ChIJ-f9vQ-JvcVMR6v2ACOfNsTE | Residence Inn Calgary Downtown/Beltline District | Set in the trendy Beltline entertainment district, this relaxed hotel is an 11-minute walk from Calgary Tower, 5 minutes on foot from a CTrain station and 14 minutes' stroll from the Glenbow Museum. Straightforward studios, some with sofabeds and/or mountain views, provide kitchenettes, flat-screen TVs and safes, in addition to free Wi-Fi. Suites add separate living rooms. Amenities include a casual restaurant, a BBQ area and a 24-hour fitness centre, as well as event space. Pets are welcome. | 610 10 Ave SW, Calgary, AB T2R 1M3, Canada | Calgary | Canada | AB | T2R 0B2 | Laura Langlais | [email protected] | (587) 885-2285 | Shanil | [email protected] | (403) 826-7651 | (587) 885-2288 | https://www.marriott.com/en-us/hotels/yycbl-residence-inn-calgary-downtown-beltline-district/overview/?scid=f2ae0541-1279-4f24-b197-a979c79310b0 | 16:00:00 | 12:00:00 | 5 | Mid-Range | active | 10.00 | NULL | NULL | 51.04386650 | -114.07472120 | NULL | NULL | NULL | 0 | 0 | NULL | ["Air conditioning", "Coffee maker", "Fridge", "Kitchen", "Microwave", "Smoke-free property", "Private bathroom", "Breakfast (free)", "Restaurant", "24-hour front desk", "Baggage storage", "Elevator", "Full-service laundry", "Housekeeping (daily)", "Wake-up calls", "Business center", "Free Wi-Fi", "Meeting rooms", "Public internet workstation", "Wi-Fi in public areas", "EV charger (extra charge)", "Parking (extra charge)", "Valet parking (extra charge)", "Kid friendly", "Dogs allowed", "Pet friendly", "Accessible", "Accessible parking"] | NULL | NULL | NULL | 1 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2025-08-02 11:49:13 | 2026-03-11 18:51:31 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | ||||
| 35 | ChIJd8HAZ7xucVMR1pnrmm29Lsg | Four Points by Sheraton Hotel & Suites Calgary West | Off the Trans-Canada Highway, this laid-back hotel is 2 km both from the WinSport ski area and from the Canada's Sports Hall of Fame. Straightforward rooms offer free Wi-Fi and flat-screen TVs, plus microwaves, minifridges and coffeemakers. Suites add separate living areas; some feature balconies, fireplaces and/or whirlpool tubs. Parking is complimentary. There's also a stylish bar/restaurant with private dining rooms. Other amenities include a 24/7 exercise room, a spa, a hot tub and an indoor pool with a slide, as well as meeting space and a business centre. Breakfast is available for a fee. | 8220 Bowridge Crescent NW, Calgary, AB T3B 2V1, Canada | Calgary | Canada | AB | T3B 2V1 | (403) 288-4441 | https://www.marriott.com/en-us/hotels/yycfp-four-points-hotel-and-suites-calgary-west/overview/?scid=f2ae0541-1279-4f24-b197-a979c79310b0 | 15:00:00 | 12:00:00 | 4 | Mid-Range | active | 10.00 | NULL | NULL | 51.08339420 | -114.20595400 | NULL | NULL | NULL | 0 | 0 | NULL | ["Air conditioning", "Coffee maker", "Microwave", "Smoke-free property", "Bar", "Breakfast (extra charge)", "Breakfast buffet", "Restaurant", "Room service", "Hot tub", "Indoor pool", "24-hour front desk", "Baggage storage", "Elevator", "Gift shop", "Housekeeping (daily)", "Self-service laundry", "Wake-up calls", "Business center", "Free Wi-Fi", "Meeting rooms", "Public internet workstation", "Wi-Fi in public areas", "Parking (free)", "Self parking", "Kid friendly", "Dogs allowed", "Pet friendly", "Accessible parking"] | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2025-08-02 20:34:35 | 2026-03-11 18:51:34 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | ||||||||||
| 36 | ChIJTwUmA6vKhVQRxPT0qqj-6kk | Best Western Plus Regency Inn & Conference Centre | Informal hotel featuring a restaurant, 2 indoor pools & a gym, plus meeting rooms & free breakfast. | 32110 Marshall Rd, Abbotsford, BC V2T 1A1, Canada | Abbotsford | Canada | BC | V2T 1A1 | Sarah & Harsh | [email protected] | (604) 853-3111 | (604) 853-3111 | https://bwregency.bc.ca/ | 16:00:00 | 11:00:00 | 4 | Mid-Range | active | 10.00 | NULL | NULL | 49.03777910 | -122.33425940 | NULL | NULL | NULL | 0 | 0 | NULL | ["Air conditioning", "Coffee maker", "Fridge", "Kitchen in some rooms", "Microwave", "Smoke-free property", "Private bathroom", "Bar", "Breakfast (free)", "Breakfast buffet", "Restaurant", "Room service", "Elliptical machine", "Fitness center (free)", "Free weights", "Treadmill", "Hot tub", "Indoor pool", "24-hour front desk", "Elevator", "Full-service laundry", "Gift shop", "Self-service laundry", "Wake-up calls", "Business center", "Free Wi-Fi", "Meeting rooms", "Parking (free)", "Kid friendly", "Dogs allowed (extra charge)", "Pet friendly", "Accessible", "Accessible elevator", "Accessible parking"] | [] | ["Onsite Ricky's Restaurant"] | [""] | 1 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2025-08-02 21:02:23 | 2026-03-11 18:51:39 | NULL | NULL | NULL | |||||||||||
| 37 | ChIJF9YwKrVhcVMRKvE-wi7DyH4 | Days Inn by Wyndham Calgary North Balzac | Set off of Highway 2, this informal roadside hotel is 10 km from Nose Creek Valley Museum. Bright rooms with understated decor offer complimentary Wi-Fi and flat-screens, along with minifridges, microwaves and coffeemakers. Suites add kitchenettes and sitting areas. Kids age 17 and under stay at no charge with an adult. Freebies include breakfast and parking. There's also an indoor pool, a hot tub and a waterslide, along with a fitness centre. | 292243 Wagon Wheel Blvd, Balzac, AB T4A 3N5, Canada | Balzac | Canada | AB | T4A 0E2 | (403) 516-3297 | https://www.wyndhamhotels.com/en-ca/days-inn/balzac-alberta/days-inn-calgary-airport-north/overview?CID=LC:iqv0j1dklijly45:50659&iata=00093796 | 16:00:00 | 12:00:00 | 4 | Mid-Range | active | 10.00 | NULL | NULL | 51.20849220 | -113.97919460 | NULL | NULL | NULL | 0 | 0 | NULL | ["Coffee maker", "Fridge", "Microwave", "Smoke-free property", "Bar", "Breakfast (free)", "Breakfast buffet", "Restaurant", "Vending machines", "Fitness center (free)", "Hot tub", "Indoor pool", "Outdoor pool", "Water slide", "24-hour front desk", "Baggage storage", "Full-service laundry", "Gift shop", "Housekeeping (daily)", "Self-service laundry", "Wake-up calls", "Free Wi-Fi", "Parking (free)", "Kid friendly", "Dogs allowed (extra charge)", "Pet friendly", "Accessible"] | NULL | NULL | NULL | 1 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2025-08-02 21:25:26 | 2026-03-11 18:51:45 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | ||||||||||
| 38 | ChIJQcqClPRwcVMREEtuV5AdwhI | Hotel Blackfoot | Set 2.7 km from the Chinook Centre, this modern, downtown hotel is 6.6 km from Heritage Park Historical Village. The upscale, sleek rooms are equipped with minifridges, iPod docks and flat-screen TVs, plus coffeemakers and free Wi-Fi. Suites add Jacuzzi tubs or additional living spaces. There's a casual restaurant, a sports bar and a lounge, plus buffets. Amenities consist of a seasonal heated outdoor pool, plus a year-round hot tub and sauna. There's also a comedy club and in-room spa services, along with off-street parking, plus 24/7 business and fitness centres. | 5940 Blackfoot Trl SE, Calgary, AB T2H 2B5, Canada | Calgary | Canada | AB | T2H 2B5 | (403) 252-2253 | http://www.hotelblackfoot.com/ | 16:00:00 | 12:00:00 | 4 | Mid-Range | active | 10.00 | NULL | NULL | 51.00041360 | -114.04701330 | NULL | NULL | NULL | 0 | 0 | NULL | ["Air conditioning", "Coffee maker", "Fridge", "Microwave", "Smoke-free property", "Bar", "Breakfast (extra charge)", "Breakfast buffet", "Restaurant", "Room service", "Table service", "Vending machines", "Elliptical machine", "Fitness center (free)", "Free weights", "Massage (extra charge)", "Treadmill", "Weight machines", "Outdoor pool", "24-hour front desk", "Baggage storage", "Elevator", "Full-service laundry", "Housekeeping (daily)", "Turndown service", "Business center", "Free Wi-Fi", "Meeting rooms", "Wi-Fi in public areas", "Airport shuttle (extra charge)", "EV charger (free)", "Parking (free)", "Self parking", "Cats allowed (extra charge)", "Dogs allowed (extra charge)", "Pet friendly", "Accessible", "Accessible elevator", "Accessible parking"] | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2025-08-02 21:41:29 | 2026-03-11 18:51:50 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | ||||||||||
| 39 | ChIJT97PfHpHoFMR2q1X564G45Y | The Kanata Fort Saskatchewan Hotel | This stylish hotel in Fort Saskatchewan is 1.2 km from the Golf and Curling Club, 2.7 km from the Dow Centennial Centre and 30.9 km from downtown Edmonton. Contemporary rooms and suites have free WiFi, microwaves, minifridges and flat-screen TVs; some add Jacuzzi tubs, desks and/or kitchenettes. Amenities include a fitness room, complimentary breakfast and a hot tub, plus free guest laundry, a business centre and meeting rooms. | 9820 86 Ave, Fort Saskatchewan, AB T8L 4P4, Canada | Fort Saskatchewan | Canada | AB | T8L 4P4 | Andrew | [email protected] | (780) 998-2770 | (780) 998-2770 | https://kanatainns.com/locations/hotel-in-fort-saskatchewan-ab/?utm_source=local&utm_medium=organic&utm_campaign=gmb | 15:00:00 | 11:00:00 | 5 | Mid-Range | active | 10.00 | NULL | NULL | 53.69726890 | -113.20782200 | NULL | NULL | NULL | 0 | 0 | NULL | ["Fridge", "Microwave", "Mini-fridge", "Smoke-free property", "Breakfast (free)", "Breakfast buffet", "Restaurant", "Fitness center (free)", "Hot tub", "24-hour front desk", "Free Wi-Fi", "Parking (free)", "Pet friendly", "Accessible"] | NULL | NULL | NULL | 1 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2025-08-02 21:58:16 | 2026-03-11 18:51:55 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |||||||
| 40 | ChIJF1vT4R1ucVMRieoXNxgCAqs | Sandman Hotel & Suites Calgary West | Set next to the Trans-Canada Highway, this unfussy hotel is an 8-minute walk from Canada Olympic Park and 14 km from downtown Calgary. Unassuming rooms come with free Wi-Fi and TVs. Some add minifridges and microwaves. Suites feature separate living areas with pull-out sofas and kitchenettes; some have whirlpool tubs. Amenities include an indoor pool and whirlpool, a gym, a casual 24-hour restaurant and a bar/lounge. There's also free parking and meeting space. | 125 Bowridge Dr NW, Calgary, AB T3B 3Y6, Canada | Calgary | Canada | AB | T3B 3Y6 | Charlotte Wilkinson | [email protected] | (403) 991-9358 | Chris Pratt | [email protected] | (403) 288-6033 | (403) 288-6033 | https://www.sandmanhotels.com/calgary-west?utm_source=google&utm_medium=maps&utm_campaign=calgary_west | 16:00:00 | 11:00:00 | 4 | Mid-Range | active | 10.00 | NULL | NULL | 51.08527320 | -114.20898170 | NULL | NULL | NULL | 0 | 0 | NULL | ["Air conditioning", "Smoke-free property", "Bar", "Breakfast (extra charge)", "Restaurant", "Room service", "Table service", "Vending machines", "Elliptical machine", "Fitness center (free)", "Free weights", "Treadmill", "Weight machines", "Hot tub", "Indoor pool", "Outdoor pool", "24-hour front desk", "Baggage storage", "Currency exchange", "Elevator", "Housekeeping (daily)", "Wake-up calls", "Business center", "Free Wi-Fi", "Meeting rooms", "Public internet workstation", "Wi-Fi in public areas", "Parking (free)", "Self parking", "Kid friendly", "Cats allowed (extra charge)", "Dogs allowed (extra charge)", "Pet friendly", "Accessible", "Accessible elevator", "Accessible parking"] | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2025-08-02 22:08:06 | 2026-03-11 18:52:00 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | ||||
| 41 | ChIJaxgxm5k9oFMRfuC0JhpyNdk | Holiday Inn Express & Suites Sherwood Park-Edmonton Area by IHG | An 8-minute walk from Millennium Place (a multi-use recreation facility with a water playground), this contemporary hotel is also 11.8 km from Rexall Place, home of the Edmonton Oilers hockey team. Straightforward rooms come with flat-screen TVs and desks, plus minifridges, premium cable channels and coffeemakers. Kids 19 and under stay free with an adult and there's free WiFi in every room, as well as a choice of hard and soft pillows. Suites add separate living spaces, kitchenettes and dining tables; some feature whirlpool tubs. The facility also offers a free breakfast bar, an exercise room and a whirlpool, as well as free parking. | 11 Portage Ln, Sherwood Park, AB T8H 2V1, Canada | Sherwood Park | Canada | AB | T8H 2V1 | Hany Tadros | [email protected] | (780) 417-3388 | Kosala Kariyawasamsk | [email protected] | (587) 731-1690 | (780) 417-3388 | https://www.ihg.com/holidayinnexpress/hotels/us/en/sherwood-park/yegsp/hoteldetail?cm_mmc=GoogleMaps-_-EX-_-CA-_-YEGSP | 16:00:00 | 12:00:00 | 4 | Mid-Range | active | 10.00 | NULL | NULL | 53.56228170 | -113.31838570 | NULL | NULL | NULL | 0 | 0 | NULL | {"0": "Bar", "1": "Breakfast (free)", "2": "Hot tub", "3": "Outdoor pool", "4": "Free Wi-Fi", "5": "Air conditioning", "6": "Coffee maker", "7": "Microwave", "8": "Smoke-free property", "11": "Breakfast buffet", "12": "Restaurant", "13": "Vending machines", "14": "Elliptical machine", "15": "Fitness center (free)", "16": "Free weights", "17": "Treadmill", "19": "24-hour front desk", "20": "Baggage storage", "21": "Elevator", "22": "Full-service laundry", "23": "Housekeeping (daily)", "24": "Wake-up calls", "25": "Business center", "27": "Meeting rooms", "28": "Parking (free)", "29": "Cats allowed", "30": "Dogs allowed", "31": "Pet friendly", "32": "Accessible", "33": "Accessible parking"} | NULL | NULL | NULL | 1 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2025-08-02 22:20:43 | 2026-03-11 18:52:06 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | ||||
| 42 | ChIJ0RXLGIctE1MR1jufGMpPj-g | Best Western Premier Executive Residency Medicine Hat | In an area with multiple fast food restaurants, this informal hotel is 5 km from the Saamis Tepee and 7 km from the Esplanade Arts & Heritage Centre. The Trans-Canada Highway is 1 km away. Accommodations range from straightforward rooms with microwaves, minifridges and coffeemakers to casual 1-bedroom suites offering kitchens, and living areas with dining tables, sofabeds and whirlpool tubs. All have Wi-Fi. Amenities include an indoor pool, a waterslide and a hot tub, plus a steam room, a gym and coin-operated laundry facilities. There’s also a restaurant, a bar and meeting space. Breakfast, parking and electric charging stations are available. | 35 Paul Stober Dr SE, Medicine Hat, AB T1B 4Y2, Canada | Medicine Hat | Canada | AB | T1B 4Y2 | Brandon Turner | [email protected] | (403) 905-3202 | (403) 905-3202 | https://www.bestwestern.com/en_US/book/hotel-rooms.61104.html?iata=00171880&ssob=BLBWI0004G&cid=BLBWI0004G:google:gmb:61104 | 16:00:00 | 12:00:00 | 5 | Mid-Range | active | 10.00 | NULL | NULL | 49.99610150 | -110.64010380 | NULL | NULL | NULL | 0 | 0 | NULL | {"0": "Restaurant", "1": "Outdoor pool", "2": "Indoor pool", "3": "Kitchen", "4": "Air conditioning", "5": "Coffee maker", "6": "Fridge", "8": "Microwave", "9": "Smoke-free property", "10": "Bar", "11": "Breakfast (free)", "12": "Breakfast buffet", "14": "Room service", "15": "Fitness center (free)", "16": "Sauna", "18": "24-hour front desk", "19": "Baggage storage", "20": "Elevator", "21": "Housekeeping (daily)", "22": "Self-service laundry", "23": "Wake-up calls", "24": "Business center", "25": "Free Wi-Fi", "26": "Meeting rooms", "27": "EV charger (extra charge)", "28": "Parking (free)", "29": "Cats allowed (extra charge)", "30": "Dogs allowed (extra charge)", "31": "Pet friendly"} | NULL | NULL | NULL | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2025-08-02 22:26:32 | 2026-03-11 18:52:12 | NULL | NULL | NULL | NULL | NULL | NULL | NULL |