Oahu Military Real Estate

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 318544,
      "site_id": 24,
      "cat_id": 80,
      "priority": 2,
      "url": "http://www.oahumilitaryrealestate.com/",
      "title": "Oahu Military Real Estate",
      "description": "                                                                                                           \r\n                       \r\n                       \r\n                                    \r\nBusiness Hours: 24/7",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 69737,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2020-02-24T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 111,
      "referrals": null,
      "country": 277,
      "countrycode": "US",
      "loc_id": 277,
      "state_id": 11,
      "city_id": 4763,
      "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": 1433,
      "d_url": null,
      "approved": null,
      "logo_ext": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "9575ea04-56da-11ed-b77c-b66e99367f32",
      "subdate": "Feb 24, 2020",
      "subcategory": "Real Estate Agents",
      "request_types": "",
      "visitcount": 184
   },
   "visits": {
      "storefront": 184,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 8,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "We are the best resource for you to utilize your VA home loan benefit and find the perfect home to fit your needs. Whether you are a first time home buyer or a seasoned investor, this is the only site you will ever need!\r
\r
We have helped hundreds of active duty, prior service, retirees, and reservists utilize their VA home loan benefit here in Hawaii. Our goal is to be your go-to resource to make home ownership a simple and stress free process.",
      "service1": "Oahu Real Estate Agents",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2020-02-24 07:47:52"
   },
   "location": {
      "uuid": "9575ea04-56da-11ed-b77c-b66e99367f32",
      "link_id": 318544,
      "account_id": 69737,
      "company": "Oahu Military Real Estate",
      "sid": 24,
      "country": 277,
      "countrycode": "US",
      "state": 11,
      "city": "4763",
      "zip": "96816",
      "address": "614 Kapahulu Ave",
      "phone": "+1 808-554-9667",
      "fax": null,
      "email": "oahumilitaryrealestatehonolulu@gmail.com",
      "name": "Oahu Military Real Estate",
      "status": "hide",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "21.2787711",
      "lon": "-157.8141779",
      "cityname": "Honolulu",
      "statename": "Hawaii"
   },
   "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": ""
}