Query
Template: /consoleAssets/gardenlandTheme/plants/dsp_plantDetail.cfm:38
Execution Time: 8.93 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--
Rose - Rosa 'A. Mackenzie' from GCM Theme Three

« Previous Plant  |  Next Plant »

Rosa 'A. Mackenzie'

Rose

  • Deep raspberry red flowers
  • New leaves are tinted red
  • Raspberry scented

Rose Details
Height 5 - 6 ft
Spread 5 - 6 ft
Zone 3 - 7
Color Red
Categories Rose

Check back soon for additional information on Rose.

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