Women > Boots

Women’s Boots
Green Gr Triad Python Vamp/floral Shaft Stetson Ladies Fashion Boot

$309.95

Note: This product is in high demand, please allow extra time for delivery.


Add to Cart

 Need it fast? Some sizes are shipped next business day. Click here for availability.


Stetson Natural Triad Python with Green Embroidered Shaft
Handmade Cowboy Boot
Narrow Fashion Toe
Single Welt
All Leather Sole
Stacked Heel
Full Welt Construction
All Leather Lining
Lightly Cushioned Leather Insole
13" Shaft

Style #12-021-6102-0314GR    Product #241



update product_parents set vendorinventorywhen = now() where parentid = '241'checking inventory...

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

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

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

2: 7 - B = 0

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

2: 7.5 - B = 0

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

2: 8 - B = 0

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

2: 8.5 - B = 0

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

2: 9 - B = 0

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

2: 9.5 - B = 0

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

2: 10 - B = 0

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

2: 10.5 - B = 0

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

2: 11 - B = 0

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Women’s Boots
Style #: 12-021-6102-0314GR
Product #: 241
Short URL:

brand: stetson   View more from Stetson brand.





refine 2014-12-13 < 2014-12-14

insert into refine_assignments set parentprodid = '12200', parentid = '241', refine_attributeid = '14', refine_categoryid = '3'

insert into refine_assignments set parentprodid = '12200', parentid = '241', refine_attributeid = '6', refine_categoryid = '3'


View All Categories


Stay in touch: