Paschall Plumbing Heating Cooling

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 314601,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "http://www.paschallplus.com/",
      "title": "Paschall Plumbing Heating Cooling",
      "description": "Paschall Plumbing Heating Cooling provides services for your AC repair, plumbing, heating and cooling needs, and more. Serving to the communities of Reno, Sparks and surrounding areas within Nevada.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 65828,
      "approve_dt": "2020-09-18T00:00:00.000Z",
      "source": null,
      "submit_dt": "2018-03-09T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 419,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 27,
      "city_id": 13805,
      "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": 5840,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "956147c9-56da-11ed-b77c-b66e99367f32",
      "subdate": "Mar 09, 2018",
      "subcategory": "Air Conditioning",
      "request_types": "",
      "visitcount": 544
   },
   "visits": {
      "storefront": 544,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 16,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "When you’ve been serving locals for as long as we have, it’s easy to see why the Reno-Sparks area calls us first when they are experiencing a plumbing, heating, or cooling problems. We have customers that have been counting on our services for over three decades. As a company that’s been around since the 80s with customers who’ve relied on us for all three of those decades, we often wonder, “why us”? There’s no shortage of plumbing and HVAC companies in the area.\n\nWhen we ask those loyal customers that have stuck it out with us for over 35 years why they never call any of our many competitors, they tell us they’ve never had a reason to call anyone else because Paschall Plumbing Heating Cooling treats them right. We aim for “Your Best Experience Each Time!” We don’t want to earn your plumbing & HVAC business one time, we want to earn the right to be your plumbing & HVAC company for forever.",
      "service1": "Heating",
      "service2": " Air Conditioning",
      "service3": " Water Heaters",
      "service4": " Plumbing",
      "service5": " Water Purification",
      "service6": " Air Purification",
      "service7": " Emergency HVAC Services",
      "submit_dt": "2018-03-09 11:39:17"
   },
   "location": {
      "uuid": "956147c9-56da-11ed-b77c-b66e99367f32",
      "link_id": 314601,
      "account_id": 65828,
      "company": "Paschall Plumbing Heating Cooling",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 27,
      "city": "13805",
      "zip": "89431",
      "address": "1519 Pittman Ave",
      "phone": "",
      "fax": null,
      "email": "paschallplus@hotmail.com",
      "name": "Paschall Plumbing Heating Cooling",
      "status": "",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "39.5292673",
      "lon": "-119.7636403",
      "cityname": "Sparks",
      "statename": "Nevada"
   },
   "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": ""
}