Avlaw Aviation Consulting

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 336671,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://avlaw.com.au/",
      "title": "Avlaw Aviation Consulting",
      "description": "Avlaw Pty Ltd, trading as Avlaw Aviation Consulting, has established a reputation in the Asia-Pacific region as a highly respected provider of aviation consultancy services, as evident from our diverse range of clients which include aircraft operators, property developers, government departments and agencies, safety regulators, airport operators, law firms, and mining and resources companies.\r\n\r\nEmail Address: info@avlaw.com.au\r\nBusiness Hours: Monday - Friday 9:00 AM–5:00 PM, Saturday - Sunday Closed",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 87404,
      "approve_dt": null,
      "source": null,
      "submit_dt": "2024-10-12T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": 1,
      "clickcount": 1,
      "referrals": null,
      "country": 77,
      "countrycode": "AU",
      "loc_id": 77,
      "state_id": 0,
      "city_id": 0,
      "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": "jpg",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "7acb8bb1-884a-11ef-ab46-b66e99367f32",
      "subdate": "Oct 12, 2024",
      "subcategory": "Business Services",
      "request_types": "",
      "visitcount": 7
   },
   "visits": {
      "storefront": 7,
      "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": "Avlaw Aviation Consulting has established a reputation in the Asia-Pacific region as a highly respected provider of aviation consultancy services.",
      "service1": "",
      "service2": "",
      "service3": "",
      "service4": "",
      "service5": "",
      "service6": "",
      "service7": "",
      "submit_dt": "2024-10-12 03:31:34"
   },
   "location": {
      "uuid": "7acb8bb1-884a-11ef-ab46-b66e99367f32",
      "link_id": 336671,
      "account_id": 87404,
      "company": "",
      "sid": 6,
      "country": 77,
      "countrycode": "AU",
      "state": 0,
      "city": "0",
      "zip": "2060",
      "address": "Suite 6.13/6 Middlemiss St, Lavender Bay NSW ",
      "phone": "+612 9980 7717",
      "fax": null,
      "email": "avlaw.access@gmail.com",
      "name": "",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "-33.8426886",
      "lon": "151.2102239",
      "statename": ""
   },
   "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": ""
}