Previous Next

004 Kaukonahua Road Waialua, HI 96791

Listing
Overview

Price: $2,500,000
Area: AG/PRESERVE
Status: Active

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202528087"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(3) "004"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(10) "Kaukonahua"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(4) "Road"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(7) "Waialua"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96791"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "2500000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(11) "AG/PRESERVE"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1100) "Discover a truly exceptional opportunity to own 5 acres of lush agricultural land just minutes from the heart of Haleiwa town and world-renowned North Shore beaches. With iconic surf breaks nearby and some of the island’s best restaurants just down the road, this location offers the perfect blend of country living and coastal lifestyle. The property is dotted with dozens of mature fruit trees, offering both beauty and bounty. A large, flat, open grass field provides endless possibilities—whether you're dreaming of a sustainable farm, family compound, or tropical retreat. Enjoy the convenience of both potable city water and a full irrigation system already in place, making it easy to bring your vision to life. Properties like this are rarely available and offer a unique chance to create something truly special in one of Oahu’s most sought-after areas. Also, this property is an easy 45 minute or less drive to Honolulu without traffic.  Don’t miss your chance to experience this one-of-a-kind agricultural gem.  **Buyer is able to build a single family residence on this property**"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(11) "Real Broker"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(9) "228864.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "2022"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(30) "Garden,Mountain,Sunrise,Sunset"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(7) "Waialua"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(7) "Waialua"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(7) "Waialua"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "RBLL"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(18) "Lex@lifeonoahu.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 277-4715"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(12) "Lex Ferguson"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19175693"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-03-02T09:58:53.593"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-12-16"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(11) "North Shore"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "09:58:53.593"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27320301"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "27320301"
    [1]=>
    string(8) "27320302"
    [2]=>
    string(8) "27320303"
    [3]=>
    string(8) "27320304"
    [4]=>
    string(8) "27320305"
    [5]=>
    string(8) "27320306"
    [6]=>
    string(8) "27320307"
    [7]=>
    string(8) "27320308"
    [8]=>
    string(8) "27320309"
    [9]=>
    string(8) "27320310"
    [10]=>
    string(8) "27320311"
    [11]=>
    string(8) "27320312"
    [12]=>
    string(8) "27320313"
    [13]=>
    string(8) "27320314"
    [14]=>
    string(8) "27320315"
    [15]=>
    string(8) "27320316"
    [16]=>
    string(8) "27320317"
    [17]=>
    string(8) "27320318"
    [18]=>
    string(8) "27320319"
    [19]=>
    string(8) "27320320"
    [20]=>
    string(8) "27320321"
    [21]=>
    string(8) "27320322"
    [22]=>
    string(8) "27320323"
    [23]=>
    string(8) "27320324"
    [24]=>
    string(8) "27320325"
    [25]=>
    string(8) "27320326"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202528087
        )

    [StreetNumber] => Array
        (
            [0] => 004
        )

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

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

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

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

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

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

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

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

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

    [Neighbourhood] => Array
        (
            [0] => AG/PRESERVE
        )

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

    [PublicRemarks] => Array
        (
            [0] => Discover a truly exceptional opportunity to own 5 acres of lush agricultural land just minutes from the heart of Haleiwa town and world-renowned North Shore beaches. With iconic surf breaks nearby and some of the island’s best restaurants just down the road, this location offers the perfect blend of country living and coastal lifestyle. The property is dotted with dozens of mature fruit trees, offering both beauty and bounty. A large, flat, open grass field provides endless possibilities—whether you're dreaming of a sustainable farm, family compound, or tropical retreat. Enjoy the convenience of both potable city water and a full irrigation system already in place, making it easy to bring your vision to life. Properties like this are rarely available and offer a unique chance to create something truly special in one of Oahu’s most sought-after areas. Also, this property is an easy 45 minute or less drive to Honolulu without traffic.  Don’t miss your chance to experience this one-of-a-kind agricultural gem.  **Buyer is able to build a single family residence on this property**
        )

    [ListOfficeName] => Array
        (
            [0] => Real Broker
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => Lex@lifeonoahu.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 277-4715
        )

    [ListAgentFullName] => Array
        (
            [0] => Lex Ferguson
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-03-02T09:58:53.593
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-12-16
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 09:58:53.593
        )

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

    [listing_image] => Array
        (
            [0] => 27320301
            [1] => 27320302
            [2] => 27320303
            [3] => 27320304
            [4] => 27320305
            [5] => 27320306
            [6] => 27320307
            [7] => 27320308
            [8] => 27320309
            [9] => 27320310
            [10] => 27320311
            [11] => 27320312
            [12] => 27320313
            [13] => 27320314
            [14] => 27320315
            [15] => 27320316
            [16] => 27320317
            [17] => 27320318
            [18] => 27320319
            [19] => 27320320
            [20] => 27320321
            [21] => 27320322
            [22] => 27320323
            [23] => 27320324
            [24] => 27320325
            [25] => 27320326
        )

)

PROPERTY INFO

• Land Area (sf): 228,864 sf
• Year Built: 2022

KEY FEATURES

• Property Condition: Above Average
• Number of Parking Spaces: 4
• View: Garden,Mountain,Sunrise,Sunset
• Listing Office: Real Broker

FINANCIAL INFO

• Land Tenure: FS - Fee Simple

SCHOOLS

• Elementary School: Waialua
• Middle School: Waialua
• 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 March 2, 2026 - 9:58 AM Information is deemed reliable but not guaranteed. Copyright: 2026 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.