canonical15:-https://aws.darveys.com/all.html?___SID=U Buy Men's & Women Clothing, Bags & Accessories Online in India | Darveys.com : BCBGMaxazria (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.

All Collection

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 INNER JOIN `darveyscatalog_product_index_eav` AS `manufacturer_idx` ON manufacturer_idx.entity_id = e.entity_id AND manufacturer_idx.attribute_id = '81' AND manufacturer_idx.store_id = 1 AND manufacturer_idx.value in (2237) WHERE 1 AND cat_index.store_id=1 AND cat_index.visibility IN(2,4) AND cat_index.category_id = '530' AND price_index.website_id = '1' AND price_index.customer_group_id = '1' AND matrix_cron.is_collection = '0' And matrix_cron.category_id = 530 AND `e`.`stock_status`=1 group by e.entity_id ORDER BY custom_sort ASC limit 96, 48
SORT BY
  2. 3
  3. 4

BCBGMaxazria Black Faux Wrap Midi Dress

BCBGMaxazria

Black Faux Wrap Midi Dress

Regular Price: 22,500

Special Price 14,950

(34% OFF)
0
BCBGMaxazria Multicolor Ruched Knit Top

BCBGMaxazria

Multicolor Ruched Knit Top

Regular Price: 18,500

Special Price 9,950

(47% OFF)
0
BCBGMaxazria Black One Shoulder Evening Dress

BCBGMaxazria

Black One Shoulder Evening Dress

Regular Price: 42,000

Special Price 34,950

In Spotlight
0
BCBGMaxazria Light Pink Cocktail Dress

BCBGMaxazria

Light Pink Cocktail Dress

Regular Price: 36,000

Special Price 25,950

(28% OFF)
0
BCBGMaxazria Black V-Neck Dress

BCBGMaxazria

Black V-Neck Dress

Regular Price: 26,500

Special Price 19,950

(25% OFF)
0
BCBGMaxazria Black Puff-Sleeve Sheer Top

BCBGMaxazria

Black Puff-Sleeve Sheer Top

Regular Price: 18,000

Special Price 11,950

(34% OFF)
0
BCBGMaxazria Black Cocktail Dress

BCBGMaxazria

Black Cocktail Dress

Regular Price: 45,000

Special Price 34,950

In Spotlight
0
BCBGMaxazria Metal One Shoulder Dress

BCBGMaxazria

Metal One Shoulder Dress

Regular Price: 40,000

Special Price 31,950

In Spotlight
0
BCBGMaxazria Fuchsia Asymmeteric Dress

BCBGMaxazria

Fuchsia Asymmeteric Dress

Regular Price: 34,000

Special Price 26,950

Editor's Pick
0
BCBGMaxazria Black High Low Mini Dress

BCBGMaxazria

Black High Low Mini Dress

Regular Price: 36,500

Special Price 23,950

(35% OFF)
0
BCBGMaxazria Rose Gold Paisley Leather Heels

BCBGMaxazria

Rose Gold Paisley Leather Heels

Regular Price: 37,500

Special Price 31,950

Editor's Pick
0
BCBGMaxazria Multicolor Ruffled Floral Blouse

BCBGMaxazria

Multicolor Ruffled Floral Blouse

Regular Price: 18,000

Special Price 11,950

(34% OFF)
0
BCBGMaxazria Tan Satin Cocktail Dress

BCBGMaxazria

Tan Satin Cocktail Dress

Regular Price: 39,500

Special Price 29,950

(25% OFF)
0
BCBGMaxazria Coral Tie Front Gown

BCBGMaxazria

Coral Tie Front Gown

Regular Price: 42,000

Special Price 33,950

In Spotlight
0
BCBGMaxazria Royal Blue Asymmetrical Sleeveless Dress

BCBGMaxazria

Royal Blue Asymmetrical Sleeveless Dress

Regular Price: 35,000

Special Price 28,950

Best Selling
0
BCBGMaxazria White Sleeveless Maxi Dress

BCBGMaxazria

White Sleeveless Maxi Dress

Regular Price: 34,000

Special Price 24,950

(27% OFF)
0
BCBGMaxazria Black Lace Detailed Bodycon Dress

BCBGMaxazria

Black Lace Detailed Bodycon Dress

Regular Price: 21,500

Special Price 13,950

(36% OFF)
0
BCBGMaxazria Beige Metallic Peplum Wrap Top

BCBGMaxazria

Beige Metallic Peplum Wrap Top

Regular Price: 19,500

Special Price 14,950

Best Selling
0
BCBGMaxazria Black Bell Sleeve Mesh Dress

BCBGMaxazria

Black Bell Sleeve Mesh Dress

Regular Price: 36,500

Special Price 23,950

(35% OFF)
0
BCBGMaxazria Pink Sweater Cocktail Dress

BCBGMaxazria

Pink Sweater Cocktail Dress

Regular Price: 36,000

Special Price 26,950

(26% OFF)
0
BCBGMaxazria Orange Textured Bodycon Dress

BCBGMaxazria

Orange Textured Bodycon Dress

Regular Price: 22,000

Special Price 15,990

(28% OFF)
0
BCBGMaxazria Beige Party Mini Dress

BCBGMaxazria

Beige Party Mini Dress

Regular Price: 35,000

Special Price 29,950

In Spotlight
0
BCBGMaxazria White Ruffle Shirtdress

BCBGMaxazria

White Ruffle Shirtdress

