IMG
Loading..
Select a color
Solid Color Silk Tie Red
Item: TD-SCS-003

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

QTY:
List Price:
Red 100% silk neck tie; 58" standard length. Available in white, black, navy blue, red, maroon, royal blue, hunter green, kelly green, purple, grey, charcoal grey, gold, pink, brown, champagne beige, yellow, french blue, turquoise, lime green, vegas gold, athletic gold, teal, violet, orange and fuchsia. Complimenting scarf available. Screen printing, laser etching, laser sheen and pad printing available - 3" x 3" maximum imprint area. Price shown is for the blank item only and does not include decoration.
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` = 'TD-SCS-003') 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`