You will be logged off in  seconds due to inactivity. Click here to continue your ordering session.

« Previous Plant  |  Next Plant »

Strawberry Allstar

All Star Strawberry

  • »  Hybrid, mid-season variety
  • »  June bearing (mid-season)
  • »  Abundant crop of large, sweet flavored light to medium red fruit in early to mid-June
  • »  Fairly firm fruit
  • »  Excellent for freezing, canning, or eating fresh
Login for pricing
Query
Template: /plantsW/qry_getPlant.cfm:60
Execution Time: 29.7 ms
Record Count: 0
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 = 1590
order by udefcategory, name, price
programnameudefSKUNameSuffixskuudefBannedStatesudefBBLudefRRudefLRudefTimsTopTwentyudefJaimesHotListpricecategorycommentsgradespecialplantSizesizesalePricelistPriceudefTier2udefTier2PriceudefTier3udefTier3PriceplantIDid

One of the all time favorite home gardening varieties, 'Allstar' is the garden star of June bearing varieties producing an abundant crop of large, sweet flavored light to medium red fruit in early to mid-June. Fruit is fairly firm and excellent for freezing, canning or just eating right off the plant!

Find a local garden center

Within...
...of zip code:
.
string