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 < 58) 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 > 58 ) ORDER BY position ASC LIMIT 1

Item #: SSB4366

925 S.Silver AAA Grade CZ Bracelets

.925 Sterling Silver With AAA Grade Quality Cubic Zirconia.

Comes With Retail Price Tag & Description  


IP Gold Style (1)
IP Gold Style (2)
IP Gold Style (3)
IP Gold Style (4)
IP Gold Style (5)
IP Gold Style (6)
IP Gold Style (7)
IP Gold Style (8)
IP Gold Style (9)
IP Gold Style (10)