Women > Shirts > Long Sleeve

Women’s Long Sleeve
Blue Modern Rose Print Stetson Ladies Collection- Spring Ii

$59.95

Stetson Beautiful Modern Rose Print On Lightweight Voile
1 Point Frt & Bk Yokes
Special Topstitched Princess Seams On Front & Back
1 Point Pockets & Flaps
Classic Pearl Snaps
Logo Embroidery On Front Placket

Style #11-050-0590-0231BU    Product #2536

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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

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 = '29757'

2: m - nodim = 0

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

2: l - nodim = 0

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

2: xl - nodim = 0

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

2: 1x - nodim = 0

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

2: 2x - nodim = 0

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

2: 3x - nodim = 0

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Women’s Long Sleeve
Color: Blue
Style #: 11-050-0590-0231BU
Product #: 2536
Short URL:

brand: stetson   View more from Stetson brand.





refine 2014-10-22 < 2014-10-24

insert into refine_assignments set parentprodid = '29757', parentid = '2536', refine_attributeid = '4', refine_categoryid = '2'

insert into refine_assignments set parentprodid = '29757', parentid = '2536', refine_attributeid = '25', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '29757', parentid = '2536', refine_attributeid = '30', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '29757', parentid = '2536', refine_attributeid = '20', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '29757', parentid = '2536', refine_attributeid = '21', refine_categoryid = '5'


View All Categories


Stay in touch: