Seahaven Bed & Breakfast

Establishment and lodging at 18 Princess Royal Street, Saint Andrews, NB E5B 2A4, Canada. Here you will find detailed information about Seahaven Bed & Breakfast: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment Lodging

Address:
18 Princess Royal Street
Saint Andrews
New Brunswick E5B 2A4
Canada
Get directions

Website:
seahavenbb.com

Reviews of Seahaven Bed & Breakfast

Sorry, but now we haven't any revews about Seahaven Bed & Breakfast.

Add review

About seahavenbb.com

St. Andrews Bed and Breakfast: Seahaven Bed and Breakfast, St. Andrews, New Brunswick Canada: An Organic, Oceanview B & B
Welcome to Seahaven Bed and Breakfast in St. Andrews, New Brunswick Canada. We are an organic bed and breakfast located at the water's edge in St. Andrews by the Sea NB.
organic bed and breakfast bb bandb b&b inn relais breakfast wholesome foods tasty local treats dulse dulce relaxing romantic seaside oceanside oceanfront oceanview water view water front waterfront waterview balcony travel tourism accommodation gite hotel bb canada New Brunswick saint andrews nb by the sea St. Andrews St. George St. Stephen oceanside bed and breakfast seaside b&b st andrews new brunswick bay of fundy passamaquoddy bay clean secure windows with screens, comfortable beds, a sitting area ceil

1	SELECT * FROM `item` WHERE url = 'seahaven-bed-breakfast' LIMIT 1
0	SELECT * FROM `region` WHERE id IN ('171') LIMIT 1
0	SELECT * FROM `locality` WHERE id IN ('15605') LIMIT 1
0	SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('167840')
0	SELECT * FROM `category` WHERE id IN ('96','107') LIMIT 2
0	SELECT * FROM `locality` WHERE url = 'saint-andrews-nb' LIMIT 1
0	SELECT * FROM `region` WHERE id = 171 LIMIT 1
1	SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 167840 AND `date` < '2024-04-26 09:43:44' ORDER BY `date` DESC
0	SELECT * FROM `photos` WHERE `item_id` IN ('167840')
1	SELECT * FROM `item` WHERE id IN ('167769','152119','167747','152069','167698','152245') LIMIT 6
0	SELECT * FROM `region` WHERE id IN ('171') LIMIT 1
0	SELECT * FROM `locality` WHERE id IN ('15605') LIMIT 1
0	SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('152069','152119','152245','167698','167747','167769')
0	SELECT * FROM `category` WHERE id IN ('96','101','129','173') LIMIT 4
0	SELECT * FROM counts where updated="2024-04-26" and table_name like 'news'
0	SELECT * FROM counts where updated="2024-04-26" and table_name like 'news'
0	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','176') LIMIT 2
0	SELECT * FROM `locality` WHERE id IN ('14777','17108') LIMIT 2
0	SELECT * FROM `photos` WHERE `item_id` IN ('387220','387221','387222','387223')
0	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
0	SELECT * FROM `region` WHERE id IN ('168') LIMIT 1

Seahaven Bed & Breakfast

Contacts

Reviews of Seahaven Bed & Breakfast

About seahavenbb.com

Share this page

Additional actions

Today's weather in Saint Andrews

Nearest places