Women > Shirts > Sleeveless

Women’s Sleeveless
Blue Sleevels Denim Dress Stetson Ladies Collection- Spring Ii

$87.95

Stetson Charming New Denim Dress With A Military Influence
Double Breasted With Lapel Collar
Flap Yoke On Right
Princess Seams
Self Belt
Side Seam Pockets
Dart Detail On Back Neck

Style #11-057-0594-0288BU    Product #11903

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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

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

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

2: s - nodim = 0

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

2: m - nodim = 0

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

2: l - nodim = 0

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

2: xl - nodim = 0

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

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Women’s Sleeveless
Color: Blue
Style #: 11-057-0594-0288BU
Product #: 11903
Short URL:

brand: stetson   View more from Stetson brand.





refine 2015-08-16 < 2015-08-21

insert into refine_assignments set parentprodid = '0', parentid = '11903', refine_attributeid = '40', refine_categoryid = '4'

insert into refine_assignments set parentprodid = '0', parentid = '11903', refine_attributeid = '30', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '0', parentid = '11903', refine_attributeid = '20', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '0', parentid = '11903', refine_attributeid = '21', refine_categoryid = '5'


View All Categories


Stay in touch: