« Previous Plant | Next Plant »
Four delicious pears are grafted onto one plant, making pollination a breeze and assuring great fruit set on one plant for the home gardener. Four pear selections on one tree means guaranteed fruit while saving space in the landscape. Variety selections marked on each branch. The varieties grafted could be 4 of these varieties: Bartlett, Comice, d’Anjou, Flemish beauty, Hood, Kieffer, Luscious, Red Bartlett, Seckel.
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 77.5 ms Record Count: 1 Cached: No Lazy: No SQL: select h.program, s.name, s.udefSKUNameSuffix, s.sku, s.udefBannedStates, s.udefBBL, s.udefRR, s.udefLR, s.udefTimsTopTwenty, s.udefJaimesHotList, s.listPrice as price, s.udefCategory as category, s.udefComments as comments, s.udefGrade as grade, s.udefSpecial as special, s.udefPlantSize as plantSize, s.qtyUnit as size, s.salePrice, s.listPrice, s.udefTier2, s.udefTier2Price, s.udefTier3, s.udefTier3Price, s.plantID, s.id from tb_plant_skus s inner join tb_lists_hotlist h on (h.sku = s.sku) where s.isactive = 1 and s.delete_date is null and s.isecommerce = 1 and s.plantID = 2383 order by udefcategory, name, price | ||||||||||||||||||||||||||
| program | name | udefSKUNameSuffix | sku | udefBannedStates | udefBBL | udefRR | udefLR | udefTimsTopTwenty | udefJaimesHotList | price | category | comments | grade | special | plantSize | size | salePrice | listPrice | udefTier2 | udefTier2Price | udefTier3 | udefTier3Price | plantID | id | ||
| 1 | PYRUS - 4 IN 1 COMBO ROUND (ASIAN PEAR) | 1011743 | 0 | 69 | 0 | 0 | 0 | 109.30 | EDIBLES: PYRUS - pear | 1 | 5-6' | #7 | 0 | 109.30 | (4-6) | 103.84 | (7+) | 94.0 | 2383 | 22009 | ||||||
| string |