Highstreet Insurance & Financial Services

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 337177,
      "site_id": 7,
      "cat_id": 70,
      "priority": 2,
      "url": "https://www.hsip.com/kennewick?state=WA&city=Kennewick-West-Tucannon-Ave",
      "title": "Highstreet Insurance & Financial Services",
      "description": "Highstreet Kennewick, previously JPI Insurance Solutions, is a premier insurance agency serving Kennewick, Richland, Pasco and the surrounding areas. Offering a full suite of insurance solutions, including auto, home, life, and health for individuals, plus extensive coverage options for businesses from leading carriers like Progressive, Safeco, Travelers, and Liberty Mutual. Now part of a vast national network, Highstreet boasts over 150 locations across 31 states, delivering unparalleled service and expertise to its clients.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 87908,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-10-23T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 7,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 46,
      "city_id": 23731,
      "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": 56,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "74667070-912f-11ef-ab46-b66e99367f32",
      "subdate": "Oct 23, 2024",
      "subcategory": "Insurance Company",
      "request_types": "",
      "visitcount": 66
   },
   "visits": {
      "storefront": 66,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 14,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "",
      "service1": "Personal Insurance",
      "service2": "Health Insurance",
      "service3": "Life",
      "service4": "Commercial Insurance",
      "service5": "Employee Benefits",
      "service6": "Auto Insurance,",
      "service7": "Homeowners Insurance",
      "submit_dt": "2024-10-23 11:10:48"
   },
   "location": {
      "uuid": "74667070-912f-11ef-ab46-b66e99367f32",
      "link_id": 337177,
      "account_id": 87908,
      "company": "Highstreet Insurance & Financial Services",
      "sid": 7,
      "country": 277,
      "countrycode": "US",
      "state": 46,
      "city": "23731",
      "zip": "99336",
      "address": "8927 West Tucannon Avenue, Suite 201",
      "phone": "(509) 736-3599",
      "fax": null,
      "email": "joepeterson@mail-burst.com",
      "name": "Highstreet Insurance & Financial Services",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "46.2254759",
      "lon": "-119.2422184",
      "cityname": "Kennewick",
      "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": ""
}