« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 65.4 ms Record Count: 2 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 = 1179 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 | DF | ROSA `DRIFT RED` | 1007525 | 616 | 0 | 0 | 0 | 0 | 20.53 | ROSES: ROSA - Driftr (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 | 1179 | 13529 | ||||
| 2 | DF | ROSA `DRIFT RED` - TREE 24 | 1020708 | 0 | 10 | 0 | 0 | 0 | 47.47 | ROSES: ROSA - Driftr (own root) | 1 | 15-18" | #3 | 0 | 47.47 | (5-9) | 45.1 | (10+) | 40.82 | 1179 | 19367 | |||||
| • | Low Maintenance |
| • | Red |
| • | Drift Roses |
| • | Spring |
| • | Late Spring |
| • | Early Summer |
| • | Summer Bloomer |
| • | Late Summer |
| • | Fall |
| • | Full Sun |
Drift® Roses are a cross between full-size groundcover roses and miniatures. From the former they kept toughness, disease resistance and Winter hardiness. From the miniatures, they inherited their well-managed size and repeat-blooming nature. - Conrad Pyle
The low, spreading habit of Drift® Roses makes them perfect for small gardens, hillsides, perennial beds and even awkward areas. They brighten up borders, fill in empty spaces, and spread delicately around your favorite established plants. - Conrad Pyle
| string |