Men > Cowboy Boots

Menís Cowboy Boots
Brown Green Shaft With Tan Upper-roper Heel Menís Stetson Boots

$229.95

Stetson Rustic Brown Vamp With Olive Shaft
Medium Sq.Toe
Single Welt
All Leather Sole
Lemonwood Peg And Brass Nail Construction
Roper Heel With Spur Ridge
All Leather Lining
Lightly Cushioned Comfort Insole
10-Row Stitching
Slotted & Stitched Pulls

Style #12-020-8602-0308BR    Product #52



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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

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

2: 7 - EE = 0

2: 7.5 - D = 0

2: 7.5 - EE = 0

2: 8 - D = 0

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

2: 8 - EE = 0

2: 8.5 - D = 0

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

2: 8.5 - EE = 0

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

2: 9 - D = 0

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

2: 9 - EE = 0

2: 9.5 - D = 0

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

2: 9.5 - EE = 0

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

2: 10 - D = 0

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

2: 10 - EE = 0

2: 10.5 - D = 0

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

2: 10.5 - EE = 0

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

2: 11 - D = 0

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

2: 11 - EE = 0

2: 11.5 - D = 0

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

2: 11.5 - EE = 0

2: 12 - D = 0

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

2: 12 - EE = 0

2: 13 - D = 0

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

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 = '10167' and parentid='52'

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

 

We are currently gathering reviews for this product.


Category: Menís Cowboy Boots
Style #: 12-020-8602-0308BR
Product #: 52
Short URL:

brand: stetson   View more from Stetson brand.

refine 2014-08-09 < 2014-08-13

insert into refine_assignments set parentprodid = '10167', parentid = '52', refine_attributeid = '12', refine_categoryid = '3'

insert into refine_assignments set parentprodid = '10167', parentid = '52', refine_attributeid = '14', refine_categoryid = '3'