Welcome, | Logout
IMG
Loading..
Select a color
Female Lab Coat
Item: 1PN-L17F

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

QTY:
List Price:
The last thing you need to worry about is the fit and durability of your lab coat. Our Women's Button Lab Coat is designed with classic styling and comfort in mind. This lab coat features an adjustable belt back, five buttons down the front, side slit access and three outside pockets in three color options. Made with soil release and wrinkle resistant fabric, our women's lab coat will maintain a clean, professional appearance. These are non-stock items and would require a specialty order to be made, which usually includes a 12 pcs minimum, up charge, and 6-8 week turnaround time.
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` = '1PN-L17F') 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`