Artificial Grass Tucson Pros

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 335551,
      "site_id": 24,
      "cat_id": 80,
      "priority": 2,
      "url": "https://artificialgrasstucsonpros.com/",
      "title": "Artificial Grass Tucson Pros",
      "description": "Artificial Grass Tucson Pros is your trusted partner for creating stunning, sustainable landscapes in the heart of the Sonoran Desert. We specialize in installing premium synthetic turf that offers the perfect blend of aesthetics and functionality. Our expert team is skilled in transforming a variety of spaces, from residential yards to commercial properties, sports fields, and children''s play areas. We pride ourselves on our customer-centric approach, offering free consultations, transparent pricing, and swift installations. Our artificial grass solutions are designed to withstand Tucson''s intense heat and sporadic rainfall, maintaining their lush appearance year-round with minimal maintenance. By choosing our services, you''re opting for a water-wise, eco-friendly alternative that aligns with our desert community''s conservation goals while enjoying a perpetually green and inviting outdoor space.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 86294,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-09-18T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 7,
      "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": 1405,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "f56bf9a9-75c3-11ef-ab46-b66e99367f32",
      "subdate": "Sep 18, 2024",
      "subcategory": "Buyers Investment Agent",
      "request_types": "",
      "visitcount": 34
   },
   "visits": {
      "storefront": 34,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 4,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-09-18 13:43:16"
   },
   "location": {
      "uuid": "f56bf9a9-75c3-11ef-ab46-b66e99367f32",
      "link_id": 335551,
      "account_id": 86294,
      "company": "Artificial Grass Tucson Pros",
      "sid": 24,
      "country": 277,
      "countrycode": "US",
      "state": 3,
      "city": "1070",
      "zip": "85705",
      "address": "2620 N Stone Ave, Tucson, AZ 85705, USA",
      "phone": "5208739432",
      "fax": null,
      "email": "ArtificialGrassTucsonPros@outlook.com",
      "name": "Artificial Grass Tucson Pros",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "32.2546347",
      "lon": "-110.9716782",
      "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": ""
}