Zeghani Jewelry

Zeghani Jewelry combines cutting edge computer modeling technology with expert craftsmanship to bring out exquisite detail in their jewelry. All Zeghani Jewelry is designed and crafted in 14K Gold to ensure superior beauty while maintaining affordability. Zeghani specializes in high quality bridal jewelry and fashion jewelry. Many celebrities wear Zeghani jewelry, including Carrie Underwood, Kesha, Jamie King, and Kristin Davis.

SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, price_index.price AS `indexed_price`, `price_index`.`price`, `price_index`.`final_price`, IF(`price_index`.`tier_price`, 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='92' 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 ORDER BY `cat_index`.`position` DESC LIMIT 15

13 Item(s)

Set Ascending Direction
per page

Grid  List 

13 Item(s)

Set Ascending Direction
per page

Grid  List