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

« Previous Plant  |  Next Plant »

Lysimachia nummularia 'Aurea'

Golden Creeping Jenny

  • »  Lime-gold carpet
  • »  Aggressive groundcover
  • »  Tolerates tough conditions

Login for pricing
Query
Template: /plantsW/qry_getPlant.cfm:60
Execution Time: 27.6 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 = 841
order by udefcategory, name, price
programnameudefSKUNameSuffixskuudefBannedStatesudefBBLudefRRudefLRudefTimsTopTwentyudefJaimesHotListpricecategorycommentsgradespecialplantSizesizesalePricelistPriceudefTier2udefTier2PriceudefTier3udefTier3PriceplantIDid
A lime-gold carpet of spreading strength, this aggressive groundcover will add a bright splash of foliage color to any dark landscape corner. You'll love how this plant responds to tough conditions with a shrug while merrily growing and covering spaces where other less tough plants fear to tread.

Find a local garden center

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