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.

LANCASTER PARIS

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 (2350) 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

Lancaster Paris Orange Solid Mini Bucket Bag

Lancaster Paris

Orange Solid Mini Bucket Bag

Regular Price: 28,000

Special Price 19,950

(29% OFF)
0
Lancaster Paris Cherry Tassel Small Crossbody

Lancaster Paris

Cherry Tassel Small Crossbody

Regular Price: 42,000

Special Price 28,950

(32% OFF)
0
Lancaster Paris Orange Rectangle Small Crossbody

Lancaster Paris

Orange Rectangle Small Crossbody

Regular Price: 25,000

Special Price 17,950

(29% OFF)
0
Lancaster Paris Off White Solid Medium Crossbody Bag

Lancaster Paris

Off White Solid Medium Crossbody Bag

Regular Price: 25,000

Special Price 17,950

(29% OFF)
0

Filter By

Gender

Designer

Type

Handbags Type

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.

    LANCASTER PARIS