Women > Shirts > Sleeveless

Women’s Sleeveless
Green Mosaic Mirror Border Print Dress Stetson Ladies Collection- Spring Ii

$89.95

Note: This product is in high demand, please allow extra time for delivery.


Add to Cart

 Need it fast? Some sizes are shipped next business day. Click here for availability.


Stetson Fun And Flirty Sundress
Mosaic Border Printed Chiffon
Adjustable Spaghetti Straps
Self Spaghetti Tie At Neck
Flowing Ruffle Bodice
Full Skirt
Knee Length
Engineered Border Placement
Fully Lined

Style #11-057-0590-0282GR    Product #11902



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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

1: xs - nodim = 3

1: s - nodim = 26

1: m - nodim = 34

1: l - nodim = 37

1: xl - nodim = 18

Karmin Importing...

2: xs - nodim = 3

update products set vendorinventory = '3', vendorinventorywhen=now() where prodid = '102836'

2: s - nodim = 26

update products set vendorinventory = '26', vendorinventorywhen=now() where prodid = '102837'

2: m - nodim = 34

update products set vendorinventory = '34', vendorinventorywhen=now() where prodid = '102838'

2: l - nodim = 37

update products set vendorinventory = '37', vendorinventorywhen=now() where prodid = '102839'

2: xl - nodim = 18

update products set vendorinventory = '18', vendorinventorywhen=now() where prodid = '102840'

TIQ 118

update product_parents set vendorinventorywhen=now(), vendorpermoos = '' where parentid='11902'

 

We are currently gathering reviews for this product.


Category: Women’s Sleeveless
Color: Green
Style #: 11-057-0590-0282GR
Product #: 11902
Short URL:

brand: stetson   View more from Stetson brand.





refine 2014-10-23 < 2014-10-24

insert into refine_assignments set parentprodid = '0', parentid = '11902', refine_attributeid = '6', refine_categoryid = '3'


View All Categories


Stay in touch: