Query Template: /consoleAssets/farmTheme/plants/dsp_plantDetail.cfm:37 Execution Time: 8.46 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 = 'Palms' group by p.friendlyURL order by p.NameLine2, p.nameLine1 | ||
myval | ||
1 | Trachycarpus-fortunei-Windmill-Palm |
Trachycarpus fortunei
Windmill Palm
3 Gallon - $29.99
- Summary
- Additional Details
- » Graceful green fronds on study base
- » Cold hardy for landscape
- » Early spring yellow flower
- » Moderate to fast growing
Can also be used as a house plant.
- Height
- 6 - 40 ft
- Spread
- 5 - 7 ft
- Zone
- 8 - 10
- SKU
- 5896-8
- Categories
- Palms
- Tags
- Drought Tolerant; Heat Tolerant; House Plant; Low Maintenance; Salt Tolerant; Staff Favorite
-
128 Raleigh St, Holly Springs, NC 27540