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 < 162) 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 > 162 ) ORDER BY position ASC LIMIT 1
Brass Hip Hop CZ Pendant
 SHOPPING CART 
 PRODUCT SEARCH 
CUSTOMER SERVICE










Wholesale Brass Jewelry

Item #: CZ1175

Brass Hip-Hop CZ Pendant

 

 

 

 

 

CN1175-1.25"(L)x0.50"(W)

 

 

 

 

CN1176-2.00"(L)x1.00"(W)

 

 

 

 

CN1177-3.00"(L)x1.50"(W)

 

 

 

IP Gold
IP Silver
IP Gold
IP Silver
IP Gold
IP Silver
IP Gold
IP Silver