Query
Template: /consoleAssets/gardenlandTheme/plants/dsp_plantDetail.cfm:38
Execution Time: 5.42 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
1Abelia-Bronze-Anniversary
2Abelia-Christmas-Parade-Abeila
3Abelia-Pinky-Bells-Abelia
4Abelia-chinensis-Chinese-Abelia
5Abelia-grandiflora-Miss-Lemon-Glossy-Abelia
6Abelia-x-Easter-Parade-Easter-Parade-Abelia
7Abelia-x-Mardi-Gras-Mardi-Gras-Abelia
8Abelia-x-Canyon-Creek-Canyon-Creek-Glossy-Abelia
9Abelia-x-grandiflora-Edward-Goucher-Edward-Goucher-Abelia
10Abelia-x-grandiflora-PIIAB-II-Eternal-Sunshine-Abelia-
11Berberis-thunbergii-Goruzam-Golden-Ruby-Barberry
12Berberis-thunbergii-BailAnna-Moscato-Barberry-
13Buxus-Green-Velvet-Green-Velvet-Boxwood
14Cryptomeria-japonica-Globosa-Nana-Dwarf-Globe-Japanese-Cedar
15Distylium-Vintage-Jade-Vintage-Jade-Distylium
16Hydrangea-macrophylla-Big-Daddy-Big-Daddy-Hydrangea
17Hydrangea-macrophylla-PIIHM-II-BloomStruck-Bigleaf-Hydrangea
18Hypericum-kalmianum-PIIHYP-I-Cobalt-n-Gold-Hypericum-
19ILEX-altaclarensis-Wilsonii-Wilson-s-Holly
20Illicium-parviflorum-Florida-Sunshine-Florida-Anise
21Rhaphiolepis-indica-Eleanor-Tabor-Indian-Hawthorn
22Rhaphiolepis-umbellata-Snow-White-Indian-Hawthorn
23Rhododendron-Autumn-Fire-Encore-Azalea
24Rosa-BAIage-High-Voltage-Rose-
25Rosa-BAIbox-Music-Box-Rose--
26Spiraea-japonica-Double-Play-Artisan-Spiraea
Spiraea - Spiraea japonica 'Double Play® Artisan®' from Landscaper Theme Three

« Previous Plant  | 

Spiraea japonica 'Double Play® Artisan®'

Spiraea

  • Red new growth in spring
  • Fuschia summer flowers, blooming until frost
  • Compact mounding growth habit

#2 cont. - $29.99
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.