Women > Boots

Womenís Boots
Brown Vamp / Red Shaft Stetson Ladies Boots

$239.95

Stetson RED SHAFT / BROWN VAMP BUCKAROO

Style #12-021-8840-0252RE    Product #1542



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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

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 = '25115'

2: 6 - nodim = 0

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

2: 6.5 - nodim = 0

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

2: 7 - nodim = 0

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

2: 7.5 - nodim = 0

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

2: 8 - nodim = 0

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

2: 8.5 - nodim = 0

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

2: 9 - nodim = 0

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

2: 9.5 - nodim = 0

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

2: 10 - nodim = 0

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

2: 10.5 - nodim = 0

2: 11 - nodim = 0

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

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Womenís Boots
Style #: 12-021-8840-0252RE
Product #: 1542
Short URL:

brand: stetson   View more from Stetson brand.

refine 2014-08-10 < 2014-08-14

insert into refine_assignments set parentprodid = '23720', parentid = '1542', refine_attributeid = '12', refine_categoryid = '3'

insert into refine_assignments set parentprodid = '23720', parentid = '1542', refine_attributeid = '6', refine_categoryid = '3'