Foam Insulation Company

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 350142,
      "site_id": 6,
      "cat_id": 39,
      "priority": 0,
      "url": "https://www.ficsprayfoam.com",
      "title": "Foam Insulation Company",
      "description": "We specialize in providing top-notch spray foam insulation solutions for both residential and commercial properties across North Carolina and South Carolina.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 100837,
      "approve_dt": "2025-09-24T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-09-24T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 0,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 39,
      "city_id": 20491,
      "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": 5732,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "1cbd9875-98ed-11f0-bb42-b66e99367f32",
      "subdate": "Sep 24, 2025",
      "subcategory": "Business Services",
      "request_types": "",
      "visitcount": 29
   },
   "visits": {
      "storefront": 29,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "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": "Since 2001, we have been proudly locally owned and operated, ensuring you always do business directly with our dedicated team. Unlike other companies that rely on contract workers, all our staff are full-time employees, allowing us to maintain the highest quality standards. Our commitment to your complete satisfaction extends months and even years after installation. We aim to reduce dependence on foreign energy, enhance indoor air quality in our community, and provide the most professional insulation services in the area. By understanding your needs and offering only the highest quality products, we achieve these goals. As an innovative insulation installer, we use the latest products and techniques to ensure superior energy performance. We diligently research independent studies and government reports on energy and health issues related to our industry. This commitment ensures we offer the safest, healthiest, and highest performing insulation systems available today.",
      "service1": "Commercial",
      "service2": "Residential",
      "service3": "Blown-In",
      "service4": "Fiberglass",
      "service5": "Spray Foam",
      "service6": "Insulation",
      "service7": "",
      "submit_dt": "2025-09-24 02:21:00"
   },
   "location": {
      "uuid": "1cbd9875-98ed-11f0-bb42-b66e99367f32",
      "link_id": 350142,
      "account_id": 100837,
      "company": "Aksel Wagner",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 39,
      "city": "20491",
      "zip": "29302",
      "address": "2991 South Pine St",
      "phone": "8885833626",
      "fax": null,
      "email": "info@ficsprayfoam.com",
      "name": "Foam Insulation Company",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": null,
      "lon": null,
      "cityname": "Spartanburg",
      "statename": "South Carolina"
   },
   "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": ""
}