Query
Template: /plantsWL/qry_getSubstitutions.cfm:163
Execution Time: 7.92 ms
Record Count: 1
Cached: No
Lazy: No
SQL:
select g.id
from tb_plant_genusoverview_substitutions s
inner join tb_plant_genusOverview g on (g.id = s.genus_id)
where g.delete_date is null and g.isactive = 1 and
g.id != '365' and
g.genus = 'Prunus'
limit 1
id
1356

Prunus salicina 'Santa Rosa'

Santa Rosa Japanese Plum

One of the most commonly planted plums. The fruit is sweet and delicious. Self-fertile and a good pollinator for others.

  • CAN NOT BE SHIPPED TO THE US
  • Dark crimson fruit with firm flesh
  • Self-pollinating
  • Higher production when another plum tree near
  • Ideal for eating fresh or in preserves

Login for pricing

j

y

m

3