Welcome, | Logout
IMG
Loading..
Select a color
Bar Apron
Item: 4PN-APBSP

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

QTY:
List Price:
Easy to maintain and highly durable, our bar apron stands up to the busiest kitchens and restaurants. The apron is perfectly sized to protect your other layers from stains and spills. Made from 100% spun polyester, this soft cloth stands up to industrial wash.

Features:
  • 6.5 oz. poplin
  • 100% spun polyester
  • 40" tubular ties
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` = '4PN-APBSP') 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`