SELECT product.*,position FROM product, cat_prod WHERE ( cat_prod.cid IN (144) ) AND ( product.prod_id=cat_prod.prod_id ) AND (isactive=1) AND ( position < 17) ORDER BY position DESC LIMIT 1
SELECT product.*,position FROM product, cat_prod WHERE ( cat_prod.cid IN (144) ) AND ( product.prod_id=cat_prod.prod_id ) AND (isactive=1) AND ( position > 17 ) ORDER BY position ASC LIMIT 1

Item #: STZPD33

S.STEEL CROSS PENDANT

YOU WILL RECEIVE HIGH QUALITY STAINLESS STEEL PENDANT.

 


Gold 2.5''X.1.25'' L
Gold 3.50''X.2'' XL
Silver 2.5''X.1.25'' L
Silver 2''X.1'' M
Gold 2''X.1'' M