Rochester Plumbing & Heating

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 333553,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://rochph.com",
      "title": "Rochester Plumbing & Heating",
      "description": "You can trust a plumber to provide fast and effective repair services for clogged water heaters or leaking pipes. Rochester Plumbing & Heating, a company dedicated to providing quality workmanship, affordable rates and excellent customer service, is the place for you if you have issues with residential, commercial and agricultural clients in Olmsted County. This local plumber has been keeping up with the latest technology in the plumbing industry for nearly a hundred years.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 84328,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-07-29T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 6,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 23,
      "city_id": 11436,
      "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": 4974,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "df12877e-4d5b-11ef-8344-b66e99367f32",
      "subdate": "Jul 29, 2024",
      "subcategory": "Plumbing",
      "request_types": "",
      "visitcount": 34
   },
   "visits": {
      "storefront": 34,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 14,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-07-29 03:37:25"
   },
   "location": {
      "uuid": "df12877e-4d5b-11ef-8344-b66e99367f32",
      "link_id": 333553,
      "account_id": 84328,
      "company": "Rochester Plumbing & Heating",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 23,
      "city": "11436",
      "zip": "55901",
      "address": "2840 Wilder Rd NW",
      "phone": "(507) 289-1613",
      "fax": null,
      "email": "rochphplumbing@burst-email.com",
      "name": "Rochester Plumbing & Heating",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "44.0350127",
      "lon": "-92.5044205",
      "cityname": "Rochester",
      "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": ""
}