Category: Women > Shirts > Sleeveless

Women’s Sleeveless Green Plaid Flannel 7135c3 Stetson Ladies Original Rugged Collection $49.95 Category: Women’s Sleeveless Stetson Cool Details Make This Flannel Shirt Special Bias Yokes, Pkts/Flaps, Placket & Inside Trim Contrasting Coverstitch Detail On Yokes & Cuff Matte Finish Snaps W/Contrasting Snaps On Cuffs Color: Green >>> Click here to check current inventory Style Number: 11-050-0597-0781GR Product Number: #2808 We're sorry. This product is currently out of stock. Notify me when you have my size in stock! Brand: View more from Stetson

refine 2012-05-14 < 2012-05-16

insert into refine_assignments set parentprodid = '30595', parentid = '2808', refine_attributeid = '2', refine_categoryid = '1'

insert into refine_assignments set parentprodid = '30595', parentid = '2808', refine_attributeid = '4', refine_categoryid = '2'

insert into refine_assignments set parentprodid = '30595', parentid = '2808', refine_attributeid = '14', refine_categoryid = '3'

insert into refine_assignments set parentprodid = '30595', parentid = '2808', refine_attributeid = '27', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '30595', parentid = '2808', refine_attributeid = '30', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '30595', parentid = '2808', refine_attributeid = '21', refine_categoryid = '5'