Benjamin Franklin Plumbing of Grand Rapids

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 348891,
      "site_id": 58,
      "cat_id": 53,
      "priority": 2,
      "url": "https://www.benjaminfranklinplumbing.com/grand-rapids/",
      "title": "Benjamin Franklin Plumbing of Grand Rapids",
      "description": "With the Benjamin Franklin Plumbing team, you get the best of both worldslocal licensed plumbers backed by a trusted national service. Because all of our locations are independently owned and operated, we live and work in the communities we serve.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": 99585,
      "approve_dt": "2025-07-08T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-06-18T00: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": 22,
      "city_id": 0,
      "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": 4197,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "1b547f46-4c3a-11f0-a909-b66e99367f32",
      "subdate": "Jun 18, 2025",
      "subcategory": "Plumbing",
      "request_types": "",
      "visitcount": 65
   },
   "visits": {
      "storefront": 65,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 24,
      "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 built on the founding principles of trust, integrity, wisdom, and humanity. Our team of highly trained, licensed plumbers is fully equipped to handle your home's diverse plumbing service needs with a commitment to excellence in every customer experience. We proudly offer a 100% customer satisfaction guarantee and an on-time guarantee that pays you $5 for every minute we're late. With 24/7 emergency services and no after-hour fees, even on weekends and holidays, we ensure all our work meets the highest industry standards and conforms to local, state, and national building codes.",
      "service1": "emergency plumbing services",
      "service2": " plumbing repairs",
      "service3": " plumbing installations",
      "service4": " drain cleaning",
      "service5": " water heater services",
      "service6": " pipe replacement",
      "service7": " 24/7 plumbing support",
      "submit_dt": "2025-06-18 11:48:09"
   },
   "location": {
      "uuid": "1b547f46-4c3a-11f0-a909-b66e99367f32",
      "link_id": 348891,
      "account_id": 99585,
      "company": "Benjamin Franklin Plumbing of Grand Rapids",
      "sid": 58,
      "country": 277,
      "countrycode": "US",
      "state": 22,
      "city": "0",
      "zip": "49525",
      "address": "4410 Plainfield Ave NE Grand Rapids, MI 49525",
      "phone": "6163174707",
      "fax": null,
      "email": "benjaminfranklinplumbingofgran@gmail.com",
      "name": "Benjamin Franklin Plumbing of Grand Rapids",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "43.0431338",
      "lon": "-85.6065817",
      "cityname": "",
      "statename": ""
   },
   "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": ""
}

all our featured social media