Business Website:

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 348321,
      "site_id": 7,
      "cat_id": 70,
      "priority": 2,
      "url": "https://agents.allstate.com/richard-oconnor-saint-johns-fl.html?utm_source=GMB&utm_medium=Website",
      "title": "Business Website: ",
      "description": "I’ve gotten to know many local families as an Allstate agent in Saint Johns. I enjoy being a part of the community, and building local relationships is one of the best parts of my job. I look forward to getting to know you and helping you to find the solutions that meet your needs.I’m committed to helping Saint Johns residents assess their immediate and long-term needs and choose options that will help them achieve their goals. When you want to explore options for protecting your home, personal property, or financial future, I’m available to answer your questions. If you’re already a customer, I’m ready to review your coverage so that you can make any necessary adjustments to fit your changing needs. \r\n",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 99016,
      "approve_dt": "2025-07-14T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-06-07T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 3,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 9,
      "city_id": 0,
      "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": 28,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "f2e9219f-4376-11f0-a909-b66e99367f32",
      "subdate": "Jun 07, 2025",
      "subcategory": "Health Insurance",
      "request_types": "",
      "visitcount": 43
   },
   "visits": {
      "storefront": 43,
      "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": "Ive gotten to know many local families as an Allstate agent in Saint Johns. I enjoy being a part of the community, and building local relationships is one of the best parts of my job. I look forward to getting to know you and helping you to find the solutions that meet your needs.Im committed to helping Saint Johns residents assess their immediate and long-term needs and choose options that will help them achieve their goals. When you want to explore options for protecting your home, personal property, or financial future, Im available to answer your questions. If youre already a customer, Im ready to review your coverage so that you can make any necessary adjustments to fit your changing needs. \r
",
      "service1": "Auto Insurance",
      "service2": "Home Insurance",
      "service3": "Homeowners Insurance",
      "service4": "Life Insurance",
      "service5": "Renters Insurance",
      "service6": "Condo Insurance",
      "service7": "",
      "submit_dt": "2025-06-07 08:11:01"
   },
   "location": {
      "uuid": "f2e9219f-4376-11f0-a909-b66e99367f32",
      "link_id": 348321,
      "account_id": 99016,
      "company": "Richard OConnor: Allstate Insurance",
      "sid": 7,
      "country": 277,
      "countrycode": "US",
      "state": 9,
      "city": "",
      "zip": "32259",
      "address": "1631 Race Track Rd, STE 206, St Johns",
      "phone": "904-292-0102",
      "fax": null,
      "email": "richardoconnorsaintjohns@outlook.com",
      "name": "Richard OConnor: Allstate Insurance",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "30.1220645",
      "lon": "-81.6218216"
   },
   "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": ""
}