Men > Shirts > Short Sleeve

Menís Short Sleeve
Blue Twin Peak Ombre Flat Weave 7878 Stetson Men’s Collection- Spring I

$64.95

Stetson Classic Plaid
1 Point. Deep Curved Back Yoke
Stetson "S" Emb
Classic Snap Front Featuring Logo Snaps

Style #11-002-0478-0248BU    Product #5237



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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

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

2: m - nodim = 0

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

2: l - nodim = 0

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

2: xl - nodim = 0

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

2: 2xl - nodim = 0

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

2: 3xl - nodim = 0

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Menís Short Sleeve
Color: Blue
Style #: 11-002-0478-0248BU
Product #: 5237
Short URL:

brand: stetson   View more from Stetson brand.





refine 2014-12-11 < 2014-12-12

insert into refine_assignments set parentprodid = '42205', parentid = '5237', refine_attributeid = '2', refine_categoryid = '1'

insert into refine_assignments set parentprodid = '42205', parentid = '5237', refine_attributeid = '4', refine_categoryid = '2'

insert into refine_assignments set parentprodid = '42205', parentid = '5237', refine_attributeid = '21', refine_categoryid = '5'


View All Categories


Stay in touch: