Filter Options
Now Shopping by
- Colour
- Rose Type
- Fragrance
- Planting Situation
-
-
Arch/Obelisk(6)
-
Back Border or Container(4)
-
Back border/hedging or container(3)
-
Fencing/Pergola/Trellis(51)
-
Front Border or Container(42)
-
Front to Mid Border or Container(33)
-
High Wall/Tree/Arbour/Large Arch(30)
-
Mid Border or Container(206)
-
Mid Border/ Central Bed or Container(25)
-
Mid to Back Border or Container(76)
-
Mid to back border/hedging or container(2)
-
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
Search results for: 'strawberries and cream standard rose'
-
Filter
- X Planting Situation Back Border or Container
- X Planting Situation Fencing/Pergola/Trellis
- X Planting Situation Mid to Back Border or Container
-
- Category
-
-
-
(131)
-
(10)
-
- Colour
- Rose Type
- Fragrance
- Planting Situation
-
-
Arch/Obelisk(6)
-
Back Border or Container(4)
-
Back border/hedging or container(3)
-
Fencing/Pergola/Trellis(51)
-
Front Border or Container(42)
-
Front to Mid Border or Container(33)
-
High Wall/Tree/Arbour/Large Arch(30)
-
Mid Border or Container(206)
-
Mid Border/ Central Bed or Container(25)
-
Mid to Back Border or Container(76)
-
Mid to back border/hedging or container(2)
-
SELECT `e`.*, `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`, `cat_index`.`position` AS `cat_index_position`, 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` FROM `catalog_product_entity` AS `e`
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 `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(3, 4) AND cat_index.category_id=2
INNER JOIN `temp_dabbbe5a8e82a5cf9d0c87e7a2c5b468c96572d3` 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 ORDER BY `search_result`.`score` DESC, `e`.`entity_id` ASC
LIMIT 25 OFFSET 125
- Related search terms
- roses in large pots/planting-situation/back-border-or-container-mid-border
- roses in large pots/fragrance/strong/planting-situation
- Roses named Mary sister or Peter or all three/planting-situation
- roses in large pots/fragrance/strong/planting-situation/back-border
- roses in large pots/rose-type/rose-of-the-year- -gold-standard-award-shrub/fragrance
![Domaine de Chantilly rose - Apricot Shrub - Gardenroses.co.uk](https://cdn.gardenroses.co.uk/media/catalog/product/cache/67c5738eaf4e507b6445c1e40e038080/d/o/domaine_de_chantilly_19_22_sq.jpg)
View Product
From £22.95
![Our Special Girl rose | Purple Floribunda | Gardenroses.co.uk](https://cdn.gardenroses.co.uk/media/catalog/product/cache/67c5738eaf4e507b6445c1e40e038080/p/e/penni_our_special_girl_19_01_cropped.jpg)
View Product
Exclusive
![](https://www.gardenroses.co.uk/static/frontend/SpiralMedia/gardenroses/en_GB/images/png/Flag-End-Right-Green.png)
Floribunda
Out of stock
![Copper Lights rose - Orange Hybrid Tea - Gardenroses.co.uk](https://cdn.gardenroses.co.uk/media/catalog/product/cache/67c5738eaf4e507b6445c1e40e038080/c/o/copper-lights-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)
Hybrid Tea
Out of stock
![The Lady Gardener](https://cdn.gardenroses.co.uk/media/catalog/product/cache/67c5738eaf4e507b6445c1e40e038080/t/h/the-lady-gardener-rose-7.jpg)
View Product
Shrub,
David Austin,
Out of stock
![Special Sister](https://cdn.gardenroses.co.uk/media/catalog/product/cache/67c5738eaf4e507b6445c1e40e038080/s/p/special-sister-garden-rose-3.jpg)
View Product
Exclusive
![](https://www.gardenroses.co.uk/static/frontend/SpiralMedia/gardenroses/en_GB/images/png/Flag-End-Right-Green.png)
Hybrid Tea
Out of stock
![Ginger Syllabub](https://cdn.gardenroses.co.uk/media/catalog/product/cache/67c5738eaf4e507b6445c1e40e038080/g/i/ginger-syllabub-garden-rose-2.jpg)
View Product
Climbing
From £23.95