Jacot Plumbing

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 308010,
      "site_id": 66,
      "cat_id": 78,
      "priority": 0,
      "url": "http://www.jacotplumbing.com",
      "title": "Jacot Plumbing",
      "description": "Jacot Plumbing is a family owned plumbing service and repair business located in Garden Grove, California known for honesty and reliability. For over 50 years, our family has served the community in residential and commercial plumbing services. ",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 59246,
      "approve_dt": "2014-01-27T00:00:00.000Z",
      "source": null,
      "submit_dt": "2014-01-24T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 2063,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 0,
      "city_id": 0,
      "ltop": "",
      "facebook": "",
      "tiktok": "",
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": "",
      "youtube": "",
      "youtube_title": "",
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": 0,
      "yahoobot": 0,
      "msnbot": 0,
      "author_id": 1560,
      "subcat_id": 5031,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "jpg",
      "pack_id": null,
      "uuid": "948710b8-56da-11ed-b77c-b66e99367f32",
      "subdate": "Jan 24, 2014",
      "subcategory": "Licensed Plumber",
      "request_types": "",
      "visitcount": 2416
   },
   "visits": {
      "storefront": 2416,
      "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": "Jacot Plumbing is a family owned plumbing service and repair business located in Garden Grove, California known for honesty and reliability. For over 50 years our family has served the community in residential and commercial plumbing services.",
      "service1": "Leak Detection",
      "service2": "Emergency Services",
      "service3": "Sewer Drain Repairs",
      "service4": "Mainline & Drain Cleaning",
      "service5": "Water Heaters/Tankless",
      "service6": "Slab Leaks",
      "service7": "Video Inspection",
      "submit_dt": "2014-01-24 23:14:00"
   },
   "location": {
      "uuid": "948710b8-56da-11ed-b77c-b66e99367f32",
      "link_id": 308010,
      "account_id": 59246,
      "company": "Jacot Plumbing",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 0,
      "city": "",
      "zip": "92840",
      "address": "10372 Stanford Avenue, Suite S, Garden Grove, CA",
      "phone": "",
      "fax": "",
      "email": "",
      "name": "",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "33.7769686",
      "lon": "-117.9522908"
   },
   "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": ""
}