University Place Certified Auto Service

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 315445,
      "site_id": 26,
      "cat_id": 5,
      "priority": 2,
      "url": "https://upautoservice.com/",
      "title": "University Place Certified Auto Service",
      "description": "We perform preventive auto / car maintenance, repairs on brakes, steering and suspension, power steering, lube service, air conditioning + heating, fuel injection system, ignition system and much much more. \n \n Our promise to you, our valued customers and friends...\n \n We will always treat you and your vehicle like family, always giving you personal service, accurate assessments and quality repairs. We''ve been trusted and honored to serve you and our community for more than 37 years and we look forward to serving you more years and beyond.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 66661,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2018-07-10T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 137,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 46,
      "city_id": 23990,
      "ltop": "",
      "facebook": "https://www.facebook.com/u.p.certifiedautoservice/",
      "tiktok": null,
      "linkedin": "",
      "twitter": "",
      "googleplus": "",
      "youtube_channel": null,
      "youtube": "https://www.youtube.com/channel/UCUpesT4JkRSu-G0e_P2bydA",
      "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": 1659,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "95633120-56da-11ed-b77c-b66e99367f32",
      "subdate": "Jul 10, 2018",
      "subcategory": "Repair Manuals",
      "request_types": "",
      "visitcount": 210
   },
   "visits": {
      "storefront": 210,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 15,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Established in 1979, University Place Certified Auto Service is your trusted name in University Place, Tacoma & Fircrest!                                                                                                                 ",
      "service1": "auto radiator repair",
      "service2": "car repair",
      "service3": "auto repair",
      "service4": "Auto Repair and Radiator Service",
      "service5": "Complete auto service and repair",
      "service6": "",
      "service7": "",
      "submit_dt": "2018-07-11 03:08:01"
   },
   "location": {
      "uuid": "95633120-56da-11ed-b77c-b66e99367f32",
      "link_id": 315445,
      "account_id": 66661,
      "company": "University Place Certified Auto Service",
      "sid": 26,
      "country": 277,
      "countrycode": "US",
      "state": 46,
      "city": "23990",
      "zip": "98466",
      "address": "6904 27th St W",
      "phone": "253-565-4165",
      "fax": null,
      "email": "upautoserviceusa@gmail.com",
      "name": "University Place Certified Auto Service",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "47.2350832",
      "lon": "-122.5294831",
      "cityname": "University Place",
      "statename": "Washington"
   },
   "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": ""
}