Query Template: /consoleAssets/farmTheme/plants/dsp_plantDetail.cfm:37 Execution Time: 8.78 ms Record Count: 1 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 | ||
1 | Nymphaea-Blue-Triumph-Waterlily |
Nymphaea 'Blue Triumph'
Waterlily
10in - $28.99
- Summary
- Additional Details
- » Fragrant showy flower
- » Glossy deep green foliage
- » Misty blue inflorescence
- Height
- 6 - 12 in
- Spread
- 24 - 48 in
- Zone
- 4-10
- Categories
- Aquatic
- Tags
- Staff Favorite; Full Sun; Water Garden;
-
128 Raleigh St, Holly Springs, NC 27540