« Previous Plant | Next Plant »
Rosa The King's Rose
The King's Rose English Shrub Rose
- » Subtle fragrance
- » Bold color
- » Very few thorns
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 28.1 ms Record Count: 0 Cached: No Lazy: No SQL: select h.program, s.name, s.udefSKUNameSuffix, s.sku, s.udefBannedStates, s.udefBBL, s.udefRR, s.udefLR, s.udefTimsTopTwenty, s.udefJaimesHotList, s.listPrice as price, s.udefCategory as category, s.udefComments as comments, s.udefGrade as grade, s.udefSpecial as special, s.udefPlantSize as plantSize, s.qtyUnit as size, s.salePrice, s.listPrice, s.udefTier2, s.udefTier2Price, s.udefTier3, s.udefTier3Price, s.plantID, s.id from tb_plant_skus s inner join tb_lists_hotlist h on (h.sku = s.sku) where s.isactive = 1 and s.delete_date is null and s.isecommerce = 1 and s.plantID = 10687 order by udefcategory, name, price | ||||||||||||||||||||||||||
| program | name | udefSKUNameSuffix | sku | udefBannedStates | udefBBL | udefRR | udefLR | udefTimsTopTwenty | udefJaimesHotList | price | category | comments | grade | special | plantSize | size | salePrice | listPrice | udefTier2 | udefTier2Price | udefTier3 | udefTier3Price | plantID | id | ||
This unique rose features semi-double blooms with striking fuchsia and white striped petals, giving it the timeless charm of old Gallica roses. Bright yellow stamens attract pollinators, while the flowers release a light musk fragrance with notes of fresh apple and rosewater. Its vigorous, vase-shaped habit and attractive heart-shaped foliage make it a standout in the landscape.
Find a local garden center
Growing & Maintenance Tips for Rosa The King's Rose
Plant in full sunlight to partial shade facing North, East, South, or West. All soil types are suitable.
| string |