Women > Shirts > Sleeveless

Women’s Sleeveless
Tin Haul White Tank With Buddah Riding Horse

$24.95

Tin Haul WHITE 2nd

Style #10-037-0501-0120WH    Product #2871



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

Opening connection to Karman, Inc...


Automatically checking vendor inventory....

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

1: s - nodim = 0

1: m - nodim = 0

1: l - nodim = 0

Karmin Importing...

2: s - nodim = 0

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

2: m - nodim = 0

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

2: l - nodim = 0

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

TIQ 0

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

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

 

We are currently gathering reviews for this product.


Category: Women’s Sleeveless
Style #: 10-037-0501-0120WH
Product #: 2871
Short URL:

brand: tin haul   View more from Tin Haul brand.

refine 2014-10-17 < 2014-10-18

insert into refine_assignments set parentprodid = '30658', parentid = '2871', refine_attributeid = '8', refine_categoryid = '3'


View All Categories


Stay in touch: