Women > Outerwear

Womenís Outerwear
Blue Jean Jacket W/angled Flap Pkts Stetson Ladies- Spring I

$99.95

Classic Updated Jean Jacket
Angled Flap Pockets
Light Vapor Wash
Princess Seams
2 Btn Adjustable Cuff
1 Point Curved Back Yoke
Stetson Embroidery Above Back Yoke

Style #11-098-0594-0300BU    Product #1437

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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

1: s - nodim = 0

1: m - nodim = 0

1: l - nodim = 0

1: xl - nodim = 0

Karmin Importing...

2: s - nodim = 0

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

2: m - nodim = 0

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

2: l - nodim = 0

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

2: xl - nodim = 0

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

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Womenís Outerwear
Color: Blue
Style #: 11-098-0594-0300BU
Product #: 1437
Short URL:

brand: stetson   View more from Stetson brand.





refine 2015-03-21 < 2015-03-23

insert into refine_assignments set parentprodid = '22574', parentid = '1437', refine_attributeid = '25', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '22574', parentid = '1437', refine_attributeid = '30', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '22574', parentid = '1437', refine_attributeid = '20', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '22574', parentid = '1437', refine_attributeid = '21', refine_categoryid = '5'


View All Categories


Stay in touch: