Welcome, | Logout
IMG
Loading..
Select a color
Mercer+Mettle Stretch Pique Henley
Item: 8MM-MM1008
Brand: Mercer+Mettle

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

QTY:
List Price:
Borrowing a classic polo's fit and rib knit trim this modern Henley lends styling versatility and casual ease to any scenario. The fabric offers just enough stretch and moisture wicking making it perfect for work or weekend wear. Rimmed black satin-finished buttons accent the neckline while notch vents finish the hem.Fabric+Weight 5.5-ounce 55/40/5 cotton/poly/spandex diamond piqueFeatures+Benefits Moisture-wicking 3-button placket Rimmed black satin-finished buttons Ribbed cuffs Self-turned hem Notched vents
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` = '8MM-MM1008') 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`