IMG
Loading..
Select a color
Woman's Scarf In Mercury Silver
Item: TS-CS0633D

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

QTY:
List Price:
Pull together a business savvy look in a snap with the help of this beautifully designed and hued Womens Scarf in Mercury Silver. The satin finished fabric adds a touch of elegance to anything it is paired with.This designer piece mixes and matches with absolutely everything in your wardrobe from business suits to casual attire. Designed by the Puccini Fashion House and made from a stain resistant microfiber.Size: 27" x 27"
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-CS0633D') 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`