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.

SANTONI

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

Santoni Black Ankle Leather Boots

Santoni

Black Ankle Leather Boots

Regular Price: 75,500

Special Price 59,950

In Spotlight
0
Santoni White Leather Sneakers

Santoni

White Leather Sneakers

Regular Price: 49,500

Special Price 38,950

Trending
0
Santoni Brown Fringes Leather Loafers

Santoni

Brown Fringes Leather Loafers

Regular Price: 75,500

Special Price 63,950

In Spotlight
0
Santoni Brown Monk Strap Dress Shoes

Santoni

Brown Monk Strap Dress Shoes

Regular Price: 69,500

Special Price 55,950

Trending
0
Santoni Blue Leather Lace Ups

Santoni

Blue Leather Lace Ups

Regular Price: 65,500

Special Price 52,950

Limited Quantity
0
Santoni Brown Leather Lace Ups

Santoni

Brown Leather Lace Ups

Regular Price: 65,500

Special Price 52,950

Limited Quantity
0

Filter By

Gender

Designer

Type

Footwear Type

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.