TSI Roofing

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 338806,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://tsi-roofing.com/",
      "title": "TSI Roofing",
      "description": "",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 89517,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-12-05T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 8,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 42,
      "city_id": 21883,
      "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": 5879,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "b0c84383-b2df-11ef-a909-b66e99367f32",
      "subdate": "Dec 05, 2024",
      "subcategory": "Roofing Contractors",
      "request_types": "",
      "visitcount": 30
   },
   "visits": {
      "storefront": 30,
      "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": "Over 15 years of extensive experience in commercial and residential roofing, our company prioritizes effective communication, meticulous logistics, and the delivery of exceptional finished products. These core principles have consistently set us apart in the industry, ensuring successful project and utmost satisfaction for our customers.",
      "service1": "Commercial Roofing",
      "service2": "TPO Roofing",
      "service3": "Commerical Roof Repairs",
      "service4": "Roof Inspection",
      "service5": "Roof Replacement",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-12-05 08:05:28"
   },
   "location": {
      "uuid": "b0c84383-b2df-11ef-a909-b66e99367f32",
      "link_id": 338806,
      "account_id": 89517,
      "company": "TSI Roofing",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "21883",
      "zip": "77027-2902",
      "address": "4212 San Felipe St",
      "phone": "(281) 801-5512",
      "fax": null,
      "email": "tsiroofing@burst-email.com",
      "name": "TSI Roofing",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "29.7470306",
      "lon": "-95.4494026",
      "cityname": "Houston",
      "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": 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": ""
}