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 Destructed Ink Wash Denim Jean Stetson 816 Boot Cut Jean

$64.95

brand: stetson


Add to Cart

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


New Destructed Ink Finish
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-0070BU    Product #2748




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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

1: OO - S = 8

1: OO - R = 8

1: OO - L = 7

1: OO - XL = 20

1: OO - 2X = 0

1: O - S = 34

1: O - R = 39

1: O - L = 38

1: O - XL = 14

1: O - 2X = 13

1: 2 - S = 13

1: 2 - R = 41

1: 2 - L = 42

1: 2 - XL = 13

1: 2 - 2X = 14

1: 4 - S = 7

1: 4 - R = 43

1: 4 - L = 49

1: 4 - XL = 26

1: 4 - 2X = 12

1: 6 - S = 17

1: 6 - R = 37

1: 6 - L = 50

1: 6 - XL = 42

1: 6 - 2X = 13

1: 8 - S = 30

1: 8 - R = 60

1: 8 - L = 73

1: 8 - XL = 24

1: 8 - 2X = 10

1: 10 - S = 25

1: 10 - R = 72

1: 10 - L = 70

1: 10 - XL = 38

1: 10 - 2X = 11

1: 12 - S = 28

1: 12 - R = 71

1: 12 - L = 46

1: 12 - XL = 31

1: 12 - 2X = 10

1: 14 - S = 36

1: 14 - R = 47

1: 14 - L = 48

1: 14 - XL = 30

1: 14 - 2X = 6

1: 16 - S = 27

1: 16 - R = 65

1: 16 - L = 13

1: 16 - XL = 14

1: 16 - 2X = 17

1: 18 - S = 41

1: 18 - R = 41

1: 18 - L = 11

1: 18 - XL = 8

1: 18 - 2X = 6

Karmin Importing...

2: OO - S = 8

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

2: OO - R = 8

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

2: OO - L = 7

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

2: OO - XL = 20

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

2: OO - 2X = 0

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

2: O - S = 34

update products set vendorinventory = '34', vendorinventorywhen=now() where prodid = '67826'

2: O - R = 39

update products set vendorinventory = '39', vendorinventorywhen=now() where prodid = '63136'

2: O - L = 38

update products set vendorinventory = '38', vendorinventorywhen=now() where prodid = '61324'

2: O - XL = 14

update products set vendorinventory = '14', vendorinventorywhen=now() where prodid = '72227'

2: O - 2X = 13

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

2: 2 - S = 13

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

2: 2 - R = 41

update products set vendorinventory = '41', vendorinventorywhen=now() where prodid = '30499'

2: 2 - L = 42

update products set vendorinventory = '42', vendorinventorywhen=now() where prodid = '31091'

2: 2 - XL = 13

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

2: 2 - 2X = 14

update products set vendorinventory = '14', vendorinventorywhen=now() where prodid = '30500'

2: 4 - S = 7

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

2: 4 - R = 43

update products set vendorinventory = '43', vendorinventorywhen=now() where prodid = '30501'

2: 4 - L = 49

update products set vendorinventory = '49', vendorinventorywhen=now() where prodid = '31092'

2: 4 - XL = 26

update products set vendorinventory = '26', vendorinventorywhen=now() where prodid = '31620'

2: 4 - 2X = 12

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

2: 6 - S = 17

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

2: 6 - R = 37

update products set vendorinventory = '37', vendorinventorywhen=now() where prodid = '31093'

2: 6 - L = 50

update products set vendorinventory = '50', vendorinventorywhen=now() where prodid = '31094'

2: 6 - XL = 42

update products set vendorinventory = '42', vendorinventorywhen=now() where prodid = '31621'

2: 6 - 2X = 13

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

2: 8 - S = 30

update products set vendorinventory = '30', vendorinventorywhen=now() where prodid = '30504'

2: 8 - R = 60

update products set vendorinventory = '60', vendorinventorywhen=now() where prodid = '31095'

2: 8 - L = 73

update products set vendorinventory = '73', vendorinventorywhen=now() where prodid = '31622'

2: 8 - XL = 24

update products set vendorinventory = '24', vendorinventorywhen=now() where prodid = '33876'

2: 8 - 2X = 10

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

2: 10 - S = 25

update products set vendorinventory = '25', vendorinventorywhen=now() where prodid = '30506'

2: 10 - R = 72

update products set vendorinventory = '72', vendorinventorywhen=now() where prodid = '30507'

2: 10 - L = 70

update products set vendorinventory = '70', vendorinventorywhen=now() where prodid = '31096'

2: 10 - XL = 38

update products set vendorinventory = '38', vendorinventorywhen=now() where prodid = '31623'

2: 10 - 2X = 11

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

2: 12 - S = 28

update products set vendorinventory = '28', vendorinventorywhen=now() where prodid = '30509'

2: 12 - R = 71

update products set vendorinventory = '71', vendorinventorywhen=now() where prodid = '31097'

2: 12 - L = 46

update products set vendorinventory = '46', vendorinventorywhen=now() where prodid = '31624'

2: 12 - XL = 31

update products set vendorinventory = '31', vendorinventorywhen=now() where prodid = '33877'

2: 12 - 2X = 10

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

2: 14 - S = 36

update products set vendorinventory = '36', vendorinventorywhen=now() where prodid = '30510'

2: 14 - R = 47

update products set vendorinventory = '47', vendorinventorywhen=now() where prodid = '31098'

2: 14 - L = 48

update products set vendorinventory = '48', vendorinventorywhen=now() where prodid = '31625'

2: 14 - XL = 30

update products set vendorinventory = '30', vendorinventorywhen=now() where prodid = '34167'

2: 14 - 2X = 6

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

2: 16 - S = 27

update products set vendorinventory = '27', vendorinventorywhen=now() where prodid = '30511'

2: 16 - R = 65

update products set vendorinventory = '65', vendorinventorywhen=now() where prodid = '31099'

2: 16 - L = 13

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

2: 16 - XL = 14

update products set vendorinventory = '14', vendorinventorywhen=now() where prodid = '34169'

2: 16 - 2X = 17

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

2: 18 - S = 41

update products set vendorinventory = '41', vendorinventorywhen=now() where prodid = '30512'

2: 18 - R = 41

update products set vendorinventory = '41', vendorinventorywhen=now() where prodid = '45065'

2: 18 - L = 11

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

2: 18 - XL = 8

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

2: 18 - 2X = 6

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

TIQ 1609

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

 

We are currently gathering reviews for this product.

Category: Women’s Jeans
Color: Blue

Style #: 11-054-0816-0070BU
Product #: 2748
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 2013-05-12 < 2013-05-14

insert into refine_assignments set parentprodid = '30464', parentid = '2748', refine_attributeid = '6', refine_categoryid = '3'

insert into refine_assignments set parentprodid = '30464', parentid = '2748', refine_attributeid = '40', refine_categoryid = '4'

insert into refine_assignments set parentprodid = '30464', parentid = '2748', refine_attributeid = '48', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '30464', parentid = '2748', refine_attributeid = '43', refine_categoryid = '6'

Item Added to Cart

You successfully added an item to your cart.

Enter Your Email:




Payment Processing



updated Tuesday, May 21, 2013
© Copyright 2010-2013, 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!