Greenwater Cabin Rentals

Establishment, lodging, real estate agency and travel agency at 108 Ash Street, Porcupine Plain, SK S0E 1H0, Canada. Here you will find detailed information about Greenwater Cabin Rentals: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Lodging   Real estate agency   Travel agency  

Address:
108 Ash Street
Porcupine Plain
Saskatchewan S0E 1H0
Canada
Get directions

Phone:
+1 306-278-3033

Website:
greenwatercabinrentals.com

Reviews of Greenwater Cabin Rentals

Sorry, but now we haven't any revews about Greenwater Cabin Rentals.

Add review

About greenwatercabinrentals.com

Greenwater Cabin Rentals Ltd. - Home
Greenwater Cabin Rentals Ltd. boasts 28 cabins (18 winterized) in a variety of styles form the non-modern cabins by the lake front, to the modern and standard cabins by the beach, and finally the cedar and log cabins with natural gas fireplaces on the hill across from the marina.

1SELECT * FROM `item` WHERE url = 'greenwater-cabin-rentals' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('179') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('18786') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('233226')
0SELECT * FROM `category` WHERE id IN ('96','107','129','159') LIMIT 4
0SELECT * FROM `locality` WHERE url = 'porcupine-plain-sk' LIMIT 1
0SELECT * FROM `region` WHERE id = 179 LIMIT 1
1SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 233226 AND `date` < '2024-04-27 19:28:04' ORDER BY `date` DESC
1SELECT * FROM `photos` WHERE `item_id` IN ('233226')
1SELECT * FROM `item` WHERE id IN ('232958','233004','233005','233015','233016','233028') LIMIT 6
1SELECT * FROM `region` WHERE id IN ('179') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('18786') LIMIT 1
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('232958','233004','233005','233015','233016','233028')
0SELECT * FROM `category` WHERE id IN ('96','99','125') LIMIT 3
0SELECT * FROM counts where updated="2024-04-27" and table_name like 'news'
1SELECT * FROM counts where updated="2024-04-27" 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
0SELECT * FROM `region` WHERE id IN ('178','176') LIMIT 2
0SELECT * FROM `locality` WHERE id IN ('18260','17059','17860','17894') LIMIT 4
0SELECT * FROM `photos` WHERE `item_id` IN ('370859','370860','370861','370864')
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 ('176') LIMIT 1