Regular Price: 36,000

Special Price 26,950

(26% OFF)
0
BCBGMaxazria Silver Metallic Long Sleeves Dress

BCBGMaxazria

Silver Metallic Long Sleeves Dress

Regular Price: 40,000

Special Price 29,950

(26% OFF)
0
BCBGMaxazria Royal Blue Tulip High-Low Top

BCBGMaxazria

Royal Blue Tulip High-Low Top

Regular Price: 18,000

Special Price 11,950

(34% OFF)
0
BCBGMaxazria Black Metallic Halter Top

BCBGMaxazria

Black Metallic Halter Top

Regular Price: 17,500

Special Price 12,950

(26% OFF)
0
BCBGMaxazria Multicolor Paisley-Print Blouson Top

BCBGMaxazria

Multicolor Paisley-Print Blouson Top

Regular Price: 22,000

Special Price 15,950

(28% OFF)
0
BCBGMaxazria Multi Color Smocked Top

BCBGMaxazria

Multi Color Smocked Top

Regular Price: 16,000

Special Price 9,950

(38% OFF)
0
BCBGMaxazria Coral Ribbed Sleeveless Crop Top

BCBGMaxazria

Coral Ribbed Sleeveless Crop Top

Regular Price: 16,000

Special Price 11,950

(26% OFF)
0
BCBGMaxazria Sahara Combo Striped Top

BCBGMaxazria

Sahara Combo Striped Top

Regular Price: 12,500

Special Price 6,950

(45% OFF)
0
BCBGMaxazria Maroon Twist Front Wrap Top

BCBGMaxazria

Maroon Twist Front Wrap Top

Regular Price: 13,500

Special Price 6,950

(49% OFF)
0
BCBGMaxazria Light Blue One Shoulder Blouse

BCBGMaxazria

Light Blue One Shoulder Blouse

Regular Price: 18,500

Special Price 12,950

(30% OFF)
0
BCBGMaxazria Multicolor Tie Front Tank Top

BCBGMaxazria

Multicolor Tie Front Tank Top

Regular Price: 12,500

Special Price 6,950

(45% OFF)
0
BCBGMaxazria White Liza Ribbed Racerback Tank Top

BCBGMaxazria

White Liza Ribbed Racerback Tank Top

Regular Price: 7,500

Special Price 3,950

(48% OFF)
0
BCBGMaxazria Off White Knot Front Top

BCBGMaxazria

Off White Knot Front Top

Regular Price: 7,500

Special Price 3,950

(48% OFF)
0
BCBGMaxazria Mustard Knot Front Pullover Top

BCBGMaxazria

Mustard Knot Front Pullover Top

Regular Price: 16,500

Special Price 7,950

(52% OFF)
0
BCBGMaxazria Off White Zip Back Peplum Top

BCBGMaxazria

Off White Zip Back Peplum Top

Regular Price: 22,500

Special Price 15,950

(30% OFF)
0
BCBGMaxazria Black Satin Slouchy Camisole Top

BCBGMaxazria

Black Satin Slouchy Camisole Top

Regular Price: 13,500

Special Price 7,950

(42% OFF)
0
BCBGMaxazria Black Mock Neck Peplum Top

BCBGMaxazria

Black Mock Neck Peplum Top

Regular Price: 17,500

Special Price 12,950

(26% OFF)
0
BCBGMaxazria White Sweater Top

BCBGMaxazria

White Sweater Top

Regular Price: 19,500

Special Price 14,950

In Spotlight
0
BCBGMaxazria Navy Blue Halter Neck Top

BCBGMaxazria

Navy Blue Halter Neck Top

Regular Price: 28,500

Special Price 21,950

Best Selling
0
BCBGMaxazria Heather Grey Liza Ribbed Racerback Tank Top

BCBGMaxazria

Heather Grey Liza Ribbed Racerback Tank Top

Regular Price: 7,500

Special Price 3,950

(48% OFF)
0
BCBGMaxazria Black Liza Ribbed Racerback Tank Top

BCBGMaxazria

Black Liza Ribbed Racerback Tank Top

Regular Price: 7,500

Special Price 3,950

(48% OFF)
0
BCBGMaxazria Gardenia Chiffon Drapey Camisole Top

BCBGMaxazria

Gardenia Chiffon Drapey Camisole Top

Regular Price: 10,500

Special Price 4,950

(53% OFF)
0
BCBGMaxazria Hazelnut Liza Ribbed Racerback Tank Top

BCBGMaxazria

Hazelnut Liza Ribbed Racerback Tank Top

Regular Price: 7,500

Special Price 3,950

(48% OFF)
0
BCBGMaxazria Dark Ink Liza Ribbed Racerback Tank Top

BCBGMaxazria

Dark Ink Liza Ribbed Racerback Tank Top

Regular Price: 7,500

Special Price 3,950

(48% OFF)
0
BCBGMaxazria Navy Blue Knit Sweater Top

BCBGMaxazria

Navy Blue Knit Sweater Top

Regular Price: 19,000

Special Price 13,950

(27% OFF)
0
BCBGMaxazria Multicolor Asymmetrical Peplum Top

BCBGMaxazria

Multicolor Asymmetrical Peplum Top

Regular Price: 24,500

Special Price 13,950

(44% OFF)
0
<12345>

Filter By

Gender

Designer

Type

Clothing Type

Footwear Type

Accessories Type

Size

Clothing Size

Footwear Size(UK)

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.