Benjamin Franklin Plumbing of Chapel Hill & South Durham

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 348367,
      "site_id": 58,
      "cat_id": 53,
      "priority": 2,
      "url": "https://www.benjaminfranklinplumbing.com/chsd/",
      "title": "Benjamin Franklin Plumbing of Chapel Hill & South Durham",
      "description": "As a result, our owners and their employees are more committed to providing excellent experiences and helping out our neighbors. We hire talent right from the community, boosting the local economy by keeping dollars in our own backyard. That''s worth being proud of.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 99062,
      "approve_dt": "2025-07-14T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-06-09T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 8,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 32,
      "city_id": 15825,
      "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": 4218,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "cefab4d3-4502-11f0-a909-b66e99367f32",
      "subdate": "Jun 09, 2025",
      "subcategory": "Air Conditioning",
      "request_types": "",
      "visitcount": 60
   },
   "visits": {
      "storefront": 60,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 18,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Benjamin Franklin Plumbing is a locally owned and operated plumbing company that combines community expertise with national backing to deliver exceptional service. Built on the founding principles of trust, integrity, wisdom, and humanity, they offer comprehensive plumbing solutions with a 100% satisfaction guarantee and on-time service promise. Their highly trained, licensed plumbers are fully equipped with thousands of parts to resolve most issues in a single visit, providing 24/7 emergency services without after-hour fees.",
      "service1": "emergency plumbing services",
      "service2": " plumbing installations and repairs",
      "service3": " comprehensive plumbing inspections",
      "service4": " plumbing remodeling projects",
      "service5": " drain cleaning services",
      "service6": " water heater installation and repair",
      "service7": " commercial plumbing solutions",
      "submit_dt": "2025-06-09 07:24:41"
   },
   "location": {
      "uuid": "cefab4d3-4502-11f0-a909-b66e99367f32",
      "link_id": 348367,
      "account_id": 99062,
      "company": "Benjamin Franklin Plumbing of Chapel Hill & South Durham",
      "sid": 58,
      "country": 277,
      "countrycode": "US",
      "state": 32,
      "city": "15825",
      "zip": "27707",
      "address": "1415 W North Carolina 54 Suite 101, Durham, NC 27707",
      "phone": "984-243-2924",
      "fax": null,
      "email": "marketingmfpchsd2@gmail.com",
      "name": "Benjamin Franklin Plumbing of Chapel Hill & South Durham",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "35.9180418",
      "lon": "-78.9637624",
      "cityname": "Durham",
      "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": ""
}