Women > Boots

Women’s Boots
Oiled Black W/embroidered Vamp&heel Stetson Ladies Embroidered Vamp Boot

$249.95

Stetson Embroidered Black Vamp and Shaft
Handmade Cowboy Boot
Snip Toe
Single Welt All Leather Sole
Lemonwood And Brass Nail Construction Stacked Heel
All Leather Lining
Lightly Cushioned Insole
9" Shaft

Style #12-021-6104-0533BL    Product #255



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 = '255'checking inventory...

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

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

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

2: 5.5 - nodim = 0

2: 6 - nodim = 0

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

2: 6.5 - nodim = 0

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

2: 7 - nodim = 0

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

2: 7.5 - nodim = 0

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

2: 8 - nodim = 0

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

2: 8.5 - nodim = 0

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

2: 9 - nodim = 0

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

2: 9.5 - nodim = 0

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

2: 10 - nodim = 0

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

2: 10.5 - nodim = 0

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

2: 11 - nodim = 0

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

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Women’s Boots
Style #: 12-021-6104-0533BL
Product #: 255
Short URL:

brand: stetson   View more from Stetson brand.

refine 2014-08-29 < 2014-09-11

insert into refine_assignments set parentprodid = '12214', parentid = '255', refine_attributeid = '7', refine_categoryid = '3'

insert into refine_assignments set parentprodid = '12214', parentid = '255', refine_attributeid = '6', refine_categoryid = '3'



Stay in touch: