Emerson Gutters and Drainage

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 326680,
      "site_id": 76,
      "cat_id": 11,
      "priority": 2,
      "url": "https://emersongutters.com/houston/",
      "title": "Emerson Gutters and Drainage",
      "description": "Emerson Gutters and Drainage of Houston has one goal in mind. To deliver the best service with the top products. We are experience in the installations and repairs of Gutters and Drainage. We offer anywhere from seamless gutters, which come in a 5 inch and 6 inch width, to custom rain gutters, and gutter guards along with full outdoor drainage solutions. French drain, Sump Pump, Channel Drain with other on the spot services needed.",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 77547,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2023-12-01T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 27,
      "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": 5955,
      "d_url": null,
      "approved": null,
      "logo_ext": null,
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "439e58c2-8ff7-11ee-8344-b66e99367f32",
      "subdate": "Dec 01, 2023",
      "subcategory": "Gutter Cleaning",
      "request_types": "",
      "visitcount": 61
   },
   "visits": {
      "storefront": 61,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 3,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "",
      "service1": "Gutter Installation",
      "service2": "Gutter repair",
      "service3": "Drainage solutions",
      "service4": "Gutter Replacement",
      "service5": "Gutter Guard Installation",
      "service6": "",
      "service7": "",
      "submit_dt": "2023-12-01 03:11:04"
   },
   "location": {
      "uuid": "439e58c2-8ff7-11ee-8344-b66e99367f32",
      "link_id": 326680,
      "account_id": 77547,
      "company": "Emerson Gutters and Drainage",
      "sid": 76,
      "country": 277,
      "countrycode": "US",
      "state": 42,
      "city": "21883",
      "zip": "77067",
      "address": "550 Greens Pkwy, 130",
      "phone": "",
      "fax": null,
      "email": "emersonhouston@brite-mail.com",
      "name": "Emerson Gutters and Drainage",
      "status": "show",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "29.9468273",
      "lon": "-95.4230022",
      "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": ""
}