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

Strawberry Seascape

Seascape Strawberry

  • »  Hybrid, everbearing strawberry
  • »  Highly tolerant of diseases and viruses
  • »  Productive, everbearing selection
  • »  A multitude of medium to large berries starting in June
  • »  Firm, sweet-tasting fruit
  • »  Great for freezing or eating fresh
Login for pricing
Query
Template: /plantsW/qry_getPlant.cfm:60
Execution Time: 31.8 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 = 1593
order by udefcategory, name, price
programnameudefSKUNameSuffixskuudefBannedStatesudefBBLudefRRudefLRudefTimsTopTwentyudefJaimesHotListpricecategorycommentsgradespecialplantSizesizesalePricelistPriceudefTier2udefTier2PriceudefTier3udefTier3PriceplantIDid
You'll be eating strawberries all season long with this very productive everbearing selection that gives you a multitude of medium to large berries starting in June. Fruit is firm and sweet tasting and will work perfectly for freezing or eating fresh.

Find a local garden center

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