Women > Shirts > Long Sleeve

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

$59.95

Note: This product is in high demand, please allow extra time for delivery.


Add to Cart

 Need it fast? Some sizes are shipped next business day. Click here for availability.


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



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-11-18 < 2014-11-19

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: