Midstate Plumbing & Air

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 331804,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://www.midstateplumbingwv.com/",
      "title": "Midstate Plumbing & Air",
      "description": "Our mission at Midstate Plumbing & Air is to be recognized as a leader in our industry by providing outstanding plumbing services to our family of customers. We provide comprehensive plumbing repairs and service to residential and commercial customers on an immediate basis, and are available 24 hours a day / 7 days a week. To achieve the best level of service, Midstate Plumbing & Air only hires the best plumbing technicians in Bridgeport and West Virginia.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 82595,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-06-14T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 11,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 48,
      "city_id": 24075,
      "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": 5018,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "728cf0f2-2a36-11ef-8344-b66e99367f32",
      "subdate": "Jun 14, 2024",
      "subcategory": "General Plumbing",
      "request_types": "",
      "visitcount": 40
   },
   "visits": {
      "storefront": 40,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 11,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Plumber",
      "service1": "Plumbing Repair",
      "service2": "Drain Cleaning",
      "service3": "Water Pipe Repair",
      "service4": "Hot Water Heater Services",
      "service5": "Sewer Services",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-06-14 10:11:21"
   },
   "location": {
      "uuid": "728cf0f2-2a36-11ef-8344-b66e99367f32",
      "link_id": 331804,
      "account_id": 82595,
      "company": "Midstate Plumbing & Air",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 48,
      "city": "24075",
      "zip": "26330",
      "address": "201 Rawhide Road",
      "phone": "+1 681-622-1972",
      "fax": null,
      "email": "midstateplumbi@brite-email.com",
      "name": "Midstate Plumbing & Air",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "39.246981",
      "lon": "-80.258836",
      "cityname": "Bridgeport",
      "statename": "West Virginia"
   },
   "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": ""
}