Avondale Turf and Landscape

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 351570,
      "site_id": 76,
      "cat_id": 11,
      "priority": 0,
      "url": "https://www.avondaleturfandlandscape.com/",
      "title": "Avondale Turf and Landscape",
      "description": "Avondale Turf and Landscape provides professional artificial turf and hardscape installation for homes and businesses across the West Valley. Services include synthetic lawns, pet turf, backyard putting greens, sports turf, and paver features. We help customers save water while creating outdoor spaces that look great year-round with minimal upkeep. Free consultations and estimates available. Serving Avondale and surrounding Arizona communities with expert landscape solutions designed for the desert climate.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 102290,
      "approve_dt": "2026-02-03T00:00:00.000Z",
      "source": null,
      "submit_dt": "2026-02-03T00: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": 851,
      "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": 5870,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "f08185b8-00ec-11f1-bb42-b66e99367f32",
      "subdate": "Feb 03, 2026",
      "subcategory": "Lawn Service",
      "request_types": "",
      "visitcount": 2
   },
   "visits": {
      "storefront": 2,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 0,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Avondale Turf and Landscape provides professional artificial turf and hardscape installation for homes and businesses across the West Valley. Services include synthetic lawns, pet turf, backyard putting greens, sports turf, and paver features. We help customers save water while creating outdoor spaces that look great year-round with minimal upkeep. Free consultations and estimates available. Serving Avondale and surrounding Arizona communities with expert landscape solutions designed for the desert climate.",
      "service1": "Patios",
      "service2": "Pool Decks",
      "service3": "Paver Installation",
      "service4": "Sports Field Turf",
      "service5": "Pet Turf Solutions",
      "service6": "Synthetic Putting Greens",
      "service7": "Artificial Turf Installation",
      "submit_dt": "2026-02-03 10:41:47"
   },
   "location": {
      "uuid": "f08185b8-00ec-11f1-bb42-b66e99367f32",
      "link_id": 351570,
      "account_id": 102290,
      "company": "Avondale Turf and Landscape",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 3,
      "city": "851",
      "zip": "85323",
      "address": "650 N 99th Ave #111",
      "phone": "(602) 962-1273",
      "fax": null,
      "email": "office@avondaleturfandlandscape.com",
      "name": "Avondale Turf and Landscape",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Avondale",
      "statename": "Arizona"
   },
   "socialmedia": [
      {
         "title": "Facebook",
         "ptype_id": 29,
         "dbtable": "links_socialmedia",
         "item": "Facebook",
         "cnt": null
      },
      {
         "title": "Instagram",
         "ptype_id": 30,
         "dbtable": "links_socialmedia",
         "item": "Instagram",
         "cnt": null
      },
      {
         "title": "Youtube",
         "ptype_id": 31,
         "dbtable": "links_socialmedia",
         "item": "Youtube Video",
         "cnt": null
      },
      {
         "title": "LinkedIn",
         "ptype_id": 32,
         "dbtable": "links_socialmedia",
         "item": "LinkedIn",
         "cnt": null
      },
      {
         "title": "TikTok",
         "ptype_id": 33,
         "dbtable": "links_socialmedia",
         "item": "TikTok",
         "cnt": null
      },
      {
         "title": "Twitter",
         "ptype_id": 34,
         "dbtable": "links_socialmedia",
         "item": "Twitter",
         "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": ""
}