canonical15:-https://aws.darveys.com/all.html?___SID=U Buy Men's & Women Clothing, Bags & Accessories Online in India | Darveys.com : Rachel Roy

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.

RACHEL ROY

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 (3106) 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
SORT BY
  1. 1
  2. 2

Rachel Roy Black Faux Leather Mini Skirt

Rachel Roy

Black Faux Leather Mini Skirt

Regular Price: 10,500

Special Price 5,950

(44% OFF)
0
Rachel Roy White Ruffle Crop Tee

Rachel Roy

White Ruffle Crop Tee

Regular Price: 8,500

Special Price 3,950

(54% OFF)
0
Rachel Roy Light Camel Stiped Trench Coat

Rachel Roy

Light Camel Stiped Trench Coat

Regular Price: 24,500

Special Price 13,950

(44% OFF)
0
Rachel Roy Black Quilted Puffer Coat

Rachel Roy

Black Quilted Puffer Coat

Regular Price: 29,500

Special Price 18,950

(36% OFF)
0
Rachel Roy Champagne Faux Fur Teddy Coat

Rachel Roy

Champagne Faux Fur Teddy Coat

Regular Price: 28,500

Special Price 15,950

(45% OFF)
0
Rachel Roy Black Faux Fur Lined Rain Coat

Rachel Roy

Black Faux Fur Lined Rain Coat

Regular Price: 32,500

Special Price 21,950

(33% OFF)
0
Rachel Roy Black Faux Fur Trim Coat

Rachel Roy

Black Faux Fur Trim Coat

Regular Price: 28,500

Special Price 19,950

(30% OFF)
0
Rachel Roy White Crepe Wrap Trench Coat

Rachel Roy

White Crepe Wrap Trench Coat

Regular Price: 28,500

Special Price 18,950

(34% OFF)
0
Rachel Roy Rose Crepe Wrap Trench Coat

Rachel Roy

Rose Crepe Wrap Trench Coat

Regular Price: 28,500

Special Price 16,950

(41% OFF)
0
Rachel Roy Grey Printed Crewneck Sweater

Rachel Roy

Grey Printed Crewneck Sweater

Regular Price: 16,500

Special Price 7,950

(52% OFF)
0
Rachel Roy True Navy Jasmin Plaid Cami Top

Rachel Roy

True Navy Jasmin Plaid Cami Top

Regular Price: 7,500

Special Price 3,950

(48% OFF)
0
Rachel Roy Black Metallic Pleated Top

Rachel Roy

Black Metallic Pleated Top

Regular Price: 8,500

Special Price 4,950

(42% OFF)
0
Rachel Roy Lime Green Jasmin Plaid Cami Top

Rachel Roy

Lime Green Jasmin Plaid Cami Top

Regular Price: 7,500

Special Price 3,950

(48% OFF)
0
Rachel Roy Black Lace Trim Cami Top

Rachel Roy

Black Lace Trim Cami Top

Regular Price: 8,500

Special Price 4,950

(42% OFF)
0

Filter By

Gender

Designer

Type

Clothing Type

Size

Clothing 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.