Women > Jeans

Women’s Jeans
Blue Ink Wash Denim Jean Stetson 816 Boot Cut Jean

$59.95

Add to Cart

 Need it fast? Some sizes are shipped next business day. Click here for availability.


New Ink Wash
Sits Low On The Waist
Slim Fit Thigh With Slightly Flared Leg
Tonal Decorative "S" Stitching On Back Pkts
Stetson Branded Buttons, Rivets And Zippers
Blasting and Whisker Details

Style #11-054-0816-0080BU    Product #2749



update product_parents set vendorinventorywhen = now() where parentid = '2749'checking inventory...

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

1: OO - S = 4

1: OO - R = 4

1: OO - L = 6

1: OO - XL = 5

1: OO - 2X = 5

1: O - S = 5

1: O - R = 20

1: O - L = 13

1: O - XL = 17

1: O - 2X = 12

1: 2 - S = 7

1: 2 - R = 9

1: 2 - L = 18

1: 2 - XL = 5

1: 2 - 2X = 0

1: 4 - S = 10

1: 4 - R = 17

1: 4 - L = 20

1: 4 - XL = 11

1: 4 - 2X = 1

1: 6 - S = 1

1: 6 - R = 2

1: 6 - L = 16

1: 6 - XL = 3

1: 6 - 2X = 0

1: 8 - S = 4

1: 8 - R = 4

1: 8 - L = 10

1: 8 - XL = 5

1: 8 - 2X = 2

1: 10 - S = 5

1: 10 - R = 4

1: 10 - L = 20

1: 10 - XL = 3

1: 10 - 2X = 0

1: 12 - S = 4

1: 12 - R = 5

1: 12 - L = 3

1: 12 - XL = 4

1: 12 - 2X = 0

1: 14 - S = 3

1: 14 - R = 0

1: 14 - L = 5

1: 14 - XL = 1

1: 14 - 2X = 1

1: 16 - S = 1

1: 16 - R = 0

1: 16 - L = 3

1: 16 - XL = 1

1: 16 - 2X = 0

1: 18 - S = 0

1: 18 - R = 0

1: 18 - L = 3

1: 18 - XL = 0

1: 18 - 2X = 0

Karmin Importing...

2: OO - S = 4

update products set vendorinventory = '4', vendorinventorywhen=now() where prodid = '43223'

2: OO - R = 4

update products set vendorinventory = '4', vendorinventorywhen=now() where prodid = '43427'

2: OO - L = 6

update products set vendorinventory = '6', vendorinventorywhen=now() where prodid = '34284'

2: OO - XL = 5

update products set vendorinventory = '5', vendorinventorywhen=now() where prodid = '34903'

2: OO - 2X = 5

update products set vendorinventory = '5', vendorinventorywhen=now() where prodid = '43224'

2: O - S = 5

update products set vendorinventory = '5', vendorinventorywhen=now() where prodid = '67827'

2: O - R = 20

update products set vendorinventory = '20', vendorinventorywhen=now() where prodid = '68419'

2: O - L = 13

update products set vendorinventory = '13', vendorinventorywhen=now() where prodid = '61325'

2: O - XL = 17

update products set vendorinventory = '17', vendorinventorywhen=now() where prodid = '72333'

2: O - 2X = 12

update products set vendorinventory = '12', vendorinventorywhen=now() where prodid = '72334'

2: 2 - S = 7

update products set vendorinventory = '7', vendorinventorywhen=now() where prodid = '34285'

2: 2 - R = 9

update products set vendorinventory = '9', vendorinventorywhen=now() where prodid = '30513'

2: 2 - L = 18

update products set vendorinventory = '18', vendorinventorywhen=now() where prodid = '31075'

2: 2 - XL = 5

update products set vendorinventory = '5', vendorinventorywhen=now() where prodid = '34286'

2: 2 - 2X = 0

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

2: 4 - S = 10

update products set vendorinventory = '10', vendorinventorywhen=now() where prodid = '30514'

2: 4 - R = 17

update products set vendorinventory = '17', vendorinventorywhen=now() where prodid = '31076'

2: 4 - L = 20

update products set vendorinventory = '20', vendorinventorywhen=now() where prodid = '31583'

2: 4 - XL = 11

