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

« Previous Plant  |  Next Plant »

Pepper Super Chile

Super Chile Hot Pepper

  • »  Hybrid hot pepper
  • »  75 days to maturity
  • »  1998 All-American Winner
  • »  Short, spreading plant
  • »  2.5 x .5" long chiles
  • »  Ripen from light green to red
  • »  Very productive, up to 300 fruit per plant
  • »  Hot and pungent taste
  • »  Great for drying, pickling, or eating fresh
Login for pricing
Query
Template: /plantsW/qry_getPlant.cfm:60
Execution Time: 102 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 = 1842
order by udefcategory, name, price
programnameudefSKUNameSuffixskuudefBannedStatesudefBBLudefRRudefLRudefTimsTopTwentyudefJaimesHotListpricecategorycommentsgradespecialplantSizesizesalePricelistPriceudefTier2udefTier2PriceudefTier3udefTier3PriceplantIDid
A 1998 All-American winner, this short, spreading plant will be awash in 2.5 x .5 long, luscious chilis that ripen from light green to red. 'Super Chili' has a reputation for being one of the most productive Chili Peppers on the market, capable of producing up to 300 fruit per plant, but its hot, pungent taste will make a name for itself, too! Superb for drying but great fresh or pickled also.

Find a local garden center

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