SELECT product.*,position FROM product, cat_prod WHERE ( cat_prod.cid IN (63) ) AND ( product.prod_id=cat_prod.prod_id ) AND (isactive=1) AND ( position < 10) ORDER BY position DESC LIMIT 1
SELECT product.*,position FROM product, cat_prod WHERE ( cat_prod.cid IN (63) ) AND ( product.prod_id=cat_prod.prod_id ) AND (isactive=1) AND ( position > 10 ) ORDER BY position ASC LIMIT 1
S.ST Micro Pave CZ Ring
 SHOPPING CART 
 PRODUCT SEARCH 
CUSTOMER SERVICE










Wholesale Stainless Steel Jewelry > S.Steel Rings

Item #: STZR09G

S.ST Micro Pave CZ Ring

IP GOLD PLATED STAINLESS STEEL MICRO PAVE CZ RING 

Size (6)
Size (7)
Size (8)
Size (9)
Size (10)
Size (11)
Size (12)
Size (13)