Mosquito Authority Greater Columbia, SC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 324858,
      "site_id": 65,
      "cat_id": 76,
      "priority": 2,
      "url": "https://www.mosquito-authority.com/locations/columbia-sc/",
      "title": "Mosquito Authority Greater Columbia, SC",
      "description": "Call our Columbia SC mosquito control location at 8032988251 for mosquito pest control and treatment. Receive a free mosquito treatment quote today! ",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 75847,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2023-05-16T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 33,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 39,
      "city_id": 20245,
      "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": 4902,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9f8ac0b0-f408-11ed-b5b4-b66e99367f32",
      "subdate": "May 16, 2023",
      "subcategory": "Mosquito Control",
      "request_types": "",
      "visitcount": 68
   },
   "visits": {
      "storefront": 68,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 3,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "When you need mosquito control in Columbia, SC, well take care of all details. Well work efficiently to rid your property of mosquitoes or ticks as soon as possible, and our flexible appointment options allow us to work at your convenience. While nothing can eliminate every mosquito from your property, our service works so well that we guarantee you won't be bothered by mosquitoes between treatments. Our mosquito control company in Columbia, SC, services the following areas: Columbia, West Columbia, Blythewood, White Rock, Little Mountain, Chapin Peak, Lexington, Cayce, Irmo, Elgin.\r
",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2023-05-16 16:42:19"
   },
   "location": {
      "uuid": "9f8ac0b0-f408-11ed-b5b4-b66e99367f32",
      "link_id": 324858,
      "account_id": 75847,
      "company": "Mosquito Authority - Greater Columbia, SC",
      "sid": 65,
      "country": 277,
      "countrycode": "US",
      "state": 39,
      "city": "20245",
      "zip": "29201",
      "address": "GREATER COLUMBIA SERVICE AREA",
      "phone": "803 298-8251",
      "fax": null,
      "email": "macolumbia@outlook.com",
      "name": "Mosquito Authority - Greater Columbia, SC",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "33.9703589",
      "lon": "-81.0255174",
      "cityname": "Columbia",
      "statename": "South 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": ""
}