Filter Options
Now Shopping by
- X Fragrance Light to Medium
- 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
Search results for: 'Garden Roses.co.uk - Floribunda "Special Son" Potted Bush'
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_4d636a9e33c90bfa8a5efde8a38dc1f21819b5c6` 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 25
- Filter
- Grid
- List
-
- Page Previous
- Page 1
- You're currently reading page 2
-
- Related search terms
- Potted blue rose
- Potted garden rose
- bush roses
- garden of eden/rose-type
- Potted patio roses
View Product
Hybrid Tea
From £24.95
View Product
Exclusive
Climbing
Out of stock
View Product
Hybrid Tea
Out of stock
View Product
Patio
Out of stock
View Product
Exclusive
Floribunda
Out of stock
- Filter
- Grid
- List
-
- Page Previous
- Page 1
- You're currently reading page 2
-