Previous Next

59-874 Kamehameha Highway Unit B Haleiwa, HI 96712

Listing
Overview

Price: $1,350,000
Area: WAIMEA
Status: Active

array(48) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202411427"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "59-874"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(10) "Kamehameha"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(7) "Highway"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(1) "B"
  }
  ["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) "1350000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(6) "WAIMEA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(534) "Welcome to a rare opportunity to own a piece of Waimea Valley! Situated just inside its entrance, this property offers easy access to the world-renowned Waimea Bay—ideal for swimming, snorkeling, and diving. Take a hike to Waimea Falls for a scenic adventure amidst its majestic cascades. Known as one of the best surfing beaches, thrill-seekers can revel in the big waves during winter months. With only 4 residences in this historical valley along Oahu’s famed North shore, the possibilities for this property are truly endless."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(23) "West Beach Realty, Inc."
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(8) "39290.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "956"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1931"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(18) "Needs Major Repair"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "8"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(48) "Marina/Canal,Mountain,Ocean,Other,Sunrise,Sunset"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "WEBR"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(20) "katkelii77@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 723-9653"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(15) "Katherine Kelii"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-05-07T11:42:56.353"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18010803"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(11) "North Shore"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(38) "Conservation,Preservation,Stream/Canal"
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26215396"
  }
  ["listing_image"]=>
  array(20) {
    [0]=>
    string(8) "26215396"
    [1]=>
    string(8) "26215397"
    [2]=>
    string(8) "26215398"
    [3]=>
    string(8) "26215399"
    [4]=>
    string(8) "26215400"
    [5]=>
    string(8) "26215401"
    [6]=>
    string(8) "26215402"
    [7]=>
    string(8) "26215403"
    [8]=>
    string(8) "26215404"
    [9]=>
    string(8) "26215405"
    [10]=>
    string(8) "26215406"
    [11]=>
    string(8) "26215407"
    [12]=>
    string(8) "26215408"
    [13]=>
    string(8) "26215409"
    [14]=>
    string(8) "26215410"
    [15]=>
    string(8) "26215411"
    [16]=>
    string(8) "26215412"
    [17]=>
    string(8) "26215413"
    [18]=>
    string(8) "26215414"
    [19]=>
    string(8) "26215415"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2024-05-16"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "11:42:56.353"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202411427
        )

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

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

    [StreetName] => Array
        (
            [0] => Kamehameha
        )

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

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

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

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

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

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

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

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

    [Neighbourhood] => Array
        (
            [0] => WAIMEA
        )

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

    [PublicRemarks] => Array
        (
            [0] => Welcome to a rare opportunity to own a piece of Waimea Valley! Situated just inside its entrance, this property offers easy access to the world-renowned Waimea Bay—ideal for swimming, snorkeling, and diving. Take a hike to Waimea Falls for a scenic adventure amidst its majestic cascades. Known as one of the best surfing beaches, thrill-seekers can revel in the big waves during winter months. With only 4 residences in this historical valley along Oahu’s famed North shore, the possibilities for this property are truly endless.
        )

    [ListOfficeName] => Array
        (
            [0] => West Beach Realty, Inc.
        )

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

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

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

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

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

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

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

    [PropertyCondition] => Array
        (
            [0] => Needs Major Repair
        )

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

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

    [View] => Array
        (
            [0] => Marina/Canal,Mountain,Ocean,Other,Sunrise,Sunset
        )

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => katkelii77@gmail.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 723-9653
        )

    [ListAgentFullName] => Array
        (
            [0] => Katherine Kelii
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-05-07T11:42:56.353
        )

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

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

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

    [PropertyFrontage] => Array
        (
            [0] => Conservation,Preservation,Stream/Canal
        )

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

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

    [listing_image] => Array
        (
            [0] => 26215396
            [1] => 26215397
            [2] => 26215398
            [3] => 26215399
            [4] => 26215400
            [5] => 26215401
            [6] => 26215402
            [7] => 26215403
            [8] => 26215404
            [9] => 26215405
            [10] => 26215406
            [11] => 26215407
            [12] => 26215408
            [13] => 26215409
            [14] => 26215410
            [15] => 26215411
            [16] => 26215412
            [17] => 26215413
            [18] => 26215414
            [19] => 26215415
        )

    [ListingContractDate] => Array
        (
            [0] => 2024-05-16
        )

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

    [MatrixModifiedTime] => Array
        (
            [0] => 11:42:56.353
        )

)

PROPERTY INFO

• BedsTotal: 2
• Full Baths: 1
• Land Area (sf): 39,290 sf
• Living (sf): 956
• Year Built: 1931

KEY FEATURES

• Property Condition: Needs Major Repair
• Number of Parking Spaces: 8
• View: Marina/Canal,Mountain,Ocean,Other,Sunrise,Sunset
• Listing Office: West Beach Realty, Inc.

FINANCIAL INFO

• Land Tenure: FS - Fee Simple

SCHOOLS

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 7, 2025 - 11:42 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.