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

« Previous Plant  |  Next Plant »

Kalmia latifolia Kaleidoscope

Kaleidoscope Mountain Laurel

  • »  Well-branched
  • »  Wide, upright habit
  • »  Brilliant red buds
  • »  Late flowering and a vigorous grower

Well-branched with a wide, upright habit. Brilliant red buds open with a broad cinnamon red band which almost fills the white corolla. Late flowering. A vigorous grower with new growth, reddish in color. A Richard Jaynes' introduction.
Login for pricing
Query
Template: /plantsW/qry_getPlant.cfm:60
Execution Time: 48.9 ms
Record Count: 3
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 = 768
order by udefcategory, name, price
programnameudefSKUNameSuffixskuudefBannedStatesudefBBLudefRRudefLRudefTimsTopTwentyudefJaimesHotListpricecategorycommentsgradespecialplantSizesizesalePricelistPriceudefTier2udefTier2PriceudefTier3udefTier3PriceplantIDid
1KALMIA LATIFOLIA `KALEIDOSCOPE`1000221024700024.93SHRUBS: KALMIA - mountain laurel19-12"#2024.93(5-9)23.68(10+)21.4476813742
2KALMIA LATIFOLIA `KALEIDOSCOPE`100034109463820039.62SHRUBS: KALMIA - mountain laurel110-14 Only $26.92 Net!! 15+ Only $26.41 Net!!15-18"#3039.62(5-9)37.64(10+)34.0776813188
3KALMIA LATIFOLIA `KALEIDOSCOPE`1001636011400063.81SHRUBS: KALMIA - mountain laurel118-21"#5063.81(4-6)60.62(7+)54.8876818664

Find a local garden center

Within...
...of zip code:
.
Attributes
• Native
Maintenance and Care
• Vigorous
Flower Color
• Red
Habit
• Upright
string