Ed Underwood - State Farm Insurance Agent

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 349659,
      "site_id": 7,
      "cat_id": 70,
      "priority": 0,
      "url": "https://www.statefarm.com/agent/us/tn/franklin/ed-underwood-qzzcj1ys000",
      "title": "Ed Underwood - State Farm Insurance Agent",
      "description": "I have lived in Franklin, Tennessee my entire life and pursued a Bachelor's degree in Business Administration at MTSU. I furthered my education by obtaining a Master's degree in Business Administration from The University of Tennessee. With over 40 years of experience as a State Farm Agent, I take pleasure in helping families who are moving to the Franklin, Brentwood, Nashville, and Spring Hill areas.\n",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 100354,
      "approve_dt": "2025-08-07T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-08-01T00: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": 41,
      "city_id": 21018,
      "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": 27,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "853f73c4-6ebd-11f0-bb42-b66e99367f32",
      "subdate": "Aug 01, 2025",
      "subcategory": "Car Insurance",
      "request_types": "",
      "visitcount": 45
   },
   "visits": {
      "storefront": 45,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 30,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "A seasoned State Farm agent with over 38 years of experience and advanced business degrees, serving Franklin and Middle Tennessee. Specializing in insurance and financial services for residents and those relocating to the Nashville area, with a convenient downtown Franklin location.",
      "service1": "auto insurance",
      "service2": " home insurance",
      "service3": " life insurance",
      "service4": " business insurance",
      "service5": " renters insurance",
      "service6": " financial services",
      "service7": " claims processing",
      "submit_dt": "2025-08-01 09:54:31"
   },
   "location": {
      "uuid": "853f73c4-6ebd-11f0-bb42-b66e99367f32",
      "link_id": 349659,
      "account_id": 100354,
      "company": "Ed Underwood Ed Underwood",
      "sid": 7,
      "country": 277,
      "countrycode": "US",
      "state": 41,
      "city": "21018",
      "zip": "37064",
      "address": "115 5th Ave N",
      "phone": "615-771-0700",
      "fax": null,
      "email": "edunderwoodstatefarm@outlook.com",
      "name": "Ed Underwood - State Farm Insurance Agent",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Forest Hills",
      "statename": "Tennessee"
   },
   "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": ""
}