« Previous Plant | Next Plant »
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 28.3 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 = 10438 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 tropical show-stopper in a compact, lush form. Bluephoria™ features eye-catching pink buds that unfurl into delicate lavender blooms, carrying a subtle, evolving palette. With superior branching and abundant flowering, this vigorous yet controller plant fills containers, baskets, or small trellises with nonstop color. Its naturally mounded habit and trailing potential make it perfect for a variety of summer settings.
Grow Bluephoria™ in full to part sun, using well-draining soil. Keep the soil consistently moist and feed regularly with a balanced fertilizer to encourage nonstop blooms. Let it trail naturally or train it up a small support as desired.
| string |