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

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 48, 48
SORT BY
  2. 2
  3. 3

BCBGMaxazria Dark Green Ruched Mini Dress

BCBGMaxazria

Dark Green Ruched Mini Dress

Regular Price: 12,500

Special Price 7,950

(37% OFF)
0
BCBGMaxazria Multicolor Colorblock Sweater

BCBGMaxazria

Multicolor Colorblock Sweater

Regular Price: 16,500

Special Price 11,950

(28% OFF)
0
BCBGMaxazria Metal One Shoulder Metallic Gown

BCBGMaxazria

Metal One Shoulder Metallic Gown

Regular Price: 54,000

Special Price 45,950

In Spotlight
0
BCBGMaxazria Dark Blue Smocked Ruffle Blouse

BCBGMaxazria

Dark Blue Smocked Ruffle Blouse

Regular Price: 7,500

Special Price 3,950

(48% OFF)
0
BCBGMaxazria Midnight Teal Turtleneck Crop Sweater Top

BCBGMaxazria

Midnight Teal Turtleneck Crop Sweater Top

Regular Price: 19,500

Special Price 9,950

(49% OFF)
0
BCBGMaxazria Black Inset Long Dress

BCBGMaxazria

Black Inset Long Dress

Regular Price: 32,000

Special Price 21,950

(32% OFF)
0
BCBGMaxazria Beige Sleeveless Sweater

BCBGMaxazria

Beige Sleeveless Sweater

Regular Price: 10,500

Special Price 5,950

(44% OFF)
0
BCBGMaxazria Yellow V-Neck Mini Dress

BCBGMaxazria

Yellow V-Neck Mini Dress

Regular Price: 15,500

Special Price 9,950

(36% OFF)
0
BCBGMaxazria White Long Sleeve Pullover Sweater

BCBGMaxazria

White Long Sleeve Pullover Sweater

Regular Price: 18,000

Special Price 11,950

(34% OFF)
0
BCBGMaxazria Light Pink Bralette Cropped Top

BCBGMaxazria

Light Pink Bralette Cropped Top

Regular Price: 9,500

Special Price 4,950

(48% OFF)
0
BCBGMaxazria Beige Sheath Midi Dress

BCBGMaxazria

Beige Sheath Midi Dress

Regular Price: 32,000

Special Price 20,950

(35% OFF)
0
BCBGMaxazria Black Faux Fur Coat

BCBGMaxazria

Black Faux Fur Coat

Regular Price: 25,000

Special Price 16,950

(33% OFF)
0
BCBGMaxazria Dark Blue A-Line Midi Dress

BCBGMaxazria

Dark Blue A-Line Midi Dress

Regular Price: 36,000

Special Price 26,950

(26% OFF)
0
BCBGMaxazria Yellow Flounce Dress

BCBGMaxazria

Yellow Flounce Dress

Regular Price: 26,000

Special Price 17,950

(31% OFF)
0
BCBGMaxazria Golden Glow Chiffon Drapey Camisole Top

BCBGMaxazria

Golden Glow Chiffon Drapey Camisole Top

Regular Price: 10,500

Special Price 4,950

(53% OFF)
0
BCBGMaxazria Lemon One Shoulder Dress

BCBGMaxazria

Lemon One Shoulder Dress

Regular Price: 42,000

Special Price 34,950

Best Selling
0
BCBGMaxazria Light Blue Long Sleeve Midi Dress

BCBGMaxazria

Light Blue Long Sleeve Midi Dress

Regular Price: 28,500

Special Price 21,950

Best Selling
0
BCBGMaxazria Light Purple Mini Cocktail Dress

BCBGMaxazria

Light Purple Mini Cocktail Dress

Regular Price: 45,000

Special Price 29,950

(34% OFF)
0
BCBGMaxazria Orange Smocked Crop Top

BCBGMaxazria

Orange Smocked Crop Top

Regular Price: 16,500

Special Price 7,950

(52% OFF)
0
BCBGMaxazria Mustard Printed Satin Shirt Dress

BCBGMaxazria

Mustard Printed Satin Shirt Dress

Regular Price: 34,000

Special Price 22,950

(33% OFF)
0
BCBGMaxazria Black Paisley Leather Heels

BCBGMaxazria

Black Paisley Leather Heels

Regular Price: 37,500

Special Price 31,950

Editor's Pick
0
BCBGMaxazria Black Strapless Evening Dress

BCBGMaxazria

Black Strapless Evening Dress

Regular Price: 39,500

Special Price 29,950

(25% OFF)
0
BCBGMaxazria Black Faux Leather Top

BCBGMaxazria

Black Faux Leather Top

Regular Price: 16,500

Special Price 9,950

(40% OFF)
0
BCBGMaxazria Light Pink A-Line Pleated Gown

BCBGMaxazria

Light Pink A-Line Pleated Gown

Regular Price: 38,000

Special Price 33,950

In Spotlight
0
BCBGMaxazria Tibetanred A-Line Jersey Mini Wrap Dress

