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

« Previous Plant  |  Next Plant »

Clematis x Boulevard® Olympia™ ('Evipo099')

Olympia™ Clematis Vine: Patent PPAF

  • »  Great specimen
  • »  Fast growing and compact
  • »  Rebloomer
  • »  Showy flowers!
  • »  Attracts hummingbirds
  • »  Deer resistant
  • »  Rabbit resistant

'Olympia' is a compact, deciduous, perennial climber with pinnate leaves divided into ovate or broadly lance-shaped, mid- to dark green leaflets and large, single, purple to violet-blue flowers from early summer into autumn.

Login for pricing
Query
Template: /plantsW/qry_getPlant.cfm:60
Execution Time: 28.4 ms
Record Count: 1
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 = 5305
order by udefcategory, name, price
programnameudefSKUNameSuffixskuudefBannedStatesudefBBLudefRRudefLRudefTimsTopTwentyudefJaimesHotListpricecategorycommentsgradespecialplantSizesizesalePricelistPriceudefTier2udefTier2PriceudefTier3udefTier3PriceplantIDid
1RECLEMATIS `OLYMPIA`101219930400020.09PERENNIALS: CLEMATIS18"020.09(6-11)19.09(12+)17.28530517001

Find a local garden center

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