Seafoam Shore

Establishment and lodging at 3789 Nova Scotia 6, River John, NS B0K 1N0, Canada. Here you will find detailed information about Seafoam Shore: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment Lodging

Address:
3789 Nova Scotia 6
River John
Nova Scotia B0K 1N0
Canada
Get directions

Phone:
+1 902-921-8339

Website:
seafoamshore.ca

Opening hours

Sunday	12:00am — 11:59pm
Monday	12:00am — 11:59pm
Tuesday	12:00am — 11:59pm
Wednesday	12:00am — 11:59pm
Thursday	12:00am — 11:59pm
Friday	12:00am — 11:59pm
Saturday	12:00am — 11:59pm

Photos

Reviews of Seafoam Shore

Sorry, but now we haven't any revews about Seafoam Shore.

Add review

About seafoamshore.ca

Seafoam Shore Bed and Breakfast
Seafoam Shore Bed and Breakfast
seafoam shore,bed and breakfast,b&b,b+b

Share this page

Additional actions

Today's weather in River John

01:00 7 ℃ 1011 hPa 95 % 3 m/s 04:00 6 ℃ 1012 hPa 94 % 2 m/s 07:00 6 ℃ 1013 hPa 93 % 2 m/s 10:00 10 ℃ 1012 hPa 68 % 3 m/s 13:00 11 ℃ 1011 hPa 69 % 1 m/s 16:00 7 ℃ 1012 hPa 87 % 4 m/s 19:00 6 ℃ 1014 hPa 95 % 2 m/s 22:00 5 ℃ 1015 hPa 96 % 4 m/s

1	SELECT * FROM `item` WHERE url = 'seafoam-shore' LIMIT 1
0	SELECT * FROM `region` WHERE id IN ('174') LIMIT 1
4	SELECT * FROM `locality` WHERE id IN ('16285') LIMIT 1
11	SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('63282')
0	SELECT * FROM `category` WHERE id IN ('96','107') LIMIT 2
1	SELECT * FROM `locality` WHERE url = 'river-john-ns' LIMIT 1
0	SELECT * FROM `region` WHERE id = 174 LIMIT 1
1	SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 63282 AND `date` < '2024-04-16 13:25:10' ORDER BY `date` DESC
1	SELECT * FROM `photos` WHERE `item_id` IN ('63282')
2	SELECT * FROM `item` WHERE id IN ('63220','62896','63296','63226','81329','81368') LIMIT 6
0	SELECT * FROM `region` WHERE id IN ('174') LIMIT 1
0	SELECT * FROM `locality` WHERE id IN ('16285') LIMIT 1
1	SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('62896','63220','63226','63296','81329','81368')
0	SELECT * FROM `category` WHERE id IN ('96','108','106','107','113') LIMIT 5
0	SELECT * FROM counts where updated="2024-04-16" and table_name like 'news'
1	SELECT * FROM counts where updated="2024-04-16" and table_name like 'news'
1	SELECT * FROM `category` ORDER BY name
1	SELECT * 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
0	SELECT * FROM `region` WHERE id IN ('169','172') LIMIT 2
1	SELECT * FROM `locality` WHERE id IN ('15032','15784') LIMIT 2
1	SELECT * FROM `photos` WHERE `item_id` IN ('171510','171511','171512','171513')
1	SELECT * 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
1	SELECT * FROM `region` WHERE id IN ('168') LIMIT 1