BCBGMaxazria

Tibetanred A-Line Jersey Mini Wrap Dress

Regular Price: 31,500

Special Price 18,950

(40% OFF)
0
BCBGMaxazria Multicolor Floral V-Neck Crop Top

BCBGMaxazria

Multicolor Floral V-Neck Crop Top

Regular Price: 12,500

Special Price 6,950

(45% OFF)
0
BCBGMaxazria Bright Elm Satin Ruffle Handkerchief Dress

BCBGMaxazria

Bright Elm Satin Ruffle Handkerchief Dress

Regular Price: 13,500

Special Price 7,950

(42% OFF)
0
BCBGMaxazria Light Pink Fringe Cocktail Dress

BCBGMaxazria

Light Pink Fringe Cocktail Dress

Regular Price: 34,000

Special Price 24,950

(27% OFF)
0
BCBGMaxazria Dark Blue Wrap Blouse

BCBGMaxazria

Dark Blue Wrap Blouse

Regular Price: 21,500

Special Price 12,950

(40% OFF)
0
BCBGMaxazria Dark Navy Combo Knit V-Neck Sheath Dress

BCBGMaxazria

Dark Navy Combo Knit V-Neck Sheath Dress

Regular Price: 16,500

Special Price 7,950

(52% OFF)
0
BCBGMaxazria Red Cocktail Dress

BCBGMaxazria

Red Cocktail Dress

Regular Price: 31,500

Special Price 18,950

(40% OFF)
0
BCBGMaxazria Sky Blue Sleeveless Surplice Top

BCBGMaxazria

Sky Blue Sleeveless Surplice Top

Regular Price: 14,500

Special Price 7,950

(46% OFF)
0
BCBGMaxazria Blue Smocked Tiered Dress

BCBGMaxazria

Blue Smocked Tiered Dress

Regular Price: 24,500

Special Price 14,950

(39% OFF)
0
BCBGMaxazria Multicolor Floral Print Criss-Cross Dress

BCBGMaxazria

Multicolor Floral Print Criss-Cross Dress

Regular Price: 27,500

Special Price 15,950

(42% OFF)
0
BCBGMaxazria Multicolor Floral Wrap Top

BCBGMaxazria

Multicolor Floral Wrap Top

Regular Price: 21,500

Special Price 12,950

(40% OFF)
0
BCBGMaxazria Black Ruffled Bell Sleeve Dress

BCBGMaxazria

Black Ruffled Bell Sleeve Dress

Regular Price: 28,500

Special Price 15,950

(45% OFF)
0
BCBGMaxazria Maroon Faux Wrap Dress

BCBGMaxazria

Maroon Faux Wrap Dress

Regular Price: 20,000

Special Price 11,950

(41% OFF)
0
BCBGMaxazria Olive Peplum Top

BCBGMaxazria

Olive Peplum Top

Regular Price: 20,000

Special Price 11,950

(41% OFF)
0
BCBGMaxazria Leopard Print Halter Midi Dress

BCBGMaxazria

Leopard Print Halter Midi Dress

Regular Price: 39,500

Special Price 29,950

(25% OFF)
0
BCBGMaxazria Rose Gold Sleeveless V-Neck Gown

BCBGMaxazria

Rose Gold Sleeveless V-Neck Gown

Regular Price: 24,000

Special Price 15,950

(34% OFF)
0
BCBGMaxazria Light Pink Tie Shoulder Print Dress

BCBGMaxazria

Light Pink Tie Shoulder Print Dress

Regular Price: 16,000

Special Price 9,950

(38% OFF)
0
BCBGMaxazria Dark Brown Faux Leather Top

BCBGMaxazria

Dark Brown Faux Leather Top

Regular Price: 16,500

Special Price 9,950

(40% OFF)
0
BCBGMaxazria Off White Fringed Lace Corset Waist Mini Dress

BCBGMaxazria

Off White Fringed Lace Corset Waist Mini Dress

Regular Price: 21,500

Special Price 12,950

(40% OFF)
0
BCBGMaxazria Yellow V-Neck Mini Dress

BCBGMaxazria

Yellow V-Neck Mini Dress

Regular Price: 28,500

Special Price 18,950

(34% OFF)
0
BCBGMaxazria Light Pink Tie Waist Maxi Dress

BCBGMaxazria

Light Pink Tie Waist Maxi Dress

Regular Price: 18,000

Special Price 11,950

(34% OFF)
0
BCBGMaxazria Off White Tank Top Blouse

BCBGMaxazria

Off White Tank Top Blouse

Regular Price: 7,500

Special Price 4,950

(34% OFF)
0
BCBGMaxazria Light Purple Halter Midi Dress

BCBGMaxazria

Light Purple Halter Midi Dress

Regular Price: 30,000

Special Price 20,950

(31% OFF)
0
BCBGMaxazria Dark Blue Tulle Rhinestone Gown

BCBGMaxazria

Dark Blue Tulle Rhinestone Gown

Regular Price: 74,500

Special Price 48,950

(35% 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.