Query
Template: /plantsWL/qry_getSubstitutions.cfm:163
Execution Time: 2.82 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 != '378' and
g.genus = 'Pyrus'
limit 1
id
1375

Pyrus pyrifolia 'Combination Pear'

Combination Asian Pear

Multiple Asian Pear varieties are budded to one tree creating a unique combination fruit tree that produces different pears through the season. Ripening times will vary. Self pollinates.

  • CAN NOT BE SHIPPED TO THE US
  • Multiple pear varieties
  • All grafted on 1 tree
  • Fruit used for jams or pies

Login for pricing