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 < 16) 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 > 16 ) ORDER BY position ASC LIMIT 1

Item #: STZPDSTA1

12 PCS OF ASSORTED S.STEEL CROSS PENDANTS

YOU WILL RECEIVE 12 PEICE ASSORTMENT OF 316L STAINLESS STEEL CROSS PENDANTS OF DIFFRENT STYLES INCLUDING IP RHODIUM, IP GOLD AND IP BLACK.

LENGTH FROM 1" - 3" APPROX

NOTE : IF YOU PICK MULTIPLE PACKAGE YOU WILL GET ALL DIFFRENT PENDANTS YOU WON'T GET THE SAME PENDANTS SINCE WE HAVE 250 DIFFRENT STYLES TO CHOOSE FROM.

CONTACT US  FOR MORE DETAIL. 


1 PACK