Catalog » Cookie Usage
 Advance Search
 
Enter search keywords or item here
 Beads Catalogs
 Decorations
 Special Beads
 Agate Beads
 Gemstone Beads
 Jade Beads
 Jasper Beads
 Quartz Beads
 Coral Beads
 Turquoise Beads
 Pearl Beads
 Shell Beads
 Glass Beads
 Lampwork Beads
 Porcelain Beads
 Wood Beads
 Indonesia Beads
 Jewellery
 Jewellery Findings
 Latest products more
LSBS232 15 inches 14mm round blue angel skin gemstone beads wholesale
LSBS232 15 inches 14mm round blue angel skin gemstone beads wholesale
 $19.50  $15.60  20% off 
 Featured more
GMN7448 4mm faceted round tiny golden obsidian beaded necklace with constellation charm
GMN7448 4mm faceted round tiny golden obsidian beaded necklace with constellation charm
 $7.04  $6.34  10% off 
 Reviews more
There are currently no product reviews
Cookie Usage Cookie Usage
Cookies must be enabled to purchase online on this store to embrace privacy and security related issues regarding your visit to this site.

By enabling cookie support on your browser, the communication between you and this site is strengthened to be certain it is you who are making transactions on your own behalf, and to prevent leakage of your privacy information.
We have detected that your browser does not support cookies, or has set cookies to be disabled.

To continue shopping online, we encourage you to enable cookies on your browser.

For Internet Explorer browsers, please follow these instructions:
  1. Click on the Tools menubar, and select Internet Options
  2. Select the Security tab, and reset the security level to Medium
We have taken this measurement of security for your benefit, and apologize upfront if any inconveniences are caused.

Please contact the store owner if you have any questions relating to this requirement, or to continue purchasing products offline.
Continue
1053 - Server shutdown in progress

SELECT DISTINCT p.products_image, pd.products_name, p.products_id, p.products_price, p.products_tax_class_id, IF(s.status, IF(ISNULL(pg.customers_group_price), LEAST(s.specials_new_products_price, p.products_price), LEAST(pg.customers_group_price, s.specials_new_products_price)), IF(ISNULL(pg.customers_group_price), p.products_price, LEAST(pg.customers_group_price, p.products_price))) as final_price FROM orders_products op left join orders o on o.orders_id=op.orders_id left join (products p LEFT JOIN specials s using(products_id) ) on op.products_id=p.products_id LEFT JOIN products_groups pg on p.products_id = pg.products_id and pg.customers_group_id = 'G', products_description pd WHERE p.products_status = '1' AND pd.products_id = p.products_id AND pd.language_id = '1' order by o.date_purchased desc limit 30

TEP_DB_ERRORR

 Shopping Cart more
0 items
 Your Account
Your Email Address
Your Password

Create an Account
Forgot your password?