Welcome, | Logout
IMG
Loading..
Select a color
SOLID COLOR POLYESTER TIE GOLD
Item: TD-SCP-011-058

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

QTY:
List Price:
Gold 100% polyester 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. Embroidery, screen printing, laser etching, laser sheen, pad printing and debossing 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-SCP-011-058') 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`