• 1-800-518-2718
  • 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')) AND (at_status.value = '1')
  • 60% 0FF
    Exclusive 925 Sterling Silver Basic Bracelet
    $65.00
    $25.95
  • 54% 0FF
    925 Sterling Silver Basic Charms Bangle
    $65.00
    $29.95
  • 56% 0FF
    Silver Grey Leather Charm Bracelet
    $45.00
    $19.95
  • Exclusive 925 Sterling Silver Basic Bracelet

    $65.00

    $25.95

  • Soufeel Sterling Silver Topaz Natural Gemstone Bracelet

    $498.00

    $199.00

  • Austrian Crystal Multicolor Miss You Bracelet

    $50.00

    $19.95

  • Austrian Crystal Lavender Tennis Bracelet

    $50.00

    $19.95

  • Austrian Crystal Multicolor Tennis Bracelet

    $50.00

    $19.95

  • Austrian Crystal Miss You Bracelet

    $50.00

    $19.95

  • Double Black Leather Charm Bracelet

    $55.00

    $23.95

  • Double Brown Leather Charm Bracelet

    $55.00

    $23.95

  • Silver Black Leather Charm Bracelet

    $45.00

    $19.95

  • Silver Grey Leather Charm Bracelet

    $45.00

    $19.95

  • Silver Brown Leather Charm Bracelet

    $45.00

    $19.95

  • 925 Sterling Silver Basic Charms Bangle

    $65.00

    $29.95