J.F. Baker's Sons Roofing Company

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 314694,
      "site_id": 67,
      "cat_id": 81,
      "priority": 2,
      "url": "http://jfbakerroofing.com",
      "title": "J.F. Baker's Sons Roofing Company",
      "description": "Count on JF Baker Roofing, roofing specialists in Columbus, OH to bring the best roofing services and the most reliable products for your money. We are the company for your total roofing repair and installation needs! Call at 614-291-4243 for free professional estimates & damage inspection!",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 65920,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2018-03-26T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 114,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 34,
      "city_id": 16903,
      "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": 5053,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9561bfb7-56da-11ed-b77c-b66e99367f32",
      "subdate": "Mar 26, 2018",
      "subcategory": "Roofing Company",
      "request_types": "",
      "visitcount": 135
   },
   "visits": {
      "storefront": 135,
      "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": "Count on JF Baker Roofing, roofing specialists in Columbus, OH to bring the best roofing services and the most reliable products for your money. We are the company for your total roofing repair and installation needs! Call at 614-291-4243 for free professional estimates & damage inspection!",
      "service1": "Roofing",
      "service2": " Residential Roofing",
      "service3": " Commercial Roofing",
      "service4": " Roofing Specialists",
      "service5": " Roofing Services",
      "service6": " Roof Repair",
      "service7": " Roof Installation",
      "submit_dt": "2018-03-26 09:59:33"
   },
   "location": {
      "uuid": "9561bfb7-56da-11ed-b77c-b66e99367f32",
      "link_id": 314694,
      "account_id": 65920,
      "company": "JF Baker Roofing",
      "sid": 67,
      "country": 277,
      "countrycode": "US",
      "state": 34,
      "city": "16903",
      "zip": "43212",
      "address": "1496 Delashmut Avenue",
      "phone": "",
      "fax": null,
      "email": "jfbakerroofing@yahoo.com",
      "name": "JF Baker Roofing",
      "status": "",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "39.9901009",
      "lon": "-83.0298649",
      "cityname": "Columbus",
      "statename": "Ohio"
   },
   "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": ""
}