Welcome, | Logout
IMG
Loading..
Select a color
Ladies Tunic, Short Sleeves
Item: 8PN-LT10

Oppps.. This color is currently out-of stock, Please contact us for availablitiy.

QTY:
List Price:
A staple in the hospitality industry, our Women's Short Sleeve Tunic Top is made to keep you looking great no matter how long the workday. This top is crafted with comfort and durability in mind. Made with soil release and wrinkle resistant fabric, it will hold up to the rigors of industrial laundering wash after wash. The tunic top coordinates with our LP11 and features two pockets and pearl buttons.
SELECT `I`.`ListID`, `I`.`ProductID`, `I`.`ItemGroup`, `I`.`ItemColorID`, `I`.`ItemColor`, `I`.`ItemSizeOnly` AS `ItemSize`, `I`.`ItemLength`, `I`.`RequiredAlterationID`, `I`.`ProspectItem`, MAX(`S`.CatID) AS CatID, `I`.`SalesPrice`,`I`.`SalesPrice` AS `WebPrice`, `I`.`AltShowListID`, `I`.`InventoryOnly` FROM `tbl_items` `I` LEFT JOIN `tbl_items_search` `S` ON (`I`.`ItemID`=`S`.`ItemID`) AND (`S`.`CatID` = '2076') WHERE (`I`.`ItemGroup` = '8PN-LT10') AND (`I`.`ShowOnlyLocal` = '1') AND (`I`.`IsActive` != '0') AND (`I`.`SpecialGroupID` Is Null OR `I`.`SpecialGroupID` = '0') GROUP BY `I`.`ListID` ORDER BY `I`.`ProspectItem`, IFNULL(`I`.`ItemColor`,'ZZZZZZ'),`I`.`SizeSort`,`I`.`ItemSize`, `I`.`ItemLength`