Blue Bear Plumbing

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 318164,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://www.bluebearplumbing.com",
      "title": "Blue Bear Plumbing",
      "description": "Blue Bear Plumbing provides trustworthy residential and commercial plumbing and HVAC services from experienced plumbers in Marshfield, MA. In addition to routine plumbing services, repairs, and installations, we''re fully equipped for more technical services such as HVAC and water heating system repairs. We also provide thorough inspections to verify that your system is running smoothly. Call our contractors at (781) 706-4682 for 24-Hour emergency services.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 69358,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2019-12-12T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 175,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 21,
      "city_id": 10008,
      "ltop": "",
      "facebook": "https://www.facebook.com/bluebearplumbing/",
      "tiktok": null,
      "linkedin": "",
      "twitter": "https://twitter.com/bear_plumbing",
      "googleplus": "",
      "youtube_channel": null,
      "youtube": "",
      "youtube_title": null,
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "https://www.instagram.com/bluebearplumbing/",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": null,
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 4974,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9573c0a0-56da-11ed-b77c-b66e99367f32",
      "subdate": "Dec 12, 2019",
      "subcategory": "Plumbing",
      "request_types": "",
      "visitcount": 278
   },
   "visits": {
      "storefront": 278,
      "articles": 0,
      "videos": 0,
      "reviews": 16,
      "coupons": 0,
      "products": 0,
      "social": 6,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Blue Bear Plumbing provides trustworthy residential and commercial plumbing and HVAC services from experienced plumbers in Marshfield, MA. In addition to routine plumbing services, repairs, and installations, we're fully equipped for more technical services such as HVAC and water heating system repairs. We also provide thorough inspections to verify that your system is running smoothly. Call our contractors at (781) 706-4682 for 24-Hour emergency services.",
      "service1": "Plumbing : Construction and Maintenance",
      "service2": "Plumbing : Construction and Maintenance",
      "service3": "Plumbing : Construction and Maintenance",
      "service4": "",
      "service5": "residential plumbing marshfield ma",
      "service6": "",
      "service7": "",
      "submit_dt": "2019-12-12 09:02:30"
   },
   "location": {
      "uuid": "9573c0a0-56da-11ed-b77c-b66e99367f32",
      "link_id": 318164,
      "account_id": 69358,
      "company": "Blue Bear Plumbing",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 21,
      "city": "10008",
      "zip": "02050",
      "address": "450 Plain Street, Suite 8",
      "phone": "781-706-4682",
      "fax": null,
      "email": "info.bluebearplumbing@gmail.com",
      "name": "Blue Bear Plumbing",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "42.1045113",
      "lon": "-70.7338989",
      "cityname": "Marshfield",
      "statename": "Massachusetts"
   },
   "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": ""
}