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 < 18) 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 > 18 ) ORDER BY position ASC LIMIT 1
Brass Initials CZ Pendants
 SHOPPING CART 
 PRODUCT SEARCH 
CUSTOMER SERVICE










Product Promotions > New Arrival

Item #: BINITILG

Brass Initials CZ Pendants

AAA Grade CZ Pendant
Comes With Retail Price Tag & Description  

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