Carolina Turf and Mosquito

{
   "vendor": "all",
   "sociallist": [
      {
         "social_id": 3516,
         "link_id": 352250,
         "vendor": "facebook",
         "title": "Carolina Turf and Mosquito",
         "description": "Are you constantly battling mosquitoes and fire ants, and you can’t seem to find a permanent solution? Are you looking for ways to make your grass look lush and feel great under your feet? At Carolina Turf and Mosquito, we help our customers with these things and much more every day. When you choose us, you can expect superior quality and customer service that won’t leave you guessing about the results you will see. We can discuss your needs from turf fertilization and lawn aeration to weed control services and mosquito control. We’ll work with you to achieve the best results, and our customer service is what will tell you that you’ve come to the right place in Charlotte, North Carolina.\n\nName: Carolina Turf and Mosquito\nAddress: 8022 Providence Rd. Ste 500-238, Charlotte, NC 28277\nPhone Number: 704-737-2637",
         "ptype_id": 29,
         "goal": 10,
         "attained": 0,
         "url": "https://www.facebook.com/profile.php?id=100063564314366",
         "start_dt": "Mar 24, 2026",
         "autorenew": 0
      },
      {
         "social_id": 3517,
         "link_id": 352250,
         "vendor": "x",
         "title": "Carolina Turf and Mosquito",
         "description": "Are you constantly battling mosquitoes and fire ants, and you can’t seem to find a permanent solution? Are you looking for ways to make your grass look lush and feel great under your feet? At Carolina Turf and Mosquito, we help our customers with these things and much more every day. When you choose us, you can expect superior quality and customer service that won’t leave you guessing about the results you will see. We can discuss your needs from turf fertilization and lawn aeration to weed control services and mosquito control. We’ll work with you to achieve the best results, and our customer service is what will tell you that you’ve come to the right place in Charlotte, North Carolina.\n\nName: Carolina Turf and Mosquito\nAddress: 8022 Providence Rd. Ste 500-238, Charlotte, NC 28277\nPhone Number: 704-737-2637",
         "ptype_id": 34,
         "goal": 10,
         "attained": 0,
         "url": "https://twitter.com/Turfandmosquito",
         "start_dt": "Mar 24, 2026",
         "autorenew": 0
      },
      {
         "social_id": 3518,
         "link_id": 352250,
         "vendor": "youtube",
         "title": "Carolina Turf and Mosquito",
         "description": "Are you constantly battling mosquitoes and fire ants, and you can’t seem to find a permanent solution? Are you looking for ways to make your grass look lush and feel great under your feet? At Carolina Turf and Mosquito, we help our customers with these things and much more every day. When you choose us, you can expect superior quality and customer service that won’t leave you guessing about the results you will see. We can discuss your needs from turf fertilization and lawn aeration to weed control services and mosquito control. We’ll work with you to achieve the best results, and our customer service is what will tell you that you’ve come to the right place in Charlotte, North Carolina.\n\nName: Carolina Turf and Mosquito\nAddress: 8022 Providence Rd. Ste 500-238, Charlotte, NC 28277\nPhone Number: 704-737-2637",
         "ptype_id": 31,
         "goal": 10,
         "attained": 0,
         "url": "https://www.youtube.com/channel/UCiEzMWdD-h7FzZmXtkyBThQ",
         "start_dt": "Mar 24, 2026",
         "autorenew": 0
      }
   ],
   "listing": {
      "link_id": 352250,
      "site_id": 69,
      "cat_id": 65,
      "priority": 0,
      "url": "https://carolinaturfandmosquito.com/",
      "title": "Carolina Turf and Mosquito",
      "description": "Are you constantly battling mosquitoes and fire ants, and you can’t seem to find a permanent solution? Are you looking for ways to make your grass look lush and feel great under your feet? At Carolina Turf and Mosquito, we help our customers with these things and much more every day. When you choose us, you can expect superior quality and customer service that won’t leave you guessing about the results you will see. We can discuss your needs from turf fertilization and lawn aeration to weed control services and mosquito control. We’ll work with you to achieve the best results, and our customer service is what will tell you that you’ve come to the right place in Charlotte, North Carolina.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 102992,
      "approve_dt": "2026-03-24T00:00:00.000Z",
      "source": null,
      "submit_dt": "2026-03-24T00: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": 32,
      "city_id": 15779,
      "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": 3095,
      "subcat_id": 5200,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "a9776518-275c-11f1-bb42-b66e99367f32",
      "subdate": "Mar 24, 2026",
      "subcategory": "Lawn Care",
      "request_types": "",
      "visitcount": 15
   },
   "visits": {
      "storefront": 15,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 1,
      "social": 4,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Transform Your Lawn into a Pest-Free Paradise. Tired of battling mosquitoes, fire ants, and lackluster grass? At Carolina Turf and Mosquito, we provide Charlotte homeowners with expert fertilization, aeration, weed control, and pest management. We combine superior quality with transparent customer service to ensure your lawn isn't just healthy—it’s a place you actually want to be.\n\nName: Carolina Turf and Mosquito\nAddress: 8022 Providence Rd. Ste 500-238, Charlotte, NC 28277\nPhone Number: 704-737-2637\n",
      "service1": "Lawn Fertilization",
      "service2": "Turf Management",
      "service3": "Mosquito Control",
      "service4": "Lawn Renovation",
      "service5": "Lawn Reseeding",
      "service6": "Soil Testing",
      "service7": "Lawn Aeration",
      "submit_dt": "2026-03-24 08:37:15"
   },
   "location": {
      "uuid": "a9776518-275c-11f1-bb42-b66e99367f32",
      "link_id": 352250,
      "account_id": 102992,
      "company": "Carolina Turf and Mosquito",
      "sid": 69,
      "country": 277,
      "countrycode": "US",
      "state": 32,
      "city": "15779",
      "zip": "28277",
      "address": "8022 Providence Rd. Ste 500-238",
      "phone": "+1 704-737-2637",
      "fax": null,
      "email": "s.e.rpnetic@gmail.com",
      "name": "Carolina Turf and Mosquito",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Charlotte",
      "statename": "North Carolina"
   },
   "socialmedia": [
      {
         "title": "Facebook",
         "ptype_id": 29,
         "dbtable": "links_socialmedia",
         "item": "Facebook",
         "cnt": 1
      },
      {
         "title": "Instagram",
         "ptype_id": 30,
         "dbtable": "links_socialmedia",
         "item": "Instagram",
         "cnt": null
      },
      {
         "title": "Youtube",
         "ptype_id": 31,
         "dbtable": "links_socialmedia",
         "item": "Youtube Video",
         "cnt": 1
      },
      {
         "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": 1
      },
      {
         "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": 1
      },
      {
         "item": "video",
         "cnt": 0
      },
      {
         "item": "product",
         "cnt": 1
      },
      {
         "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": {
      "pid": 1092,
      "link_id": 352250,
      "product_title": "Carolina Turf and Mosquito",
      "product_description": "Are you constantly battling mosquitoes and fire ants, and you can’t seem to find a permanent solution? Are you looking for ways to make your grass look lush and feel great under your feet? At Carolina Turf and Mosquito, we help our customers with these things and much more every day. When you choose us, you can expect superior quality and customer service that won’t leave you guessing about the results you will see. We can discuss your needs from turf fertilization and lawn aeration to weed control services and mosquito control. We’ll work with you to achieve the best results, and our customer service is what will tell you that you’ve come to the right place in Charlotte, North Carolina.\n\nName: Carolina Turf and Mosquito\nAddress: 8022 Providence Rd. Ste 500-238, Charlotte, NC 28277\nPhone Number: 704-737-2637",
      "product_link": "https://carolinaturfandmosquito.com/",
      "image_name": "carolina-turf-and-mosquito-company-logo.png",
      "extension": "png",
      "status": null,
      "subcat_id": 5200,
      "product_price": "$",
      "click_count": null,
      "keywords": null,
      "view_count": 5,
      "pdate": "2026-03-24T00:00:00.000Z",
      "post_status": 0
   }
}