Skyline Roofing & Construction

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 331240,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://skylineroofservices.com/",
      "title": "Skyline Roofing & Construction",
      "description": "Skyline Roofing & Construction is a premier provider of roofing and construction services, proudly serving Houston, Sugar Land, Woodlands, Cypress, Katy, and surrounding areas. Specializing in the installation, repair, and replacement of roofs, our dedicated team ensures meticulous attention to detail, using only top-quality materials to guarantee lasting durability and aesthetic appeal. Our expertise extends beyond roofing, encompassing a range of construction services such as gutters, fencing.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 82039,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-05-28T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 15,
      "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": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "560fc295-1d12-11ef-8344-b66e99367f32",
      "subdate": "May 28, 2024",
      "subcategory": "Roofing Contractors",
      "request_types": "",
      "visitcount": 41
   },
   "visits": {
      "storefront": 41,
      "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": "Roof repair",
      "service2": "roof replacement",
      "service3": "roof installation",
      "service4": "gutter installation",
      "service5": "siding installation",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-05-28 16:50:06"
   },
   "location": {
      "uuid": "560fc295-1d12-11ef-8344-b66e99367f32",
      "link_id": 331240,
      "account_id": 82039,
      "company": "Skyline Roofing & Construction",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "21883",
      "zip": "77018",
      "address": "1011 W 34th St, #436",
      "phone": "713-597-2587",
      "fax": null,
      "email": "skylineroof@brite-mail.com",
      "name": "Skyline Roofing & Construction",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "29.8170824",
      "lon": "-95.4184197",
      "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": ""
}