{
"vendor": "all",
"sociallist": [],
"listing": {
"link_id": 345913,
"site_id": 87,
"cat_id": 1,
"priority": 2,
"url": "https://www.esshakicpa.com/",
"title": "",
"description": "",
"keywords": null,
"status": "0",
"affiliate_id": 0,
"cust_id": 96608,
"approve_dt": null,
"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": 22,
"city_id": 10676,
"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": 6374,
"d_url": null,
"approved": null,
"logo_ext": "jpg",
"screen_ext": "png",
"pack_id": null,
"uuid": "8f9b4780-2179-11f0-a909-b66e99367f32",
"subdate": "Apr 25, 2025",
"subcategory": "Accounting",
"request_types": "",
"visitcount": 16
},
"visits": {
"storefront": 16,
"articles": 0,
"videos": 0,
"reviews": 0,
"coupons": 0,
"products": 0,
"social": 6,
"services": 0,
"article_externals": 0,
"video_externals": 0,
"coupon_externals": 0,
"product_externals": 0,
"service_externals": 0
},
"services": {
"service_description": "Whether you're the owner of medical practice or law firm, our office is here for you. We pair years of experience and extensive skills to offer you financial services ranging from bookkeeping support to business tax preparation. You can rest assured that our CPAs will treat you with professionalism and kindness, no matter what you service you need from us. Our team, depending on your needs, can meet with you monthly to review our progress and address any of your concerns.",
"service1": "tax resolution, accounting",
"service2": "tax preparer, tax consulting",
"service3": "tax preparation, tax help",
"service4": "individual taxes, business taxes",
"service5": "",
"service6": "",
"service7": "",
"submit_dt": "2025-04-25 02:04:03"
},
"location": {
"uuid": "8f9b4780-2179-11f0-a909-b66e99367f32",
"link_id": 345913,
"account_id": 96608,
"company": "Esshaki & Associates",
"sid": 87,
"country": 277,
"countrycode": "US",
"state": 22,
"city": "10676",
"zip": "48076",
"address": "20750 Civic Center Drive, Ste 120",
"phone": "+1 248-968-4700",
"fax": null,
"email": "esshakiassociates@burst-email.com",
"name": "Esshaki & Associates",
"status": "show",
"start_dt": null,
"end_dt": null,
"lat": "42.4819364",
"lon": "-83.2500153",
"cityname": "Southfield",
"statename": "Michigan"
},
"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
