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

« Previous Plant  |  Next Plant »

Rosa Roseraie de l'Hay

Roseraie de l'Hay Rugosa Rose

  • »  Bold color
  • »  Repeat blooms
  • »  Fragrant
  • »  Supports bees
Login for pricing
Query
Template: /plantsW/qry_getPlant.cfm:60
Execution Time: 56.1 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 = 10720
order by udefcategory, name, price
programnameudefSKUNameSuffixskuudefBannedStatesudefBBLudefRRudefLRudefTimsTopTwentyudefJaimesHotListpricecategorycommentsgradespecialplantSizesizesalePricelistPriceudefTier2udefTier2PriceudefTier3udefTier3PriceplantIDid
Elongated buds open into large, double blooms in a vibrant magenta shade with a powerful fragrance. This vigorous, reliable shrub features lush, glossy apple-green foliage and strong garden performance.

Find a local garden center

Within...
...of zip code:
.
Attributes
• Border or Bed
• Fragrant
• Reblooming
Foliage Color
• Green
Attracts Wildlife
• Supports Bees
Flower Color
• Pink
• Purple
Programs
• David Austin Roses
Exposure
• Full Sun
• Partial Shade
Soil Moisture
• Average Water
Growing & Maintenance Tips for Rosa Roseraie de l'Hay

Plant in full sun to partial shade North, East, South, or West facing. All soil types

string