View large image

Cornish Heart Stud Earrings

£25.00

HTS

In Stock

Dainty open heart earrings made of pure Cornish tin.

Quantity:

Add to Cart

Categories: Earrings Earrings

SELECT DISTINCT parentProd.*, IF(parentProd.`pd_offer_price`, parentProd.`pd_offer_price`, parentProd.`pd_price`) AS `price` FROM `mod_shop_product_parent` AS `parentProd`LEFT JOIN `mod_shop_product_child` AS childProd ON parentProd.`pd_id` = childProd.`pd_parent_id` LEFT JOIN `mod_shop_prod_cat` AS prodCat ON parentProd.`pd_id` = prodCat.`pdID` WHERE parentProd.`pd_hide` = 0 AND parentProd.`pd_status` = 'live' AND parentProd.`pd_start_date` < NOW() AND (parentProd.`pd_end_date` = 0 OR parentProd.`pd_end_date` > NOW()) AND (prodCat.`catID` = ?)  ORDER BY parentProd.`pd_featured` DESC, `pd_order` ASC

Array
(
    [0] => 3
)

Similar Products

Eternity Twist Earrings

Eternity Long Earrings

Kerenza Triple Disc Earrings

Kerenza Domed Heart Earrings

Kerenza Heart Earrings

Kerenza Heart Stud Earrings

Kerenza Star Stud Earrings

Kerenza Disc Drop Earrings

Cornish Celtic Knot Earrings

Cornish Celtic Knot Stud Earrings

Cornish Daisy Stud Earrings