Greenview Irrigation & Lawn Maintenance LLC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 317203,
      "site_id": 69,
      "cat_id": 65,
      "priority": 2,
      "url": "https://www.greenviewirrigation.net/",
      "title": "Greenview Irrigation & Lawn Maintenance LLC",
      "description": "Greenview Irrigation & Lawn Maintenance LLC, has 15 years of experience in this industry, from stump grinding and tree removal to driveway and sidewalk projects to power washing, we can do it all. Call us today at (601) 520-3082!!\r\n",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 68401,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2019-06-07T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 166,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 24,
      "city_id": 11757,
      "ltop": "",
      "facebook": "https://www.facebook.com/Greenview-Irrigation-675713512486614/",
      "tiktok": null,
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": null,
      "youtube": "",
      "youtube_title": null,
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "https://www.instagram.com/greenviewirrigation/",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": null,
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 5190,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "956e7db6-56da-11ed-b77c-b66e99367f32",
      "subdate": "Jun 07, 2019",
      "subcategory": "Landscape Contractors",
      "request_types": "",
      "visitcount": 261
   },
   "visits": {
      "storefront": 261,
      "articles": 0,
      "videos": 0,
      "reviews": 18,
      "coupons": 0,
      "products": 0,
      "social": 8,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Greenview Irrigation & Lawn Maintenance LLC, has 15 years of experience in this industry, from stump grinding and tree removal to driveway and sidewalk projects to power washing, we can do it all. Call us today at (601) 520-3082!!\r\n",
      "service1": "Landscape Restoration Hattiesburg MS",
      "service2": "Tree Services Petal MS",
      "service3": "Lawn Care Hattiesburg MS",
      "service4": "Greenview Irrigation & Lawn Maintenance LLC",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2019-06-07 05:43:08"
   },
   "location": {
      "uuid": "956e7db6-56da-11ed-b77c-b66e99367f32",
      "link_id": 317203,
      "account_id": 68401,
      "company": "Greenview Irrigation & Lawn Maintenance LLC",
      "sid": 69,
      "country": 277,
      "countrycode": "US",
      "state": 24,
      "city": "11757",
      "zip": "39401",
      "address": "400 East Pine",
      "phone": "601-520-3082",
      "fax": null,
      "email": "greenviewirrigation01@gmail.com",
      "name": "Greenview Irrigation & Lawn Maintenance LLC",
      "status": "hide",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "31.3295225",
      "lon": "-89.2876743",
      "cityname": "Hattiesburg",
      "statename": "Mississippi"
   },
   "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": ""
}