Women > Shirts > Long Sleeve

Women’s Long Sleeve
Red Cotton Jersey Cap Sleeve Dress Stetson Ladies Collection- Summer I

$117.95

Stetson Crisp White Embroidery Contrasts Beautifully On This Red Dress
Cotton Jersey Fabric
Cap Sleeve
V Neck With Raw Edge Band
Raw Edge Hems
Handkerchief Hem

Style #11-057-0513-0489RE    Product #12708

View more: Western Shirts



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 = '12708'checking inventory...

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

1: xs - nodim = 0

1: s - nodim = 0

1: m - nodim = 0

1: l - nodim = 0

1: xl - nodim = 0

Karmin Importing...

2: xs - nodim = 0

2: s - nodim = 0

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

2: m - nodim = 0

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

2: l - nodim = 0

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

2: xl - nodim = 0

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

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Women’s Long Sleeve
Style #: 11-057-0513-0489RE
Product #: 12708
Short URL:

brand: stetson   View more from Stetson brand.





refine 2014-10-24 < 2014-10-25

insert into refine_assignments set parentprodid = '0', parentid = '12708', refine_attributeid = '6', refine_categoryid = '3'

insert into refine_assignments set parentprodid = '0', parentid = '12708', refine_attributeid = '8', refine_categoryid = '3'

insert into refine_assignments set parentprodid = '0', parentid = '12708', refine_attributeid = '17', refine_categoryid = '4'

insert into refine_assignments set parentprodid = '0', parentid = '12708', refine_attributeid = '27', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '0', parentid = '12708', refine_attributeid = '25', refine_categoryid = '5'


View All Categories


Stay in touch: