Women > Jeans

Women’s Jeans
Black 214 City Trouser/grey Denim -long Only Stetson Ladies Denim

$49.95

Note: This product is in high demand, please allow extra time for delivery.


Add to Cart

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


Trouser Style Western Jean
Sits Low On The Waist
Moderately Fit Thigh W/Slightly Flared Leg
2 Button Flap Exaggerated Waist Band
Keystone Back Belt Loop
Stetson Branded Buttons, Rivets And Zippers
Blasting Detail

Style #11-054-0594-1602BL    Product #213



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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

1: O - nodim = 0

1: 2 - nodim = 0

1: 4 - nodim = 0

1: 6 - nodim = 0

1: 8 - nodim = 0

1: 10 - nodim = 0

1: 12 - nodim = 0

1: 14 - nodim = 0

1: 16 - nodim = 0

1: 18 - nodim = 0

Karmin Importing...

2: O - nodim = 0

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

2: 2 - nodim = 0

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

2: 4 - nodim = 0

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

2: 6 - nodim = 0

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

2: 8 - nodim = 0

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

2: 10 - nodim = 0

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

2: 12 - nodim = 0

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

2: 14 - nodim = 0

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

2: 16 - nodim = 0

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

2: 18 - nodim = 0

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

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Women’s Jeans
Color: Black
Style #: 11-054-0594-1602BL
Product #: 213
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-11-19 < 2014-11-20

insert into refine_assignments set parentprodid = '12023', parentid = '213', refine_attributeid = '6', refine_categoryid = '3'

insert into refine_assignments set parentprodid = '12023', parentid = '213', refine_attributeid = '40', refine_categoryid = '4'

insert into refine_assignments set parentprodid = '12023', parentid = '213', refine_attributeid = '30', refine_categoryid = '5'


View All Categories


Stay in touch: