You will be logged off in  seconds due to inactivity. Click here to continue your ordering session.

« Previous Plant  |  Next Plant »

Kerria japonica 'Pleniflora'

Japanese Kerria

  • »  A great shrub for shady border
  • »  Bright yellow blooms heaviest in late spring, flower sporadically all year
  • »  Green stems

Login for pricing
Query
Template: /plantsW/qry_getPlant.cfm:60
Execution Time: 32.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 = 775
order by udefcategory, name, price
programnameudefSKUNameSuffixskuudefBannedStatesudefBBLudefRRudefLRudefTimsTopTwentyudefJaimesHotListpricecategorycommentsgradespecialplantSizesizesalePricelistPriceudefTier2udefTier2PriceudefTier3udefTier3PriceplantIDid
A free flowering, fine textured shrub that performs well on borders and tolerates shadier conditions without compromising bloom. Bright yellow blossoms are heaviest in late April to early May but plant will flower sporadically throughout the year. Interesting bright green stems are effective in the winter landscape.

Find a local garden center

Within...
...of zip code:
.
Foliage Color
• Green
Flower Color
• Yellow
Exposure
• Partial Shade
string