Women > Shirts > Long Sleeve

Women’s Long Sleeve
Brown Leopard Print Burnout Dress Stetson Ladies Collection- Winter I

$77.95

Stetson Darling New Dress In Fun Leopard Printed Burnout
Shirred Bodice Flatters Every Figure
Slight Fullness In Skirt
3/4 Sleeve
Scoop Neck With Binding
Coverstitched Hems
Fully Lined

Style #11-057-0513-0100BR    Product #4515



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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

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 = '38786'

2: m - nodim = 0

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

2: l - nodim = 0

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

2: xl - nodim = 0

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

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Women’s Long Sleeve
Color: Brown
Style #: 11-057-0513-0100BR
Product #: 4515
Short URL:

brand: stetson   View more from Stetson brand.

refine 2014-08-13 < 2014-08-14

insert into refine_assignments set parentprodid = '38786', parentid = '4515', refine_attributeid = '6', refine_categoryid = '3'