By the Quay B&B

Establishment and lodging at 2959 Kingsway Avenue, Port Alberni, BC V9Y 1X8, Canada. Here you will find detailed information about By the Quay B&B: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Lodging  

Address:
2959 Kingsway Avenue
Port Alberni
British Columbia V9Y 1X8
Canada
Get directions

Phone:
+1 250-724-5156

Website:
bythequay.ca

Photos

Reviews of By the Quay B&B

Sorry, but now we haven't any revews about By the Quay B&B.

Add review

About bythequay.ca

By The Quay Bed and Breakfast
Rest and relax in this pet and smoke free home located near the hub of visitors attractions. Easy walk to the Alberni Harbour Quay, Lady Rose, Maritime Museum and the Alberni Paciifc Railway train station. Affordable rates throughout the year. By the Quay is ideal for your stay in Port Alberni. Well maintained character home. 1st bedroom views Alberni Inlet.

2SELECT * FROM `item` WHERE url = 'quay-bb' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('169') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('14923') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('135377')
0SELECT * FROM `category` WHERE id IN ('96','107') LIMIT 2
0SELECT * FROM `locality` WHERE url = 'port-alberni-bc' LIMIT 1
0SELECT * FROM `region` WHERE id = 169 LIMIT 1
1SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 135377 AND `date` < '2024-04-25 15:45:42' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('135377')
1SELECT * FROM `item` WHERE id IN ('353261','353147','353168','189737','135549','353195') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('169') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('14923') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('135549','189737','353147','353168','353195','353261')
0SELECT * FROM `category` WHERE id IN ('96','167','133') LIMIT 3
0SELECT * FROM counts where updated="2024-04-25" and table_name like 'news'
0SELECT * FROM counts where updated="2024-04-25" and table_name like 'news'
0SELECT * FROM `category` ORDER BY name
2SELECT * FROM `item` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `item`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 4
0SELECT * FROM `region` WHERE id IN ('179','176') LIMIT 2
0SELECT * FROM `locality` WHERE id IN ('18789','16444') LIMIT 2
0SELECT * FROM `photos` WHERE `item_id` IN ('398605','398606','398607','398608')
0SELECT * FROM `locality` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `locality`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 7
0SELECT * FROM `region` WHERE id IN ('168') LIMIT 1