Our Featured Plants



Our quality and consistency is sure to impress each and every one of our customers. We are the top supplier of conifers, shrubs, and maples. All container material is thoroughly rooted through and full in its post, ready for the retail lot. Every plant in our nursery is sheered and pruned from a young age to ensure a full-bodied, heavy plant will be the end result.

SELECT p.plant_id, p.botanical_name, p.plant_library_id, p.common_name, p.featured, p.description, IF(image !='', image, (SELECT pai_image.image FROM plant_availability_image AS pai_image WHERE pai_image.plant_id=p.plant_id AND p.client_id=36 ORDER BY pai_image.id LIMIT 1)) AS image FROM plant_featured_list AS pfl LEFT JOIN plant AS p USING(plant_id) LEFT JOIN plant_featured AS pf ON(pf.id=pfl.plant_featured_id) WHERE pf.client_id=36 AND pf.title='Featured Plants' ORDER BY pfl.id ASCTable 'newlifen_upload.plant_featured_list' doesn't exist