Sellers Roofing Company - New Brighton

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 328922,
      "site_id": 67,
      "cat_id": 81,
      "priority": 2,
      "url": "https://www.roofingexpertsstpaul.com/",
      "title": "Sellers Roofing Company - New Brighton",
      "description": "At our core, we are a dedicated team of professionals specializing in both commercial and residential roofing services, with a keen focus on hail damage roof repair and full roof replacements. Our mission is to ensure that every customer receives unparalleled service, reflecting our commitment to excellence in every project we undertake. What sets us apart is not just our technical expertise but our unwavering commitment to customer satisfaction.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 79747,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-03-06T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 11,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 23,
      "city_id": 11331,
      "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": 5103,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "80dba4ea-db6d-11ee-8344-b66e99367f32",
      "subdate": "Mar 06, 2024",
      "subcategory": "Roofers",
      "request_types": "",
      "visitcount": 43
   },
   "visits": {
      "storefront": 43,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 14,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "",
      "service1": "Residential Roof Replacement",
      "service2": "Residential Roof Repairs",
      "service3": "Storm & Hail Damage Roofing",
      "service4": "Commercial roofing Repairs",
      "service5": "commercial roofing replacement",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-03-06 03:56:25"
   },
   "location": {
      "uuid": "80dba4ea-db6d-11ee-8344-b66e99367f32",
      "link_id": 328922,
      "account_id": 79747,
      "company": "",
      "sid": 67,
      "country": 277,
      "countrycode": "US",
      "state": 23,
      "city": "11331",
      "zip": "55112",
      "address": "366 New Brighton Rd",
      "phone": "+1 651-703-2336",
      "fax": null,
      "email": "roofingexpertsstpaul@mail-burst.com",
      "name": "Sellers Roofing Company - New Brighton",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "45.0436099",
      "lon": "-93.1830528",
      "cityname": "New Brighton",
      "statename": "Minnesota"
   },
   "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": ""
}