Copyright © 2018-19 Welspun India Limited, All rights reserved.
SELECT DISTINCT `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` 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='34' LEFT 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 `catalog_product_index_eav` AS `layered_nav_pattern` ON `layered_nav_pattern`.`entity_id` = `e`.`entity_id` AND `layered_nav_pattern`.`attribute_id` = '160' AND `layered_nav_pattern`.`store_id` = '1' AND `layered_nav_pattern`.`value` IN (55) WHERE (stock_status_index.stock_status=1) AND (stock_status_index.stock_status=1) AND (stock_status_index.stock_status=1) AND (stock_status_index.stock_status=1) AND (stock_status_index.stock_status=1) AND (stock_status_index.stock_status=1) ORDER BY `cat_index`.`position` ASC, `e`.`entity_id` ASC LIMIT 2000
- WELHOME Snapshot CurtainSpecial Price ₹664 Regular Price ₹949 30% offSort By
Buy Curtains OnlineCurtains are for more than just providing shade and warmth. A well-chosen curtain can change the mood of the room. They can also speak volumes about your style and taste, so they are a crucial part of your home décor. Apart from this, they add more comfort and intimacy to your living space. So, when you buy curtains online, choosing the right ones for your home becomes twice as important.
Curtains online come in a variety of colours and designs. At Spaces.in, the sizes, colours and designs of door and window curtains have been chosen with an understanding of a wide range of needs and preferences. From solid coloured curtains in fresh shades, which instantly uplift the vibe of any room, to patterns such as stripes and geometric prints, which can go with any kind of room décor, you can buy curtains online at Spcaes.in which will be the right choice for your home.
Visit Spaces Blog for more information on curtains, their types and designs.