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 '%Emerald%' OR product.display_sku LIKE '%Emerald%' OR product.title LIKE 'Emerald%' OR product.title LIKE '% Emerald%' OR product.metal_type LIKE '%Emerald%') AND product_category.category_id = '626' AND product_category.category_id = category.id AND product.id = product_category.product_id Emerald
Sterling Silver Imitation Emerald 16"... $100.00
Sterling Silver Emerald 18" Necklace $136.00
Sterling Silver Emerald Family 16-18"... $188.00
Sterling Silver Lab-Grown Emerald &.0... $264.00
Sterling Silver 7 mm Lab-Grown Emeral... $288.00
Sterling Silver Lab-Grown Emerald & .... $304.00
14K White Chatham® Created Emerald He... $335.00
14K White Created Emerald & .02 CTW D... $348.00
14K Yellow Chatham® Created Emerald &... $348.00
14K White Chatham® Created Emerald Cr... $383.00
14K Yellow Emerald "May" Birthstone 1... $390.00
14K White Created Emerald & .05 CTW D... $425.00
14K White Chatham® Created Emerald Be... $473.00
14K White Chatham® Created Emerald Pe... $545.00
14K White Emerald Cross Pendant $555.00
14K White Emerald Bezel-Set 16" Bar N... $565.00
14K Yellow Emerald Disc Pendant $740.00
14K White 8 mm Round Chatham® Created... $770.00
14K Yellow Chatham® Created Emerald &... $792.00
Saved Items (0)

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