Global Syn-Turf has taken artificial grass realism to a whole new level. Our revolutionary series of top-quality, luxurious synthetic turf features a wide range of different colors, textures, and combinations! Choose from single or double-layered thatch to enhance the authentic grass look. Ideal for residential and commercial applications, putting green, or even potty training for your pets! Global Syn-Turf offers exclusive, resilient blades with premium solid construction.
With more than seventy-five turf products to choose from, Global Syn-Turf has artificial grass for any situation, application, or location. Our Performance, Emerald, Mt. Sierra, Evergreen, Putting Green, Patriot, Pet Grass, and Spring series are just a handful of products we offer that are consistently attractive, lavishly green, and consistently cost-effective, requiring little to no maintenance or watering.
select a.* from articles a left join sections b on a.sections_id=b.sections_id where a.published>0 and a.sections_id in (93,94,95,96,97,98) and a.sections_top>0 order by b.ord