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 '%Aquamarine%' OR product.display_sku LIKE '%Aquamarine%' OR product.title LIKE 'Aquamarine%' OR product.title LIKE '% Aquamarine%' OR product.metal_type LIKE '%Aquamarine%') AND product_category.category_id = '623' AND product_category.category_id = category.id AND product.id = product_category.product_id Aquamarine
Sterling Silver Aquamarine Family Bar... $112.00
14K White 3 mm Round March Imitation ... $236.00
14K Yellow 4 mm Round Aquamarine Birt... $243.00
14K White Youth Aquamarine Pendant $280.00
14K Yellow Aquamarine Cross Pendant $300.00
14K White Aquamarine Heart 16" Neckla... $378.00
14K White Aquamarine & .02 CTW Diamon... $380.00
14K White Aquamarine Bezel-Set 16" Ba... $388.00
14K White 4 mm Round Aquamarine Bezel... $390.00
14K White Aquamarine & .02 CTW Diamon... $395.00
14K White Aquamarine Pierced Cross Di... $440.00
14K White Aquamarine Cross Pendant $455.00
14K White Aquamarine Cross 16-18" Nec... $490.00
14K White Aquamarine Solitaire 16-18"... $525.00
14K Rose Aquamarine Bezel-Set Bar 18"... $543.00
Sterling Silver Aquamarine & .01 CTW ... $556.00
14K Yellow Aquamarine & 1/5 CTW Diamo... $563.00
Aquamarine & Diamond Pendant $568.00
14K White Aquamarine Three-Stone Gran... $580.00
Saved Items (0)

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