In Demand Plumbing

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 331288,
      "site_id": 66,
      "cat_id": 78,
      "priority": 2,
      "url": "https://www.indemandplumbing.com/near-me/concord-plumbing-services",
      "title": "In Demand Plumbing",
      "description": "In Demand Plumbing in Concord offers professional plumbing services with a focus on quality and reliability for both residential and commercial clients. Expert plumbers handle emergencies, maintenance, and installations with prompt, effective solutions. Known for customer satisfaction, the company provides transparent pricing and same-day services. Key offerings include drain cleaning, water heater services, and sewer repair.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 82087,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-05-29T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 23,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 1810,
      "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": 5009,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "7c49f891-1e14-11ef-8344-b66e99367f32",
      "subdate": "May 29, 2024",
      "subcategory": "Home Plumbing",
      "request_types": "",
      "visitcount": 72
   },
   "visits": {
      "storefront": 72,
      "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": "Plumbing",
      "service2": "Water Heater",
      "service3": "Leak Detection",
      "service4": "Repipe",
      "service5": "Sewer Repair",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-05-29 23:38:00"
   },
   "location": {
      "uuid": "7c49f891-1e14-11ef-8344-b66e99367f32",
      "link_id": 331288,
      "account_id": 82087,
      "company": "",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "1810",
      "zip": "94520",
      "address": "1320 Willow Pass Rd, Suite 600",
      "phone": "(925) 515-4477",
      "fax": null,
      "email": "indemndplumb@brite-mail.com",
      "name": "In Demand Plumbing",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "37.968226",
      "lon": "-122.0513661",
      "cityname": "Concord",
      "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": ""
}