Warning Warning: I am able to write to the configuration file: /home/ambercom/public_html/includes/configure.php. This is a potential security risk - please set the right user permissions on this file.
  Catalog » Amber brooches
Amber Braceletes (8)
Amber brooches (5)
  Broches with turquoise (2)
  Brooches with amber and turquoise (1)
  Silver with amber (2)
Amber cuff links (1)
Amber earrings (8)
Amber necklaces (6)
Amber pendants (8)
Amber rings (3)


Earrings E108T
Earrings E108T
8.28EUR
 
Use keywords to find the product you are looking for.
Advanced Search
Shipping & Returns
Privacy Notice
Conditions of Use
Contact Us
Categories

Broches with turquoise

Brooches with amber and turquoise

Silver with amber
New Products For March
Brooch B15AT
Brooch B15AT
10.11EUR
Buy 1 'Brooch B15AT' now
Brooch B19G
Brooch B19G
6.90EUR
Buy 1 'Brooch B19G' now
Brooch B13MIX
Brooch B13MIX
25.74EUR
Buy 1 'Brooch B13MIX' now
Brooch B2AT
Brooch B2AT
12.44EUR
Buy 1 'Brooch B2AT' now
Brooch B05T
Brooch B05T
19.94EUR
Buy 1 'Brooch B05T' now
1054 - Unknown column 'p.products_id' in 'on clause'

select distinct p.products_id, p.products_image, p.products_tax_class_id, s.status as specstat, s.specials_new_products_price, p.products_price from products p left join specials s on p.products_id = s.products_id, products_to_categories p2c, categories c left join featured f on p.products_id = f.products_id where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '33' and p.products_status = '1' and f.status = '1' order by rand() DESC limit 2

[TEP STOP]