Salty Rose Cottages

Establishment and lodging at 3299 Nova Scotia 332, Rose Bay, NS B0J 2X0, Canada. Here you will find detailed information about Salty Rose Cottages: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Lodging  

Address:
3299 Nova Scotia 332
Rose Bay
Nova Scotia B0J 2X0
Canada
Get directions

Phone:
+1 902-766-4923

Website:
saltyrose.com

Photos

Reviews of Salty Rose Cottages

Sorry, but now we haven't any revews about Salty Rose Cottages.

Add review

About saltyrose.com

Salty Rose Oceanfront Cottages
Salty Rose Oceanfront Cottages, offering the sights and sounds of the Atlantic Ocean
Salty Rose, Cottages, South Shore, Nova Scotia, Accommodations, Atlantic Canada, Atlantic Ocean, beach front, Adventure, Lighthouse Route, Cabin, vacation rental, Cottage, vacation

1SELECT * FROM `item` WHERE url = 'salty-rose-cottages' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('174') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('16289') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('19437')
0SELECT * FROM `category` WHERE id IN ('96','107') LIMIT 2
0SELECT * FROM `locality` WHERE url = 'rose-bay-ns' LIMIT 1
0SELECT * FROM `region` WHERE id = 174 LIMIT 1
1SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 19437 AND `date` < '2024-04-25 15:51:53' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('19437')
1SELECT * FROM `item` WHERE id IN ('19297','19346','19315','19504','19296','19329') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('174') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('16158','16287','16289') LIMIT 3
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('19296','19297','19315','19329','19346','19504')
0SELECT * FROM `category` WHERE id IN ('96','107','113') 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 ('178','171') LIMIT 2
0SELECT * FROM `locality` WHERE id IN ('18433','15610') LIMIT 2
0SELECT * FROM `photos` WHERE `item_id` IN ('457164','457166','457168','457172')
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