Waialua, HI 96791

Listing
Overview

Price: $6,000,000
Area: MOKULEIA
Status: Sold

Over 100 yards beach frontage! 7 acres! Unique opportunity to own one of the last large, oceanfront properties on Oahu. The best beachfront value in all Hawaiian islands! Create your secluded and sustainable lifestyle. Let the Ocean and Land feed your family, and your soul. Two dwellings allowed along with agricultural accessory structures such as barns, stables and AG processing buildings. Stunning beaches stretch for miles. World class surfing, fishing, diving and sailing in your front yard. Magical ocean and mountain views. Haleiwa town with dozens of shops and restaurants is a short bike ride and Honolulu is only 45 minutes away. North Shore Oahu’s neighbor island experience without getting on a plane. Listing by: Real Broker, LLC (808) 372-8700

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202506680"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(16) "Lots/Acres/Farms"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["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) "6000000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(8) "MOKULEIA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(722) "Over 100 yards beach frontage! 7 acres! Unique opportunity to own one of the last large, oceanfront properties on Oahu.
The best beachfront value in all Hawaiian islands! Create your secluded and sustainable lifestyle. Let the Ocean and Land feed
your family, and your soul. Two dwellings allowed along with agricultural accessory structures such as barns, stables and AG
processing buildings. Stunning beaches stretch for miles. World class surfing, fishing, diving and sailing in your front yard.
Magical ocean and mountain views. Haleiwa town with dozens of shops and restaurants is a short bike ride and Honolulu is
only 45 minutes away. North Shore Oahu’s neighbor island experience without getting on a plane."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(16) "Real Broker, LLC"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(11) "30657775.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(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(0) ""
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "RBLL"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(18) "seanginella@me.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 372-8700"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(14) "Sean F Ginella"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-03-06"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18613198"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-03-19T18:01:51.873"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2024-09-29"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(11) "North Shore"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(11) "Ocean,Other"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "18:01:51.873"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26922293"
  }
  ["listing_image"]=>
  array(2) {
    [0]=>
    string(8) "26922293"
    [1]=>
    string(8) "26922294"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202506680
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Over 100 yards beach frontage! 7 acres! Unique opportunity to own one of the last large, oceanfront properties on Oahu.
The best beachfront value in all Hawaiian islands! Create your secluded and sustainable lifestyle. Let the Ocean and Land feed
your family, and your soul. Two dwellings allowed along with agricultural accessory structures such as barns, stables and AG
processing buildings. Stunning beaches stretch for miles. World class surfing, fishing, diving and sailing in your front yard.
Magical ocean and mountain views. Haleiwa town with dozens of shops and restaurants is a short bike ride and Honolulu is
only 45 minutes away. North Shore Oahu’s neighbor island experience without getting on a plane.
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => seanginella@me.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 372-8700
        )

    [ListAgentFullName] => Array
        (
            [0] => Sean F Ginella
        )

    [CloseDate] => Array
        (
            [0] => 2025-03-06
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-03-19T18:01:51.873
        )

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

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

    [PropertyFrontage] => Array
        (
            [0] => Ocean,Other
        )

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

    [MatrixModifiedTime] => Array
        (
            [0] => 18:01:51.873
        )

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

    [listing_image] => Array
        (
            [0] => 26922293
            [1] => 26922294
        )

)

  • Land Area (sf): 30,657,775 sf

  • View: Garden,Mountain,Ocean,Sunset
  • Listing Office: Real Broker, LLC

  • 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 March 19, 2025 - 6:01 PM 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.