IMG
Loading..
Select a color
8" X 45" Paisley Collection Silk Scarves Maroon-Blue
Item: TS-PAIS-0323-845

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

QTY:
List Price:
Maroon and blue 100% silk, 8" x 45" Paisley patterned wet dyed scarf. Available in black and grey paisley, navy blue and maroon paisley, maroon and blue paisley, and gold and blue paisley. Complimenting tie available. Embroidery and screen 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` = 'TS-PAIS-0323-845') 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`