Watertight Roofing and Exteriors

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 323983,
      "site_id": 24,
      "cat_id": 80,
      "priority": 2,
      "url": "https://www.watertightroofingindy.com",
      "title": "Watertight Roofing and Exteriors",
      "description": "",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 75027,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2023-01-24T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 45,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 14,
      "city_id": 25395,
      "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": 1435,
      "d_url": null,
      "approved": null,
      "logo_ext": "com",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "31fd629f-9bdb-11ed-b5b4-b66e99367f32",
      "subdate": "Jan 24, 2023",
      "subcategory": "Real Estate Companies",
      "request_types": "",
      "visitcount": 72
   },
   "visits": {
      "storefront": 72,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 5,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Watertight Roofing and Exteriors (formally House Mechanics) is one of the highest rated roofing companies in Indianapolis. With over 90 years of experience, they are one of the ONLY roofing companies to offer a lifetime labor warranty on any job they complete. Watertight uses patented methods to ensure that your roof lasts and that the job is done right. Schedule your free quote today!",
      "service1": "RoofWarranty",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2023-01-24 11:35:25"
   },
   "location": {
      "uuid": "31fd629f-9bdb-11ed-b5b4-b66e99367f32",
      "link_id": 323983,
      "account_id": 75027,
      "company": "Watertight Roofing and Exteriors",
      "sid": 24,
      "country": 277,
      "countrycode": "US",
      "state": 14,
      "city": "25395",
      "zip": "46204",
      "address": "120 E Market St Suite 1253",
      "phone": "317-248-3704",
      "fax": null,
      "email": "watertightroofingindy0@gmail.com",
      "name": "Watertight Roofing and Exteriors",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "39.7687611",
      "lon": "-86.1555162",
      "cityname": "Indianapolis",
      "statename": "Indiana"
   },
   "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": ""
}