« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 85.9 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 = 385 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 | CORNUS AMOMUM | 1001512 | 0 | 1353 | 345 | 0 | 0 | 26.83 | SHRUBS: CORNUS - dogwood shrubs | 1 | 21-24" | #3 | 0 | 26.83 | (5-9) | 25.49 | (10+) | 23.07 | 385 | 13965 | ||||||
| • | Green |
| • | Low Maintenance |
| • | Attracts Songbirds |
| • | Deer Resistant |
| • | White |
| • | American Beauties Native Plants® |
| • | Upright |
Silky Dogwood does particularly well in moist areas, so would be a great addition to your yard for those soggy areas that are difficult to find good plantings for. Prefers partial shade but will do well in sunnier spots as well.
| string |