Benjamin Franklin Plumbing of Greater Minneapolis

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 348015,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://www.benjaminfranklinplumbing.com/minneapolis/?utm_source=GMB&utm_medium=organic&utm_campaign=ramsey",
      "title": "Benjamin Franklin Plumbing of Greater Minneapolis",
      "description": "Northern Ben Franklin is a trusted Minneapolis-area plumbing company serving Minneapolis, St. Paul, Anoka, Ramsey, and surrounding communities with comprehensive plumbing solutions. With highly-trained, licensed plumbers available 24/7, the company provides straightforward pricing and reliable service designed to give customers peace of mind, handling everything from emergency repairs to routine maintenance and installations.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 98710,
      "approve_dt": "2025-07-18T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-06-03T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 23,
      "city_id": 11415,
      "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": 5026,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "a6902bb5-4015-11f0-a909-b66e99367f32",
      "subdate": "Jun 03, 2025",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 36
   },
   "visits": {
      "storefront": 36,
      "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": "Benjamin Franklin Plumbing is one of the leading plumbing brands in the United States because of our commitment to customer satisfaction. Our plumbers provide quality repairs, installations, replacements, and maintenance for homes and businesses, resulting in reliable plumbing that lasts. We are licensed and qualified to handle plumbing projects of any size, from routine maintenance to major remodels.",
      "service1": "Water Heater Installation",
      "service2": "Plumbing Repairs",
      "service3": "Plumbing Inspections",
      "service4": "Tankless Water Heaters",
      "service5": "Drain Cleaning",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-06-03 00:56:58"
   },
   "location": {
      "uuid": "a6902bb5-4015-11f0-a909-b66e99367f32",
      "link_id": 348015,
      "account_id": 98710,
      "company": "Benjamin Franklin Plumbing of Greater Minneapolis",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 23,
      "city": "11415",
      "zip": "55303",
      "address": "9431 Alpine Drive, B",
      "phone": "+1 612-430-6547",
      "fax": null,
      "email": "benjaminfranklinplumb@burst-email.com",
      "name": "",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "45.2515377",
      "lon": "-93.5094367",
      "cityname": "Ramsey",
      "statename": "Minnesota"
   },
   "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": ""
}