Coast Engagement Rings

Coast Engagement Rings

Since 1978, Coast Jewelry has been committed to creating fine quality jewelry that is stylish, imaginative and instills lasting memories. Coast applies the highest standards of integrity and consistency to its products and services. Elegant design and superb quality are the hallmarks of a Coast Diamond Engagement Ring. Each Coast Engagement ring is completely customizable for any shape or size center stone and any metal type, making each ring as unique as the person wearing it.

 

 

 

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='132' 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

Items 1 to 15 of 20 total

Set Ascending Direction
per page

Grid  List 

Page:
  1. 1
  2. 2

Items 1 to 15 of 20 total

Set Ascending Direction
per page

Grid  List 

Page:
  1. 1
  2. 2