Optimal Plumbing Solutions

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 329794,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://theoptimalplumber.com/",
      "title": "Optimal Plumbing Solutions",
      "description": "When you are looking for an efficient and affordable plumbing company in Raleigh, NC and the surrounding areas, look no further than Optimal Plumbing Solutions. Whether you require a water heater installation or drain cleaning services, just let us know what you need! From plumber repairs to water or sewer line repair and installations, we are the locally owned experts to handle it for you. Serving Raleigh, Durham, Clayton NC, as well as Wake County, Johnston County and surrounding areas.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 80607,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-04-09T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 14,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 32,
      "city_id": 16128,
      "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": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "498cecf7-f6ac-11ee-8344-b66e99367f32",
      "subdate": "Apr 09, 2024",
      "subcategory": "General Plumbing",
      "request_types": "",
      "visitcount": 55
   },
   "visits": {
      "storefront": 55,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 9,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "",
      "service1": "Plumbing",
      "service2": "Water Heater Repair",
      "service3": "Sewer Repair",
      "service4": "Water Leak Repair",
      "service5": "Drain Cleaning",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-04-09 20:03:52"
   },
   "location": {
      "uuid": "498cecf7-f6ac-11ee-8344-b66e99367f32",
      "link_id": 329794,
      "account_id": 80607,
      "company": "Optimal Plumbing Solutions",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 32,
      "city": "16128",
      "zip": "27603",
      "address": "1805 Garner Station Blvd",
      "phone": "(919) 917-2797",
      "fax": null,
      "email": "theoptimalplumbermarketing@gmail.com",
      "name": "Optimal Plumbing Solutions",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "35.7242611",
      "lon": "-78.6595755",
      "cityname": "Raleigh",
      "statename": "North 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": ""
}