Filter Options
Shopping Options
- Colour
- Rose Type
- Fragrance
- Planting Situation
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
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_8e278594f93b05109381623e33b07323a1672ca7` 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
![Del Boy- Yellow Floribunda Rose - Gardenroses.co.uk](https://cdn.gardenroses.co.uk/media/catalog/product/cache/67c5738eaf4e507b6445c1e40e038080/d/e/del_boy_floribunda_garden_rose_23-11.jpg)
View Product
New
Exclusive
![](https://www.gardenroses.co.uk/static/frontend/SpiralMedia/gardenroses/en_GB/images/png/Flag-End-Right-Pink.png)
![](https://www.gardenroses.co.uk/static/frontend/SpiralMedia/gardenroses/en_GB/images/png/Flag-End-Right-Green.png)
Floribunda
Out of stock
![Leah Tutu rose - Yellow Shrub - Gardenroses.co.uk](https://cdn.gardenroses.co.uk/media/catalog/product/cache/67c5738eaf4e507b6445c1e40e038080/l/e/leah-tutu-rose-1.jpg)
View Product
Shrub
From £20.95
![Leah Tutu rose - Yellow Shrub - Gardenroses.co.uk](https://cdn.gardenroses.co.uk/media/catalog/product/cache/67c5738eaf4e507b6445c1e40e038080/l/e/leah_tutu_std_20_04_ps2.jpg)
View Product
Standard Roses
Out of stock
![Love of my Life rose - Red Hybrid Tea - Gardenroses.co.uk](https://cdn.gardenroses.co.uk/media/catalog/product/cache/67c5738eaf4e507b6445c1e40e038080/l/o/love_of_my_life_20_12_cropped.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
![Luke - Yellow Climbing Rose - Gardenroses.co.uk](https://cdn.gardenroses.co.uk/media/catalog/product/cache/67c5738eaf4e507b6445c1e40e038080/l/u/luke_climbing_rose_garden_rose_23-15.jpg)
View Product
New
Exclusive
![](https://www.gardenroses.co.uk/static/frontend/SpiralMedia/gardenroses/en_GB/images/png/Flag-End-Right-Pink.png)
![](https://www.gardenroses.co.uk/static/frontend/SpiralMedia/gardenroses/en_GB/images/png/Flag-End-Right-Green.png)
Climbing
From £24.95
![Our Joe rose - Yellow Hybrid Tea - Gardenroses.co.uk](https://cdn.gardenroses.co.uk/media/catalog/product/cache/67c5738eaf4e507b6445c1e40e038080/j/o/joe-longthorne-rose-rose-4.jpg)
View Product
UK Exclusive
![](https://www.gardenroses.co.uk/static/frontend/SpiralMedia/gardenroses/en_GB/images/png/Flag-End-Right-Pink.png)
Floribunda
Out of stock
![Peter rose | Red Hybrid Tea | Gardenroses.co.uk](https://cdn.gardenroses.co.uk/media/catalog/product/cache/67c5738eaf4e507b6445c1e40e038080/p/e/peter_hybrid_tea_garden_rose_21_17.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