update products set vendorinventory = '11', vendorinventorywhen=now() where prodid = '36516'

2: 4 - 2X = 1

update products set vendorinventory = '1', vendorinventorywhen=now() where prodid = '34287'

2: 6 - S = 1

update products set vendorinventory = '1', vendorinventorywhen=now() where prodid = '30515'

2: 6 - R = 2

update products set vendorinventory = '2', vendorinventorywhen=now() where prodid = '31077'

2: 6 - L = 16

update products set vendorinventory = '16', vendorinventorywhen=now() where prodid = '31584'

2: 6 - XL = 3

update products set vendorinventory = '3', vendorinventorywhen=now() where prodid = '35958'

2: 6 - 2X = 0

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

2: 8 - S = 4

update products set vendorinventory = '4', vendorinventorywhen=now() where prodid = '30516'

2: 8 - R = 4

update products set vendorinventory = '4', vendorinventorywhen=now() where prodid = '31078'

2: 8 - L = 10

update products set vendorinventory = '10', vendorinventorywhen=now() where prodid = '31079'

2: 8 - XL = 5

update products set vendorinventory = '5', vendorinventorywhen=now() where prodid = '31585'

2: 8 - 2X = 2

update products set vendorinventory = '2', vendorinventorywhen=now() where prodid = '43227'

2: 10 - S = 5

update products set vendorinventory = '5', vendorinventorywhen=now() where prodid = '30517'

2: 10 - R = 4

update products set vendorinventory = '4', vendorinventorywhen=now() where prodid = '31080'

2: 10 - L = 20

update products set vendorinventory = '20', vendorinventorywhen=now() where prodid = '31586'

2: 10 - XL = 3

update products set vendorinventory = '3', vendorinventorywhen=now() where prodid = '34288'

2: 10 - 2X = 0

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

2: 12 - S = 4

update products set vendorinventory = '4', vendorinventorywhen=now() where prodid = '30519'

2: 12 - R = 5

update products set vendorinventory = '5', vendorinventorywhen=now() where prodid = '31081'

2: 12 - L = 3

update products set vendorinventory = '3', vendorinventorywhen=now() where prodid = '31587'

2: 12 - XL = 4

update products set vendorinventory = '4', vendorinventorywhen=now() where prodid = '34289'

2: 12 - 2X = 0

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

2: 14 - S = 3

update products set vendorinventory = '3', vendorinventorywhen=now() where prodid = '30520'

2: 14 - R = 0

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

2: 14 - L = 5

update products set vendorinventory = '5', vendorinventorywhen=now() where prodid = '31588'

2: 14 - XL = 1

update products set vendorinventory = '1', vendorinventorywhen=now() where prodid = '34290'

2: 14 - 2X = 1

update products set vendorinventory = '1', vendorinventorywhen=now() where prodid = '43229'

2: 16 - S = 1

update products set vendorinventory = '1', vendorinventorywhen=now() where prodid = '30521'

2: 16 - R = 0

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

2: 16 - L = 3

update products set vendorinventory = '3', vendorinventorywhen=now() where prodid = '31589'

2: 16 - XL = 1

update products set vendorinventory = '1', vendorinventorywhen=now() where prodid = '43230'

2: 16 - 2X = 0

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

2: 18 - S = 0

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

2: 18 - R = 0

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

2: 18 - L = 3

update products set vendorinventory = '3', vendorinventorywhen=now() where prodid = '45062'

2: 18 - XL = 0

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

2: 18 - 2X = 0

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

TIQ 302

update product_parents set vendorinventorywhen=now(), vendorpermoos = '' where parentid='2749'

 

We are currently gathering reviews for this product.


Category: Women’s Jeans
Color: Blue
Style #: 11-054-0816-0080BU
Product #: 2749
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-08-25 < 2014-08-26

insert into refine_assignments set parentprodid = '30465', parentid = '2749', refine_attributeid = '6', refine_categoryid = '3'

insert into refine_assignments set parentprodid = '30465', parentid = '2749', refine_attributeid = '40', refine_categoryid = '4'

insert into refine_assignments set parentprodid = '30465', parentid = '2749', refine_attributeid = '48', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '30465', parentid = '2749', refine_attributeid = '43', refine_categoryid = '6'



Stay in touch: