Fairfield Subaru

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 345450,
      "site_id": 26,
      "cat_id": 5,
      "priority": 2,
      "url": "http://www.fairfieldsubaru.com/",
      "title": "Fairfield Subaru",
      "description": "Fairfield Subaru has proudly served Solano and Yolo counties for decades, offering a seamless and transparent car-buying experience. As a One True Price dealership, we provide upfront pricing and a dedicated consultant to guide you through every step. Whether you''re financing a new Subaru or need expert service, our team is here to help. Enjoy Subaru loaner cars, access to genuine parts, and our Subaru Love Encore Program. With over 20 years of commitment to customer satisfaction and community support, Fairfield Subaru ensures a stress-free experience.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 96145,
      "approve_dt": "2025-10-04T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-04-16T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 5,
      "city_id": 1928,
      "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": 1609,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "7123daa5-1aa1-11f0-a909-b66e99367f32",
      "subdate": "Apr 16, 2025",
      "subcategory": "Car Accessories",
      "request_types": "",
      "visitcount": 25
   },
   "visits": {
      "storefront": 25,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 3,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Fairfield Subaru is your trusted automotive home in Fairfield, CA, serving Vacaville, Suisun City, and Davis with a stress-free, friendly car-buying experience. We offer an extensive selection of new Subaru models and reliable pre-owned vehicles, backed by exceptional customer service, competitive pricing, and expert vehicle care to ensure a smooth, transparent, and enjoyable experience from your first visit to every mile ahead.",
      "service1": "new Subaru sales",
      "service2": " pre-owned vehicle sales",
      "service3": " certified pre-owned vehicles",
      "service4": " Subaru leasing",
      "service5": " vehicle financing",
      "service6": " automotive service and repair",
      "service7": " trade-in evaluations",
      "submit_dt": "2025-04-16 09:01:53"
   },
   "location": {
      "uuid": "7123daa5-1aa1-11f0-a909-b66e99367f32",
      "link_id": 345450,
      "account_id": 96145,
      "company": "Fairfield Subaru",
      "sid": 26,
      "country": 277,
      "countrycode": "US",
      "state": 5,
      "city": "1928",
      "zip": "94534",
      "address": "2525 Martin Road, Fairfield, CA 94534 USA",
      "phone": "707-639-9073",
      "fax": null,
      "email": "fairfieldsubaru2@gmail.com",
      "name": "Fairfield Subaru",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "38.2762856",
      "lon": "-122.0487384",
      "cityname": "Fairfield",
      "statename": "California"
   },
   "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": ""
}