Previous Next

59-557 Ke Iki Road Unit A Haleiwa, HI 96712

Take a Virtual Tour

Listing
Overview

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

array(48) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202414881"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "59-557"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(6) "Ke Iki"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(4) "Road"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(1) "A"
  }
  ["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(54) "https://shoots.styronphoto.com/sites/zejbkjq/unbranded"
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "4695000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(11) "SUNSET AREA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(984) "Owner Financing/Agreement of Sale option available. please contact agent.
Welcome to Stunning Sunsets and one of the Top white sand beaches on the North Shore and Oahu!
This very unique North Shore beachfront home, beautifully upgraded and well appointed, is just steps to the sand. 
Scenic views from the luscious lawn, living room, kitchen, upstairs-loft suite, and covered lanai include seasonal surf and whale watching. The well established landscaping and vegetation ensure privacy from beach. Ideally located in the middle of the “Seven Mile Miracle”, close to schools, shopping, golf, snorkeling, churches and some of the best surf breaks in the world. 
*Brand New Spilt AC Throughout, Blue Rock Driveway and Backyard Sod.
Perfect for a primary residence, second home or family retreat!
This is a Flag Lot- Private drive. See included survey.

*Be sure to Click on Virtual Tour Icon*
Recent Eddie Surf Contest- 
December 22,2024. -NO Water on Property from Waves!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(14) "Sterman Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "6260.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1938"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1978"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(15) "Two,Split Level"
  }
  ["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(7) "Waialua"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "STER"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(19) "Beatnik@sterman.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(321) 431-5763"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(15) "Beatnik A Cross"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-05-04T17:00:01.333"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18090721"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(11) "North Shore"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(17) "Ocean,Sandy Beach"
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26602763"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "26602763"
    [1]=>
    string(8) "26602764"
    [2]=>
    string(8) "26602765"
    [3]=>
    string(8) "26602766"
    [4]=>
    string(8) "26602767"
    [5]=>
    string(8) "26602768"
    [6]=>
    string(8) "26602769"
    [7]=>
    string(8) "26602770"
    [8]=>
    string(8) "26602771"
    [9]=>
    string(8) "26602772"
    [10]=>
    string(8) "26602773"
    [11]=>
    string(8) "26602774"
    [12]=>
    string(8) "26602775"
    [13]=>
    string(8) "26602776"
    [14]=>
    string(8) "26602777"
    [15]=>
    string(8) "26602778"
    [16]=>
    string(8) "26602779"
    [17]=>
    string(8) "26602780"
    [18]=>
    string(8) "26602781"
    [19]=>
    string(8) "26602782"
    [20]=>
    string(8) "26602783"
    [21]=>
    string(8) "26602784"
    [22]=>
    string(8) "26602785"
    [23]=>
    string(8) "26602786"
    [24]=>
    string(8) "26602787"
    [25]=>
    string(8) "26603766"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2024-06-28"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "17:00:01.333"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202414881
        )

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

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

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

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

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

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

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

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

    [VirtualTourURLUnbranded] => Array
        (
            [0] => https://shoots.styronphoto.com/sites/zejbkjq/unbranded
        )

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Owner Financing/Agreement of Sale option available. please contact agent.
Welcome to Stunning Sunsets and one of the Top white sand beaches on the North Shore and Oahu!
This very unique North Shore beachfront home, beautifully upgraded and well appointed, is just steps to the sand. 
Scenic views from the luscious lawn, living room, kitchen, upstairs-loft suite, and covered lanai include seasonal surf and whale watching. The well established landscaping and vegetation ensure privacy from beach. Ideally located in the middle of the “Seven Mile Miracle”, close to schools, shopping, golf, snorkeling, churches and some of the best surf breaks in the world. 
*Brand New Spilt AC Throughout, Blue Rock Driveway and Backyard Sod.
Perfect for a primary residence, second home or family retreat!
This is a Flag Lot- Private drive. See included survey.

*Be sure to Click on Virtual Tour Icon*
Recent Eddie Surf Contest- 
December 22,2024. -NO Water on Property from Waves!
        )

    [ListOfficeName] => Array
        (
            [0] => Sterman Realty
        )

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

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

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

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

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

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

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

    [PropertyCondition] => Array
        (
            [0] => Excellent
        )

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

    [StoriesType] => Array
        (
            [0] => Two,Split Level
        )

    [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] => Waialua
        )

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

    [ListAgentEmail] => Array
        (
            [0] => Beatnik@sterman.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (321) 431-5763
        )

    [ListAgentFullName] => Array
        (
            [0] => Beatnik A Cross
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-05-04T17:00:01.333
        )

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

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

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

    [PropertyFrontage] => Array
        (
            [0] => Ocean,Sandy Beach
        )

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

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

    [listing_image] => Array
        (
            [0] => 26602763
            [1] => 26602764
            [2] => 26602765
            [3] => 26602766
            [4] => 26602767
            [5] => 26602768
            [6] => 26602769
            [7] => 26602770
            [8] => 26602771
            [9] => 26602772
            [10] => 26602773
            [11] => 26602774
            [12] => 26602775
            [13] => 26602776
            [14] => 26602777
            [15] => 26602778
            [16] => 26602779
            [17] => 26602780
            [18] => 26602781
            [19] => 26602782
            [20] => 26602783
            [21] => 26602784
            [22] => 26602785
            [23] => 26602786
            [24] => 26602787
            [25] => 26603766
        )

    [ListingContractDate] => Array
        (
            [0] => 2024-06-28
        )

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

    [MatrixModifiedTime] => Array
        (
            [0] => 17:00:01.333
        )

)

PROPERTY INFO

• BedsTotal: 3
• Full Baths: 2
• Half Baths: 1
• Land Area (sf): 6,260 sf
• Living (sf): 1,938
• Year Built: 1978

KEY FEATURES

• Property Condition: Excellent
• Number of Parking Spaces: 4
• View: Coastline,Ocean,Sunset
• Listing Office: Sterman Realty

FINANCIAL INFO

• Land Tenure: FS - Fee Simple

SCHOOLS

• Elementary School: Sunset Beach
• High School: Waialua

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 May 4, 2025 - 5:00 PM Information is deemed reliable but not guaranteed. Copyright: 2025 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.