SELECT product.*,position FROM product, cat_prod WHERE ( cat_prod.cid IN (26) ) AND ( product.prod_id=cat_prod.prod_id ) AND (isactive=1) AND ( position < 15) ORDER BY position DESC LIMIT 1
SELECT product.*,position FROM product, cat_prod WHERE ( cat_prod.cid IN (26) ) AND ( product.prod_id=cat_prod.prod_id ) AND (isactive=1) AND ( position > 15 ) ORDER BY position ASC LIMIT 1
ACRYLIC BEADS ROSARY W/ SILVER CROSS 10MM
 SHOPPING CART 
 PRODUCT SEARCH 
CUSTOMER SERVICE










Wholesale HipHop Jewelry > Fashion Rosary

Item #: ROS51

ACRYLIC BEADS ROSARY W/ SILVER CROSS 10MM

10MM BLACK ACRYLIC BEADS ROSARY 

LENGTH 36"

 

HOT PINK BEADS
ORANGE BEADS
TURQUOISE BEADS
PURPLE BEADS
LIGHT GREEN BEADS
BLACK BEADS
RED BEADS
DARK GREEN BEADS
WHITE BEADS