Costello Roofing

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 314928,
      "site_id": 67,
      "cat_id": 81,
      "priority": 2,
      "url": "http://costelloroofings.com/",
      "title": "Costello Roofing",
      "description": "One of the reputed roof repair and installation service company in USA, Texas. Costello roofing is specialized in all types of roofing services, be it, re-installations of roofs, leak roof repairs, roof maintenance, etc. We also do chimney repair services as well.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 66147,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2018-04-25T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 117,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 42,
      "city_id": 0,
      "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": 5046,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "95631515-56da-11ed-b77c-b66e99367f32",
      "subdate": "Apr 25, 2018",
      "subcategory": "Roofing",
      "request_types": "",
      "visitcount": 163
   },
   "visits": {
      "storefront": 163,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 8,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "We here at Costello Roofing offer homeowners in Texas, or Greater Houston area quality roof solutions.  It is your home roof, which protects you from natureu2019s fury. Therefore, you certainly need to stress on the best options in the roof segment. We have been working on roofs for ages now and understand everything about this trade.",
      "service1": "leak roof repair service",
      "service2": "roof installations",
      "service3": "roof repair service",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2018-04-25 11:14:28"
   },
   "location": {
      "uuid": "95631515-56da-11ed-b77c-b66e99367f32",
      "link_id": 314928,
      "account_id": 66147,
      "company": "Costello Roofing",
      "sid": 67,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "0",
      "zip": "77082",
      "address": " 13026 Richmond Ave, Houston, TX 77082, USA",
      "phone": "",
      "fax": null,
      "email": "costelloroofings@gmail.com",
      "name": "Costello Roofing",
      "status": "",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "29.7282689",
      "lon": "-95.6174788",
      "cityname": "",
      "statename": ""
   },
   "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": ""
}