First Rate Plumbing Inc

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 310636,
      "site_id": 66,
      "cat_id": 78,
      "priority": 0,
      "url": "http://firstrate.plumbing/",
      "title": "First Rate Plumbing Inc",
      "description": "First Rate Plumbing has 20 years of experience and we provide the finest quality plumbing work in. We specialize in Plumbing Service and Repair, Drain Line Stoppages, as well as Drain Cleaning. \n\n",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 61871,
      "approve_dt": "2015-10-08T00:00:00.000Z",
      "source": null,
      "submit_dt": "2015-10-06T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 946,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 2452,
      "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": 0,
      "subcat_id": 5029,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "954e78d0-56da-11ed-b77c-b66e99367f32",
      "subdate": "Oct 06, 2015",
      "subcategory": "Plumber Supply",
      "request_types": "",
      "visitcount": 1116
   },
   "visits": {
      "storefront": 1116,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 3,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "We do offer a variety of services to provide help with specific problems, such as camera inspection, and location of sewer lines. We use Hydro Jetting to clean and remove sewer line blockages. We repair slab leaks and install conventional water heaters and tankless water heaters.\nIf you are doing remodels and new construction that is something we do extremely well. If you are looking to get any plumbing work done, please call us!",
      "service1": "Plumbing Service and repair",
      "service2": " Drain Line Stoppages",
      "service3": " Drain Cleaning",
      "service4": " Camera Inspection and location sewer lines",
      "service5": " Hyrdo Jetting",
      "service6": " Slab Leaks",
      "service7": " Water Heaters",
      "submit_dt": "2015-10-07 03:53:02"
   },
   "location": {
      "uuid": "954e78d0-56da-11ed-b77c-b66e99367f32",
      "link_id": 310636,
      "account_id": 61871,
      "company": "First Rate Plumbing Inc",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "2452",
      "zip": "",
      "address": "",
      "phone": "(619) 717-6686",
      "fax": "",
      "email": "rhart123457@gmail.com",
      "name": "First Rate Plumbing Inc",
      "status": "hide",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": null,
      "lon": null,
      "cityname": "San Diego",
      "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": ""
}