IMG
Loading..
Select a color
“Cashmere”-Like, V-Neck Long Sleeve Pullover
Item: 5CB-2009
Brand: Cobmex

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

QTY:
List Price:
100% Durapil Ultra™ Acrylic

Durapil Ultra™ by Cobmex is the most technologically advanced anti-pilling treatment applied to acrylic yarn. Rigorous lab tests and market research have shown unprecedented durability and pill control that result in garments that last longer and continue to feel great. Following the wash/care instructions of these garments will ensure their long lasting quality, wear after wear and wash after wash. That’s the Cobmex assurance.
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` = '5CB-2009') 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`