Ewa Moving Co.

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 341718,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://ewamoving.com/",
      "title": "Ewa Moving Co.",
      "description": "  ",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 92411,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2025-01-31T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 5,
      "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": 6129,
      "d_url": null,
      "approved": null,
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "21e0c59d-df76-11ef-a909-b66e99367f32",
      "subdate": "Jan 31, 2025",
      "subcategory": "Movers",
      "request_types": "",
      "visitcount": 39
   },
   "visits": {
      "storefront": 39,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 11,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Aloha! Ewa Moving Co. is a trusted Honolulu moving company, offering expert services to residents across Oahu. As experienced residential movers, we handle everything from local moving to large relocations with care and precision. Whether you need assistance with packing, transporting, or unpacking, our team of professional Honolulu movers is here to help. Serving the community with top-quality moving services, we make every move smooth and efficient. Mahalo!",
      "service1": "Residential Moving",
      "service2": "Local Moving",
      "service3": "Commercial Moving",
      "service4": "Apartment Moving",
      "service5": "Senior Moving",
      "service6": "",
      "service7": "",
      "submit_dt": "2025-01-31 01:53:13"
   },
   "location": {
      "uuid": "21e0c59d-df76-11ef-a909-b66e99367f32",
      "link_id": 341718,
      "account_id": 92411,
      "company": "Ewa Moving Co.",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 11,
      "city": "4763",
      "zip": "96814",
      "address": "1415 Kinau St Unit A1",
      "phone": "(808) 300-0223",
      "fax": null,
      "email": "ewamovinghi@brite-mail.com",
      "name": "Ewa Moving Co.",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "21.3006666",
      "lon": "-157.8387834",
      "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": ""
}