Query
Template: /consoleAssets/gardenlandTheme/plants/dsp_plantDetail.cfm:38
Execution Time: 8.09 ms
Record Count: 9
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 = 'Rose'
group by p.friendlyURL
order by p.NameLine2, p.nameLine1
myval
1Rosa-American-Flagship-Rose
2Rosa-Angel-Face-Rose
3Rosa-Apertif-Rose
4Rosa-Balpeace-Love-and-Peace-Rose
5Rosa-A-Mackenzie-Rose
6Rosa-AUSwonder-Ambridge-Rose
7Rosa-Caramella-Rose
8Rosa-BAIage-High-Voltage-Rose-
9Rosa-BAIbox-Music-Box-Rose--
Ambridge Rose - Rosa 'AUSwonder' from GCM Theme Three

« Previous Plant  |  Next Plant »

Rosa 'AUSwonder'

Ambridge Rose

  • Light apricot colored, rosette-shaped blooms
  • Does well in hot areas
  • Cut flower favorite
  • Unmatched beautiful fragrance

Ambridge Rose Details
Height 3 - 4 ft
Spread 3 - 4 ft
Zone 5 - 9
Color Salmon
Categories Rose

Check back soon for additional information on Ambridge Rose.

Check back soon for more in-depth details on Ambridge Rose.