Suzy Shier

Establishment and clothing store at 1300 Saint Peter Avenue, Bathurst, NB E2A 3A6, Canada. Here you will find detailed information about Suzy Shier: address, phone, fax, opening hours, customer reviews, photos, directions and more.

Contacts

Categories:
Establishment   Clothing store  

Address:
1300 Saint Peter Avenue
Bathurst
New Brunswick E2A 3A6
Canada
Get directions

Phone:
+1 506-546-6316

Website:
suzyshier.com

Reviews of Suzy Shier

Sorry, but now we haven't any revews about Suzy Shier.

Add review

About suzyshier.com

Suzy Shier Online Store - women's fashion, shoes & accessories
Suzy Shier Online Store - women's fashion, shoes & accessories
Suzy, Suzy Shier, Suzy Sheer, Suzie Shier, Suzy Sheir, Suzie Sheir, Suzie Sheer, Suzi Shier, Suzi Sheer, Suzy Shier clothing, Suzy clothing, Suzy Sheer clothing, Suzy Shier fashion, Suzy fashion, Suzy Sheer fashion, women's clothing, womens clothing, women's fashion, womens fashion, clothing store, fashion clothing, women's clothing store, womens clothing store, womens fashion store, womens store, tops, shirts, blouses, sweaters, tees, tanks, t-shirts, pants, dress pants, career pants, capris, shorts, dress

1SELECT * FROM `item` WHERE url = 'suzy-shier-31' LIMIT 1
0SELECT * FROM `region` WHERE id IN ('171') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('15395') LIMIT 1
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('87642')
0SELECT * FROM `category` WHERE id IN ('96','148') LIMIT 2
0SELECT * FROM `locality` WHERE url = 'bathurst-nb' LIMIT 1
0SELECT * FROM `region` WHERE id = 171 LIMIT 1
1SELECT * FROM `reviews` WHERE `status` = 1 AND `item_id` = 87642 AND `date` < '2024-04-19 22:42:50' ORDER BY `date` DESC
0SELECT * FROM `photos` WHERE `item_id` IN ('87642')
2SELECT * FROM `item` WHERE id IN ('87364','87415','87514','87531','87542','87546') LIMIT 6
1SELECT * FROM `region` WHERE id IN ('171') LIMIT 1
1SELECT * FROM `locality` WHERE id IN ('15395') LIMIT 1
2SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('87364','87415','87514','87531','87542','87546')
1SELECT * FROM `category` WHERE id IN ('96','122','128','154','149','165','152') LIMIT 7
0SELECT * FROM counts where updated="2024-04-19" and table_name like 'news'
0SELECT * FROM counts where updated="2024-04-19" and table_name like 'news'
1SELECT * 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 ('178') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('17957','18421') LIMIT 2
0SELECT * FROM `photos` WHERE `item_id` IN ('90895','90896','90897','90898')
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