Category: Men > Outerwear

Men’s Outerwear Brown Garment Washed Leather Blazer Stetson Men’s Collection-outerwear $349.95 Choose Size SM out of stock $349.95 Category: Men’s Outerwear Stetson Rich Tobacco Brown Leather Blazer Distressed & Washed Leather Shell 1 Point Flaps on Frt Welt Pkts Single Welt Pkt On Left Chest Classic Lapel Shape Western Cuff >>> Click here to check current inventory Style Number: 11-097-0539-0613BR Product Number: #2079 Notify me when you have my size in stock! Brand: View more from Stetson update product_parents set vendorinventorywhen = now() where parentid = '2079'checking inventory... Opening connection to Karman, Inc...

refine 2012-05-15 < 2012-05-16

insert into refine_assignments set parentprodid = '27979', parentid = '2079', refine_attributeid = '12', refine_categoryid = '3'

insert into refine_assignments set parentprodid = '27979', parentid = '2079', refine_attributeid = '30', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '27979', parentid = '2079', refine_attributeid = '23', refine_categoryid = '5'