Previous Next

59-495 Ke Waena Road Haleiwa, HI 96712

Listing
Overview

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

array(48) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202408680"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "59-495"
  }
  ["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) "4270000.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(1099) "Location, location, LOCATION! Situated at Log Cabins, which is arguably one of the best stretches of beach on the "7-Mile Miracle", you don't need to look any further for your ideal North Shore beach house. Surfing, swimming, white sand beaches, and stunning year-round sunsets are just outside your door. The main level of the home consists of 2 bedrooms and 1 full bathroom, plus there is a bonus studio downstairs with an additional full bathroom and kitchenette, all of which has been immaculately renovated and well maintained. With a modern kitchen and spacious living room with breathtaking ocean views, a large lanai ideal for hosting BBQs, a beautifully landscaped yard, an outside shower, and more for maximum comfortability, this is the perfect island retreat!

In the summertime, snorkel and swim out front or just enjoy your day basking on the beach. During the winter,  watch the surfers from the deck and catch a glimpse of the passing whales! Enjoy strolling the bike path, which passes in front of the home and stretches for 3.5 shady, lush miles.

This is truly paradise found!"
  }
  ["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) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "5695.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1540"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1970"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(28) "Garden,Mountain,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(6) "Kahuku"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(6) "Kahuku"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "STER"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(18) "sophia@sterman.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 780-5673"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(15) "Sophia L Miller"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-04-07T06:01:29.710"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "17951626"
  }
  ["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) "26173561"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "26173561"
    [1]=>
    string(8) "26173562"
    [2]=>
    string(8) "26173563"
    [3]=>
    string(8) "26173564"
    [4]=>
    string(8) "26173565"
    [5]=>
    string(8) "26173566"
    [6]=>
    string(8) "26173567"
    [7]=>
    string(8) "26173568"
    [8]=>
    string(8) "26173569"
    [9]=>
    string(8) "26173570"
    [10]=>
    string(8) "26173571"
    [11]=>
    string(8) "26173572"
    [12]=>
    string(8) "26173573"
    [13]=>
    string(8) "26173574"
    [14]=>
    string(8) "26173575"
    [15]=>
    string(8) "26173576"
    [16]=>
    string(8) "26173577"
    [17]=>
    string(8) "26173578"
    [18]=>
    string(8) "26173579"
    [19]=>
    string(8) "26173580"
    [20]=>
    string(8) "26173581"
    [21]=>
    string(8) "26173582"
    [22]=>
    string(8) "26173583"
    [23]=>
    string(8) "26173584"
    [24]=>
    string(8) "26173585"
    [25]=>
    string(8) "26173586"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2024-04-18"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "06:01:29.710"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202408680
        )

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Location, location, LOCATION! Situated at Log Cabins, which is arguably one of the best stretches of beach on the "7-Mile Miracle", you don't need to look any further for your ideal North Shore beach house. Surfing, swimming, white sand beaches, and stunning year-round sunsets are just outside your door. The main level of the home consists of 2 bedrooms and 1 full bathroom, plus there is a bonus studio downstairs with an additional full bathroom and kitchenette, all of which has been immaculately renovated and well maintained. With a modern kitchen and spacious living room with breathtaking ocean views, a large lanai ideal for hosting BBQs, a beautifully landscaped yard, an outside shower, and more for maximum comfortability, this is the perfect island retreat!

In the summertime, snorkel and swim out front or just enjoy your day basking on the beach. During the winter,  watch the surfers from the deck and catch a glimpse of the passing whales! Enjoy strolling the bike path, which passes in front of the home and stretches for 3.5 shady, lush miles.

This is truly paradise found!
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 780-5673
        )

    [ListAgentFullName] => Array
        (
            [0] => Sophia L Miller
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-04-07T06:01:29.710
        )

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

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

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

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

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

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

    [listing_image] => Array
        (
            [0] => 26173561
            [1] => 26173562
            [2] => 26173563
            [3] => 26173564
            [4] => 26173565
            [5] => 26173566
            [6] => 26173567
            [7] => 26173568
            [8] => 26173569
            [9] => 26173570
            [10] => 26173571
            [11] => 26173572
            [12] => 26173573
            [13] => 26173574
            [14] => 26173575
            [15] => 26173576
            [16] => 26173577
            [17] => 26173578
            [18] => 26173579
            [19] => 26173580
            [20] => 26173581
            [21] => 26173582
            [22] => 26173583
            [23] => 26173584
            [24] => 26173585
            [25] => 26173586
        )

    [ListingContractDate] => Array
        (
            [0] => 2024-04-18
        )

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

    [MatrixModifiedTime] => Array
        (
            [0] => 06:01:29.710
        )

)

PROPERTY INFO

• BedsTotal: 3
• Full Baths: 2
• Land Area (sf): 5,695 sf
• Living (sf): 1,540
• Year Built: 1970

KEY FEATURES

• Property Condition: Above Average
• Number of Parking Spaces: 2
• View: Garden,Mountain,Ocean,Sunset
• Listing Office: Sterman Realty

FINANCIAL INFO

• Land Tenure: FS - Fee Simple

SCHOOLS

• Elementary School: Sunset Beach
• Middle School: Kahuku
• 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 April 7, 2025 - 6:01 AM 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.