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
Types of Roses
Front Border & Patio Roses
Front Border and Patio Roses in terms of early and repeat flowering, lots of blooms, healthy and easy to manage roses, there is nothing better in the rose world than Front border or Patio Roses! Shorter growing and very easily managed with the same flowering style and habit of our Floribunda roses but with smaller leaves and flowers with more compact/shorter habit, perfect for container planting or at the front of a sunny border.
Front border or Patio garden roses make a great alternative to traditional summer bedding plants, lasting for many years with excellent long lasting displays of colour and rain tolerant flowers. Apart from being really great in containers they are also perfect for planting in sunny garden borders, Plant fragrant patio roses around 60cm apart, flowering heights for patio bushes range from 45cm to 75cm depending on chosen variety, Fragrant Patio Roses produce superb looking, well rounded balanced heads which look perfect as Standard Roses they require planting 90cm apart and are supplied as Quarter Standards (Flowering Height 90cm approx) or Half Standards (Flowering Height 150cm approx) where available also perfect for large containers in any sunny position.
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=289
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_d27a494cb018c3481c4327c7f92e7a605207383a` 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
