Women > Shirts > Long Sleeve

Women’s Long Sleeve
Green 7556 Brushed Twill Tarnich Plaid Dress Stetson Ladies Collection- Fall Iii

$98.95

Stetson Beautiful Tarnish Plaid In Soft Brushed Twill
Darling New Dress Shape
Lapel Collar
1 Open Pkt
Fitted Waistband With Self Belt
Turned-Up Cuff With Mixed Metal Stud Detail

Style #11-057-0565-0650GR    Product #3547



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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

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

2: m - nodim = 0

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

2: l - nodim = 0

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

2: xl - nodim = 0

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

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Women’s Long Sleeve
Color: Green
Style #: 11-057-0565-0650GR
Product #: 3547
Short URL:

brand: stetson   View more from Stetson brand.

refine 2014-10-12 < 2014-10-14

insert into refine_assignments set parentprodid = '32678', parentid = '3547', refine_attributeid = '2', refine_categoryid = '1'

insert into refine_assignments set parentprodid = '32678', parentid = '3547', refine_attributeid = '59', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '32678', parentid = '3547', refine_attributeid = '58', refine_categoryid = '6'



Stay in touch: