« Previous Plant | Next Plant »
One of the best pears for the home garden, Moonglow is so easy to grow with its disease-resistant nature. On top of that, it also is one of the best producers in the backyard orchard delivering basket upon basket of medium to large sized, dull yellow brushed pink fruit that features the least gritty white flesh of any pear with a sweet, juicy taste that makes it ideal for fresh eating or canning. Moonglow fruit matures from mid-August to mid-September and can be pollinated by any other non-Asian Pear. Dwarf, compact form.
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 48.1 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 = 1107 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 X `MOONGLOW` (PEAR) | 1000766 | 0 | 242 | 0 | 0 | 0 | 50.46 | EDIBLES: PYRUS - pear | 1 | 4-5' | #7 | 0 | 50.46 | (4-6) | 47.94 | (7+) | 43.4 | 1107 | 13288 | ||||||
| string |