SELECT product.*,position FROM product, cat_prod WHERE ( cat_prod.cid IN (74) ) AND ( product.prod_id=cat_prod.prod_id ) AND (isactive=1) AND ( position < 275) ORDER BY position DESC LIMIT 1
SELECT product.*,position FROM product, cat_prod WHERE ( cat_prod.cid IN (74) ) AND ( product.prod_id=cat_prod.prod_id ) AND (isactive=1) AND ( position > 275 ) ORDER BY position ASC LIMIT 1
Brass CZ Pendant
 SHOPPING CART 
 PRODUCT SEARCH 
CUSTOMER SERVICE










Wholesale Brass Jewelry

Item #: INITIAL1

Brass Baguette Initials

Gold(B)
Gold(C)
Gold(D)
Gold(E)
Gold(F)
Gold(G)
Gold(H)
Gold(I)
Gold(J)
Gold(K)
Gold(L)
Gold(M)
Gold(N)
Gold(O)
Gold(P)
Gold (Q)
Gold (S)
Gold (T)
Gold (U)
Gold (V)
Gold (W)
Gold (X)
Gold (Y)
Gold (Z)
Silver(A)
Silver(B)
Silver(C)
Silver(D)
Silver(E)
Silver(F)
Silver(G)
Silver(H)
Silver(I)
Silver(J)
Silver(K)
Silver(L)
Silver(M)
Silver(N)
Silver(O)
Silver(P)
Silver(Q)
Silver(R)
Silver(S)
Silver(T)
Silver(U)
Silver(V)
Silver(X)
Silver(Z)