Women > Shirts > Long Sleeve

Women’s Long Sleeve
6335 Scroll Jacquard - Brown Stetson Ladies Premier Quality Collection

$109.95

Stetson Elegant Silk/Cotton Jacquard Solids With Scroll Motif
Self-Piped 1 Point Frt & Bk Yokes
1 Point Pkts W/Curved Flaps
3 Snap Cuff W/Piping
Curved Triple Dart Detail On Back
Classic Pearl Snap

Style #11-050-1201-0707BR    Product #1149



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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

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

2: m - nodim = 0

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

2: l - nodim = 0

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

2: xl - nodim = 0

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

2: 1x - nodim = 0

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

2: 2x - nodim = 0

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

2: 3x - nodim = 0

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Women’s Long Sleeve
Color: Brown
Style #: 11-050-1201-0707BR
Product #: 1149
Short URL:

brand: stetson   View more from Stetson brand.

refine 2014-07-23 < 2014-07-26

insert into refine_assignments set parentprodid = '16190', parentid = '1149', refine_attributeid = '1', refine_categoryid = '1'

insert into refine_assignments set parentprodid = '16190', parentid = '1149', refine_attributeid = '4', refine_categoryid = '2'

insert into refine_assignments set parentprodid = '16190', parentid = '1149', refine_attributeid = '12', refine_categoryid = '3'

insert into refine_assignments set parentprodid = '16190', parentid = '1149', refine_attributeid = '17', refine_categoryid = '4'

insert into refine_assignments set parentprodid = '16190', parentid = '1149', refine_attributeid = '30', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '16190', parentid = '1149', refine_attributeid = '21', refine_categoryid = '5'