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
Red & Brown
If you are on the hunt for the most classic colour in roses - red, then look no further. We have a huge collection available in different styles from floribundas to climbers. All of our roses are chosen for their disease resistance and ability to flower well through the summer months.
Use the filters to find your perfect rose, whether a more fragrant red rose is important to you you'll find your perfect one easily.
Within this section you will also find some of our roses classified as brown which have more rusty red and terracotta hues, which make really eyecatching and unusual shades to put into your garden, sure to garner attention by neighbours and visitors!
If you are on the hunt for the most classic colour in roses - red, then look no further. We have a huge collection available in different styles from floribundas to climbers. All of our roses are chosen for their disease resistance and ability to flower well through the summer months.
Use the filters to find your perfect rose, whether a more fragrant red rose is important to you you'll find your perfect one easily.
Within this section you will also find some of our roses classified as brown which have more rusty red and terracotta hues, which make really eyecatching and unusual shades to put into your garden, sure to garner attention by neighbours and visitors!
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=125
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_e6b0154bd8f4ee8f30a954bcc5f04256789e77c4` 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
