SELECT product.*,position FROM product, cat_prod WHERE ( cat_prod.cid IN (47) ) AND ( product.prod_id=cat_prod.prod_id ) AND (isactive=1) AND ( position < 192) ORDER BY position DESC LIMIT 1
SELECT product.*,position FROM product, cat_prod WHERE ( cat_prod.cid IN (47) ) AND ( product.prod_id=cat_prod.prod_id ) AND (isactive=1) AND ( position > 192 ) ORDER BY position ASC LIMIT 1
Fashion CZ Bubble Initials
 SHOPPING CART 
 PRODUCT SEARCH 
CUSTOMER SERVICE










Product Promotions > New Arrival

Item #: FBUB2

Fashion Silver Chain & CZ Bubble Initials Set

Fashion Silver (A)
Fashion Silver (B)
Fashion Silver (C)
Fashion Silver (D)
Fashion Silver (E)
Fashion Silver(F)
Fashion Silver(G)
Fashion Silver (H)
Fashion Silver (I)
Fashion Silver (K)
Fashion Silver (L)
Fashion Silve r(M)
Fashion Silver (N)
Fashion Silver (P)
Fashion Silver (Q)
Fashion Silver (R)
Fashion Silver (S)
Fashion Silver (T)