Query
Template: /consoleAssets/gardenlandTheme/plants/dsp_plantDetail.cfm:38
Execution Time: 7 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
Glossy Abelia - Abelia grandiflora 'Miss Lemon™' from Landscaper Theme Three

« Previous Plant  |  Next Plant »

Abelia grandiflora 'Miss Lemon™'

Glossy Abelia

  • Loads of light pink flowers
  • Yellow foliage with green centers
  • Attracts hummingbirds and butterflies

3 Gallon - $39.99
Glossy Abelia Details
Height 2 - 3 ft
Spread 3 - 4 ft
Zone 6-9
Color Pink
SKU 123456
Categories Shrub
Breeder PDSI