Associated Pilot Cars

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 350027,
      "site_id": 26,
      "cat_id": 5,
      "priority": 0,
      "url": "https://associatedpilotcars.com",
      "title": "Associated Pilot Cars",
      "description": "Associated Pilot Cars is a professional pilot car service company based in Phoenix, AZ, specializing in safe and timely escort services for oversized loads and specialized deliveries. With comprehensive resources and expertise in logistics coordination, the company is dedicated to handling complex transportation needs while maintaining the highest standards of professionalism and punctuality. Associated Pilot Cars strives to exceed client expectations by providing reliable escort services that ensure safe passage for oversized cargo throughout Arizona and beyond.\n",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 100722,
      "approve_dt": "2025-09-12T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-09-10T00: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": 3,
      "city_id": 990,
      "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": 1669,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "0c12d9e1-8e35-11f0-bb42-b66e99367f32",
      "subdate": "Sep 10, 2025",
      "subcategory": "Truck Parts",
      "request_types": "",
      "visitcount": 34
   },
   "visits": {
      "storefront": 34,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 20,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "If you are in need of a pilot cars service in Phoenix, AZ, call on Associated Pilot Cars. We have all the resources to handle your delivery needs professionally and on-time. We specialize in oversize loads, logistics, truck delivery, and much more. We strive to exceed our clients expectations to ensure they are satisfied. For a great service in Phoenix, AZ, call on Associated Pilot Cars.",
      "service1": "Pilot car escort services",
      "service2": " Oversize load coordination",
      "service3": " Logistics management",
      "service4": " Truck delivery escort",
      "service5": " Wide load piloting",
      "service6": " Route planning assistance",
      "service7": " Transportation safety services",
      "submit_dt": "2025-09-10 10:58:13"
   },
   "location": {
      "uuid": "0c12d9e1-8e35-11f0-bb42-b66e99367f32",
      "link_id": 350027,
      "account_id": 100722,
      "company": "Associated Pilot Cars ",
      "sid": 26,
      "country": 277,
      "countrycode": "US",
      "state": 3,
      "city": "990",
      "zip": "85086",
      "address": "41003 N Citrus Canyon Trail",
      "phone": "623-518-4794",
      "fax": null,
      "email": "associatedpilotcarsaz@inboxbear.com",
      "name": "Associated Pilot Cars",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Phoenix",
      "statename": "Arizona"
   },
   "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": ""
}