Women > Boots

Women’s Boots
Short Black Distressed Washed With Side Zip Stetson Ladies Washed & Distressed Side Zip Shorty

$239.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.


Stetson Hand Sanded
Washed and Distressed
Cowboy Boot
Narrow Toe
Single Welt All Leather Sole
Lemonwood And Brass Nail Construction Stacked Heel
All Leather Lining
Lightly Cushioned Insole
Rugged Side Zip
7" Shaft

Style #12-021-5102-0524BL    Product #1582



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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

1: 5 - nodim = 0

1: 5.5 - nodim = 0

1: 6 - nodim = 0

1: 6.5 - nodim = 0

1: 7 - nodim = 0

1: 7.5 - nodim = 0

1: 8 - nodim = 0

1: 8.5 - nodim = 0

1: 9 - nodim = 0

1: 9.5 - nodim = 0

1: 10 - nodim = 0

1: 10.5 - nodim = 0

1: 11 - nodim = 0

Karmin Importing...

2: 5 - nodim = 0

2: 5.5 - nodim = 0

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

2: 6 - nodim = 0

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

2: 6.5 - nodim = 0

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

2: 7 - nodim = 0

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

2: 7.5 - nodim = 0

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

2: 8 - nodim = 0

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

2: 8.5 - nodim = 0

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

2: 9 - nodim = 0

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

2: 9.5 - nodim = 0

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

2: 10 - nodim = 0

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

2: 10.5 - nodim = 0

2: 11 - nodim = 0

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

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Women’s Boots
Color: Black
Style #: 12-021-5102-0524BL
Product #: 1582
Short URL:

brand: stetson   View more from Stetson brand.





refine 2014-11-15 < 2014-11-16

insert into refine_assignments set parentprodid = '23760', parentid = '1582', refine_attributeid = '7', refine_categoryid = '3'


View All Categories


Stay in touch: