« 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. Guaranteed fruit while saving space in the landscape. Variety selections marked on each branch.
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 111 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 = 8372 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 (PEAR) | 1007035 | 0 | 69 | 0 | 0 | 0 | 109.30 | EDIBLES: PYRUS - pear | 1 | 4-5' | #7 | 0 | 109.30 | (4-6) | 103.84 | (7+) | 94.0 | 8372 | 15193 | ||||||
| string |