Women > Boots

Women’s Boots
Stetson Blue Emerald Green Vamp Orange Shaft

$224.95

Stetson x

Style #12-021-8801-0672BU    Product #13602

We're sorry. This product is currently out of stock.

Notify me when you have my size in stock!



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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

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: 11 - nodim = 0

Karmin Importing...

2: 5 - nodim = 0

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

2: 5.5 - nodim = 0

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

2: 6 - nodim = 0

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

2: 6.5 - nodim = 0

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

2: 7 - nodim = 0

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

2: 7.5 - nodim = 0

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

2: 8 - nodim = 0

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

2: 8.5 - nodim = 0

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

2: 9 - nodim = 0

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

2: 9.5 - nodim = 0

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

2: 10 - nodim = 0

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

2: 11 - nodim = 0

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Women’s Boots
Color: Blue
Style #: 12-021-8801-0672BU
Product #: 13602
Short URL:

brand: stetson   View more from Stetson brand.





refine 2015-04-08 < 2015-04-11

insert into refine_assignments set parentprodid = '0', parentid = '13602', refine_attributeid = '14', refine_categoryid = '3'

insert into refine_assignments set parentprodid = '0', parentid = '13602', refine_attributeid = '11', refine_categoryid = '3'

insert into refine_assignments set parentprodid = '0', parentid = '13602', refine_attributeid = '13', refine_categoryid = '3'


View All Categories


Stay in touch: