canonical15:-https://aws.darveys.com/women/innerwear.html?___SID=U Intimates - Women (Page 3)

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 Intimates

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 = '837' AND price_index.website_id = '1' AND price_index.customer_group_id = '1' AND matrix_cron.is_collection = '0' And matrix_cron.category_id = 837 group by e.entity_id ORDER BY custom_sort ASC limit 96, 48
SORT BY
  2. 3
  3. 4

DKNY Poplin White Lace Satin-Trim Thong

DKNY

Poplin White Lace Satin-Trim Thong

Regular Price: 6,500

Special Price 3,990

(39% OFF)
0
Calvin Klein Black V-Neck Bralette

Calvin Klein

Black V-Neck Bralette

Regular Price: 6,500

Special Price 3,990

(39% OFF)
0
Michael Kors Black One-Piece Swimsuit

Michael Kors

Black One-Piece Swimsuit

Regular Price: 18,500

Special Price 12,950

(30% OFF)
0
DKNY Black Glossy Demi Logo Bra

DKNY

Black Glossy Demi Logo Bra

Regular Price: 11,500

Special Price 8,990

Editor's Pick
0
DKNY Black Satin-Trim Thong Underwear

DKNY

Black Satin-Trim Thong Underwear

Regular Price: 4,500

Special Price 2,990

(34% OFF)
0
DKNY White T-Shirt Bra

DKNY

White T-Shirt Bra

Regular Price: 11,500

Special Price 8,990

Editor's Pick
0
DKNY Black Side Tie Bikini Bottom

DKNY

Black Side Tie Bikini Bottom

Regular Price: 14,500

Special Price 8,990

(38% OFF)
0
DKNY Cherry Strappy Back Bra

DKNY

Cherry Strappy Back Bra

Regular Price: 12,500

Special Price 5,950

(53% OFF)
0
Rachel Roy Multicolor Swim Bottom

Rachel Roy

Multicolor Swim Bottom

Regular Price: 7,500

Special Price 3,950

(48% OFF)
0
DKNY Natural Lace Sheer-Crochet Bra

DKNY

Natural Lace Sheer-Crochet Bra

Regular Price: 12,500

Special Price 9,990

Favorites
0
DKNY Natural Satin-Trim Thong Underwear

DKNY

Natural Satin-Trim Thong Underwear

Regular Price: 4,500

Special Price 2,990

(34% OFF)
0
DKNY Black Glossy T-Shirt Bra

DKNY

Black Glossy T-Shirt Bra

Regular Price: 11,500

Special Price 8,990

Editor's Pick
0
DKNY Black Logo-Printed Hipster

DKNY

Black Logo-Printed Hipster

Regular Price: 6,500

Special Price 3,990

(39% OFF)
0
Calvin Klein Coral Eclipse Light Lined Bralette

Calvin Klein

Coral Eclipse Light Lined Bralette

Regular Price: 6,500

Special Price 3,990

(39% OFF)
0
Ralph Lauren Blue Floral Double Tie One-Piece

Ralph Lauren

Blue Floral Double Tie One-Piece

Regular Price: 16,500

Special Price 9,950

(40% OFF)
0
DKNY Black Litewear Custom Lift Bra

DKNY

Black Litewear Custom Lift Bra

Regular Price: 11,500

Special Price 8,990

Editor's Pick
0
DKNY Natural Lace Satin-Trim Thong

DKNY

Natural Lace Satin-Trim Thong

Regular Price: 6,500

Special Price 3,990

(39% OFF)
0
DKNY Vanilla Litewear Wirefree Bra

DKNY

Vanilla Litewear Wirefree Bra

Regular Price: 11,500

Special Price 8,990

Editor's Pick
0
DKNY Mauve Lace Sheer Hipster Underwear

DKNY

Mauve Lace Sheer Hipster Underwear

Regular Price: 4,000

Special Price 1,990

(51% OFF)
0
DKNY Black Dizzy Tropics Print Sports Bra

DKNY

Black Dizzy Tropics Print Sports Bra

Regular Price: 11,500

Special Price 6,990

(40% OFF)
0
Rachel Roy Multicolor Bikini Swim Top

Rachel Roy

Multicolor Bikini Swim Top

Regular Price: 7,500

Special Price 3,950

(48% OFF)
0
DKNY Black Modern Lace Strapless Bra

DKNY

Black Modern Lace Strapless Bra

Regular Price: 11,500

Special Price 6,990

(40% OFF)
0
DKNY Purple Soft Tech Mesh Bodysuit

DKNY

Purple Soft Tech Mesh Bodysuit

Regular Price: 17,500

Special Price 14,990

Editor's Pick
0
Calvin Klein White Racerback Bralette

Calvin Klein

White Racerback Bralette

Regular Price: 6,500

Special Price 3,990

(39% OFF)
0
Ralph Lauren Cobalt Stripe Tie Printed Racer Bra

Ralph Lauren

Cobalt Stripe Tie Printed Racer Bra

Regular Price: 8,500

Special Price 5,950

(30% OFF)
0
DKNY Natural Glossy Demi Logo Bra

DKNY

Natural Glossy Demi Logo Bra

Regular Price: 11,500

Special Price 8,990

Editor's Pick
0
DKNY Poplin White Modern Lace Demi Bra

DKNY

Poplin White Modern Lace Demi Bra

Regular Price: 11,500

Special Price 8,990

Editor's Pick
0
DKNY Pink Modern Lace Longline Bralette

DKNY

Pink Modern Lace Longline Bralette

Regular Price: 8,500

Special Price 5,990

(30% OFF)
0
Rachel Roy Multicolor Floral Print Swim Top

Rachel Roy

Multicolor Floral Print Swim Top

Regular Price: 7,500

Special Price 3,950

(48% OFF)
0
DKNY Black Modern Lace Demi Bra

DKNY

Black Modern Lace Demi Bra

Regular Price: 11,500

Special Price 8,990

Editor's Pick
0
DKNY White Sheers Strapless Mesh Bra

DKNY

White Sheers Strapless Mesh Bra

Regular Price: 12,500

Special Price 9,990

In Spotlight
0
Calvin Klein Natural Striped Lace Triangle Bralette

Calvin Klein

Natural Striped Lace Triangle Bralette

Regular Price: 8,500

Special Price 4,990

(42% OFF)
0
Ralph Lauren Fuchsia Solid Plunge Bikini Top

Ralph Lauren

Fuchsia Solid Plunge Bikini Top

Regular Price: 14,500

Special Price 8,950

(39% OFF)
0
DKNY Light Pink Underwire Unlined Bra

DKNY

Light Pink Underwire Unlined Bra

Regular Price: 10,000

Special Price 5,990

(41% OFF)
0
DKNY Storm Soft Tech Mesh Bra

DKNY

Storm Soft Tech Mesh Bra

Regular Price: 13,500

Special Price 7,990

(41% OFF)
0
DKNY Black Modern Lace Longline Bralette

DKNY

Black Modern Lace Longline Bralette

Regular Price: 8,500

Special Price 5,990

(30% OFF)
0
Rachel Roy Multicolor Ombre Bikini Bottom

Rachel Roy

Multicolor Ombre Bikini Bottom

Regular Price: 12,500

Special Price 6,950

(45% OFF)
0
DKNY Black Underwire Lace Bra

DKNY

Black Underwire Lace Bra

Regular Price: 11,500

Special Price 6,990

(40% OFF)
0
DKNY Black Leopard Lace Bustier

DKNY

Black Leopard Lace Bustier

Regular Price: 14,500

Special Price 8,990

(38% OFF)
0
Calvin Klein Black Ribbed Logo Sports Bralette

Calvin Klein

Black Ribbed Logo Sports Bralette

Regular Price: 8,500

Special Price 4,990

(42% OFF)
0
Rachel Roy Multicolor One Piece Swimsuit

Rachel Roy

Multicolor One Piece Swimsuit

Regular Price: 9,500

Special Price 5,950

(38% OFF)
0
DKNY Glow Custom Lift Bra

DKNY

Glow Custom Lift Bra

Regular Price: 9,500

Special Price 6,990

(27% OFF)
0
DKNY Natural Custom Lift Push-Up Bra

DKNY

Natural Custom Lift Push-Up Bra

Regular Price: 9,500

Special Price 6,990

(27% OFF)
0
DKNY Poplin White Modern Lace Longline Bralette

DKNY

Poplin White Modern Lace Longline Bralette

Regular Price: 8,500

Special Price 5,990

(30% OFF)
0
DKNY Black Custom Lift Bra

DKNY

Black Custom Lift Bra

Regular Price: 9,500

Special Price 6,990

(27% OFF)
0
DKNY Poplin White Lace Sheer Demi Bra

DKNY

Poplin White Lace Sheer Demi Bra

Regular Price: 9,500

Special Price 6,990

(27% OFF)
0
Calvin Klein Dark Blue V-Neck Bralette

Calvin Klein

Dark Blue V-Neck Bralette

Regular Price: 6,500

Special Price 3,990

(39% OFF)
0
DKNY Black Soft Tech Mesh Bodysuit

DKNY

Black Soft Tech Mesh Bodysuit

Regular Price: 17,500

Special Price 14,990

Editor's Pick
0
<12345>

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.