- Home
- Collections
- Bangles
Bangles
The perfect accessory sculpted for the hand that nourishes love and life.
SELECT DISTINCT `e`.*, `cat_index`.`position` AS `cat_index_position`, `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` FROM `km7_catalog_product_entity` AS `e`
INNER JOIN `km7_catalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id='7'
INNER JOIN `km7_catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0
LEFT JOIN `km7_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
INNER JOIN `km7_catalog_product_index_eav` AS `layered_nav_style` ON `layered_nav_style`.`entity_id` = `e`.`entity_id` AND `layered_nav_style`.`attribute_id` = '157' AND `layered_nav_style`.`store_id` = '1' AND `layered_nav_style`.`value` IN (29) ORDER BY `e`.`created_at` DESC, `e`.`created_at` DESC
LIMIT 15
Refine items
Showing 15 items
Sort by
-
Adding to your Wishlist Removing from your Wishlist
Captivating Pure Gold Bangles
$3,638.13 -
Adding to your Wishlist Removing from your Wishlist
Exquisite Karigaris Bangle
$3,051.21 -
Adding to your Wishlist Removing from your Wishlist
Charming Heavily Designed Bangle
$3,511.04 -
Adding to your Wishlist Removing from your Wishlist
Ravishing Bangle With Crafted Enamel Work
$3,484.69 -
Adding to your Wishlist Removing from your Wishlist
Elegant design Bangles
$2,779.42 -
Adding to your Wishlist Removing from your Wishlist
Gorgeous Unmatched Gold Bangles
$3,648.41 -
Adding to your Wishlist Removing from your Wishlist
Splendid Modern Floral BanglesĀ
$3,474.79 -
Adding to your Wishlist Removing from your Wishlist
Mesmerizing Paisley Work Bangle
$3,710.65 -
Adding to your Wishlist Removing from your Wishlist
Extravagant Classic Gold Bangle
$3,396.49 -
Adding to your Wishlist Removing from your Wishlist
Three Balls Bewitching Bangle
$4,064.70 -
Adding to your Wishlist Removing from your Wishlist
Classic Spiral Gold Bangle
$2,618.23 -
Adding to your Wishlist Removing from your Wishlist
Set of 6 Dial Tone Bangles
$5,351.65 -
Adding to your Wishlist Removing from your Wishlist
Khajuraho Bangle Pair
$4,162.21 -
Adding to your Wishlist Removing from your Wishlist
Set of 6 Hallow Gold Kadas
$5,603.77 -
Adding to your Wishlist Removing from your Wishlist
Lakshmi Kasu Bangles
$5,179.94
You chose United States of America(USA) as shipping country and trying to checkout with currency INR. So, please click the below button to change the currency to USD.
You chose India as shipping country and trying to checkout with currency USD. So, please click the below button to change the currency to INR.
Sign In
Create New Account