Plumbers Roseville

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 326040,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://www.plumbersroseville.com/",
      "title": "Plumbers Roseville",
      "description": "Plumbers Roseville in Roseville, CA is a reputable plumbing service that offers a wide range of services to residential and commercial customers. With a team of highly skilled and experienced plumbers, we are committed to providing exceptional service and ensuring customer satisfaction. From simple repairs like fixing leaks and clogged drains to complex tasks such as pipe replacements and sewer line repairs, Plumbers Roseville has the expertise to tackle any plumbing issue efficiently and effectively. We use state-of-the-art equipment and industry best practices to diagnose problems accurately and provide long-lasting solutions. Additionally, our team maintains professionalism throughout the entire process, arriving promptly at scheduled appointments, offering transparent pricing with no hidden fees, and leaving the work area clean. Our dedication to quality craftsmanship combined with excellent customer service makes Plumbers Roseville a trusted choice for all plumbing needs in the community of Roseville, CA.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 76937,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2023-10-16T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 98,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2428,
      "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": 5003,
      "d_url": null,
      "approved": null,
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "b44ea72a-6bda-11ee-8344-b66e99367f32",
      "subdate": "Oct 16, 2023",
      "subcategory": "Basic Plumbing",
      "request_types": "",
      "visitcount": 117
   },
   "visits": {
      "storefront": 117,
      "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": "",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2023-10-16 04:15:59"
   },
   "location": {
      "uuid": "b44ea72a-6bda-11ee-8344-b66e99367f32",
      "link_id": 326040,
      "account_id": 76937,
      "company": "Plumbers Roseville",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2428",
      "zip": "95661",
      "address": "1700 Eureka Rd ste 155",
      "phone": "916-755-6779",
      "fax": null,
      "email": "plumbersroseville@gmail.com",
      "name": "Plumbers Roseville",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "38.7424489",
      "lon": "-121.247054",
      "cityname": "Roseville",
      "statename": "California"
   },
   "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": ""
}