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

« Previous Plant  |  Next Plant »

Parthenocissus tricuspidata

Boston Ivy

  • »  Quick grower
  • »  Choice vine for university buildings
  • »  Very similar in habit and growing conditions as quinquefolia
  • »  Excellent fall color
  • »  Produces fruit
  • »  Attracts birds

Login for pricing
Query
Template: /plantsW/qry_getPlant.cfm:60
Execution Time: 52.3 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 = 970
order by udefcategory, name, price
programnameudefSKUNameSuffixskuudefBannedStatesudefBBLudefRRudefLRudefTimsTopTwentyudefJaimesHotListpricecategorycommentsgradespecialplantSizesizesalePricelistPriceudefTier2udefTier2PriceudefTier3udefTier3PriceplantIDid
  • Category:Vine
  • Hardiness Zone:4-8
  • Height:40-50 ft
  • Spread:40-50 ft
  • Bloom Color: Green Shades
The vine of choice for university buildings! A quick grower that adds a look of stateliness wherever it grows. Very similar in habit and growing conditions as quinquefolia with the same excellent fall color and bird attracting fruit.

Find a local garden center

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