Welcome, | Logout
IMG
Loading..
Select a color
Portwest US476 Berlin Executive Hi-Vis Vest
Item: 4PW-US476
Brand: PortWest

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

QTY:
List Price:
Revolutionary in its design the executive vest combines the light weight of a waistcoat with the practicality of pockets for those situations when a jacket may be too warm. A clear ID pocket for security passes and cards compliments this unique garment. With many companies and their operatives now using combinations of visibility orange and yellow fabrics together these contrasting styles are in increasing demand for many customers. Dimensions are 20" x 11" x 17"
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` = '4PW-US476') 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`