Query
Template: /consoleAssets/gardenlandTheme/plants/dsp_plantDetail.cfm:38
Execution Time: 5.98 ms
Record Count: 2
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 = 'Tropical'
group by p.friendlyURL
order by p.NameLine2, p.nameLine1
myval
1Acalypha-pendula-Trailing-Red-Cattail
2Hibiscus-rosa-sinensis-Peach-Tropical-Hibiscus
Peach Tropical Hibiscus - Hibiscus rosa-sinensis from Landscaper Theme Three

« Previous Plant  | 

Hibiscus rosa-sinensis

Peach Tropical Hibiscus

  • Showy peach flowers during warm months
  • Glossy green foliage
  • Excellent container plant in colder climates

1 Gallon - $29.99
Peach Tropical Hibiscus Details
Height 3 - 5 ft
Spread 3 - 5 ft
Zone 10 - 11
SKU 4554-891
Categories Tropical

Add a tropical touch to your patio or deck.

Check back soon for more in-depth details on Peach Tropical Hibiscus.