James Smith Well Drilling

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 350154,
      "site_id": 76,
      "cat_id": 11,
      "priority": 0,
      "url": "http://Jamessmithwelldrilling.com/",
      "title": "James Smith Well Drilling",
      "description": "We offer professional installation and repair services for water wells, pumps, pressure tanks, filters, softeners, and aerators. Our team also provides septic system services, including septic pump installation, drain field repairs, and full system replacements. Dedicated to quality and customer satisfaction, we ensure long-lasting solutions and are available for emergency services to handle urgent issues quickly and  effectively.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 100849,
      "approve_dt": "2025-09-25T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-09-25T00: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": 10,
      "city_id": 4717,
      "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": 6285,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "b7af9143-99e3-11f0-bb42-b66e99367f32",
      "subdate": "Sep 25, 2025",
      "subcategory": "Contractor",
      "request_types": "",
      "visitcount": 57
   },
   "visits": {
      "storefront": 57,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 17,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "We offer professional installation and repair services for water wells, pumps, pressure tanks, filters, softeners, and aerators. Our team also provides septic system services, including septic pump installation, drain field repairs, and full system replacements. Dedicated to quality and customer satisfaction, we ensure long-lasting solutions and are available for emergency services to handle urgent issues quickly and  effectively.",
      "service1": "Water filter installation",
      "service2": "Pressure tank installation",
      "service3": "Well pump repair",
      "service4": "Well pump installation",
      "service5": "Water well repair",
      "service6": "Water well installation",
      "service7": "Well Drilling",
      "submit_dt": "2025-09-25 07:46:16"
   },
   "location": {
      "uuid": "b7af9143-99e3-11f0-bb42-b66e99367f32",
      "link_id": 350154,
      "account_id": 100849,
      "company": "James Smith Well Drilling",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 10,
      "city": "4717",
      "zip": "31569",
      "address": "6858 Old Jefferson Hwy",
      "phone": "912-464-7012",
      "fax": null,
      "email": "haislelivingston493@gmail.com",
      "name": "James Smith Well Drilling",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Woodbine",
      "statename": "Georgia"
   },
   "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": ""
}