« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 62.2 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 = 9393 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 | ||
Stunning, bi-color blooms of red and yellows cluster along large spikes. Westcountry™ series has strong and sturdy stems to encourage its straight, upright habit that reaches up to 3 feet tall; group together with others from the series for a masterpiece that’s sure to catch your eyes! Add lupine to your landscape behind low-growing plants to draw your eyes upward or to sunny gardens where color is needed between late spring through early summer.
Lupines thrive in full sun or light shade in rich, slightly acidic soil with good drainage. Apply mulch around the plant to keep the roots cool and for protection during the winter months. Remove faded flowers to encourage rebloom.
| string |