Spruce Hill Financial LLC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 340283,
      "site_id": 87,
      "cat_id": 1,
      "priority": 2,
      "url": "https://www.sprucehillfinancialllc.com/",
      "title": "Spruce Hill Financial LLC",
      "description": "Each year, countless business ventures fall short of their financial goals because they don''t have the professional assistance they need. If you''re looking for a firm that''s committed to providing excellent services with excellent client support, Spruce Hill Financial LLC is here for you. We proudly offer extensive accounting and bookkeeping services that help free up your schedule while critical tasks and responsibilities are handled correctly.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 90980,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-01-07T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 0,
      "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": 6373,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "d0e637f1-ccc0-11ef-a909-b66e99367f32",
      "subdate": "Jan 07, 2025",
      "subcategory": "Accountant",
      "request_types": "",
      "visitcount": 5
   },
   "visits": {
      "storefront": 5,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 2,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-01-07 06:29:58"
   },
   "location": {
      "uuid": "d0e637f1-ccc0-11ef-a909-b66e99367f32",
      "link_id": 340283,
      "account_id": 90980,
      "company": "Spruce Hill Financial LLC",
      "sid": 87,
      "country": 277,
      "countrycode": "US",
      "state": 0,
      "city": "0",
      "zip": "",
      "address": "",
      "phone": "(517) 675-8976",
      "fax": null,
      "email": "sprucehillfina@mail-burst.com",
      "name": "Spruce Hill Financial LLC",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "",
      "statename": ""
   },
   "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": ""
}