Urban Western Wear

My Account | International Shipping | Tel: 832-369-6715     

  

cart


buy an UrbanWesternClothing.com gift card Gift Cards Available

Invitations

You have five friend invitations remaning.

Click here

 

Category: Women > Jeans


Women’s Jeans
Blue Classic Bootcut Mineral Wash Strch Stetson 816 Boot Cut Jean

$59.95


brand: stetson


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.


New Mineral 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-0090BU    Product #2751




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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

1: OO - S = 0

1: OO - R = 0

1: OO - L = 2

1: OO - XL = 0

1: OO - 2X = 4

1: O - S = 0

1: O - R = 0

1: O - L = 7

1: O - XL = 4

1: O - 2X = 4

1: 2 - S = 7

1: 2 - R = 12

1: 2 - L = 17

1: 2 - XL = 7

1: 2 - 2X = 7

1: 4 - S = 0

1: 4 - R = 22

1: 4 - L = 19

1: 4 - XL = 10

1: 4 - 2X = 4

1: 6 - S = 0

1: 6 - R = 16

1: 6 - L = 19

1: 6 - XL = 18

1: 6 - 2X = 3

1: 8 - S = 0

1: 8 - R = 6

1: 8 - L = 45

1: 8 - XL = 23

1: 8 - 2X = 0

1: 10 - S = 0

1: 10 - R = 5

1: 10 - L = 15

1: 10 - XL = 8

1: 10 - 2X = 3

1: 12 - S = 1

1: 12 - R = 12

1: 12 - L = 4

1: 12 - XL = 20

1: 12 - 2X = 0

1: 14 - S = 1

1: 14 - R = 0

1: 14 - L = 12

1: 14 - XL = 3

1: 14 - 2X = 1

1: 16 - S = 2

1: 16 - R = 1

1: 16 - L = 5

1: 16 - XL = 2

1: 16 - 2X = 2

1: 18 - S = 0

1: 18 - R = 0

1: 18 - L = 0

1: 18 - XL = 1

1: 18 - 2X = 2

Karmin Importing...

2: OO - S = 0

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

2: OO - R = 0

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

2: OO - L = 2

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

2: OO - XL = 0

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

2: OO - 2X = 4

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

2: O - S = 0

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

2: O - R = 0

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

2: O - L = 7

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

2: O - XL = 4

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

2: O - 2X = 4

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

2: 2 - S = 7

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

2: 2 - R = 12

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

2: 2 - L = 17

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

2: 2 - XL = 7

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

2: 2 - 2X = 7

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

2: 4 - S = 0

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

2: 4 - R = 22

update products set vendorinventory = '22', vendorinventorywhen=now() where prodid = '31035'

2: 4 - L = 19

update products set vendorinventory = '19', vendorinventorywhen=now() where prodid = '31036'

2: 4 - XL = 10

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

2: 4 - 2X = 4

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

2: 6 - S = 0

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

2: 6 - R = 16

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

2: 6 - L = 19

update products set vendorinventory = '19', vendorinventorywhen=now() where prodid = '31591'

2: 6 - XL = 18

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

2: 6 - 2X = 3

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

2: 8 - S = 0

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

2: 8 - R = 6

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

2: 8 - L = 45

update products set vendorinventory = '45', vendorinventorywhen=now() where prodid = '31592'

2: 8 - XL = 23

update products set vendorinventory = '23', vendorinventorywhen=now() where prodid = '33618'

2: 8 - 2X = 0

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

2: 10 - S = 0

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

2: 10 - R = 5

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

2: 10 - L = 15

update products set vendorinventory = '15', vendorinventorywhen=now() where prodid = '31593'

2: 10 - XL = 8

update products set vendorinventory = '8', vendorinventorywhen=now() where prodid = '33619'

2: 10 - 2X = 3

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

2: 12 - S = 1

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

2: 12 - R = 12

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

2: 12 - L = 4

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

2: 12 - XL = 20

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

2: 12 - 2X = 0

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

2: 14 - S = 1

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

2: 14 - R = 0

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

2: 14 - L = 12

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

2: 14 - XL = 3

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

2: 14 - 2X = 1

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

2: 16 - S = 2

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

2: 16 - R = 1

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

2: 16 - L = 5

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

2: 16 - XL = 2

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

2: 16 - 2X = 2

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

2: 18 - S = 0

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

2: 18 - R = 0

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

2: 18 - L = 0

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

2: 18 - XL = 1

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

2: 18 - 2X = 2

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

TIQ 356

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

 


Customer Reviews

Customer:
Date: July 31, 2012
Rating: 5 / 5 stars
Sizing: this product fits true to size
Comments: great length on jeans. If you are extreamly long legged these are the jeans for you!

Category: Women’s Jeans
Color: Blue

Style #: 11-054-0816-0090BU
Product #: 2751
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-04-10 < 2014-04-11

insert into refine_assignments set parentprodid = '0', parentid = '2751', refine_attributeid = '6', refine_categoryid = '3'

insert into refine_assignments set parentprodid = '0', parentid = '2751', refine_attributeid = '48', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '0', parentid = '2751', refine_attributeid = '43', refine_categoryid = '6'

Item Added to Cart

You successfully added an item to your cart.

Enter Your Email:




Payment Processing

Customer Service: 832-369-6715
Contact Us | Blogs | Facebook | Search | Sizing Charts
Coupons | Group Discounts | Site Maps
Resources | Privacy Policy | Return Policy | Gift Cards

International
Shipping

 
Join Our Email List
Email:  


updated Friday, April 18, 2014
© Copyright 2010-2014, Urban Western Wear. All rights reserved.
Photos, imagery and any other information from this site may not be used without prior written consent.

 

   THANK YOU FOR VISITING OUR SITE!