Stewart's Landscaping

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 315057,
      "site_id": 69,
      "cat_id": 65,
      "priority": 2,
      "url": "http://stewartslandscaping.net/",
      "title": "Stewart's Landscaping",
      "description": "Stewart’s Landscaping is an experienced, quality design and installation company that specializes in working on a one-to-one basis with homeowners to help fulfill their outdoor living environment needs. Our landscapers have many years of experience, striving to bring the best in custom designs and installation. ",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 66276,
      "approve_dt": "2018-06-12T00:00:00.000Z",
      "source": null,
      "submit_dt": "2018-05-15T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 834,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 32,
      "city_id": 15779,
      "ltop": "",
      "facebook": "https://www.facebook.com/Stewarts-Landscaping-359585976149/?fref=ts",
      "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": 5203,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9563d3dd-56da-11ed-b77c-b66e99367f32",
      "subdate": "May 15, 2018",
      "subcategory": "Home Landscaping",
      "request_types": "",
      "visitcount": 1104
   },
   "visits": {
      "storefront": 1104,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 7,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Stewartu2019s Landscaping is an experienced, quality design and installation company that specializes in working on a one-to-one basis with homeowners to help fulfill their outdoor living environment needs. Our landscapers have many years of experience, striving to bring the best in custom designs and installation. ",
      "service1": "Landscape charlotte nc",
      "service2": "landscape charlotte nc",
      "service3": "Landscaping",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2018-05-15 09:29:57"
   },
   "location": {
      "uuid": "9563d3dd-56da-11ed-b77c-b66e99367f32",
      "link_id": 315057,
      "account_id": 66276,
      "company": "Stewart's Landscaping",
      "sid": 69,
      "country": 277,
      "countrycode": "US",
      "state": 32,
      "city": "15779",
      "zip": "28210",
      "address": "1408 Edgewater Drive",
      "phone": "704-363-8774",
      "fax": null,
      "email": "Stewartslandscaping1@hotmail.com",
      "name": "Stewart's Landscaping",
      "status": "hide",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "35.1429567",
      "lon": "-80.8739484",
      "cityname": "Charlotte",
      "statename": "North Carolina"
   },
   "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": ""
}