Urban Western Wear

My Account | Coupons    

  

cart

buy an UrbanWesternClothing.com gift card Gift Cards Available

Invitations

You have five friend invitations remaning.

Click here

 

Category: Men > Shirts > Long Sleeve

Men’s Long Sleeve
White Star Dobby Stripe Flat Weave W/dobby Stetson Men’s Collection- Spring I
$64.95


brand: stetson


Category: Men’s Long Sleeve
Stetson Y/D Stripe W/Dobby
Straight Back Yoke W/Pleat
Stetson "S" Emb
"Stetson" Emb On Right Sleeve Placket
Contrast Thread Color
2 Btn Adjustable Mitered Edge Cuff
Triple Needle Stitch On Bk Yoke
Classic Logo Btn Front

Color: White





Style Number: 11-001-0575-0356WH
Product Number: #2485


We're sorry. This product is currently out of stock.


Notify me when you have my size in stock!


brand: stetson
Brand: View more from Stetson


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

Opening connection to Karman, Inc...

Automatically checking vendor inventory...

1: s - nodim = 0

1: m - nodim = 0

1: l - nodim = 0

1: xl - nodim = 0

1: 2xl - nodim = 0

1: 3xl - nodim = 0

Karmin Importing...

2: s - nodim = 0

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

2: m - nodim = 0

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

2: l - nodim = 0

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

2: xl - nodim = 0

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

2: 2xl - nodim = 0

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

2: 3xl - nodim = 0

TIQ 0

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

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

refine 2012-05-03 < 2012-05-18

insert into refine_assignments set parentprodid = '29629', parentid = '2485', refine_attributeid = '3', refine_categoryid = '1'

insert into refine_assignments set parentprodid = '29629', parentid = '2485', refine_attributeid = '6', refine_categoryid = '3'

insert into refine_assignments set parentprodid = '29629', parentid = '2485', refine_attributeid = '27', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '29629', parentid = '2485', refine_attributeid = '28', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '29629', parentid = '2485', refine_attributeid = '21', refine_categoryid = '5'

Item Added to Cart

You successfully added an item to your cart.




updated Friday, May 25, 2012
© Copyright 2010-2012, 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!