Steven Douglas

Steven Douglas Jewelry is hand-crafted by skilled artisans using old world techniques, often involving at least 40 hours of labor to bring out fine details. Only top quality materials and gemstones are used in Steven Douglas Jewelry to meet the highest standards of today’s jewelry industry. Steven Biggs, the creator and designer of Steven Douglas Jewelry, grew up in Southern California where his love for art and the ocean inspired him to create the Steven Douglas Jewelry Company 25 years ago. Steven Douglas Jewelry is now world-famous for its beautiful miniature sculptures inspired by the ocean.

 
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='88' 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 32 total

Set Ascending Direction
per page

Grid  List 

Page:
  1. 1
  2. 2
  3. 3

Items 1 to 15 of 32 total

Set Ascending Direction
per page

Grid  List 

Page:
  1. 1
  2. 2
  3. 3