61-006 Kamehameha Highway Haleiwa, HI 96712

Listing
Overview

Price: $4,900,000
Area: WAIMEA
Status: Active

SPEECHELSS!! A ONE OF A KIND, MAJESTIC PROPERTY ON HIGH OVER LOOKING OAHU'S MAJESTIC LANDMARK KNOWN AS, "WAIMEA BAY." HOME TO 30 FOOT WAVES WITH SURFERS FLOCKING IN FROM ALL OVER THE WORLD. WATCH DOLPHINS AND TURTLES FROLICKING AS YOU SUNBATHE FROM UP TOP. BRING YOUR VISION OF UNLIMITED POTENTIALS. Listing by: West Oahu Realty, Inc. (808) 428-6363

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202319183"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "61-006"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(16) "Lots/Acres/Farms"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(10) "Kamehameha"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(7) "Highway"
  }
  ["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) "4900000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "4900000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(6) "WAIMEA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(300) "SPEECHELSS!!  A ONE OF A KIND, MAJESTIC PROPERTY ON HIGH OVER LOOKING OAHU'S MAJESTIC LANDMARK KNOWN AS, "WAIMEA BAY." HOME TO 30 FOOT WAVES WITH SURFERS FLOCKING IN FROM ALL OVER THE WORLD. WATCH DOLPHINS AND TURTLES FROLICKING AS YOU SUNBATHE FROM UP TOP. BRING YOUR VISION OF UNLIMITED POTENTIALS."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "West Oahu Realty, Inc."
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(9) "281049.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(30) "Coastline,Ocean,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) "WORI"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(23) "coyoteatkunia@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 428-6363"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(15) "Nainiu J Fakava"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2023-08-12T12:03:13.330"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "17499923"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2023-08-11T15:29:34.513"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(11) "North Shore"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(12) "Preservation"
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "25914776"
  }
  ["listing_image"]=>
  array(6) {
    [0]=>
    string(8) "25914776"
    [1]=>
    string(8) "25914777"
    [2]=>
    string(8) "25915526"
    [3]=>
    string(8) "25915527"
    [4]=>
    string(8) "25915528"
    [5]=>
    string(8) "25915529"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202319183
        )

    [StreetNumber] => Array
        (
            [0] => 61-006
        )

    [PropertyType] => Array
        (
            [0] => Lots/Acres/Farms
        )

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => SPEECHELSS!!  A ONE OF A KIND, MAJESTIC PROPERTY ON HIGH OVER LOOKING OAHU'S MAJESTIC LANDMARK KNOWN AS, "WAIMEA BAY." HOME TO 30 FOOT WAVES WITH SURFERS FLOCKING IN FROM ALL OVER THE WORLD. WATCH DOLPHINS AND TURTLES FROLICKING AS YOU SUNBATHE FROM UP TOP. BRING YOUR VISION OF UNLIMITED POTENTIALS.
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 428-6363
        )

    [ListAgentFullName] => Array
        (
            [0] => Nainiu J Fakava
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2023-08-12T12:03:13.330
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2023-08-11T15:29:34.513
        )

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

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

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

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

    [listing_image] => Array
        (
            [0] => 25914776
            [1] => 25914777
            [2] => 25915526
            [3] => 25915527
            [4] => 25915528
            [5] => 25915529
        )

)

  • Land Area (sf): 281,049

  • View: Coastline,Ocean,Sunrise,Sunset
  • Listing Office: West Oahu Realty, Inc.

  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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