Urban Western Wear logo

My Account | International Shipping | Tel: 832-369-6715     

  

cart


buy an UrbanWesternClothing.com gift card Gift Cards Available

Invitations

You have five friend invitations remaning.

Click here

 

Category: Men > Cowboy Boots


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


$249.95

brand: stetson

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-07-19 < 2014-07-22

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'

Item Added to Cart

You successfully added an item to your cart.

Enter Your Email:




Payment Processing

Customer Service: 832-369-6715
Contact Us | Blogs | Facebook | Search | Sizing Charts
Coupons | Group Discounts | Site Maps
Resources | Privacy Policy | Return Policy | Gift Cards

International
Shipping

 
Join Our Email List
Email:  


updated Tuesday, July 29, 2014
© Copyright 2010-2014, Urban Western Wear. All rights reserved.
Photos, imagery and any other information from this site may not be used without prior written consent.

   THANK YOU FOR VISITING OUR SITE!