SELECT product.*, product_category.category_id AS product_category_id FROM product, category, product_category WHERE product.status = '1' AND category.status = '1' AND (product.sku LIKE '%Amethyst%' OR product.display_sku LIKE '%Amethyst%' OR product.title LIKE 'Amethyst%' OR product.title LIKE '% Amethyst%' OR product.metal_type LIKE '%Amethyst%') AND product_category.category_id = '622' AND product_category.category_id = category.id AND product.id = product_category.product_id Amethyst
Sterling Silver Amethyst Family 16-18... $84.00
Sterling Silver 2 mm Round Amethyst B... $124.00
Sterling Silver London Blue Topaz, Br... $164.00
Sterling Silver Amethyst & .01 CTW Di... $168.00
Sterling Silver Amethyst & .015 CTW D... $184.00
14K White Amethyst Pendant $195.00
Sterling Silver Amethyst & .01 CTW Di... $200.00
14K Yellow 6 mm Amethyst Heart Pendant $200.00
Sterling Silver Amethyst Double Heart... $204.00
14K Yellow 3 mm Round February Imitat... $220.00
14K Yellow Amethyst Pendant $260.00
14K Yellow 22.65x11.4 mm Amethyst Cro... $276.00
Sterling Silver Amethyst & Cubic Zirc... $284.00
14K White Amethyst & .02 CTW Diamond ... $300.00
14K White Amethyst Cross Pendant $308.00
14K White 4 mm Round Amethyst Bezel-S... $313.00
14K White 4 mm Round Amethyst Birthst... $313.00
14K Yellow Amethyst Cross 16-18" Neck... $323.00
14K White Amethyst Solitaire 16" Neck... $325.00
Saved Items (0)

Use this space to save the products you like. To add a product here, simply click the icon.