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='10' 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 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
- SPACES DoharSpecial Price ₹1,947 Regular Price ₹2,995 35% offSPACES DoharSpecial Price ₹1,947 Regular Price ₹2,995 35% offSPACES ESSENTIALS DoharSpecial Price ₹1,297 Regular Price ₹1,995 35% offSPACES ESSENTIALS DoharSpecial Price ₹1,947 Regular Price ₹2,995 35% offSPACES Marvel Single Dohar₹1,795SPACES Marvel Single Dohar₹1,795SPACES Starwars Single Dohar₹1,795Sort By
Dohar OnlineDohar is a soft, cosy blanket which is light enough for the summer and warm enough for the winter. This blanket is your friend in every season. Apart from offering you comfortable sleep, these dohar can also infuse warmth and style in your room with the patterns and colours that they come in. You can find a wide variety of options in dohar online.
Buying dohar online at Spaces.in will help you make the right choice for your home because you can narrow down your search according to your needs and preferences, by adding filters such as size, price, colour, pattern and fabric. The SPACES dohar are available in a wide range of colours such as bright green, neutral white and soothing pastel blue. The patterns have been chosen with an understanding of the tastes of people from all age groups. So, you will find dohar of premium quality material sporting patterns sporting ethnic and contemporary prints for your room as well digitally printed Disney and Marvel animated characters for children. Buy dohar online at Spaces.in and transform the look of your room.
For details about Dohar like the blanket benefits, types and uses, check Spaces Blog.