Women > Shirts > Sleeveless

Women’s Sleeveless
Blue 5158 Peri Petals, Printed Lawn Stetson Ladies- Spring 1 Group

$39.95

Stetson Classic Sleeveless Style
Beautifully Colored Floral Print On Cotton Lawn
Self- Piped Curved Front & Back Yokes
Curved Pkt Flaps
Front, Back & Bust Darts For A Great Fit

Style #11-052-0590-0206BU    Product #995



We're sorry. This product is currently out of stock.

Notify me when you have my size in stock!

update product_parents set vendorinventorywhen = now() where parentid = '995'checking inventory...

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

update product_parents set nextdelivery = '' where parentid = '995'

1: xs - nodim = 0

1: s - nodim = 0

1: m - nodim = 0

1: l - nodim = 0

1: xl - nodim = 0

1: 1x - nodim = 0

1: 2x - nodim = 0

1: 3x - nodim = 0

Karmin Importing...

2: xs - nodim = 0

2: s - nodim = 0

update products set vendorinventory = '0', vendorinventorywhen=now() where prodid = '15621'

2: m - nodim = 0

2: l - nodim = 0

2: xl - nodim = 0

2: 1x - nodim = 0

2: 2x - nodim = 0

2: 3x - nodim = 0

TIQ 0

update products set vendorinventory = '0', vendorinventorywhen=now() , vendorpermoos = 'y' where prodid = '15621' and parentid='995'

update product_parents set vendorinventory = '0', vendorinventorywhen=now() , vendorpermoos = 'y' where parentid='995'

 

We are currently gathering reviews for this product.


Category: Women’s Sleeveless
Color: Blue
Style #: 11-052-0590-0206BU
Product #: 995
Short URL:

brand: stetson   View more from Stetson brand.





refine 2014-12-06 < 2014-12-13

insert into refine_assignments set parentprodid = '15621', parentid = '995', refine_attributeid = '6', refine_categoryid = '3'

insert into refine_assignments set parentprodid = '15621', parentid = '995', refine_attributeid = '17', refine_categoryid = '4'

insert into refine_assignments set parentprodid = '15621', parentid = '995', refine_attributeid = '30', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '15621', parentid = '995', refine_attributeid = '21', refine_categoryid = '5'


View All Categories


Stay in touch: