Speir Innovations LLC

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 317156,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://www.speirinnovations.com/",
      "title": "Speir Innovations LLC",
      "description": "If you're interested in the solar panel experience Speir Innovations is the company you are looking for. Excellent customer service, honest and knowledgeable. \r\n",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 68354,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2019-06-01T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 530,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 42,
      "city_id": 22273,
      "ltop": "",
      "facebook": "https://www.facebook.com/speirinno/",
      "tiktok": null,
      "linkedin": "https://www.linkedin.com/company/speir-innovations-llc/",
      "twitter": "https://twitter.com/SpeirInnovatio1",
      "googleplus": "https://goo.gl/maps/Fif8Ce4v1RD2",
      "youtube_channel": "https://www.youtube.com/channel/UCbVC8qP9MlSEMrujbuyxG5g",
      "youtube": "https://www.youtube.com/channel/UCbVC8qP9MlSEMrujbuyxG5g",
      "youtube_title": null,
      "pinterest": "",
      "yelp": "",
      "foursquare": "",
      "instagram": "https://www.instagram.com/speirinnovations/",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": "https://www.speirinnovations.com/blog/",
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 6499,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "956e38c8-56da-11ed-b77c-b66e99367f32",
      "subdate": "Jun 01, 2019",
      "subcategory": "Solar Energy",
      "request_types": "",
      "visitcount": 652
   },
   "visits": {
      "storefront": 652,
      "articles": 0,
      "videos": 100,
      "reviews": 17,
      "coupons": 0,
      "products": 0,
      "social": 10,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Speir Innovations is a rising sustainability company based in Austin, Texas.  We were established by a group of close friends dedicated to the sustainability movement who shared the common goal of contributing to the progress and development of sustainable practices.  With prior experience in the solar industry and education in sustainable sciences, the founders of Speir Innovations formed a company in which the primary goal is to improve the quality of living by increasing the long-term implementation of sustainable practices. for more visit: https://www.speirinnovations.com",
      "service1": "Artificial Grass",
      "service2": "Solar",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2019-06-01 09:47:28"
   },
   "location": {
      "uuid": "956e38c8-56da-11ed-b77c-b66e99367f32",
      "link_id": 317156,
      "account_id": 68354,
      "company": "Speir Innovations LLC",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "22273",
      "zip": "78212",
      "address": "5327 McCullough Avenue",
      "phone": "512-537-6527",
      "fax": null,
      "email": "speirinnovationstx@gmail.com",
      "name": "Speir Innovations LLC",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "29.480099",
      "lon": "-98.492183",
      "cityname": "Olmos Park",
      "statename": "Texas"
   },
   "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": 1
      },
      {
         "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": ""
}