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 Emerald 18" Necklace $136.00
Sterling Silver Emerald Family 16-18"... $192.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... $348.00
14K White Created Emerald & .02 CTW D... $355.00
14K Yellow Chatham® Created Emerald &... $355.00
14K Yellow 3 mm Round May Genuine Eme... $370.00
14K Yellow 4 mm Round Chatham® Lab-Cr... $378.00
14K White Chatham® Created Emerald Cr... $388.00
14K White Created Emerald & .05 CTW D... $433.00
14K White Chatham® Created Emerald Be... $485.00
14K White Chatham® Created Emerald Pe... $548.00
14K White Emerald Cross Pendant $553.00
14K White Emerald Bezel-Set 16" Bar N... $575.00
14K Yellow Emerald Disc Pendant $753.00
14K White 8 mm Round Chatham® Created... $785.00
14K Yellow Chatham® Lab-Created Emera... $800.00
Saved Items (0)

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