Crystal Lake Golf Course

Establishment at 128 Lakeview Drive, Stenen, SK S0A 3X0, Canada. Here you will find detailed information about Crystal Lake Golf Course: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment  

Address:
128 Lakeview Drive
Stenen
Saskatchewan S0A 3X0
Canada
Get directions

Phone:
+1 306-548-5522

Website:
crystallakegolfcourse.ca

Photos

Reviews of Crystal Lake Golf Course

Sorry, but now we haven't any revews about Crystal Lake Golf Course.

Add review

About crystallakegolfcourse.ca

Crystal Lake Golf Course | Sturgis, Saskatchewan
The nine hole course offers wide fairways, reachable greens, strategically placed sand traps & mature trees. Lakeview Dr, Sturgis, SK
Course, Crystal, Golf, Lake, Lakeview Dr, Sturgis

1SELECT * FROM `item` WHERE url = 'crystal-lake-golf-course' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('179') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('18851') LIMIT 1
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('222215')
0SELECT * FROM `category` WHERE id IN ('96') LIMIT 1
0SELECT * FROM `locality` WHERE url = 'stenen-sk' LIMIT 1
0SELECT * FROM `region` WHERE id = 179 LIMIT 1
1SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 222215 AND `date` < '2024-04-18 15:59:40' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('222215')
1SELECT * FROM `item` WHERE id IN ('222249','222015','225776','225482','225576','225554') LIMIT 6
0SELECT * FROM `region` WHERE id IN ('179') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('18851') LIMIT 1
3SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('222015','222249','225482','225554','225576','225776')
2SELECT * FROM `category` WHERE id IN ('96','97','130','99','133','169','98') LIMIT 7
0SELECT * FROM counts where updated="2024-04-18" and table_name like 'news'
0SELECT * FROM counts where updated="2024-04-18" 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 ('179','168','169') LIMIT 3
0SELECT * FROM `locality` WHERE id IN ('18874','14658','14781') LIMIT 3
0SELECT * FROM `photos` WHERE `item_id` IN ('282818','282819','282822','282823')
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