« Previous Plant | Next Plant »
Get four stone fruits on a single plant - A backyard orchard winner with each branch offering a different type of stone fruit: Apricot, nectarine, peach, and plum all grafted on one tree that fruits heavily! Very productive. A unique collection of 4 different stone fruits. Outstanding flavor for eating fresh or canning.
| Query Template: /plantsW/qry_getPlant.cfm:60 Execution Time: 66.2 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 = 4216 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 | PRUNUS `FRUIT SALAD` STONE FRUITS | 1012799 | 0 | 0 | 73 | 0 | 0 | 109.30 | EDIBLES: PRUNUS - plum | 2 | 5-6' | #7 | 0 | 109.30 | (4-6) | 103.84 | (7+) | 94.0 | 4216 | 17662 | ||||||
Likes moist, enriched soils but tolerates salt and sand very well. Prune after flowering to remove crossing or inward growing branches. No second tree needed!
| string |