« Previous Plant | Next Plant »
A new, upright, oval-shaped crabapple. Abundant pink buds opening to white flowers. Persistent dark red fruit. Disease-resistant. Adds interest to the landscape all season with spring blooms, nice foliage and summer to fall fruits. Low maintenance and easy to grow. Great for smaller spaces.
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 49.6 ms Record Count: 3 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 = 870 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 | MALUS X `SUGAR TYME` | 1001488 | 0 | 112 | 0 | 0 | 0 | 77.08 | TREES: MALUS - flowering crabapple | 1 | 4-8 Only $52.37 Net!! 9+ Only $51.37 Net!! | 6-7' | #7 | 0 | 77.08 | (4-6) | 73.23 | (7+) | 66.29 | 870 | 14533 | |||||
| 2 | MALUS X `SUGAR TYME` | 1000403 | 0 | 0 | 85 | 0 | 0 | 114.53 | TREES: MALUS - flowering crabapple | 2 | 8-9' | #15 | 0 | 114.53 | (4-6) | 108.8 | (7+) | 98.5 | 870 | 14596 | ||||||
| 3 | MALUS X `SUGAR TYME` | 1000493 | 0 | 6 | 0 | 0 | 0 | 260 | Wholesale Yard B&B | 1 | - | 2/2.5 B+B | 0 | 260 | 870 | 20643 | ||||||||||
| string |