Baie Ste Marie Oceanfront

Establishment at 5 Riverside Road, Church Point, NS B0W 1M0, Canada. Here you will find detailed information about Baie Ste Marie Oceanfront: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment  

Address:
5 Riverside Road
Church Point
Nova Scotia B0W 1M0
Canada
Get directions

Phone:
+1 902-769-0797

Website:
nsoceanfrontcottages.com

Reviews of Baie Ste Marie Oceanfront

Sorry, but now we haven't any revews about Baie Ste Marie Oceanfront.

Add review

About nsoceanfrontcottages.com

Oceanfront Cottages - Baie Ste-Marie, Nova Scotia
Rentals cottages, Vacation Rentals, Vacation cabins, Rental cabins, Lodging, Beach, Oceanfront, Accommodations, Cottages, Rentals, Holiday rentals, Chalets rentals, Apartments, Villas, Destinations, Vacations, Condos, Travel, Vacation home, Canada vacation rentals, Fresh Alt antic Lobster, Whale Watching tours

2SELECT * FROM `item` WHERE url = 'baie-ste-marie-oceanfront' LIMIT 1
1SELECT * FROM `region` WHERE id IN ('174') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('16054') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('56776')
0SELECT * FROM `category` WHERE id IN ('96') LIMIT 1
0SELECT * FROM `locality` WHERE url = 'church-point-ns' LIMIT 1
0SELECT * FROM `region` WHERE id = 174 LIMIT 1
1SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 56776 AND `date` < '2024-04-26 23:04:34' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('56776')
2SELECT * FROM `item` WHERE id IN ('57112','57224','56766','56769','56954','56976') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('174') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('16018','16054') LIMIT 2
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('56766','56769','56954','56976','57112','57224')
0SELECT * FROM `category` WHERE id IN ('96','120','121','132','164','108','100') LIMIT 7
1SELECT * FROM counts where updated="2024-04-26" and table_name like 'news'
0SELECT * FROM counts where updated="2024-04-26" and table_name like 'news'
0SELECT * FROM `category` ORDER BY name
3SELECT * 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 ('169','170') LIMIT 2
1SELECT * FROM `locality` WHERE id IN ('14823','14749','15348') LIMIT 3
0SELECT * FROM `photos` WHERE `item_id` IN ('273208','273209','273210','273211')
1SELECT * 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