Rosa 'New Dawn' New Dawn Climbing Rose from Prides Corner Farms

Rosa 'New Dawn'

New Dawn Climbing Rose

» Repeat bloomer
» Large, blush-pink double flowers
» Blooms profusely until frost
» Fragrant flowers
» Attracts butterflies
» Can be grown as a shrub or a climber
» Voted the most popular rose in the world at the 11th World Convention of Rose Societies

Hardiness Zone:5-8
Height:8-12 ft
Spread:3-6 ft
Category:Rose
Bloom Color: Pink Shades

This repeat blooming rose has captivated the world with its large, blush-pink double flowers that bloom profusely until frost. Its abundance of fragrant flowers has made it so enticing, in fact, thatNew Dawn was voted the most popular rose in the world at the 11th World Convention of Rose Societies! Butterflies adore this rose, which can be grown as a shrub, but is more well-known for its excellence as a climber.

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

program

name

udefSKUNameSuffix

sku

udefBannedStates

udefBBL

udefRR

udefLR

udefTimsTopTwenty

udefJaimesHotList

price