• 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('SL001', 'XL', 'SZ001', 'CXL038', 'CXL019K', 'CSZ027')) AND (at_status.value = '1')
  • 14K GOLD SYMBOL OF LOVE BRACELET
    $59.00
    $59.00
  • 54% 0FF
    Exclusive 925 Sterling Silver Basic Bracelet
    $65.00
    $29.95
  • 60% 0FF
    925 Sterling Silver Basic Charms Bangle
    $65.00
    $25.95
  • 61% 0FF
    When Spring Comes Charm Bracelet 925 Sterling Silver
    $440.00
    $173.00
  • 57% 0FF
    Scorpio Zodiac Charm Bracelet 925 Sterling Silver
    $155.00
    $66.95
  • 59% 0FF
    Love Token Charm Bangle 925 Sterling Silver
    $310.00
    $126.00
Page:
  1. FIRST
  2. PREV
  3. 1
  4. 2
  • Drifting Snow Charm Bangle 925 Sterling Silver

    $315.00

    $129.00

  • When Spring Comes Charm Bracelet 925 Sterling Silver

    $440.00

    $173.00

  • Butterfly Dream Charm Bangle 925 Sterling Silver

    $280.00

    $116.00

  • Animals Union Charm Bracelet 925 Sterling Silver

    $565.00

    $223.00

  • Birthstone Set Charm Bracelet 925 Sterling Silver

    $865.00

    $343.00

  • Love Token Charm Bangle 925 Sterling Silver

    $310.00

    $126.00

  • Red Genuine Leather Bracelet

    $45.00

    $17.95

  • Exclusive 925 Sterling Silver Basic Bracelet

    $65.00

    $29.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

  • Aries Zodiac Charm Bracelet 925 Sterling Silver

    $185.00

    $76.95

  • Sweet Journey Charm Bracelet 925 Sterling Silver

    $185.00

    $73.95

  • Mickey's Journey Charm Bracelet 925 Sterling Silver

    $175.00

    $66.95

  • Leo Zodiac Charm Bracelet 925 Sterling Silver

    $200.00

    $86.95

  • Pisces Zodiac Charm Bracelet 925 Sterling Silver

    $175.00

    $73.95

  • Sagittarius Zodiac Charm Bracelet 925 Sterling Silver

    $185.00

    $79.95

  • Good Brothers Charm Bracelet 925 Sterling Silver

    $185.00

    $76.95

  • Cancer Zodiac Charm Bracelet 925 Sterling Silver

    $160.00

    $69.95

  • Aquarius Zodiac Charm Bracelet 925 Sterling Silver

    $165.00

    $69.95

  • Scorpio Zodiac Charm Bracelet 925 Sterling Silver

    $155.00

    $66.95

  • Gemini Zodiac Charm Bracelet 925 Sterling Silver

    $180.00

    $73.95

  • Capricorn Zodiac Charm Bracelet 925 Sterling Silver

    $155.00

    $66.95

  • Libra Zodiac Charm Bracelet 925 Sterling Silver

    $180.00

    $76.95

  • Taurus Zodiac Charm Bracelet 925 Sterling Silver

    $165.00

    $69.95

  • Ladybug's Dream Charm Bracelet 925 Sterling Silver

    $250.00

    $106.00

  • Thank You Dear Mom Charm Bangle 925 Sterling Silver

    $270.00

    $113.00

  • Lunar Love Charm Bangle 925 Sterling Silver

    $250.00

    $103.00

  • Taking Back Our Town Charm Bangle 925 Sterling Silver

    $260.00

    $109.00

  • Love Like Honey Charm Bangle 925 Sterling Silver

    $225.00

    $99.95

  • Whole Family Enjoy Happiness Charm Bangle 925 Sterling Silver

    $180.00

    $73.95

  • Austrian Crystal Multicolor Tennis Bracelet

    $50.00

    $19.95

  • Double Black Leather Charm Bracelet

    $55.00

    $23.95

  • Double Brown Leather Charm Bracelet

    $55.00

    $23.95

  • Double Silver Skin Color Leather Charm Bracelet

    $55.00

    $23.95

  • Double Silver Grey Leather Charm Bracelet

    $55.00

    $23.95

  • Silver Wine Red Leather Charm Bracelet

    $45.00

    $19.95

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