Women > Shirts > Sleeveless

Women’s Sleeveless
Blue 7522 Patchwork Denim Dress Stetson Ladies Collection- Summer Ii

$109.95

Stetson Playful New Sundress
Patchwork Denim In 3 Shades Of Blue
Spaghetti Straps Adjust With A Tie In Back
Contrasting Raw-Edge Trim On Hem And Bodice
Fully Lined
Garment Washed For Softness

Style #11-057-0594-0438BU    Product #2835



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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

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

2: m - nodim = 0

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

2: l - nodim = 0

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

2: xl - nodim = 0

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

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Women’s Sleeveless
Style #: 11-057-0594-0438BU
Product #: 2835
Short URL:

brand: stetson   View more from Stetson brand.





refine 2014-11-15 < 2014-11-16

insert into refine_assignments set parentprodid = '30622', parentid = '2835', refine_attributeid = '9', refine_categoryid = '3'

insert into refine_assignments set parentprodid = '30622', parentid = '2835', refine_attributeid = '40', refine_categoryid = '4'

insert into refine_assignments set parentprodid = '30622', parentid = '2835', refine_attributeid = '27', refine_categoryid = '5'

insert into refine_assignments set parentprodid = '30622', parentid = '2835', refine_attributeid = '23', refine_categoryid = '5'


View All Categories


Stay in touch: