H2 Real Estate

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 317105,
      "site_id": 24,
      "cat_id": 80,
      "priority": 2,
      "url": "http://www.h2realestate.com",
      "title": "H2 Real Estate ",
      "description": "",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 68302,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2019-05-29T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 173,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 1,
      "city_id": 42,
      "ltop": "",
      "facebook": "http://facebook.com/h2realestate",
      "tiktok": null,
      "linkedin": "https://www.linkedin.com/company/h2-real-estate-birmingham",
      "twitter": "http://twitter.com/h2_realestate",
      "googleplus": "",
      "youtube_channel": null,
      "youtube": "https://www.youtube.com/channel/UC8SzwUI1m7IuJOS7ha6ZlOw",
      "youtube_title": null,
      "pinterest": "https://www.pinterest.com/h2realestate/",
      "yelp": "",
      "foursquare": "",
      "instagram": "https://www.instagram.com/h2realestate/",
      "tripadvisor": null,
      "trustpilot": null,
      "blog_link": null,
      "ss_exchange": 0,
      "googlebot": null,
      "yahoobot": null,
      "msnbot": null,
      "author_id": null,
      "subcat_id": 1433,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "956df0b5-56da-11ed-b77c-b66e99367f32",
      "subdate": "May 29, 2019",
      "subcategory": "Real Estate Agents",
      "request_types": "",
      "visitcount": 253
   },
   "visits": {
      "storefront": 253,
      "articles": 0,
      "videos": 0,
      "reviews": 2,
      "coupons": 0,
      "products": 0,
      "social": 4,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "A home is more than a house. It is people. It is places. It is stories.\r\nH2 Real Estate understands this and wants to find you the perfect home in Birmingham. Whether you are a recent college graduate looking for your first apartment or a family of four searching for a great historic home, we want to help.\r\nWe are locals who live, work, and play in Birmingham. We are passionate about this city and all it has to offer. Birmingham has an exciting future ahead of it, and we canu2019t wait for you to be a part of it!\r\nAre you ready? ",
      "service1": "Apartment Building",
      "service2": "Custom Home Builder",
      "service3": "Real Estate Agency",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2019-05-29 06:52:47"
   },
   "location": {
      "uuid": "956df0b5-56da-11ed-b77c-b66e99367f32",
      "link_id": 317105,
      "account_id": 68302,
      "company": "H2 Real Estate ",
      "sid": 24,
      "country": 277,
      "countrycode": "US",
      "state": 1,
      "city": "42",
      "zip": "35203",
      "address": "2012 1st Ave N",
      "phone": "(205) 583-5007",
      "fax": null,
      "email": "alh2realestate@gmail.com",
      "name": "H2 Real Estate ",
      "status": "hide",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "22.845641",
      "lon": "89.5403279",
      "cityname": "Birmingham",
      "statename": "Alabama"
   },
   "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": ""
}