Previous Next

59-475 Ke Waena Road Haleiwa, HI 96712

Listing
Overview

Price: $4,600,000
Area: SUNSET AREA
Status: Active

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202609398"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "59-475"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(8) "Ke Waena"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(4) "Road"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(7) "Haleiwa"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96712"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "4600000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(11) "SUNSET AREA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(972) "This was an Exempt Listing that just went Live on August 18th, 2026.
I consider the North Shore as Oahu’s “Hamptons”!  
Escape and relax, It’s only 35 miles away from Town.  Surf out front, Walk the endless beach, Paddleboard, or ride you Cruiser on the bike path, which runs from Three Tables to Sunset Beach.  This stretch of coastline is World Known as the “Seven Mile Miracle”. The Sunsets are Absolutely Amazing from the Hot Tub, beach or Lanai.  
Cleanse your Body and Mind.  
The North Shore will Change your Life!  
This home is a short drive to the Ritz Carlton @ Turtle Bay where you can Enjoy Fine Dining and World Class Golf as well.  Haleiwa is also a short drive away.
The main house has Three Bedrooms and two baths and also has a Recreation Room above the garage, which I consider to be one of the Key Selling Features,  with a Murphy Bed, bathroom and Kitchen.  The enclosed, two car garage is also helpful for secured surfboard storage."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(11) "Real Broker"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "6694.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1897"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1974"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(22) "Coastline,Ocean,Sunset"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(12) "Sunset Beach"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(6) "Kahuku"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "RBLL"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(25) "patjames@oceanregroup.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 256-5000"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(9) "Pat James"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19456188"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-09-16T17:30:03.027"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-05-09"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(11) "North Shore"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2026-05-12T13:35:28.100"
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "17:30:03.027"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27495312"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "27495312"
    [1]=>
    string(8) "27495313"
    [2]=>
    string(8) "27495314"
    [3]=>
    string(8) "27495315"
    [4]=>
    string(8) "27495316"
    [5]=>
    string(8) "27495317"
    [6]=>
    string(8) "27495318"
    [7]=>
    string(8) "27495319"
    [8]=>
    string(8) "27495320"
    [9]=>
    string(8) "27495321"
    [10]=>
    string(8) "27495322"
    [11]=>
    string(8) "27495323"
    [12]=>
    string(8) "27495324"
    [13]=>
    string(8) "27495325"
    [14]=>
    string(8) "27495326"
    [15]=>
    string(8) "27495327"
    [16]=>
    string(8) "27495328"
    [17]=>
    string(8) "27495329"
    [18]=>
    string(8) "27495330"
    [19]=>
    string(8) "27495331"
    [20]=>
    string(8) "27495332"
    [21]=>
    string(8) "27495333"
    [22]=>
    string(8) "27495334"
    [23]=>
    string(8) "27500389"
    [24]=>
    string(8) "27500390"
    [25]=>
    string(8) "27500391"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202609398
        )

    [StreetNumber] => Array
        (
            [0] => 59-475
        )

    [PropertyType] => Array
        (
            [0] => Single Family
        )

    [StreetName] => Array
        (
            [0] => Ke Waena
        )

    [StreetSuffix] => Array
        (
            [0] => Road
        )

    [UnitNumber] => Array
        (
            [0] => 
        )

    [City] => Array
        (
            [0] => Haleiwa
        )

    [StateOrProvince] => Array
        (
            [0] => HI
        )

    [PostalCode] => Array
        (
            [0] => 96712
        )

    [VirtualTourURLUnbranded] => Array
        (
            [0] => 
        )

    [ListPrice] => Array
        (
            [0] => 4600000.00
        )

    [Neighbourhood] => Array
        (
            [0] => SUNSET AREA
        )

    [Status] => Array
        (
            [0] => Active
        )

    [PublicRemarks] => Array
        (
            [0] => This was an Exempt Listing that just went Live on August 18th, 2026.
I consider the North Shore as Oahu’s “Hamptons”!  
Escape and relax, It’s only 35 miles away from Town.  Surf out front, Walk the endless beach, Paddleboard, or ride you Cruiser on the bike path, which runs from Three Tables to Sunset Beach.  This stretch of coastline is World Known as the “Seven Mile Miracle”. The Sunsets are Absolutely Amazing from the Hot Tub, beach or Lanai.  
Cleanse your Body and Mind.  
The North Shore will Change your Life!  
This home is a short drive to the Ritz Carlton @ Turtle Bay where you can Enjoy Fine Dining and World Class Golf as well.  Haleiwa is also a short drive away.
The main house has Three Bedrooms and two baths and also has a Recreation Room above the garage, which I consider to be one of the Key Selling Features,  with a Murphy Bed, bathroom and Kitchen.  The enclosed, two car garage is also helpful for secured surfboard storage.
        )

    [ListOfficeName] => Array
        (
            [0] => Real Broker
        )

    [BedsTotal] => Array
        (
            [0] => 4
        )

    [BathsFull] => Array
        (
            [0] => 3
        )

    [BathsHalf] => Array
        (
            [0] => 0
        )

    [LotSizeArea] => Array
        (
            [0] => 6694.00
        )

    [SqftTotal] => Array
        (
            [0] => 1897
        )

    [YearBuilt] => Array
        (
            [0] => 1974
        )

    [BuildingName] => Array
        (
            [0] => 
        )

    [PropertyCondition] => Array
        (
            [0] => Above Average
        )

    [ParkingTotal] => Array
        (
            [0] => 4
        )

    [StoriesType] => Array
        (
            [0] => One
        )

    [View] => Array
        (
            [0] => Coastline,Ocean,Sunset
        )

    [MaintenanceExpense] => Array
        (
            [0] => 
        )

    [LandTenure] => Array
        (
            [0] => FS - Fee Simple
        )

    [ElementarySchool] => Array
        (
            [0] => Sunset Beach
        )

    [MiddleOrJuniorSchool] => Array
        (
            [0] => 
        )

    [HighSchool] => Array
        (
            [0] => Kahuku
        )

    [ListOfficeMLSID] => Array
        (
            [0] => RBLL
        )

    [ListAgentEmail] => Array
        (
            [0] => patjames@oceanregroup.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 256-5000
        )

    [ListAgentFullName] => Array
        (
            [0] => Pat James
        )

    [CloseDate] => Array
        (
            [0] => 
        )

    [Matrix_Unique_ID] => Array
        (
            [0] => 19456188
        )

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-09-16T17:30:03.027
        )

    [ListingContractDate] => Array
        (
            [0] => 2026-05-09
        )

    [MLSAreaMajor] => Array
        (
            [0] => North Shore
        )

    [PropertyFrontage] => Array
        (
            [0] => 
        )

    [ExemptListingEntryTimestamp] => Array
        (
            [0] => 2026-05-12T13:35:28.100
        )

    [MatrixModifiedTime] => Array
        (
            [0] => 17:30:03.027
        )

    [_thumbnail_id] => Array
        (
            [0] => 27495312
        )

    [listing_image] => Array
        (
            [0] => 27495312
            [1] => 27495313
            [2] => 27495314
            [3] => 27495315
            [4] => 27495316
            [5] => 27495317
            [6] => 27495318
            [7] => 27495319
            [8] => 27495320
            [9] => 27495321
            [10] => 27495322
            [11] => 27495323
            [12] => 27495324
            [13] => 27495325
            [14] => 27495326
            [15] => 27495327
            [16] => 27495328
            [17] => 27495329
            [18] => 27495330
            [19] => 27495331
            [20] => 27495332
            [21] => 27495333
            [22] => 27495334
            [23] => 27500389
            [24] => 27500390
            [25] => 27500391
        )

)

PROPERTY INFO

• BedsTotal: 4
• Full Baths: 3
• Land Area (sf): 6,694 sf
• Living (sf): 1,897
• Year Built: 1974

KEY FEATURES

• Property Condition: Above Average
• Number of Parking Spaces: 4
• View: Coastline,Ocean,Sunset
• Listing Office: Real Broker

FINANCIAL INFO

• Land Tenure: FS - Fee Simple

SCHOOLS

• Elementary School: Sunset Beach
• High School: Kahuku

CONTACT US

Marcus Realty

#RB-7120
info@marcushawaii.com
(808)839-7446

Based on information from the Multiple Listing Service of HiCentral MLS, Ltd. listings last updated on September 16, 2026 - 5:30 PM Information is deemed reliable but not guaranteed. Copyright: 2026 by HiCentral MLS, Ltd.
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.