Richard OConnor: Allstate Insurance

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 345937,
      "site_id": 7,
      "cat_id": 70,
      "priority": 2,
      "url": "https://agents.allstate.com/richard-oconnor-saint-augustine-fl.html",
      "title": "Richard OConnor: Allstate Insurance",
      "description": "Richard O'Connor is an experienced Allstate insurance agent serving the Jacksonville and St. Augustine communities since 2006, after previously working as an independent agent. A family man with three sons (two of whom work in the agency), Richard is deeply involved in local sports programs and community activities. When not helping clients protect their loved ones and assets, he enjoys outdoor activities like hunting, fishing, and golfing at his St. Augustine river house.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 96632,
      "approve_dt": "2025-08-20T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-04-25T00: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": 3929,
      "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": 29,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "e5cd558a-21ab-11f0-a909-b66e99367f32",
      "subdate": "Apr 25, 2025",
      "subcategory": "Home Insurance",
      "request_types": "",
      "visitcount": 19
   },
   "visits": {
      "storefront": 19,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 8,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Established in 2006, Richard OConnor's Allstate Insurance Agency is a trusted insurance agency in St. Augustine and Jacksonville, Florida. They offer a variety of insurance products, including auto, home, life, renters, and motorcycle insurance, to help you protect what matters most.\r
",
      "service1": "Auto Insurance",
      "service2": "Car Insurance",
      "service3": "Home Insurance",
      "service4": "Homeowners Insurance",
      "service5": "Life Insurance",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-04-25 08:04:22"
   },
   "location": {
      "uuid": "e5cd558a-21ab-11f0-a909-b66e99367f32",
      "link_id": 345937,
      "account_id": 96632,
      "company": "Richard OConnor: Allstate Insurance",
      "sid": 7,
      "country": 277,
      "countrycode": "US",
      "state": 9,
      "city": "3929",
      "zip": "32092",
      "address": "157 Hampton Point Dr, STE 2",
      "phone": "904-288-8821",
      "fax": null,
      "email": "richardoconnorallstate@outlook.com",
      "name": "Richard OConnor: Allstate Insurance",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "30.0559849",
      "lon": "-81.5389865",
      "cityname": "St. Augustine",
      "statename": "Florida"
   },
   "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": ""
}