Query Template: /consoleAssets/farmTheme/plants/dsp_plantDetail.cfm:37 Execution Time: 6.78 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 |
« Previous Plant | Next Plant »
Abelia grandiflora 'Miss Lemon™'
Glossy Abelia
3 Gallon - $39.99
- Summary
- Additional Details
- » Loads of light pink flowers
- » Yellow foliage with green centers
- » Attracts hummingbirds and butterflies
- Height
- 2 - 3 ft
- Spread
- 3 - 4 ft
- Zone
- 6-9
- Color
- Pink
- SKU
- 123456
- Categories
- Shrub
- Breeder
- PDSI
- Tags
- Attracts Butterflies; Attracts Humming-birds; Border or Bed; Drought Tolerant; Great Foliage; Long Blooming
-
128 Raleigh St, Holly Springs, NC 27540