Rosa Flower Carpet Pink Supreme Pink Supreme Flower Carpet Groundcover Rose from Prides Corner Farms

Rosa Flower Carpet Pink Supreme

Pink Supreme Flower Carpet Groundcover Rose

» Northern hardy
» Vigorous
» Low, spreading mound
» Deep green, shiny, disease-resistant foliage
» Fuscia-colored flowers that are semi-double
» Season-long color
» Easy to care for

Hardiness Zone:5-8
Height:1-2 ft
Spread:5-7 ft
Category:Rose
Bloom Color: Pink Shades
Breeder:Flower Carpet Roses

(Northern Hardy) You'll be stunned by the shot of color and vigor this new selection will add to the Flower Carpet® series! Deep green, shiny, disease-resistant foliage grows vigorously to form a low, spreading, mounding plant that soon covers itself with buds. As they start cracking, you'll notice this is not your ordinary pink Flower Carpet... it's 'supreme' with hot, fuscia pink color. Semi-double form and a will to bloom will make you shake your head in admiration! With color throughout the season and an incredibly easy care nature, this may soon be your flower carpet favorite.

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

program

name

udefSKUNameSuffix

sku

udefBannedStates

udefBBL

udefRR

udefLR

udefTimsTopTwenty

udefJaimesHotList

price