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
1Trachycarpus-fortunei-Windmill-Palm
Windmill Palm - Trachycarpus fortunei from Landscaper Theme Two

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 TolerantHeat TolerantHouse PlantLow MaintenanceSalt TolerantStaff Favorite

  • 128 Raleigh St, Holly Springs, NC 27540