Sterling Investment Advisor Arizona

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 309891,
      "site_id": 87,
      "cat_id": 39,
      "priority": 0,
      "url": "http://www.sterlinginvest.org/",
      "title": "Sterling Investment Advisor Arizona",
      "description": "Locating, selecting and trusting a financial advisor can be a difficult task, but at Sterling Investment Advisor we are a leader in the financial services industry because we take a personal, caring approach to business that starts with a face to face meeting between you and your financial advisor about how to meet your goals.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 61127,
      "approve_dt": "2015-07-08T00:00:00.000Z",
      "source": null,
      "submit_dt": "2015-07-07T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 1087,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 3,
      "city_id": 961,
      "ltop": "",
      "facebook": "https://www.facebook.com/sterlinginvestorg",
      "tiktok": "",
      "linkedin": "https://www.linkedin.com/company/sterling-investment",
      "twitter": "https://twitter.com/SterlingSII",
      "googleplus": "https://plus.google.com/+SterlinginvestOrg",
      "youtube_channel": "",
      "youtube": "https://www.youtube.com/c/SterlinginvestOrg",
      "youtube_title": "",
      "pinterest": "http://www.pinterest.com/sterlingadvisor/",
      "yelp": "http://www.yelp.com/biz/sterling-investment-advisor-mesa",
      "foursquare": "",
      "instagram": "http://instagram.com/sterlinginvestment/",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "",
      "ss_exchange": 0,
      "googlebot": 0,
      "yahoobot": 0,
      "msnbot": 0,
      "author_id": 0,
      "subcat_id": 282,
      "d_url": "",
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "954a60fe-56da-11ed-b77c-b66e99367f32",
      "subdate": "Jul 07, 2015",
      "subcategory": "Financial Services",
      "request_types": "",
      "visitcount": 1362
   },
   "visits": {
      "storefront": 1362,
      "articles": 0,
      "videos": 0,
      "reviews": 26,
      "coupons": 0,
      "products": 0,
      "social": 19,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "As a leader in the financing sector, we offer a broad spectrum of products and solutions which can be customized to meet our clients’ needs.\nOur team is comprised of highly seasoned financial services professionals. Our diversity and experience allow us to offer our clients the highest level of creativity, flexibility, and responsiveness.\nSince its founding, Sterling Investment has continuously expanded the scope and depth of its coverage and products all without compromising the standards of quality and customer service that drive its success. We provide clients access to the largest and most well respected companies in the financial industry.\nAt Sterling Investment Advisor, we will work closely with you to ensure your long-term strategies are tailored to meet your personal risk tolerance, investment timelines and most valued life goals. Whether you’re saving for your children’s education, buying a home, growing your business, or building a legacy for your family, there’s a solution to help you meet your needs.",
      "service1": "Financial Planning",
      "service2": " Financial Advisor",
      "service3": " Investment Advisor",
      "service4": " Education Savings",
      "service5": " Retirement Strategies",
      "service6": " Business Planning",
      "service7": " Estate Preservation",
      "submit_dt": "2015-07-07 12:44:41"
   },
   "location": {
      "uuid": "954a60fe-56da-11ed-b77c-b66e99367f32",
      "link_id": 309891,
      "account_id": 61127,
      "company": "Sterling Investment Advisor",
      "sid": 87,
      "country": 277,
      "countrycode": "US",
      "state": 3,
      "city": "961",
      "zip": "85209",
      "address": "2500 S Power Rd, Suite 217 ",
      "phone": "480-729-8000",
      "fax": "",
      "email": "sterlinginvestmentinc@gmail.com",
      "name": "Sterling Investment Advisor",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "33.3698037",
      "lon": "-111.6884761",
      "cityname": "Mesa",
      "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": ""
}