Oahu Painting Contractors

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 319707,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "http://www.oahuinteriorpainting.com/",
      "title": "Oahu Painting Contractors",
      "description": "",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 70901,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2020-08-28T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 163,
      "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": 5732,
      "d_url": null,
      "approved": null,
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "957bc1d5-56da-11ed-b77c-b66e99367f32",
      "subdate": "Aug 28, 2020",
      "subcategory": "Business Services",
      "request_types": "",
      "visitcount": 230
   },
   "visits": {
      "storefront": 230,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 15,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Oahu Painting Contractors is known for our superior work ethic and ability to perfect each project we work on. We operate out of Honolulu and service all areas of Oahu. Not only do we provide painting services, but we also do general home improvements. Another service we provide is our high-quality granite and quartz countertop installations. Feel free to call us so we can get your home or business the fresh new paint project it needs today. It could be just the new and refreshing energy you are looking for. We also provide Low VOC paints because we care about staying eco-friendly.",
      "service1": "painting contractors",
      "service2": "Honolulu house painters",
      "service3": "Oahu painting contractor",
      "service4": "painter",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2020-08-28 13:15:32"
   },
   "location": {
      "uuid": "957bc1d5-56da-11ed-b77c-b66e99367f32",
      "link_id": 319707,
      "account_id": 70901,
      "company": "Oahu Painting Contractors",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 11,
      "city": "4763",
      "zip": "96860",
      "address": "1470 Pierce St.",
      "phone": "808-400-9996",
      "fax": null,
      "email": "oahuinteriorpaintinghawaii@outlook.com",
      "name": "Oahu Painting Contractors",
      "status": "hide",
      "start_dt": "2024-08-08T00:00:00.000Z",
      "end_dt": "2124-08-08T00:00:00.000Z",
      "lat": "21.3568808",
      "lon": "-157.9404529",
      "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": ""
}