Juniperus chinensis Lemon Pfizz® Lemon Pfizz® Juniper from Prides Corner Farms

Juniperus chinensis Lemon Pfizz®

Lemon Pfizz® Juniper

» Glowing yellow foliage
» Evergreen
» Drought tolerance
» Low, spreading habit

Query
Template: /plantsW/qry_getPlant.cfm:60
Execution Time: 41.5 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 = 760
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

Category:Shrub
Hardiness Zone:5-8
Height:18-24 ft
Spread:4-5 ft
Bloom Color: Yellow Shades
Foliage Color: Yellow Shades

Add some real "Pfizz-AZZ" to your landscape with this brilliant evergreen with color that will have you raving! Gone are the days of drab, green and mildly yellow Junipers. This beauty shines above the rest with its vivid yellow coloring in spring, perfectly contrasting to its blue-green hued old growth, aging during the summer months to a soft lemon tone that will be a smash in your summer landscape. Packed with all the benefits of chinensis Junipers such as excellent drought tolerance once established, a low, spreading habit, and a virtually maintanence free demeanor, this beauty shines beyond what any other so called yellow Juniper has the power to shine. Use Lemon Pfizz® in group plantings for a brilliant swath of landscape color or use it alone as a colorful addition to any summer color garden.