Query
Template: /consoleAssets/gardenlandTheme/plants/dsp_plantDetail.cfm:38
Execution Time: 5.77 ms
Record Count: 5
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 = 'Aquatic'
group by p.friendlyURL
order by p.NameLine2, p.nameLine1
myval
1Equisetum-hyemale-Horsetail
2Nymphaea-Joey-Tomocik-Joey-Tomocik-Waterlily
3Nymphaea-Luciana-Luciana-Waterlily
4Nymphaea-Almost-Black-Waterlily
5Nymphaea-Blue-Triumph-Waterlily
Waterlily - Nymphaea 'Almost Black' from GCM Theme Three

« Previous Plant  |  Next Plant »

Nymphaea 'Almost Black'

Waterlily

  • This red lily is set apart from the other reds because the flowers are blackish red
  • Flowers have a very pleasant odor.
  • Moderate bloomer.

Waterlily Details
Height 3 - 6 in
Spread 12 - 24 in
Zone 5-11
Color Red
Categories Aquatic

Check back soon for additional information on Waterlily.

Check back soon for more in-depth details on Waterlily.