(unit #b) 59-497 Ke Waena Rd, Haleiwa

Haleiwa Home For Sale

Ultimate beachfront living on the North Shore! Unbeatable location, just steps to beautiful Log Cabins beach and world class waves. Built by renowned local builder, Trent Johnson, this 4 Bed 4 Bath beachfront masterpiece of design and craftsmanship features Two Ocean View Master Suites opening to a large covered lanai with spectacular views. Kids will love the oversized 3rd bedroom with custom built-in bunk beds and a private lanai. Main level features an additional guest bedroom and full bath. Premier chef's kitchen with premium finishes including custom cabinets, black soapstone countertops, Subzero and Wolf gas range. Beautiful Ironwood floors and vaulted ceilings throughout provide an open concept and design. Huge pocket sliding doors connect indoor/outdoor living, leading to a spacious lanai, large grass area, and path straight to the sand and surf! Link to video: https://bit.ly/2NbCvmg

Property Details

(unit #b) 59-497 Ke Waena RdSquare Ft: 3,474Lot Size: 0.11Bedrooms: 4Bathrooms: 4Price: $3,790,000Zip: 96712
MLS® #: 201930110Neighborhood: SUNSET AREACommunity: SUNSET AREALevels: TwoSchool District: Days on Market: 254

Sales Agent

Beach Cities Real Estate
  • Beach Cities Real Estate
  • Phone: (888) 990-7111
  • Cell: (888) 990-7111
  • Contact Agent Now

Mortgage Calculator

  • (In Dollars)
  • %
  • years
  • %

  • Show me the calculations and amortization.

Essential Information

  • MLS® #:
  • Price:
  • Bedrooms:
  • Bathrooms:
  • Full Baths:
  • Square Footage:
  • Acres:
  • Year Built:
  • Type:
    Single Family
  • Sub-Type:
    Single Family
  • Style:
    CPR, Detach Single Family
  • Status:
    In Escrow Showing

Community Information

  • Address:
    (unit #b) 59-497 Ke Waena Rd
  • Area:
    North Shore
  • Subdivision:
  • City:
  • State:
  • Zip Code:


  • Amenities:
    Bedroom on 1st Floor, Full Bath on 1st Floor, Landscaped, Patio/Deck
  • Utilities:
    Cable, Internet, Public Water, Telephone, Overhead Electricity, Septic
  • Parking Spaces:
  • Parking:
    Garage, 3 Car+
  • View:
    Coastline, Ocean, Sunset
  • Is Waterfront:
  • Waterfront:
    Ocean, Sandy Beach, Waterfront
  • Pool:


  • Stories:


  • Exterior:
    Double Wall, Wood Frame
  • Lot Description:

School Information

  • Elementary:
    Sunset Beach
  • Middle:
  • High:

Additional Information

  • Date Listed:
    October 26th, 2019
  • Days on Market:

Listing Details

  • Listing Office:
    Elite Pacific Properties, LLC

Price Change History for (unit #b) 59-497 Ke Waena Rd, Haleiwa, HI (MLS® #201930110)

Date Details Price Change
In Escrow Showing (from Active)
Price Reduced (from $3,990,000) $3,790,000 $200,000 (5.01%)
Back to Search Results

Based on information from the Multiple Listing Service of the HiCentral MLS®, Ltd. active listings last updated on July 7th, 2020 at 7:40am PDT. Information is deemed reliable but not guaranteed. Copyright: 2020 by the HiCentral MLS®, Ltd.

Listing information is provided exclusively for consumers' personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing.

Some of the active listings appearing on this site may be listed by other REALTORS®. If you are interested in those active listings, our company may represent you as the buyer's agent. If the active listing you are interested in is our company's active listing, you may speak to one of our agents regarding your options for representation.