canonical15:-https://aws.darveys.com/women/innerwear/bras.html?___SID=U Bras (Page 2)

Loading...

SIGN IN

If you are not registered with Darveys.com, a Member’s Exclusive Website, become a lifetime Darveys Member with a onetime fee of ₹2000.

GET NOTIFIED

We will notify you once this item comes back in stock.

    • Wrong Email or Password.

THANK YOU

We will notify you once this item comes back in stock.

But Wait Before You Leave!

We have some amazing items waiting for you at Upto 60% Off on your favorite Designer.

Please enter your VIP Code for early access.

Women's Bras

SELECT `e`.`entity_id`, matrix_cron.sort_order as custom_sort, `e`.`type_id`, `e`.`is_kids_product`, `e`.`name`, `e`.`sku`, `e`.`price`, `e`.`special_price`, `e`.`special_from_date`, `e`.`special_to_date`, `e`.`manufacturer_value`, `e`.`small_image`, `e`.`news_from_date`, `e`.`news_to_date`, `e`.`url_path`, `e`.`default_sort_value`, `e`.`luxe`, `e`.`luxe_value`, `e`.`stock_status`, `e`.`discount_percent` FROM `darveyscatalog_product_flat_1` AS `e` INNER JOIN `darveyscatalog_category_product_index` AS `cat_index` ON cat_index.product_id=e.entity_id INNER JOIN `darveyscatalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id INNER JOIN `darveysvss_matrix_cron_test` AS `matrix_cron` ON matrix_cron.product_id=e.entity_id WHERE 1 AND cat_index.store_id=1 AND cat_index.visibility IN(2,4) AND cat_index.category_id = '838' AND price_index.website_id = '1' AND price_index.customer_group_id = '1' AND matrix_cron.is_collection = '0' And matrix_cron.category_id = 838 group by e.entity_id ORDER BY custom_sort ASC limit 48, 48
SORT BY
  2. 2
  3. 3

DKNY Black Monogram Mesh Demi Bra

DKNY

Black Monogram Mesh Demi Bra

Regular Price: 11,500

Special Price 8,990

Editor's Pick
0
DKNY Black Sheers Strapless Mesh Bra

DKNY

Black Sheers Strapless Mesh Bra

Regular Price: 12,500

Special Price 9,990

In Spotlight
0
DKNY Natural Modern Lace Demi Bra

DKNY

Natural Modern Lace Demi Bra

Regular Price: 11,500

Special Price 8,990

Editor's Pick
0
<12

Filter By

Designer

Type

Intimates Type

Size

Intimates Size

Discount

Color

Price

methods:
    • Contact Us
    Contact us 1800-212-0085
    Email: assistance@darveys.com
    copyright @ 2019 darveys.com

    Darveys.com is best experienced in the portrait mode.

    Please Rotate your screen.

    Bras