All types
 
Français

By The Water Shellfish Inc

Establishment and food at 4 Borden Avenue, Borden-Carleton, PE C0B 1X0, Canada. Here you will find detailed information about By The Water Shellfish Inc: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Food  

Address:
4 Borden Avenue
Borden-Carleton
Prince Edward Island C0B 1X0
Canada
Get directions

Phone:
+1 902-437-3627

Website:
bythewaterlobster.com

Photos

By The Water Shellfish Inc

Reviews of By The Water Shellfish Inc

Sorry, but now we haven't any revews about By The Water Shellfish Inc.

Add review

About bythewaterlobster.com

By The Water Shellfish
By the Water Shellfish sells lobster from Borden, Prince Edward Island, Canada. Live and cooked lobster, frozen lobster, lobster tails & Malpeque oysters.

Share this page

Additional actions

Today's weather in Borden-Carleton

22:00 1 ℃ 1029 hPa 66 % 3 m/s

Nearest places

1SELECT * FROM `item` WHERE url = 'water-shellfish-inc-2' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('177') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('17359') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('58398')
0SELECT * FROM `category` WHERE id IN ('96','99') LIMIT 2
1SELECT * FROM `locality` WHERE url = 'borden-carleton-pe' LIMIT 1
0SELECT * FROM `region` WHERE id = 177 LIMIT 1
1SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 58398 AND `date` < '2024-04-28 02:26:47' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('58398')
1SELECT * FROM `item` WHERE id IN ('58422','58679','58597','58555','58583','58414') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('177') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('17359') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('58414','58422','58555','58583','58597','58679')
0SELECT * FROM `category` WHERE id IN ('96','99','108') LIMIT 3
2SELECT * FROM counts where updated="2024-04-28" and table_name like 'news'
0SELECT * FROM counts where updated="2024-04-28" and table_name like 'news'
1SELECT * FROM `category` ORDER BY name
1SELECT * 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
1SELECT * FROM `region` WHERE id IN ('176','170','179') LIMIT 3
0SELECT * FROM `locality` WHERE id IN ('17105','15334','15127','18799') LIMIT 4
0SELECT * FROM `photos` WHERE `item_id` IN ('218675','218676','218677','218678')
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 ('170') LIMIT 1