There are no items currently on your wishlist. Visit any product on our website and click the "Add to Wishlist" button to save for later or share your wishlist with family or friends
Patio Pot / Container
There's always room for a rose in a pot! A lovely way to fill up some pots with roses that will keep bringing you pleasure for many years to come, without having to continually replace other more colourful plant options such as bedding.
Placing roses into containers are a fantastic idea, they can be placed near doorways and on patios - they can also be moved around the garden in different areas.
Roses should be planted in a deep pot with a minimum diameter of 50cm wide but the taller the rose the larger the pot should become. Plant roses into containers into a compost that is specifically for roses (we recommend John Innes number 3).
If you have larger pots you are wishing to fill, you might want to view the Large Containers/Half Barrels category which is larger roses suited to larger containers.
There's always room for a rose in a pot! A lovely way to fill up some pots with roses that will keep bringing you pleasure for many years to come, without having to continually replace other more colourful plant options such as bedding.
Placing roses into containers are a fantastic idea, they can be placed near doorways and on patios - they can also be moved around the garden in different areas.
Roses should be planted in a deep pot with a minimum diameter of 50cm wide but the taller the rose the larger the pot should become. Plant roses into containers into a compost that is specifically for roses (we recommend John Innes number 3).
If you have larger pots you are wishing to fill, you might want to view the Large Containers/Half Barrels category which is larger roses suited to larger containers.
SELECT `e`.*, `cat_index`.`position` AS `cat_index_position`, `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`, IFNULL(review_summary.reviews_count, 0) AS `reviews_count`, IFNULL(review_summary.rating_summary, 0) AS `rating_summary`, `stock_status_index`.`stock_status` AS `is_salable`, IF(at_name.value_id > 0, at_name.value, at_name_default.value) AS `name` 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=199
INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.customer_group_id = 0 AND price_index.website_id = '1'
INNER JOIN `temp_c21c6c3cf42743a6ffe40be1825f2104e5a53276` AS `search_result` ON `e`.`entity_id` = `search_result`.`entity_id`
LEFT JOIN `review_entity_summary` AS `review_summary` ON e.entity_id = review_summary.entity_pk_value AND review_summary.store_id = 1 AND review_summary.entity_type = (SELECT `review_entity`.`entity_id` FROM `review_entity` WHERE (entity_code = 'product'))
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
LEFT JOIN `catalog_product_entity_varchar` AS `at_name_default` ON (`at_name_default`.`entity_id` = `e`.`entity_id`) AND (`at_name_default`.`attribute_id` = '73') AND `at_name_default`.`store_id` = 0
LEFT JOIN `catalog_product_entity_varchar` AS `at_name` ON (`at_name`.`entity_id` = `e`.`entity_id`) AND (`at_name`.`attribute_id` = '73') AND (`at_name`.`store_id` = 1) ORDER BY `name` ASC, `e`.`entity_id` DESC, `e`.`entity_id` ASC
LIMIT 25
Exclusive
