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

« Previous Plant  |  Next Plant »

Hydrangea paniculata 'Limelight'

Limelight Panicle Hydrangea

  • »  Lime green flowers starting mid-August
  • »  Vigorous and floriferous
  • »  Large, snowball-shaped clusters of flowers

Get ready for a revolutionary new member of the Hydrangea family! 'Limelight' will take your breath away with its unique lime-green flowers that cover the plant in big, poofy snowballs starting in mid-August. Very vigorous and very floriferous, this is just the plant to inject excitement into the late summer landscape.
Login for pricing
Query
Template: /plantsW/qry_getPlant.cfm:60
Execution Time: 76.7 ms
Record Count: 5
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 = 662
order by udefcategory, name, price
programnameudefSKUNameSuffixskuudefBannedStatesudefBBLudefRRudefLRudefTimsTopTwentyudefJaimesHotListpricecategorycommentsgradespecialplantSizesizesalePricelistPriceudefTier2udefTier2PriceudefTier3udefTier3PriceplantIDid
1PWHYDRANGEA PAN. `LIMELIGHT`100370502855990023.86SHRUBS: HYDRANGEA - panicle hydrangea112-15"#2023.86(5-9)22.67(10+)20.5266214488
2PWHYDRANGEA PAN. `LIMELIGHT`10037060042050029.85SHRUBS: HYDRANGEA - panicle hydrangea124-30"#3029.85(5-9)28.36(10+)25.6766214501
3PWHYDRANGEA PAN. `LIMELIGHT`10037074011667380042.61SHRUBS: HYDRANGEA - panicle hydrangea123-26"#5042.61(4-6)40.48(7+)36.6466214273
4PWHYDRANGEA PAN. `LIMELIGHT`1003708063700098.88SHRUBS: HYDRANGEA - panicle hydrangea121-24"#10098.88(4-6)93.94(7+)85.0466214199
5PWHYDRANGEA PAN. `LIMELIGHT` - TREETREE FORM1004964115813357110084.31SHRUBS: HYDRANGEA - panicle hydrangea14-5'#7084.31(4-6)80.09(7+)72.5166214666

Find a local garden center

Within...
...of zip code:
.

Proven Winners® Gardener Channel: Proven Winners® Limelight Hydrangea

Flower Color
• Green
Programs
• Proven Winners
Season of Interest (Flowering)
• Late Summer

Great Companions for Limelight Panicle Hydrangea

string