All types
 
Français

Andrew Sheret Limited

Establishment, food, home goods store and furniture store at 2717 Columbia Avenue, Wholesale Counter, Castlegar, BC V1N 2X6, Canada. Here you will find detailed information about Andrew Sheret Limited: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Food   Home goods store   Furniture store  

Address:
2717 Columbia Avenue
Wholesale Counter
Castlegar
British Columbia V1N 2X6
Canada
Get directions

Phone:
+1 250-365-2597

Website:
sheret.com

Opening hours

Monday 07:00am — 04:30pm
Tuesday 07:00am — 04:30pm
Wednesday 07:00am — 04:30pm
Thursday 07:00am — 04:30pm
Friday 07:00am — 04:30pm
Saturday 08:00am — 04:00pm

Photos

Andrew Sheret Limited

Reviews of Andrew Sheret Limited

Sorry, but now we haven't any revews about Andrew Sheret Limited.

Add review

About sheret.com

Andrew Sheret Limited

Share this page

Additional actions

Today's weather in Castlegar

22:00 9 ℃ 1018 hPa 36 % 2 m/s

Nearest places

1SELECT * FROM `item` WHERE url = 'andrew-sheret-limited-5' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('169') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('14716') LIMIT 1
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('163683')
0SELECT * FROM `category` WHERE id IN ('96','99','128','154') LIMIT 4
1UPDATE locality SET weather = '{\"date\":\"2024-04-17\",\"data\":{\"2024-04-16\":{\"22\":{\"temp\":9,\"pressure\":1018,\"humidity\":36,\"icon\":\"04n\",\"wind\":2}},\"2024-04-17\":{\"01\":{\"temp\":5,\"pressure\":1021,\"humidity\":50,\"icon\":\"04n\",\"wind\":2},\"04\":{\"temp\":2,\"pressure\":1025,\"humidity\":77,\"icon\":\"04n\",\"wind\":2},\"07\":{\"temp\":0,\"pressure\":1028,\"humidity\":95,\"icon\":\"04n\",\"wind\":2},\"10\":{\"temp\":4,\"pressure\":1028,\"humidity\":69,\"icon\":\"03d\",\"wind\":1},\"13\":{\"temp\":8,\"pressure\":1026,\"humidity\":55,\"icon\":\"10d\",\"wind\":1},\"16\":{\"temp\":10,\"pressure\":1025,\"humidity\":54,\"icon\":\"10d\",\"wind\":1},\"19\":{\"temp\":7,\"pressure\":1026,\"humidity\":73,\"icon\":\"10d\",\"wind\":1},\"22\":{\"temp\":3,\"pressure\":1028,\"humidity\":88,\"icon\":\"13n\",\"wind\":0}},\"2024-04-18\":{\"01\":{\"temp\":1,\"pressure\":1029,\"humidity\":91,\"icon\":\"13n\",\"wind\":1},\"04\":{\"temp\":1,\"pressure\":1030,\"humidity\":93,\"icon\":\"13n\",\"wind\":1},\"07\":{\"temp\":0,\"pressure\":1030,\"humidity\":96,\"icon\":\"13n\",\"wind\":1},\"10\":{\"temp\":3,\"pressure\":1029,\"humidity\":85,\"icon\":\"13d\",\"wind\":1},\"13\":{\"temp\":7,\"pressure\":1026,\"humidity\":68,\"icon\":\"10d\",\"wind\":2},\"16\":{\"temp\":8,\"pressure\":1026,\"humidity\":62,\"icon\":\"10d\",\"wind\":1},\"19\":{\"temp\":8,\"pressure\":1025,\"humidity\":58,\"icon\":\"10d\",\"wind\":1},\"22\":{\"temp\":3,\"pressure\":1027,\"humidity\":83,\"icon\":\"13n\",\"wind\":1}}}}' WHERE id = 14716 LIMIT 1
0SELECT * FROM `locality` WHERE url = 'castlegar-bc' LIMIT 1
0SELECT * FROM `region` WHERE id = 169 LIMIT 1
1SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 163683 AND `date` < '2024-04-17 00:01:15' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('163683')
1SELECT * FROM `item` WHERE id IN ('351897','348983','351824','351848','351838','163967') LIMIT 6
1SELECT * FROM `region` WHERE id IN ('169') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('14716') LIMIT 1
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('163967','348983','351824','351838','351848','351897')
0SELECT * FROM `category` WHERE id IN ('96','118','164','97','99') LIMIT 5
0SELECT * FROM counts where updated="2024-04-17" and table_name like 'news'
0SELECT * FROM counts where updated="2024-04-17" and table_name like 'news'
0SELECT * 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 ('176','172') LIMIT 2
0SELECT * FROM `locality` WHERE id IN ('17251','15865') LIMIT 2
0SELECT * FROM `photos` WHERE `item_id` IN ('99284','99285','99286','99288')
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