Filter Options
Now Shopping by
- Colour
- Rose Type
- Fragrance
- Planting Situation
-
-
Arch/Obelisk(2)
-
Back Border or Container(2)
-
Back border/hedging or container(2)
-
Fencing/Pergola/Trellis(3)
-
Front Border or Container(20)
-
Front to Mid Border or Container(7)
-
High Wall/Tree/Arbour/Large Arch(6)
-
Mid Border or Container(52)
-
Mid Border/ Central Bed or Container(2)
-
Mid to Back Border or Container(13)
-
My Wish List
Last Added Items
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
Default Category
A-Z of Roses
-
Filter
- X Rose Type Standard Roses
- X Planting Situation Arch/Obelisk
- X Planting Situation Front Border or Container
- X Planting Situation Mid to Back Border or Container
-
- Category
-
-
-
(35)
-
(15)
-
(9)
-
(15)
-
- Colour
- Rose Type
- Fragrance
- Planting Situation
-
-
Arch/Obelisk(2)
-
Back Border or Container(2)
-
Back border/hedging or container(2)
-
Fencing/Pergola/Trellis(3)
-
Front Border or Container(20)
-
Front to Mid Border or Container(7)
-
High Wall/Tree/Arbour/Large Arch(6)
-
Mid Border or Container(52)
-
Mid Border/ Central Bed or Container(2)
-
Mid to Back Border or Container(13)
-
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=154
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_d93f67c14f6224ee17ebff0e916f87903549da58` 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 OFFSET 25
- Filter
- Grid
- List
-
- Page Previous
- Page 1
- You're currently reading page 2
-
![Rebecca rose | Pink Patio rose | Gardenroses.co.uk](https://cdn.gardenroses.co.uk/media/catalog/product/cache/67c5738eaf4e507b6445c1e40e038080/r/e/rebecca-garden-rose-2.jpg)
View Product
Exclusive
![](https://www.gardenroses.co.uk/static/frontend/SpiralMedia/gardenroses/en_GB/images/png/Flag-End-Right-Green.png)
Patio
Out of stock
![Rebecca standard rose | Pink Patio | Gardenroses.co.uk](https://cdn.gardenroses.co.uk/media/catalog/product/cache/67c5738eaf4e507b6445c1e40e038080/r/e/rebecca-garden-rose-1_1.jpg)
View Product
Exclusive
![](https://www.gardenroses.co.uk/static/frontend/SpiralMedia/gardenroses/en_GB/images/png/Flag-End-Right-Green.png)
Standard Roses
From £59.95
![Special Friend rose | Pink Patio | Gardenroses.co.uk](https://cdn.gardenroses.co.uk/media/catalog/product/cache/67c5738eaf4e507b6445c1e40e038080/s/p/special_friend_patio_garden_rose_22_07.jpg)
View Product
Patio
From £19.95
![Special Friend standard rose | Pink Patio | Gardenroses.co.uk](https://cdn.gardenroses.co.uk/media/catalog/product/cache/67c5738eaf4e507b6445c1e40e038080/s/p/special_friend_patio_standard_rose_22_13.jpg)
View Product
Standard Roses
Out of stock
![Suma weeping standard rose | Pink Ground Cover rose | Gardenroses.co.uk](https://cdn.gardenroses.co.uk/media/catalog/product/cache/67c5738eaf4e507b6445c1e40e038080/s/u/suma-garden-rose-3_3.jpg)
View Product
Standard Roses
From £64.95
![Swany weeping standard rose | White Weeping Standard | Gardenroses.co.uk](https://cdn.gardenroses.co.uk/media/catalog/product/cache/67c5738eaf4e507b6445c1e40e038080/s/w/swany-garden-rose-2.jpg)
View Product
Standard Roses
From £67.95
![Tango Showground rose | Orange Ground Cover | Gardenroses.co.uk](https://cdn.gardenroses.co.uk/media/catalog/product/cache/67c5738eaf4e507b6445c1e40e038080/t/a/tango-showground-garden-rose-2.jpg)
View Product
Ground Cover,
Standard Roses,
From £20.95
![Tango Showground standard rose | Orange Ground Cover | Gardenroses.co.uk](https://cdn.gardenroses.co.uk/media/catalog/product/cache/67c5738eaf4e507b6445c1e40e038080/t/a/tango-showground-garden-rose-3_1.jpg)
View Product
Standard Roses
From £67.95
![Wild Fire rose | Orange Patio rose | Gardenroses.co.uk](https://cdn.gardenroses.co.uk/media/catalog/product/cache/67c5738eaf4e507b6445c1e40e038080/w/i/wild_fire-_1_sq.jpg)
View Product
Patio
From £19.95
![Wild Fire standard rose | Orange Patio | Gardenroses.co.uk](https://cdn.gardenroses.co.uk/media/catalog/product/cache/67c5738eaf4e507b6445c1e40e038080/w/i/wild-fire-standard-rose.jpg)
View Product
Standard Roses
From £49.95
- Filter
- Grid
- List
-
- Page Previous
- Page 1
- You're currently reading page 2
-