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: Women > Boots


Women’s Boots
Hand Tinted Red Vamp Shaft, Snip Toe Stetson Ladies Boots


$239.95

brand: stetson

Stetson HAND TINTED RED VAMP/SHAFT, SNIP TOE
BLACK LOW STACKED HEEL & OUTSOLE


Style #12-021-6104-0583RE    Product #1567




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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

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

2: 5.5 - B = 0

2: 6 - B = 0

2: 6.5 - B = 0

2: 7 - B = 0

2: 7.5 - B = 0

2: 8 - B = 0

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

2: 8.5 - B = 0

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

2: 9 - B = 0

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

2: 9.5 - B = 0

2: 10 - B = 0

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

2: 10.5 - B = 0

2: 11 - B = 0

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

TIQ 0

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

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

 

We are currently gathering reviews for this product.

Category: Women’s Boots

Style #: 12-021-6104-0583RE
Product #: 1567
Short URL:


brand: stetson   View more from Stetson brand.


refine 2014-07-19 < 2014-07-24

insert into refine_assignments set parentprodid = '23745', parentid = '1567', refine_attributeid = '7', refine_categoryid = '3'

insert into refine_assignments set parentprodid = '23745', parentid = '1567', refine_attributeid = '6', refine_categoryid = '3'

insert into refine_assignments set parentprodid = '23745', parentid = '1567', refine_attributeid = '41', refine_categoryid = '5'

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 Thursday, July 31, 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!