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

« Previous Plant  |  Next Plant »

Pyrus x 'Bartlett'

Bartlett Pear

  • »  Semi-dwarf
  • »  Vigorous and productive
  • »  Large and golden yellow fruit
  • »  Buttery, juicy and highly flavored fruit

Semi-dwarf. This vigorous, productive tree bears fruit at a young age which ripens well on the trees. Fruit is large, golden-yellow, with a wonderful quality. Buttery, juicy, highly flavored fruit.
Login for pricing
Query
Template: /plantsW/qry_getPlant.cfm:60
Execution Time: 195 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 = 1820
order by udefcategory, name, price
programnameudefSKUNameSuffixskuudefBannedStatesudefBBLudefRRudefLRudefTimsTopTwentyudefJaimesHotListpricecategorycommentsgradespecialplantSizesizesalePricelistPriceudefTier2udefTier2PriceudefTier3udefTier3PriceplantIDid
1PYRUS X `BARTLETT` (PEAR)1000893011481800050.46EDIBLES: PYRUS - pear14-5'#7050.46(4-6)47.94(7+)43.4182013316

Find a local garden center

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