Schaible''s Plumbing & Heating

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 313928,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "http://www.schaiblesplumbing.com/",
      "title": "Schaible''s Plumbing & Heating",
      "description": "Schaible''s Plumbing & Heating provides residential and commercial plumbing, heating & air conditioning services in Washington, Flemington & Clinton, New Jersey (NJ). Call us at 908-537-6770.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 65153,
      "approve_dt": "2020-09-03T00:00:00.000Z",
      "source": null,
      "submit_dt": "2017-11-27T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 707,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 29,
      "city_id": 14057,
      "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": "jpg",
      "pack_id": null,
      "uuid": "955d5b94-56da-11ed-b77c-b66e99367f32",
      "subdate": "Nov 27, 2017",
      "subcategory": "Plumbers",
      "request_types": "",
      "visitcount": 940
   },
   "visits": {
      "storefront": 940,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 5,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Of course Schaible’s is adept at the odd plumbing and heating crisis, like leaks and breaks in pipes. But we really shine at designing and sourcing the replacement system perfectly suited for your budget and your needs.\n\nAre you looking to conserve water? We can provide the latest in water-efficient toilets, water heaters, and boilers. Want instantly hot water for the shower? One of our tankless hot water heaters may be the best solution. Updating or remodeling a bathroom? Let us source the faucets, regulators, and shower heads in your choice of style and get better quality and longer lifespan than what you’ll find in the big-box DIY stores.",
      "service1": "Comfort Plans",
      "service2": " Air Conditioning Indoor Air Quality Systems",
      "service3": " Service & Repairs",
      "service4": " Leak Protection",
      "service5": " Water Treatment",
      "service6": " Boilers",
      "service7": " Radiant Heat Systems",
      "submit_dt": "2017-11-28 04:52:55"
   },
   "location": {
      "uuid": "955d5b94-56da-11ed-b77c-b66e99367f32",
      "link_id": 313928,
      "account_id": 65153,
      "company": "Schaible''s Plumbing & Heating",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 29,
      "city": "14057",
      "zip": "08827",
      "address": "241 Van Syckels Rd",
      "phone": "908-537-6770",
      "fax": null,
      "email": "schaiblesplumbing@gmail.com",
      "name": "Schaible's Plumbing & Heating",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "40.6411105",
      "lon": "-74.9825883",
      "cityname": "Hampton",
      "statename": "New Jersey"
   },
   "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": ""
}