All Service Plumbing Drain and Hydro-Jet

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 325298,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://allserviceplumbers.com",
      "title": "All Service Plumbing Drain and Hydro-Jet",
      "description": "",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 76253,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2023-07-08T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 2,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2483,
      "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": 6646,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "65309cf9-1d7b-11ee-8344-b66e99367f32",
      "subdate": "Jul 08, 2023",
      "subcategory": "Construction",
      "request_types": "",
      "visitcount": 6
   },
   "visits": {
      "storefront": 6,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 1,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "All Service Plumbing Drain and Hydrojet is your local trusted family owned plumbing company. We can help you with all your plumbing needs. Same day or next day service available for Hydro Jetting, Camera Inspections, Drain Cleaning, Gas and Water Leak Detection, Water Main Service, Repiping, and the newest Trenchless technology like Pipe Bursting and Sewer Lining.\r
\r
Business Email : allserviceplumbers@gmail.com\r
",
      "service1": "Santa Fe Springs plumbing services",
      "service2": "Drain cleaning in Santa Fe Springs",
      "service3": "Hydro-jetting experts Santa Fe Springs",
      "service4": "Sewer line repairs Santa Fe Springs",
      "service5": "Professional plumbers Santa Fe Springs CA",
      "service6": "",
      "service7": "",
      "submit_dt": "2023-07-08 10:37:11"
   },
   "location": {
      "uuid": "65309cf9-1d7b-11ee-8344-b66e99367f32",
      "link_id": 325298,
      "account_id": 76253,
      "company": "All Service Plumbing Drain and Hydro-Jet",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2483",
      "zip": "90670",
      "address": "11337 Davenrich St",
      "phone": "(562)-275-8928",
      "fax": null,
      "email": "allserviceplumbers@outlook.com",
      "name": "All Service Plumbing Drain and Hydro-Jet",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "33.9460195",
      "lon": "-118.0913561",
      "cityname": "Santa Fe Springs",
      "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": ""
}