• 1-800-518-2718 US/CA only
  • cs@soufeel.com

Bracelets

Offer Expires In
SELECT `e`.*, IF(at_special_price.value_id > 0, at_special_price.value, at_special_price_default.value) AS `special_price`, `at_status`.`value` AS `status` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_product_entity_decimal` AS `at_special_price_default` ON (`at_special_price_default`.`entity_id` = `e`.`entity_id`) AND (`at_special_price_default`.`attribute_id` = '567') AND `at_special_price_default`.`store_id` = 0 LEFT JOIN `catalog_product_entity_decimal` AS `at_special_price` ON (`at_special_price`.`entity_id` = `e`.`entity_id`) AND (`at_special_price`.`attribute_id` = '567') AND (`at_special_price`.`store_id` = 1) INNER JOIN `catalog_product_entity_int` AS `at_status` ON (`at_status`.`entity_id` = `e`.`entity_id`) AND (`at_status`.`attribute_id` = '273') AND (`at_status`.`store_id` = 0) INNER JOIN `catalog_product_website` AS `product_website` ON product_website.product_id = e.entity_id AND product_website.website_id = '1' WHERE (IF(at_special_price.value_id > 0, at_special_price.value, at_special_price_default.value) > 1) AND (`e`.`sku` IN('XL', 'SZ001', 'PL003', 'PL301', 'PL302', 'PL004-40')) AND (at_status.value = '1')
  • 69% 0FF
    Exclusive 925 Sterling Silver Basic Bracelet
    $65.00
    $19.95
  • 60% 0FF
    925 Sterling Silver Basic Charms Bangle
    $65.00
    $25.95
  • 56% 0FF
    Silver Grey Leather Charm Bracelet
    $45.00
    $19.95
  • 60% 0FF
    Black Genuine Leather Bracelet
    $45.00
    $17.95
  • 60% 0FF
    Red Genuine Leather Bracelet
    $45.00
    $17.95
  • 56% 0FF
    Double Silver Skin Color Leather Charm Bracelet
    $55.00
    $23.95
Page:
  1. FIRST
  2. PREV
  3. 1
  4. 2
  • Black Genuine Leather Bracelet

    $45.00

    $17.95

  • Red Genuine Leather Bracelet

    $45.00

    $17.95

  • Exclusive 925 Sterling Silver Basic Bracelet

    $65.00

    $19.95

  • Sweet Journey Charm Bracelet 925 Sterling Silver

    $185.00

    $73.95

  • Sea World Charm Bracelet 925 Sterling Silver

    $310.00

    $126.00

  • Love Shopping Charm Bracelet 925 Sterling Silver

    $205.00

    $79.95

  • Leo Zodiac Charm Bracelet 925 Sterling Silver

    $200.00

    $86.95

  • Fancy World Charm Bracelet 925 Sterling Silver

    $250.00

    $96.95

  • Pisces Zodiac Charm Bracelet 925 Sterling Silver

    $175.00

    $73.95

  • Sagittarius Zodiac Charm Bracelet 925 Sterling Silver

    $185.00

    $79.95

  • Colorful Butterflies Charm Bracelet 925 Sterling Silver

    $220.00

    $86.95

  • Brilliant Purple Charm Bracelet 925 Sterling Silver

    $215.00

    $83.95

  • Cancer Zodiac Charm Bracelet 925 Sterling Silver

    $160.00

    $69.95

  • Good Brothers Charm Bracelet 925 Sterling Silver

    $185.00

    $76.95

  • Aquarius Zodiac Charm Bracelet 925 Sterling Silver

    $165.00

    $69.95

  • Scorpio Zodiac Charm Bracelet 925 Sterling Silver

    $155.00

    $66.95

  • My Angel Charm Bracelet 925 Sterling Silver

    $400.00

    $163.00

  • True Love Charm Bracelet 925 Sterling Silver

    $230.00

    $93.95

  • Gemini Zodiac Charm Bracelet 925 Sterling Silver

    $180.00

    $73.95

  • Love Blossoms Charm Bracelet 925 Sterling Silver

    $315.00

    $126.00

  • Capricorn Zodiac Charm Bracelet 925 Sterling Silver

    $155.00

    $66.95

  • Libra Zodiac Charm Bracelet 925 Sterling Silver

    $180.00

    $76.95

  • Naughty Little Tiger Charm Bracelet 925 Sterling Silver

    $375.00

    $153.00

  • Taurus Zodiac Charm Bracelet 925 Sterling Silver

    $165.00

    $69.95

  • Ladybug's Dream Charm Bracelet 925 Sterling Silver

    $250.00

    $106.00

  • Seahorse With Honey Bees Charm Bracelet 925 Sterling Silver

    $215.00

    $86.95

  • Big Hand Hold Little Hand Charm Bracelet 925 Sterling Silver

    $200.00

    $79.95

  • Virgo Zodiac Charm Bracelet 925 Sterling Silver

    $185.00

    $73.95

  • Mickey's Journey Charm Bracelet 925 Sterling Silver

    $175.00

    $66.95

  • Aries Zodiac Charm Bracelet 925 Sterling Silver

    $185.00

    $76.95

  • Lunar Love Charm Bangle 925 Sterling Silver

    $250.00

    $103.00

  • Thank You Dear Mom Charm Bangle 925 Sterling Silver

    $270.00

    $113.00

  • Happy Christmas Charm Bangle 925 Sterling Silver

    $315.00

    $123.00

  • Go Shopping With Mom Charm Bangle 925 Sterling Silver

    $190.00

    $83.95

  • Taking Back Our Town Charm Bangle 925 Sterling Silver

    $260.00

    $109.00

  • Merry Christmas Charm Bangle 925 Sterling Silver

    $225.00

    $89.95

Page:
  1. FIRST
  2. PREV
  3. 1
  4. 2