Women > Jeans

Women’s Jeans
Blue 816 Classic Boot Cut/sinister Abraided Stetson Ladies No. 816-special Edition Flap Back Pocket Jean

$69.95

5 Pocket Stretch Jean In New Wash And Finish
Flap Back Pockets
Sits Low On Waist
Slim Fit Through Thigh
Slightly Flared Leg
Stetson Brand Buttons, Rivets, And Zippers

Style #11-054-0816-0052BU    Product #198



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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

1: O - 32 = 0

1: O - 34 = 0

1: O - 36 = 0

1: 2 - 32 = 0

1: 2 - 34 = 0

1: 2 - 36 = 0

1: 4 - 32 = 0

1: 4 - 34 = 0

1: 4 - 36 = 0

1: 6 - 32 = 0

1: 6 - 34 = 0

1: 6 - 36 = 0

1: 8 - 32 = 0

1: 8 - 34 = 0

1: 8 - 36 = 0

1: 10 - 32 = 0

1: 10 - 34 = 0

1: 10 - 36 = 0

1: 12 - 32 = 0

1: 12 - 34 = 0

1: 12 - 36 = 0

1: 14 - 32 = 0

1: 14 - 34 = 0

1: 14 - 36 = 0

1: 16 - 32 = 0

1: 16 - 34 = 0

Karmin Importing...

2: O - 32 = 0

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

2: O - 34 = 0

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

2: O - 36 = 0

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

2: 2 - 32 = 0

2: 2 - 34 = 0

2: 2 - 36 = 0

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

2: 4 - 32 = 0

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

2: 4 - 34 = 0

2: 4 - 36 = 0

2: 6 - 32 = 0

2: 6 - 34 = 0

2: 6 - 36 = 0

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

2: 8 - 32 = 0

2: 8 - 34 = 0

2: 8 - 36 = 0

2: 10 - 32 = 0

2: 10 - 34 = 0

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

2: 10 - 36 = 0

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

2: 12 - 32 = 0

2: 12 - 34 = 0

2: 12 - 36 = 0

2: 14 - 32 = 0

2: 14 - 34 = 0

2: 14 - 36 = 0

2: 16 - 32 = 0

2: 16 - 34 = 0

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Women’s Jeans
Color: Blue
Style #: 11-054-0816-0052BU
Product #: 198
Short URL:

Stetson Jeans Inseam (length) Fit Guide
30" S - Short
32" R - Regular
34" L - Long
36" XL - X-Long
38" XXL - XX-Long

brand: stetson   View more from Stetson brand.

refine 2014-09-03 < 2014-09-10

insert into refine_assignments set parentprodid = '11705', parentid = '198', refine_attributeid = '6', refine_categoryid = '3'

insert into refine_assignments set parentprodid = '11705', parentid = '198', refine_attributeid = '48', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '11705', parentid = '198', refine_attributeid = '30', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '11705', parentid = '198', refine_attributeid = '20', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '11705', parentid = '198', refine_attributeid = '43', refine_categoryid = '6'



Stay in touch: