{
"vendor": "all",
"sociallist": [],
"listing": {
"link_id": 340049,
"site_id": 7,
"cat_id": 70,
"priority": 2,
"url": "https://www.johnsoninsurance.info/?cmpid=vaf2c6_blm_0001",
"title": "",
"description": "",
"keywords": null,
"status": "0",
"affiliate_id": 0,
"cust_id": 90750,
"approve_dt": "2025-11-24T00:00:00.000Z",
"source": null,
"submit_dt": "2025-01-03T00: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": 3,
"city_id": 990,
"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": {
"type": "Buffer",
"data": [
49
]
},
"logo_ext": null,
"screen_ext": "png",
"pack_id": null,
"uuid": "52224dfa-c978-11ef-a909-b66e99367f32",
"subdate": "Jan 03, 2025",
"subcategory": "Insurance Company",
"request_types": "",
"visitcount": 33
},
"visits": {
"storefront": 33,
"articles": 0,
"videos": 0,
"reviews": 0,
"coupons": 0,
"products": 0,
"social": 13,
"services": 0,
"article_externals": 0,
"video_externals": 0,
"coupon_externals": 0,
"product_externals": 0,
"service_externals": 0
},
"services": {
"service_description": "Like a Good Neighbor, our mission at State Farm Johnson Insurance Inc. has always been to secure, insure, and build the insurance and financial future of the families, communities, and businesses we serve in the wonderful state of Arizona. We have a team of experienced and dedicated professionals committed to providing the highest level of service to all the members of our shared community. License #: AZ-18047152",
"service1": "",
"service2": "",
"service3": "",
"service4": "",
"service5": "",
"service6": "",
"service7": "",
"submit_dt": "2025-01-03 02:13:28"
},
"location": {
"uuid": "52224dfa-c978-11ef-a909-b66e99367f32",
"link_id": 340049,
"account_id": 90750,
"company": "Ajamu Johnson - State Farm Insurance Agent",
"sid": 7,
"country": 277,
"countrycode": "US",
"state": 3,
"city": "990",
"zip": "85009-2605",
"address": "2746 W McDowell Rd",
"phone": "(480) 426-8079",
"fax": null,
"email": "ajamujohnson@mail-burst.com",
"name": "Ajamu Johnson - State Farm Insurance Agent",
"status": "show",
"start_dt": null,
"end_dt": null,
"lat": "33.4662546",
"lon": "-112.1191059",
"cityname": "Phoenix",
"statename": "Arizona"
},
"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": ""
}
all our featured social media
