Women > Shirts > Long Sleeve

Women’s Long Sleeve
Blue Atlantic Ombre Plaid Dress Stetson Ladies Collection- Winter I

$94.95

Stetson Stunning Ombre Plaid In A Fun New Dress Body
Full Trapeze Styling Looks Great Left Full Or Belted
1 Point Frt & Bk Yokes
Angled 1 Point Pocket
Roll Up Sleeves
Pullover Styling With Front Placket
Frt & Bk Princess Seams

Style #11-057-0597-0104BU    Product #4516

View more: Western Shirts



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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

1: xs - nodim = 0

1: s - nodim = 0

1: m - nodim = 0

1: l - nodim = 0

1: xl - nodim = 0

Karmin Importing...

2: xs - nodim = 0

2: s - nodim = 0

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

2: m - nodim = 0

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

2: l - nodim = 0

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

2: xl - nodim = 0

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

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Women’s Long Sleeve
Color: Blue
Style #: 11-057-0597-0104BU
Product #: 4516
Short URL:

brand: stetson   View more from Stetson brand.





refine 2014-10-22 < 2014-10-25

insert into refine_assignments set parentprodid = '38787', parentid = '4516', refine_attributeid = '2', refine_categoryid = '1'

insert into refine_assignments set parentprodid = '38787', parentid = '4516', refine_attributeid = '20', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '38787', parentid = '4516', refine_attributeid = '21', refine_categoryid = '5'


View All Categories


Stay in touch: