Women > Boots

Womenís Boots
Oak Shaft Tan Rough Out-cowboy Heel Ladiesí Stetson Boots

$229.95

Stetson Rough-Out Leather Vamp
Oak Shaft
Horseman Handmade
Medium Square Toe
Double Welt
All Leather Sole
Lemonwood Peg And Brass Nail Construction
Stacked Heel
All Leather Lining
Lightly Cushioned Insole
11" Shaft Contrasting Collar

Style #12-021-8201-0307TA    Product #274



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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

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

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

2: 5.5 - B = 0

2: 6 - B = 0

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

2: 6.5 - B = 0

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

2: 7 - B = 0

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

2: 7.5 - B = 0

2: 8 - B = 0

2: 8.5 - B = 0

2: 9 - B = 0

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

2: 9.5 - B = 0

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

2: 10 - B = 0

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

2: 10.5 - B = 0

2: 11 - B = 0

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

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Womenís Boots
Color: Tan
Style #: 12-021-8201-0307TA
Product #: 274
Short URL:

brand: stetson   View more from Stetson brand.





refine 2014-10-22 < 2014-10-24

insert into refine_assignments set parentprodid = '12233', parentid = '274', refine_attributeid = '27', refine_categoryid = '5'


View All Categories


Stay in touch: