app-download-header
Trending Now

Premium collection

Premium

Filter
Shopping Options
Category
Category
Styles
Styles
  1. Asymmetrical Dresses 4 items
  2. Blouses 3 items
  3. Body Suits 3 items
  4. Bodycon 23 items
  5. Crop Tops 4 items
  6. Jumpsuits 1 item
  7. Maxi Dresses 10 items
  8. Maxi Skirts 2 items
  9. Midi Dresses 12 items
  10. Midi Skirts 1 item
  11. Nightwear Set 2 items
  12. Off Shoulder Tops 5 items
  13. Off-shoulder And Bandeau Dresses 4 items
  14. Pencil Dresses 2 items
  15. Playsuits And Rompers 3 items
  16. Sets 29 items
  17. Shift Dresses 3 items
  18. Shirts 1 item
  19. Short And Mini Skirts 2 items
  20. Skater Dresses 5 items
  21. Skater Skirts 1 item
  22. T-shirts 8 items
  23. Vests And Camis 7 items
  24. Sports 2 items
  25. Sports Bra 1 item
  26. Vests 1 item
  27. Corsets & Tube Tops 3 items
Colour
Colour
  1. Beige 30 items
  2. Black 295 items
  3. Blue 109 items
  4. Brown 76 items
  5. Gold 3 items
  6. Green 85 items
  7. Grey 61 items
  8. Maroon 1 item
  9. Multi 33 items
  10. Orange 27 items
  11. Pink 75 items
  12. Purple 31 items
  13. Red 56 items
  14. Silver 15 items
  15. White 107 items
  16. Yellow 11 items
Less
Size
Size
  1. 1XL 2 items
  2. 2XL 15 items
  3. 3XL 7 items
  4. 4XL 3 items
  5. 70B 2 items
  6. 70C 2 items
  7. 70D 2 items
  8. 70E 2 items
  9. 75B 4 items
  10. 75C 4 items
  11. 75D 4 items
  12. 75E 2 items
  13. 80B 4 items
  14. 80C 4 items
  15. 80D 4 items
  16. 80E 2 items
  17. 85B 4 items
  18. 85C 4 items
  19. 85D 4 items
  20. 85E 2 items
  21. 90C 2 items
  22. 90D 2 items
  23. 95C 2 items
  24. 95D 2 items
  25. FS 4 items
  26. L 166 items
  27. M 158 items
  28. S 148 items
  29. XL 77 items
  30. XS 11 items
  31. XXL 5 items
  32. 0XL 1 item
Less
Price
Price
  1. Rs. 0 - 200 4 items
  2. Rs. 200 - 400 42 items
  3. Rs. 400 - 600 4 items
  4. Rs. 600 - 800 39 items
  5. Rs. 800 - 1000 138 items
  6. Rs. 1000 - 1200 193 items
  7. Rs. 1200 - 1400 233 items
  8. Rs. 1400 - 1600 248 items
  9. Rs. 1600 - 1800 214 items
  10. Rs. 1800 - 2000 163 items
  11. Rs. 2000 - 2500 332 items
  12. Rs. 2500 - 3000 245 items
  13. Rs. 3000 - 3500 95 items
  14. Rs. 3500 - 4000 35 items
  15. Rs. 4000 - 4500 15 items
  16. Rs. 4500 - 5000 4 items
  17. Rs. 5000 - 5500 1 item
  18. Rs. 5500 - 6000 1 item
  1. White Remove This Item
  2. Red Remove This Item
  3. S Remove This Item
  4. Rs. 1800 - 2000 Remove This Item

SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `stock_status_index`.`stock_status` AS `is_salable`, `price_index`.`price`, `price_index`.`tax_class_id`, `price_index`.`final_price`, IF(price_index.tier_price IS NOT NULL, LEAST(price_index.min_price, price_index.tier_price), price_index.min_price) AS `minimal_price`, `price_index`.`min_price`, `price_index`.`max_price`, `price_index`.`tier_price` FROM `catalog_product_entity` AS `e` INNER JOIN `catalog_category_product_index_store1` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=1 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=1539 INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id AND stock_status_index.website_id = 0 AND stock_status_index.stock_id = 1 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `search_tmp_66055a3c19e643_60339909` AS `search_result` ON e.entity_id = search_result.entity_id WHERE (stock_status_index.stock_status = 1) ORDER BY `e`.`entity_id` DESC LIMIT 24

163 styles found
  1. 60% Off
    -60%
    Red Crop Top And Long Skirt Set
  2. 60% Off
    -60%
    Red V-neck Ruched A-line Short Dress
  3. 60% Off
    -60%
    RED FLORAL TWO PIECE SWIMWEAR SET
  4. 60% Off
    -60%
    Black Regular Printed Cropped Tee
  5. 60% Off
    -60%
    WHITE CRISS-CROSS BACK SPORTS BRA
  6. 60% Off
    -60%
    White Frill-cuffed Sheer Lace Top
  7. 60% Off
    -60%
    White Knot-tie Back Sports Top
  8. 60% Off
    -60%
    White Sleeveless Slim Fit Vest
  9. 60% Off
    -60%
    Ribbed Buttoned Front Playsuit
  10. 60% Off
    -60%
    White Pyjama Top & Shorts Set
  11. 60% Off
    -60%
    White Floral Pattern V-neck Dress
  12. 60% Off
    -60%
    White Polo Neck Cut-out Playsuit
  13. 60% Off
    -60%
    White High-waisted Sports Shorts
  14. 60% Off
    -60%
    White Hook-&-eye Lace Corset Top
  15. 60% Off
    -60%
    Crimson Lace-detail V-neck Slim Top
  16. 60% Off
    -60%
    White A-line V-neck Tiered Dress