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

« Previous Plant  |  Next Plant »

Rosa rugosa

rugosa rose

  • »  Tough and hardy
  • »  Popular for seashore locations
  • »  Large pink flowers bloom late May to July
  • »  Attracts birds and butterflies

Tough,hardy, native plant that thrives in difficult sites. Used extensively in seashore locations. Large, flowers that bloom somewhat continously all summer.
Login for pricing
Query
Template: /plantsW/qry_getPlant.cfm:60
Execution Time: 100 ms
Record Count: 2
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 = 1210
order by udefcategory, name, price
programnameudefSKUNameSuffixskuudefBannedStatesudefBBLudefRRudefLRudefTimsTopTwentyudefJaimesHotListpricecategorycommentsgradespecialplantSizesizesalePricelistPriceudefTier2udefTier2PriceudefTier3udefTier3PriceplantIDid
1ROSA RUGOSA10017542708000017.19ROSES: ROSA - hardy landscape roses (own root)115-18"#2017.19(5-9)16.33(10+)14.78121013549
2ROSA RUGOSA100175606100020.76ROSES: ROSA - hardy landscape roses (own root)112-15"#3020.76(5-9)19.72(10+)17.85121013552

Find a local garden center

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