All
Currently Shopping by:
  1. Remove This Item Style: 3-stone
  2. Remove This Item Style: Modern
  3. Remove This Item Style: Halo
Clear All

Shopping Options

Style 
  1. 3-stone (0)
  2. Cathedral (2)
  3. Classic (5)
  4. Gemstone (37)
  5. Halo (1)
  6. Metal Only (24)
  7. Mixed Metal (2)
  8. Modern (10)
  9. Pave (3)
  10. Solitaire (1)
  11. Statement (2)
  12. TIFFANY (1)
  13. Diamond (82)
  14. Vintage (2)
Metal Type 
Metal Color 
Price Range 

Clearance

40 - 80% offDig in and find a real bargain! These prices are so low you won't believe it! Engagement rings up to 70% off, fine jewelry up to 70% off... more in our stores, VISIT US!

SELECT DISTINCT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price` FROM `magento_catalog_product_entity` AS `e` INNER JOIN `magento_catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id='1430' INNER JOIN `magento_catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `magento_catalog_product_index_eav` AS `gf_style_idx` ON `gf_style_idx`.entity_id = e.entity_id AND `gf_style_idx`.attribute_id = '139' AND `gf_style_idx`.store_id = 1 AND `gf_style_idx`.value in (647,750,640) ORDER BY `cat_index`.`position` ASC LIMIT 24

11 Item(s)

per page
SELECT DISTINCT `e`.*, `cat_index`.`position` AS `cat_index_position`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price` FROM `magento_catalog_product_entity` AS `e` INNER JOIN `magento_catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id='1430' INNER JOIN `magento_catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `magento_catalog_product_index_eav` AS `gf_style_idx` ON `gf_style_idx`.entity_id = e.entity_id AND `gf_style_idx`.attribute_id = '139' AND `gf_style_idx`.store_id = 1 AND `gf_style_idx`.value in (647,750,640) ORDER BY `cat_index`.`position` ASC LIMIT 24

11 Item(s)

per page

why would you ever pay retail? Learn More

Copyright Howard’s Jewelry Center PB.100203.000

To top