Foster's Automotive Service

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 349413,
      "site_id": 26,
      "cat_id": 5,
      "priority": 0,
      "url": "https://fostersautomotiveservice.com",
      "title": "Foster's Automotive Service",
      "description": "Auto Repair Shop in Houston, TX  \n\nAuto Repair Shop, Mechanical Work, Auto Maintenance, State Vehicle Inspections, Alignments, Transmission Services, Brake Repair, Oil Changes, Brakes, Suspension and Chassis, Engine Repair, Auto Windshield\n\n\n\n",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 100108,
      "approve_dt": "2025-07-16T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-07-16T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 0,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 42,
      "city_id": 21883,
      "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": 1659,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "1bc7bc86-6202-11f0-a909-b66e99367f32",
      "subdate": "Jul 16, 2025",
      "subcategory": "Repair Manuals",
      "request_types": "",
      "visitcount": 26
   },
   "visits": {
      "storefront": 26,
      "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": "Foster's Automotive Service is a trusted auto repair shop in Houston, TX, dedicated to providing comprehensive automotive services with a focus on efficient and dependable workmanship. The shop offers a wide range of automotive maintenance and repair solutions, ensuring reliable service for all vehicle types while maintaining high standards of quality and customer satisfaction.",
      "service1": "brake repair",
      "service2": " wheel alignments",
      "service3": " state vehicle inspections",
      "service4": " automotive maintenance",
      "service5": " general auto repair",
      "service6": " diagnostic services",
      "service7": " oil changes",
      "submit_dt": "2025-07-16 05:02:44"
   },
   "location": {
      "uuid": "1bc7bc86-6202-11f0-a909-b66e99367f32",
      "link_id": 349413,
      "account_id": 100108,
      "company": "Foster's Automotive Service",
      "sid": 26,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "21883",
      "zip": "77023",
      "address": "3909 Polk St",
      "phone": "713-228-2385",
      "fax": null,
      "email": "fostersautomotive@inboxbear.com",
      "name": "Foster's Automotive Service",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Houston",
      "statename": "Texas"
   },
   "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": ""
}