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 INNER JOIN `magento_catalog_product_index_eav` AS `gemstone_idx` ON gemstone_idx.entity_id = e.entity_id AND gemstone_idx.attribute_id = '235' AND gemstone_idx.store_id = 1 AND gemstone_idx.value = '41' ORDER BY `cat_index`.`position` DESC LIMIT 15

1 Item(s)

Set Ascending Direction
per page

Grid  List 

1 Item(s)

Set Ascending Direction
per page

Grid  List