« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 82.7 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 = 9167 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 | ||
A delicate and dainty choice to add to a bouquet or garden, Mikayla Miranda has a rounded face with lavender tops that fade to white in the center. 6-8” blooms on a sturdy 3’ tall stems. Excellent for cutting or leave in the garden to be a butterfly magnet!
| • | Blooms all Season |
| • | Container |
| • | Cut Flower/Foliage |
| • | Focal Point |
| • | Long Blooming |
| • | Reblooming |
| • | Summer Bloomer |
| • | Green |
| • | Deer Resistant |
| • | Upright |
Thrives in full sun. Feed regularly with organic fertilizer during the bloom season. Trim off spent blooms to encourage even more bloom. Outstanding as a colorful specimen in-ground and brilliant in a deck container.
| string |