Valentines Day Jewelry

Valentines Jewelry is a perfect Valentines Day Gift for your loved one. We have the best selection in Tallahassee of Valentines Jewelry, Heart Jewelry, Love Jewelry, Heart Lockets, Valentines Pendants, Valentines Rings, and Valentines Diamond Jewelry.
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='109' 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 28 total

Set Ascending Direction
per page

Grid  List 

Page:
  1. 1
  2. 2

Items 1 to 15 of 28 total

Set Ascending Direction
per page

Grid  List 

Page:
  1. 1
  2. 2