Plumbing Contractors near me

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 335556,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://plumbersacramento247.com/",
      "title": "Plumbing Contractors near me",
      "description": "New Flow Plumbing Roseville is your top choice for plumbing in Roseville and Sacramento, CA. We handle all plumbing needs, from installations and repairs to drain cleaning and maintenance. Our licensed plumbers are ready to fix any issue fast with quality work and great service. For trusted plumbing help, call us at 916-527-8885 for a free estimate. Choose New Flow Plumbing for reliable repairs where your satisfaction comes first!",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 86299,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-09-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": 0,
      "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": 5018,
      "d_url": null,
      "approved": null,
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "26b95292-75cc-11ef-ab46-b66e99367f32",
      "subdate": "Sep 18, 2024",
      "subcategory": "General Plumbing",
      "request_types": "",
      "visitcount": 6
   },
   "visits": {
      "storefront": 6,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 2,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "New Flow Plumbing Roseville is your top choice for plumbing in Roseville and Sacramento, CA. We handle all plumbing needs, from installations and repairs to drain cleaning and maintenance. Our licensed plumbers are ready to fix any issue fast with quality work and great service. For trusted plumbing help, call us at 916-527-8885 for a free estimate. Choose New Flow Plumbing for reliable repairs where your satisfaction comes first!",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-09-18 14:41:55"
   },
   "location": {
      "uuid": "26b95292-75cc-11ef-ab46-b66e99367f32",
      "link_id": 335556,
      "account_id": 86299,
      "company": "New Flow Plumbing Roseville",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 0,
      "city": "",
      "zip": "95661",
      "address": "622 Whyte Ave",
      "phone": "(916) 527-8885",
      "fax": null,
      "email": "newflowplumbingroseville@notifao.com",
      "name": "New Flow Plumbing Roseville",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "38.7218853",
      "lon": "-121.2828888"
   },
   "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": ""
}