| Query Template: /consoleAssets/gardenlandTheme/plants/dsp_plantDetail.cfm:38 Execution Time: 7.2 ms Record Count: 26 Cached: No Lazy: No SQL: select p.friendlyURL as myval from tb_users_plants p where p.isactive and p.displayOnWebsite = 1 and isnull(p.deleteDate) and userID = 3829 and p.type = 'Shrub' group by p.friendlyURL order by p.NameLine2, p.nameLine1  | ||
| myval | ||
| 1 | Abelia-Bronze-Anniversary | |
| 2 | Abelia-Christmas-Parade-Abeila | |
| 3 | Abelia-Pinky-Bells-Abelia | |
| 4 | Abelia-chinensis-Chinese-Abelia | |
| 5 | Abelia-grandiflora-Miss-Lemon-Glossy-Abelia | |
| 6 | Abelia-x-Easter-Parade-Easter-Parade-Abelia | |
| 7 | Abelia-x-Mardi-Gras-Mardi-Gras-Abelia | |
| 8 | Abelia-x-Canyon-Creek-Canyon-Creek-Glossy-Abelia | |
| 9 | Abelia-x-grandiflora-Edward-Goucher-Edward-Goucher-Abelia | |
| 10 | Abelia-x-grandiflora-PIIAB-II-Eternal-Sunshine-Abelia- | |
| 11 | Berberis-thunbergii-Goruzam-Golden-Ruby-Barberry | |
| 12 | Berberis-thunbergii-BailAnna-Moscato-Barberry- | |
| 13 | Buxus-Green-Velvet-Green-Velvet-Boxwood | |
| 14 | Cryptomeria-japonica-Globosa-Nana-Dwarf-Globe-Japanese-Cedar | |
| 15 | Distylium-Vintage-Jade-Vintage-Jade-Distylium | |
| 16 | Hydrangea-macrophylla-Big-Daddy-Big-Daddy-Hydrangea | |
| 17 | Hydrangea-macrophylla-PIIHM-II-BloomStruck-Bigleaf-Hydrangea | |
| 18 | Hypericum-kalmianum-PIIHYP-I-Cobalt-n-Gold-Hypericum- | |
| 19 | ILEX-altaclarensis-Wilsonii-Wilson-s-Holly | |
| 20 | Illicium-parviflorum-Florida-Sunshine-Florida-Anise | |
| 21 | Rhaphiolepis-indica-Eleanor-Tabor-Indian-Hawthorn | |
| 22 | Rhaphiolepis-umbellata-Snow-White-Indian-Hawthorn | |
| 23 | Rhododendron-Autumn-Fire-Encore-Azalea | |
| 24 | Rosa-BAIage-High-Voltage-Rose- | |
| 25 | Rosa-BAIbox-Music-Box-Rose-- | |
| 26 | Spiraea-japonica-Double-Play-Artisan-Spiraea | |
| Spiraea Details | |
|---|---|
| Height | 24 - 30 in | 
| Spread | 24 - 30 in | 
| Zone | 3-9 | 
| Color | Pink | 
| Categories | Shrub | 
| Breeder | Proven Winners | 
Its blue-green foliage emerges a rich purple-red setting it apart from all other Spirea.
Check back soon for more in-depth details on Spiraea.