Jake Sweeney Mazda Tri-County

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 351804,
      "site_id": 26,
      "cat_id": 5,
      "priority": 0,
      "url": "https://www.jakesweeneymazda.com/",
      "title": "Jake Sweeney Mazda Tri-County",
      "description": "Mazda dealership offering new and used Mazda vehicles, financing, service, and parts. Our Cincinnati Mazda dealership is proud to serve those in the Hamilton, Fairfield, West Chester and Mason areas. We pride ourselves in bringing these customers excellent customer service and meeting all of their automotive needs at competitive prices.\n\nOur dedication to our customers shows through our professional staff's commitment to keeping our customers satisfied and knowledgeable. We want to make sure that every person that comes in contact with our dealership is well informed on everything that they need. Our goal is for all of our potential customers to make automotive decisions that are intelligent and hassle-free. We're committed to ensuring you get the best possible price on your new vehicle. If you find the same model at a lower price elsewhere, we'll refund 100% of the difference. This promise is part of our dedication to making your car-buying experience straightforward and satisfying.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 102529,
      "approve_dt": "2026-02-22T00:00:00.000Z",
      "source": null,
      "submit_dt": "2026-02-19T00: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": 34,
      "city_id": 16884,
      "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": 1642,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "8272bcfa-0d6a-11f1-bb42-b66e99367f32",
      "subdate": "Feb 19, 2026",
      "subcategory": "Mazda Parts",
      "request_types": "",
      "visitcount": 0
   },
   "visits": {
      "storefront": 0,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 0,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Mazda dealership offering new and used Mazda vehicles, financing, service, and parts. Our Cincinnati Mazda dealership is proud to serve those in the Hamilton, Fairfield, West Chester and Mason areas. We pride ourselves in bringing these customers excellent customer service and meeting all of their automotive needs at competitive prices.\n\nOur dedication to our customers shows through our professional staff's commitment to keeping our customers satisfied and knowledgeable. We want to make sure that every person that comes in contact with our dealership is well informed on everything that they need. Our goal is for all of our potential customers to make automotive decisions that are intelligent and hassle-free. We're committed to ensuring you get the best possible price on your new vehicle. If you find the same model at a lower price elsewhere, we'll refund 100% of the difference. This promise is part of our dedication to making your car-buying experience straightforward and satisfying.",
      "service1": "Online Car Buying",
      "service2": "Delivery & Shipping",
      "service3": "Parts & Accessories",
      "service4": "Maintenance & Repair",
      "service5": "Vehicle Financing",
      "service6": "Certified Pre‑Owned Sales",
      "service7": "New Car Sales",
      "submit_dt": "2026-02-19 08:10:53"
   },
   "location": {
      "uuid": "8272bcfa-0d6a-11f1-bb42-b66e99367f32",
      "link_id": 351804,
      "account_id": 102529,
      "company": "Jake Sweeney Mazda Tri-County",
      "sid": 26,
      "country": 277,
      "countrycode": "US",
      "state": 34,
      "city": "16884",
      "zip": "45246",
      "address": "135 Northland Blvd",
      "phone": "513-782-1150",
      "fax": null,
      "email": "jakesweeney.mazda@outlook.com",
      "name": "Jake Sweeney Mazda Tri-County",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Cincinnati",
      "statename": "Ohio"
   },
   "socialmedia": [
      {
         "title": "Facebook",
         "ptype_id": 29,
         "dbtable": "links_socialmedia",
         "item": "Facebook",
         "cnt": null
      },
      {
         "title": "Instagram",
         "ptype_id": 30,
         "dbtable": "links_socialmedia",
         "item": "Instagram",
         "cnt": null
      },
      {
         "title": "Youtube",
         "ptype_id": 31,
         "dbtable": "links_socialmedia",
         "item": "Youtube Video",
         "cnt": null
      },
      {
         "title": "LinkedIn",
         "ptype_id": 32,
         "dbtable": "links_socialmedia",
         "item": "LinkedIn",
         "cnt": null
      },
      {
         "title": "TikTok",
         "ptype_id": 33,
         "dbtable": "links_socialmedia",
         "item": "TikTok",
         "cnt": null
      },
      {
         "title": "Twitter",
         "ptype_id": 34,
         "dbtable": "links_socialmedia",
         "item": "Twitter",
         "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": ""
}