Oahu Photography Tours

{
   "vendor": "all",
   "sociallist": [],
   "listing": {
      "link_id": 345564,
      "site_id": 6,
      "cat_id": 39,
      "priority": 2,
      "url": "https://www.oahuphotographytours.com/",
      "title": "Oahu Photography Tours",
      "description": "Embark on a photographic journey of discovery with Oahu Photography Tours. We provide more than just sightseeing, we offer an immersive experience focused on capturing the perfect shot. Our tours are tailored to different skill levels and interests, ensuring a personalized and rewarding adventure. Discover the hidden corners and iconic landmarks of Oahu through the eye of your camera, guided by local experts.   ",
      "keywords": null,
      "status": "0",
      "affiliate_id": 0,
      "cust_id": 96259,
      "approve_dt": "2025-10-02T00:00:00.000Z",
      "source": null,
      "submit_dt": "2025-04-18T00:00:00.000Z",
      "filler": null,
      "points": null,
      "ppc_remain": null,
      "ppc_points": null,
      "link_points": null,
      "clickcount": 2,
      "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": 302,
      "d_url": null,
      "approved": {
         "type": "Buffer",
         "data": [
            49
         ]
      },
      "logo_ext": "png",
      "screen_ext": "png",
      "pack_id": null,
      "uuid": "61adae5c-1c44-11f0-a909-b66e99367f32",
      "subdate": "Apr 18, 2025",
      "subcategory": "Photography",
      "request_types": "",
      "visitcount": 61
   },
   "visits": {
      "storefront": 61,
      "articles": 0,
      "videos": 0,
      "reviews": 0,
      "coupons": 0,
      "products": 0,
      "social": 28,
      "services": 0,
      "article_externals": 0,
      "video_externals": 0,
      "coupon_externals": 0,
      "product_externals": 0,
      "service_externals": 0
   },
   "services": {
      "service_description": "Oahu Photo Tours offers small group and private photography tours that showcase the best of Oahu, from iconic landmarks to hidden gems. Locally owned since 2011, they provide expertly guided experiences that blend breathtaking scenery, local culture, hands-on photography tips, and authentic Hawaiian adventures. With passionate local guides, perfect timing for optimal lighting, and small groups for a personalized experience, they help travelers capture unforgettable memories while exploring the island's most stunning and crowd-free locations.",
      "service1": "sunrise photography tours",
      "service2": " complete island adventure tours",
      "service3": " sunset and sea cliff tours",
      "service4": " local food and photo tours",
      "service5": " night sky and light painting tours",
      "service6": " private custom tours",
      "service7": " Waikiki hotel pickup service",
      "submit_dt": "2025-04-18 11:00:47"
   },
   "location": {
      "uuid": "61adae5c-1c44-11f0-a909-b66e99367f32",
      "link_id": 345564,
      "account_id": 96259,
      "company": "Oahu Photography Tours",
      "sid": 6,
      "country": 277,
      "countrycode": "US",
      "state": 11,
      "city": "4763",
      "zip": "96815",
      "address": "2421 Tusitala St APT 801",
      "phone": "808-679-1938",
      "fax": null,
      "email": "oahuphotographytour@outlook.com",
      "name": "Oahu Photography Tours",
      "status": "show",
      "start_dt": null,
      "end_dt": null,
      "lat": "21.2775503",
      "lon": "-157.8226861",
      "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": ""
}