me: select * from articles a left join a_cities b on a.geonameid=b.geonameid where a.geonameid>0 and a.published>0 and a.arts_type=8 and state_abbr='HI'

Customer Reviews: Pearl City Hawaii

5 stars based on 2 customer reviews

Cody Sablan

Posted Apr 17, 2020 7:08 AM

Artificial Turf For Hawaii

Honolulu Hawaii

I finally found an artificial turf dealer in Hawaii. After calling what seems like 100 turf companies I finally reached Global Syn Turf and wow they had a distributor of artificial grass in Hawaii. My hat is off to Global Syn Turf and their beautiful looking artificial grass.

8 likes

Kristal Mclauren

Posted Mar 21, 2020 3:02 AM

Global Syn Turf!

Honolulu Hawaii

In Hawaii, scenery is everything. Customers love their artificial grass and ivy. That's why when we moved to California as a company, we focused mainly on residential landscaping. The turf that GST offers is exceptional and the quality is unbeatable for the price. I had a few talks with the sales reps prior to partnering with them and they are very knowledgeable on their products. They helped me make an informed decision and I appreciate that they weren't trying so hard to sell me right from the beginning. I prefer suppliers with more products to choose from and I'm glad that GST is able to offer that big selection for me.

5 likes