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 '%Pink Tourmaline%' OR product.display_sku LIKE '%Pink Tourmaline%' OR product.title LIKE 'Pink Tourmaline%' OR product.title LIKE '% Pink Tourmaline%' OR product.metal_type LIKE '%Pink Tourmaline%') AND product_category.category_id = '682' AND product_category.category_id = AND = product_category.product_id Pink Tourmaline

Pink Tourmaline

Sterling Silver Imitation Pink Tourma... $120.00
Saved Items (0)

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