24/7 Plumbing Repair

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 309708,
      "site_id": 66,
      "cat_id": 78,
      "priority": 0,
      "url": "http://qualityplumbingrepairdenver.com",
      "title": "24/7 Plumbing Repair",
      "description": "We are a locally owned and operated business that provides complete expert services to customers throughout Colorado Springs and the surrounding region. Our site details the various services we provide and includes contact information allowing customers to get prompt response to plumbing emergencies any time, day or night.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 60944,
      "approve_dt": "2015-06-17T00:00:00.000Z",
      "source": null,
      "submit_dt": "2015-06-12T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1298,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 6,
      "city_id": 2782,
      "ltop": "",
      "facebook": "https://www.facebook.com/pages/247-Plumbing-Repair/431386193543989",
      "tiktok": "",
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": "http://www.youtube.com/watch?v=UKTf8YneZnc",
      "youtube": "http://www.youtube.com/watch?v=UKTf8YneZnc",
      "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": 4976,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9549673e-56da-11ed-b77c-b66e99367f32",
      "subdate": "Jun 12, 2015",
      "subcategory": "Plumbing Contractor",
      "request_types": "",
      "visitcount": 1593
   },
   "visits": {
      "storefront": 1593,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 10,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "24/7 Plumbing Repair was established to provide emergency plumbing services to commercial and residential customers in Fort Collins and the nearby cities. Our techs are highly knowledgeable and hold several years of professional experience in the industry enabling them to handle just about any project customers may have. We repair and maintain water heaters, garbage disposals and other appliances as well as plumbing and fixtures. Our response time to urgent situations is very quick and available 24 hours a day.",
      "service1": "plumbing repair",
      "service2": " emergency plumbing",
      "service3": " drain cleaning",
      "service4": " water heater installation",
      "service5": " sewer line inspections",
      "service6": " plumbing remodels",
      "service7": " water lines",
      "submit_dt": "2015-06-12 17:35:57"
   },
   "location": {
      "uuid": "9549673e-56da-11ed-b77c-b66e99367f32",
      "link_id": 309708,
      "account_id": 60944,
      "company": "24/7 Plumbing Repair",
      "sid": 66,
      "country": 277,
      "countrycode": "US",
      "state": 6,
      "city": "2782",
      "zip": "80227",
      "address": "2490 S. Sheridan Blvd",
      "phone": "",
      "fax": "",
      "email": "247.plumbing.repair@ibizlocal.net",
      "name": "24/7 Plumbing Repair",
      "status": "",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "39.674506",
      "lon": "-105.0528983",
      "cityname": "Denver",
      "statename": "Colorado"
   },
   "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": ""
}