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 Bar 16... $172.00
Sterling Silver 7 mm Lab-Grown Emeral... $180.00
14K Yellow 3 mm Round May Imitation E... $232.00
Sterling Silver Lab-Grown Emerald &.0... $264.00
Sterling Silver Lab-Grown Emerald & .... $308.00
14K White 22.65x11.4 mm Emerald Cross... $324.00
14K White Emerald Family Engravable B... $365.00
14K Yellow Chatham® Created Emerald &... $370.00
14K White Chatham® Created Emerald He... $373.00
14K Yellow 4 mm Round Chatham® Lab-Cr... $393.00
14K White Chatham® Created Emerald Cr... $395.00
14K White Emerald Family Heart Slide ... $410.00
14K White Chatham® Lab-Created Emeral... $513.00
14K White Chatham® Created Emerald Pe... $555.00
14K White Emerald Cross Pendant $558.00
14K White Emerald Bezel-Set 16" Bar N... $575.00
14K Yellow Emerald Disc Pendant $790.00
14K White 8 mm Round Chatham® Created... $795.00
Saved Items (0)

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