Men > Cowboy Boots

Menís Cowboy Boots
Brown Vamp With White Shaft Stetson Handmade Boots

$249.95

Stetson Oiled Chocolate Vamp
White Shaft
R Toe
Single Welt
All Leather Sole
Lemonwood Peg And Brass Nail Construction
1-1/2" Stacked Heel
13" Shaft
All Leather Lining
Lightly Cushioned Comfort Insole
10-Row Stitching
Slotted & Stitched Pulls

Style #12-020-7302-0234WH    Product #4310



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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

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

1: 15 - D = 0

1: 15 - EE = 0

Karmin Importing...

2: 7 - D = 0

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

2: 8 - EE = 0

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

2: 8.5 - D = 0

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

2: 8.5 - EE = 0

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

2: 9 - D = 0

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

2: 9 - EE = 0

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

2: 9.5 - D = 0

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

2: 9.5 - EE = 0

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

2: 10 - D = 0

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

2: 10 - EE = 0

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

2: 10.5 - D = 0

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

2: 10.5 - EE = 0

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

2: 11 - D = 0

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

2: 11 - EE = 0

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

2: 11.5 - D = 0

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

2: 11.5 - EE = 0

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

2: 12 - D = 0

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

2: 12 - EE = 0

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

2: 13 - D = 0

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

2: 13 - EE = 0

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

2: 14 - D = 0

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

2: 14 - EE = 0

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

2: 15 - D = 0

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

2: 15 - EE = 0

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Menís Cowboy Boots
Style #: 12-020-7302-0234WH
Product #: 4310
Short URL:

brand: stetson   View more from Stetson brand.

refine 2014-08-25 < 2014-08-26

insert into refine_assignments set parentprodid = '38552', parentid = '4310', refine_attributeid = '12', refine_categoryid = '3'

insert into refine_assignments set parentprodid = '38552', parentid = '4310', refine_attributeid = '8', refine_categoryid = '3'



Stay in touch: