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='KY'

Customer Reviews: Lexington-Fayette Kentucky

5 stars based on 2 customer reviews

2020-04-22T23:44:46+00:00
Louisville Kentucky

We had an awesome experience with Global Syn Turf.  They referred us to their dealer here in Kentucky that does the best installations.  Their installers are Certified Global Syn Turf artificial grass installers.  Danny and his team are super professional and easy to work with.  Global Syn Turf manufacture's the best artificial turf and has the largest selection of synthetic grass products to meet and any and all your needs.  I vote Global Syn Turf # 1.

3 likes

2020-04-18T05:58:40+00:00
Lexington Kentucky

We are a proud people down in the south and there is nothing like the state of Kentucky.  I just bought 2,400 sq. ft. of turf from the Global Syn Turf dealer here in Kentucky.  I told them the service was awesome and they asked me to go online to write a review.  So here I am letting everyone know that Global Syn Turf and their team of Artificial Turf Dealers are the best.  A+.


Chat with Us