• My Account
  • Register
  • Compare Products
Shop
Wishlist
My Cart
Shop
Account
Return to Previous Page
x

Categories: Jewelry

SELECT `e`.*, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price`, `stock_status_index`.`stock_status` AS `is_salable`, `product_attributes`.`absolute_price`, `product_attributes`.`absolute_cost`, `product_attributes`.`absolute_weight`, `product_attributes`.`hide_additional_product_price`, `product_attributes`.`dependency_rules`, `product_attributes`.`hidden_dependents` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '5' LEFT JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 LEFT JOIN `mageworx_optionbase_product_attributes` AS `product_attributes` ON `e`.`entity_id` = `product_attributes`.`product_id` WHERE (e.entity_id IN (68019, 68026, 74751, 74813, 74814, 76739, 76740, 85907, 85908, 85913, 85914, 85935, 85937, 82008, 79404, 34236, 60613, 68002, 68016, 68022, 68023, 76729, 76741, 76751, 85917, 85927, 85928, 85929, 85931, 85932, 85933, 85934)) ORDER BY FIELD(e.entity_id,68019,68026,74751,74813,74814,76739,76740,85907,85908,85913,85914,85935,85937,82008,79404,34236,60613,68002,68016,68022,68023,76729,76741,76751,85917,85927,85928,85929,85931,85932,85933,85934)

Items 1-32 of 34

Set Ascending Direction
per page
Page
  1. Cancer Zodiac Sentiment Bracelet
    Carrie Elspeth Cancer Zodiac Sentiment Bracelet
    Special Price $18.00 Regular Price $30.00
    Add to Wish List Add to Compare
  2. Aquarius Zodiac Sentiment Bracelet
    Carrie Elspeth Aquarius Zodiac Sentiment Bracelet
    Special Price $18.00 Regular Price $30.00
    Add to Wish List Add to Compare
  3. ‘Granddaughters’ Sentiment Bracelet
    Carrie Elspeth ‘Granddaughters’ Sentiment Bracelet
    Special Price $18.00 Regular Price $30.00
    Add to Wish List Add to Compare
  4. Pink Pearl Earrings
    Carrie Elspeth Pink Pearl Earrings
    Special Price $15.00 Regular Price $25.00
    Add to Wish List Add to Compare
  5. Pink Pearl Full Necklace
    Carrie Elspeth Pink Pearl Full Necklace
    Special Price $20.40 Regular Price $34.00
    Add to Wish List Add to Compare
  6. Teal & Green Filaments Earrings
    Carrie Elspeth Teal & Green Filaments Earrings
    Special Price $15.00 Regular Price $25.00
    Add to Wish List Add to Compare
  7. Blue & Pink Filaments Earrings
    Carrie Elspeth Blue & Pink Filaments Earrings
    Special Price $15.00 Regular Price $25.00
    Add to Wish List Add to Compare
  8. Silver Heart Charm Brown Leather Bracelet
    Carrie Elspeth Silver Heart Charm Brown Leather Bracelet
    Special Price $20.40 Regular Price $34.00
    Add to Wish List Add to Compare
  9. Silver Heart Charm Burgundy Leather Bracelet
    Carrie Elspeth Silver Heart Charm Burgundy Leather Bracelet
    Special Price $20.40 Regular Price $34.00
    Add to Wish List Add to Compare
  10. Putty Round Silver Stud Earrings
    Carrie Elspeth Putty Round Silver Stud Earrings
    Special Price $15.00 Regular Price $25.00
    Add to Wish List Add to Compare
  11. Black Round Silver Stud Earrings
    Carrie Elspeth Black Round Silver Stud Earrings
    Special Price $15.00 Regular Price $25.00
    Add to Wish List Add to Compare
  12. Monochrome Cubes Spaced Necklace
    Carrie Elspeth Monochrome Cubes Spaced Necklace
    Special Price $20.40 Regular Price $34.00
    Add to Wish List Add to Compare
  13. Monochrome Seashell Earrings
    Carrie Elspeth Monochrome Seashell Earrings
    Special Price $18.60 Regular Price $31.00
    Add to Wish List Add to Compare
  14. Pink Ostrich & Palms Jewellery Case
    Sara Miller Pink Ostrich & Palms Jewellery Case
    Special Price $30.60 Regular Price $51.00
    Add to Wish List Add to Compare
  15. ‘All You Need is Love’ Pin Badge
    The Beatles ‘All You Need is Love’ Pin Badge
    Special Price $6.30 Regular Price $7.00
    Add to Wish List Add to Compare
  16. Rainbow Glow Earrings
    Carrie Elspeth Rainbow Glow Earrings
    Special Price $15.00 Regular Price $25.00
    Out of stock
    Add to Wish List Add to Compare
  17. World’s Greatest Mum Sentiment Bracelet
    Carrie Elspeth World’s Greatest Mum Sentiment Bracelet
    Special Price $18.00 Regular Price $30.00
    Out of stock
    Add to Wish List Add to Compare
  18. Rainbow Carnival Earrings
    Carrie Elspeth Rainbow Carnival Earrings
    Special Price $18.60 Regular Price $31.00
    Out of stock
    Add to Wish List Add to Compare
  19. Aries Zodiac Sentiment Bracelet
    Carrie Elspeth Aries Zodiac Sentiment Bracelet
    Special Price $18.00 Regular Price $30.00
    Out of stock
    Add to Wish List Add to Compare
  20. Libra Zodiac Sentiment Bracelet
    Carrie Elspeth Libra Zodiac Sentiment Bracelet
    Special Price $18.00 Regular Price $30.00
    Out of stock
    Add to Wish List Add to Compare
  21. Scorpio Zodiac Sentiment Bracelet
    Carrie Elspeth Scorpio Zodiac Sentiment Bracelet
    Special Price $18.00 Regular Price $30.00
    Out of stock
    Add to Wish List Add to Compare
  22. Green & Purple Filaments Bracelet
    Carrie Elspeth Green & Purple Filaments Bracelet
    Special Price $22.50 Regular Price $25.00
    Out of stock
    Add to Wish List Add to Compare
  23. Green & Purple Filaments Earrings
    Carrie Elspeth Green & Purple Filaments Earrings
    Special Price $22.50 Regular Price $25.00
    Out of stock
    Add to Wish List Add to Compare
  24. Royal Blue Strata Earrings
    Carrie Elspeth Royal Blue Strata Earrings
    Special Price $15.00 Regular Price $25.00
    Out of stock
    Add to Wish List Add to Compare
  25. Sky Blue Round Silver Stud Earrings
    Carrie Elspeth Sky Blue Round Silver Stud Earrings
    Special Price $15.00 Regular Price $25.00
    Out of stock
    Add to Wish List Add to Compare
  26. Pastel Harmony Earrings
    Carrie Elspeth Pastel Harmony Earrings
    Special Price $18.60 Regular Price $31.00
    Out of stock
    Add to Wish List Add to Compare
  27. Pastel Harmony Links Necklace
    Carrie Elspeth Pastel Harmony Links Necklace
    Special Price $20.40 Regular Price $34.00
    Out of stock
    Add to Wish List Add to Compare
  28. Summer Agate Waves Bracelet
    Carrie Elspeth Summer Agate Waves Bracelet
    Special Price $20.40 Regular Price $34.00
    Out of stock
    Add to Wish List Add to Compare
  29. Warm Summer Agate Waves Earrings
    Carrie Elspeth Warm Summer Agate Waves Earrings
    Special Price $15.00 Regular Price $25.00
    Out of stock
    Add to Wish List Add to Compare
  30. Summer Agate Waves Links Necklace
    Carrie Elspeth Summer Agate Waves Links Necklace
    Special Price $20.40 Regular Price $34.00
    Out of stock
    Add to Wish List Add to Compare
  31. Monochrome Geo Bracelet
    Carrie Elspeth Monochrome Geo Bracelet
    Special Price $20.40 Regular Price $34.00
    Out of stock
    Add to Wish List Add to Compare
  32. Monochrome Geo Earrings
    Carrie Elspeth Monochrome Geo Earrings
    Special Price $15.00 Regular Price $25.00
    Out of stock
    Add to Wish List Add to Compare

Items 1-32 of 34

Set Ascending Direction
per page
Page
Trending In This Category
Cancer Zodiac Sentiment Bracelet
Cancer Zodiac Sentiment Bracelet
Special Price $18.00 Regular Price $30.00
Aquarius Zodiac Sentiment Bracelet
Aquarius Zodiac Sentiment Bracelet
Special Price $18.00 Regular Price $30.00
‘Granddaughters’ Sentiment Bracelet
‘Granddaughters’ Sentiment Bracelet
Special Price $18.00 Regular Price $30.00
Pink Pearl Earrings
Pink Pearl Earrings
Special Price $15.00 Regular Price $25.00
Pink Pearl Full Necklace
Pink Pearl Full Necklace
Special Price $20.40 Regular Price $34.00
Teal & Green Filaments Earrings
Teal & Green Filaments Earrings
Special Price $15.00 Regular Price $25.00
Blue & Pink Filaments Earrings
Blue & Pink Filaments Earrings
Special Price $15.00 Regular Price $25.00
‘All You Need is Love’ Pin Badge
‘All You Need is Love’ Pin Badge
Special Price $6.30 Regular Price $7.00
Pink Ostrich & Palms Jewellery Case
Pink Ostrich & Palms Jewellery Case
Special Price $30.60 Regular Price $51.00
Silver Heart Charm Brown Leather Bracelet
Silver Heart Charm Brown Leather Bracelet
Special Price $20.40 Regular Price $34.00
closex

Customer Service

Fast and secure payment with:
Secure Payment Options
Terms & Conditions
© Great British Brands USA 2023 - 2026