66-86 Haleiwa Road Haleiwa, HI 96712

Listing
Overview

Price: $3,188,000
Area: HALEIWA
Status: Active

Discover your own oasis nestled on 3 acres of picturesque land with a tranquil stream and breathtaking mountain views. This property features studio, 1 bath and Outdoor kitchen perfect for enjoying the natural surroundings Serene atmosphere ideal for relaxation and rejuvenation .Whether you're seeking a peaceful retreat or a place to create your dream home, this property offers endless possibilities to enjoy nature's beauty. Conveniently located just a 1-minute walk from Haleiwa town, enjoy easy access to paddleboarding, dining, and more. Don't miss the chance to make this serene haven your own! Listing by: Keller Williams Honolulu (808) 596-2888

array(48) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202418933"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(5) "66-86"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(16) "Lots/Acres/Farms"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(7) "Haleiwa"
  }
  ["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) "3188000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "3188000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "HALEIWA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(602) "Discover your own oasis nestled on 3 acres of picturesque land with a tranquil stream and breathtaking mountain views. This property features studio, 1 bath and Outdoor kitchen perfect for enjoying the natural surroundings Serene atmosphere ideal for relaxation and rejuvenation .Whether you're seeking a peaceful retreat or a place to create your dream home, this property offers endless possibilities to enjoy nature's beauty. Conveniently located just a 1-minute walk from Haleiwa town, enjoy easy access to paddleboarding, dining, and more. Don't miss the chance to make this serene haven your own!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(24) "Keller Williams Honolulu"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(9) "132335.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(21) "Garden,Mountain,Other"
  }
  ["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) "KWPP"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(26) "showings@tonggpartners.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 596-2888"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(14) "Charlene Tongg"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-02-19T10:44:22.910"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18220624"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-09-05T15:10:52.167"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(11) "North Shore"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(29) "Lake/Pond,Marina,Stream/Canal"
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26683835"
  }
  ["listing_image"]=>
  array(22) {
    [0]=>
    string(8) "26683835"
    [1]=>
    string(8) "26683836"
    [2]=>
    string(8) "26683837"
    [3]=>
    string(8) "26683838"
    [4]=>
    string(8) "26683839"
    [5]=>
    string(8) "26683840"
    [6]=>
    string(8) "26683841"
    [7]=>
    string(8) "26683842"
    [8]=>
    string(8) "26683843"
    [9]=>
    string(8) "26683844"
    [10]=>
    string(8) "26683845"
    [11]=>
    string(8) "26683846"
    [12]=>
    string(8) "26683847"
    [13]=>
    string(8) "26683848"
    [14]=>
    string(8) "26683849"
    [15]=>
    string(8) "26683850"
    [16]=>
    string(8) "26683851"
    [17]=>
    string(8) "26683852"
    [18]=>
    string(8) "26683853"
    [19]=>
    string(8) "26683854"
    [20]=>
    string(8) "26683855"
    [21]=>
    string(8) "26683856"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2024-09-05"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "10:44:22.910"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202418933
        )

    [StreetNumber] => Array
        (
            [0] => 66-86
        )

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Discover your own oasis nestled on 3 acres of picturesque land with a tranquil stream and breathtaking mountain views. This property features studio, 1 bath and Outdoor kitchen perfect for enjoying the natural surroundings Serene atmosphere ideal for relaxation and rejuvenation .Whether you're seeking a peaceful retreat or a place to create your dream home, this property offers endless possibilities to enjoy nature's beauty. Conveniently located just a 1-minute walk from Haleiwa town, enjoy easy access to paddleboarding, dining, and more. Don't miss the chance to make this serene haven your own!
        )

    [ListOfficeName] => Array
        (
            [0] => Keller Williams Honolulu
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => showings@tonggpartners.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 596-2888
        )

    [ListAgentFullName] => Array
        (
            [0] => Charlene Tongg
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-02-19T10:44:22.910
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-09-05T15:10:52.167
        )

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

    [PropertyFrontage] => Array
        (
            [0] => Lake/Pond,Marina,Stream/Canal
        )

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

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

    [listing_image] => Array
        (
            [0] => 26683835
            [1] => 26683836
            [2] => 26683837
            [3] => 26683838
            [4] => 26683839
            [5] => 26683840
            [6] => 26683841
            [7] => 26683842
            [8] => 26683843
            [9] => 26683844
            [10] => 26683845
            [11] => 26683846
            [12] => 26683847
            [13] => 26683848
            [14] => 26683849
            [15] => 26683850
            [16] => 26683851
            [17] => 26683852
            [18] => 26683853
            [19] => 26683854
            [20] => 26683855
            [21] => 26683856
        )

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 10:44:22.910
        )

)

  • Land Area (sf): 132,335 sf

  • View: Garden,Mountain,Other
  • Listing Office: Keller Williams Honolulu

  • Land Tenure: FS - Fee Simple

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 February 19, 2025 - 10:44 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.

© Marcus Realty. All Rights Reserved.