Campsis x tag. Summer Jazz™ Fire Summer Jazz™ Fire Trumpet Vine from Prides Corner Farms

Campsis x tag. Summer Jazz™ Fire ('Takarazuka Fresa')

Summer Jazz™ Fire Trumpet Vine: Patent PP23917

» Half the size and half the vigor as species
» Deep red flower with an orange throat
» Easy to grow
» Low maintenance
» Blooms starting in July
» Attracts butterflies and hummingbirds
» Great for small spaces, trellis, and archways

Hardiness Zone:5-8
Height:6-10 ft
Spread:6-10 ft
Category:Vine
Bloom Color: Red Shades

Less than half the size of regular Trumpet Vine, this selection blooms brilliantly with orange to red flowers starting in July. Attracts butterflies and hummingbirds. Spectacular vine for relatively smaller spaces. Perfect for use with a heavy trellis or archway. Easy to grow with few pests.

Query
Template: /plantsW/qry_getPlant.cfm:60
Execution Time: 55.3 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 = 2431
order by udefcategory, name, price

program

name

udefSKUNameSuffix

sku

udefBannedStates

udefBBL

udefRR

udefLR

udefTimsTopTwenty

udefJaimesHotList

price