Men > Shirts > Long Sleeve

Menís Long Sleeve
Blue Chocolate Royal Plaid Flat Weave 9164 Stetson Men’s Collection- Summer Ii

$69.95

Stetson Y/D Plaid
1 Point. Ultra Deep Curved Bk Yoke
Stetson "S" Emb
"Stetson" Emb On Rt. Sleeve Placket
Contrast Inside Trim
Cover Stitch On Hem
3 Snap Cuff
Classic Snap Front Featuring Logo Snaps

Style #11-001-0478-0440BU    Product #12545

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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

1: s - nodim = 0

1: m - nodim = 0

1: l - nodim = 0

1: xl - nodim = 0

1: 2xl - nodim = 0

1: 3xl - nodim = 0

Karmin Importing...

2: s - nodim = 0

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

2: m - nodim = 0

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

2: l - nodim = 0

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

2: xl - nodim = 0

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

2: 2xl - nodim = 0

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

2: 3xl - nodim = 0

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

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Menís Long Sleeve
Color: Blue
Style #: 11-001-0478-0440BU
Product #: 12545
Short URL:

brand: stetson   View more from Stetson brand.





refine 2016-04-26 < 2016-04-28

insert into refine_assignments set parentprodid = '0', parentid = '12545', refine_attributeid = '2', refine_categoryid = '1'

insert into refine_assignments set parentprodid = '0', parentid = '12545', refine_attributeid = '4', refine_categoryid = '2'

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

insert into refine_assignments set parentprodid = '0', parentid = '12545', refine_attributeid = '21', refine_categoryid = '5'


View Homepage


Stay in touch: