Women > Boots

Women’s Boots
Hand Tinted Red Vamp Shaft, Snip Toe Stetson Ladies Boots

$239.95

Stetson HAND TINTED RED VAMP/SHAFT, SNIP TOE
BLACK LOW STACKED HEEL & OUTSOLE

Style #12-021-6104-0583RE    Product #1567



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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

1: 5 - B = 0

1: 5.5 - B = 0

1: 6 - B = 0

1: 6.5 - B = 0

1: 7 - B = 0

1: 7.5 - B = 0

1: 8 - B = 0

1: 8.5 - B = 0

1: 9 - B = 0

1: 9.5 - B = 0

1: 10 - B = 0

1: 10.5 - B = 0

1: 11 - B = 0

Karmin Importing...

2: 5 - B = 0

2: 5.5 - B = 0

2: 6 - B = 0

2: 6.5 - B = 0

2: 7 - B = 0

2: 7.5 - B = 0

2: 8 - B = 0

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

2: 8.5 - B = 0

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

2: 9 - B = 0

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

2: 9.5 - B = 0

2: 10 - B = 0

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

2: 10.5 - B = 0

2: 11 - B = 0

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

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Women’s Boots
Style #: 12-021-6104-0583RE
Product #: 1567
Short URL:

brand: stetson   View more from Stetson brand.

refine 2014-08-22 < 2014-08-23

insert into refine_assignments set parentprodid = '23745', parentid = '1567', refine_attributeid = '7', refine_categoryid = '3'

insert into refine_assignments set parentprodid = '23745', parentid = '1567', refine_attributeid = '6', refine_categoryid = '3'

insert into refine_assignments set parentprodid = '23745', parentid = '1567', refine_attributeid = '41', refine_categoryid = '5'



Stay in touch: