« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 135 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 = 10774 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 | BAPTISIA `GRAPE ESCAPE` | 1030712 | 0 | 0 | 503 | 0 | 0 | 11.47 | PERENNIALS: BAPTISIA - false indigo | 2 | - | #1 | 0 | 11.47 | (6-11) | 10.9 | (12+) | 9.86 | 10774 | 22059 | ||||||
| • | Border or Bed |
| • | Container |
| • | Cut Flower/Foliage |
| • | Dried Flower/Foliage |
| • | Focal Point |
| • | Specimen |
| • | Salt Tolerant |
| • | Deer Resistant |
| • | Purple |
| • | Late Spring |
| • | Full Sun |
Thrives in full sun and well-drained, poor to average soil; tolerates light shade but may need staking. Once established, its deep taproot provides moderate drought tolerance.
| string |