Men > Cowboy Boots

Menís Cowboy Boots
Oiled Black Sq Toe Vamp, Speckle Red Stetson Mens Boots

$249.95

Stetson OILED BLACK SQ TOE VAMP, SPECKLE RED SHAFT, WALKING HEEL NATURAL OUTSOLE

Style #12-020-8801-0230RE    Product #2586



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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

1: 7 - D = 0

1: 7 - EE = 0

1: 7.5 - D = 0

1: 7.5 - EE = 0

1: 8 - D = 0

1: 8 - EE = 0

1: 8.5 - D = 0

1: 8.5 - EE = 0

1: 9 - D = 0

1: 9 - EE = 0

1: 9.5 - D = 0

1: 9.5 - EE = 0

1: 10 - D = 0

1: 10 - EE = 0

1: 10.5 - D = 0

1: 10.5 - EE = 0

1: 11 - D = 0

1: 11 - EE = 0

1: 11.5 - D = 0

1: 11.5 - EE = 0

1: 12 - D = 0

1: 12 - EE = 0

1: 13 - D = 0

1: 13 - EE = 0

1: 14 - D = 0

1: 14 - EE = 0

Karmin Importing...

2: 7 - D = 0

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

2: 7 - EE = 0

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

2: 7.5 - D = 0

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

2: 7.5 - EE = 0

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

2: 8 - D = 0

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

2: 8 - EE = 0

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

2: 8.5 - D = 0

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

2: 8.5 - EE = 0

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

2: 9 - D = 0

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

2: 9 - EE = 0

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

2: 9.5 - D = 0

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

2: 9.5 - EE = 0

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

2: 10 - D = 0

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

2: 10 - EE = 0

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

2: 10.5 - D = 0

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

2: 10.5 - EE = 0

2: 11 - D = 0

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

2: 11 - EE = 0

2: 11.5 - D = 0

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

2: 11.5 - EE = 0

2: 12 - D = 0

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

2: 12 - EE = 0

2: 13 - D = 0

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

2: 13 - EE = 0

2: 14 - D = 0

2: 14 - EE = 0

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Menís Cowboy Boots
Style #: 12-020-8801-0230RE
Product #: 2586
Short URL:

brand: stetson   View more from Stetson brand.

refine 2014-08-07 < 2014-08-13

insert into refine_assignments set parentprodid = '29840', parentid = '2586', refine_attributeid = '7', refine_categoryid = '3'

insert into refine_assignments set parentprodid = '29840', parentid = '2586', refine_attributeid = '6', refine_categoryid = '3'