Apex Turf

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 349583,
      "site_id": 69,
      "cat_id": 65,
      "priority": 0,
      "url": "https://apexturfaz.com/areas-served/tucson",
      "title": "Apex Turf",
      "description": "Apex Turf installs artificial grass, backyard putting greens, pet turf, and pavers in Tucson, AZ. We’re licensed, insured, and known for honest pricing, seamless installs, and top-quality materials. Whether you’re updating your front yard or creating a full backyard makeover, Apex Turf makes it easy. Free on site estimates across the greater Tucson area.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 100278,
      "approve_dt": "2025-07-25T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-07-25T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 0,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 3,
      "city_id": 1070,
      "ltop": "",
      "facebook": "",
      "tiktok": null,
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": null,
      "youtube": "",
      "youtube_title": null,
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": null,
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 5178,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "ace307ae-6942-11f0-a909-b66e99367f32",
      "subdate": "Jul 25, 2025",
      "subcategory": "Landscaping",
      "request_types": "",
      "visitcount": 55
   },
   "visits": {
      "storefront": 55,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 20,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Apex Turf is an Arizona-based artificial turf company founded in 2019 by Kile Dobberstein, serving the East Valley and Chandler community. With three full-time crews and thousands of installations completed, they specialize in quality artificial grass solutions for residential and commercial properties, focusing on competitive pricing and excellent customer service with plans to expand into the West Valley.",
      "service1": "artificial grass installation",
      "service2": " putting greens",
      "service3": " pet lawn systems",
      "service4": " paving services",
      "service5": " lawn design",
      "service6": " residential turf installation",
      "service7": " commercial artificial turf solutions",
      "submit_dt": "2025-07-25 10:32:33"
   },
   "location": {
      "uuid": "ace307ae-6942-11f0-a909-b66e99367f32",
      "link_id": 349583,
      "account_id": 100278,
      "company": "Apex Turf",
      "sid": 69,
      "country": 277,
      "countrycode": "US",
      "state": 3,
      "city": "1070",
      "zip": "85705",
      "address": "230 E Roger Rd",
      "phone": "(520) 600-0471",
      "fax": null,
      "email": "erionmusajgj36@gmail.com",
      "name": "Apex Turf",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Tucson",
      "statename": "Arizona"
   },
   "socialmedia": [
      {
         "title": "Facebook",
         "ptype_id": 29,
         "dbtable": "links_socialmedia",
         "item": "Page",
         "cnt": null
      },
      {
         "title": "Instagram",
         "ptype_id": 30,
         "dbtable": "links_socialmedia",
         "item": "Page",
         "cnt": null
      },
      {
         "title": "Youtube",
         "ptype_id": 31,
         "dbtable": "links_socialmedia",
         "item": "Youtube Video",
         "cnt": null
      },
      {
         "title": "LinkedIn",
         "ptype_id": 32,
         "dbtable": "links_socialmedia",
         "item": "Page",
         "cnt": null
      },
      {
         "title": "TikTok",
         "ptype_id": 33,
         "dbtable": "links_socialmedia",
         "item": "Videos",
         "cnt": null
      },
      {
         "title": "Twitter",
         "ptype_id": 34,
         "dbtable": "links_socialmedia",
         "item": "Page",
         "cnt": null
      },
      {
         "title": "Reddit",
         "ptype_id": 37,
         "dbtable": "links_socialmedia",
         "item": "Reddit",
         "cnt": null
      },
      {
         "title": "SnapChat",
         "ptype_id": 38,
         "dbtable": "links_socialmedia",
         "item": "SnapChat",
         "cnt": null
      }
   ],
   "promos": [
      {
         "item": "article",
         "cnt": 0
      },
      {
         "item": "video",
         "cnt": 0
      },
      {
         "item": "product",
         "cnt": 0
      },
      {
         "item": "coupon",
         "cnt": 0
      },
      {
         "item": "service",
         "cnt": 0
      },
      {
         "item": "article_external",
         "cnt": 0
      },
      {
         "item": "video_external",
         "cnt": 0
      },
      {
         "item": "product_external",
         "cnt": 0
      },
      {
         "item": "coupon_external",
         "cnt": 0
      },
      {
         "item": "service_external",
         "cnt": 0
      }
   ],
   "featuredproduct": ""
}