« Previous Plant | Next Plant »
You’ll find true love with True Love™- an easy to grow Floribunda shrub rose. It’s mass of crimson-red, high-petal-count blooms continuously bloom throughout the season. The compact habit is a great low maintenance option and its high flower count, bigger blooms, and green-glossy foliage is an eye-catcher in the landscape.
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 61.2 ms Record Count: 1 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 = 9188 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 | ||
| 1 | TB | ROSA `TRUE LOVE` | 1014617 | 342 | 548 | 0 | 0 | 0 | 20.53 | ROSES: ROSA - True Bloom Rosesr (own root) | 1 | 10-14 Only $13.95 Net!! 15+ Only $13.68 Net!! | 12-15" | #2 | 0 | 20.53 | (5-9) | 19.5 | (10+) | 17.66 | 9188 | 18155 | ||||
| string |