68-247 Au Street Waialua, HI 96791

Listing
Overview

Price: $1,500,000
Area: WAIALUA
Status: Sold (Limited photos per MLS privacy policy)

Rare Beachfront Opportunity in Waialua -Discover a rare chance to own a prime beachfront parcel in the breathtaking Waialua area, just steps from a pristine white sandy beach. This ready-to-build property features a solid foundation elevated 12 feet above sea level, along with installed perimeter walls. Essential utilities—including sewer, water, electricity, and a septic system beneath the foundation—are already in place. Don’t miss this incredible opportunity to create your own paradise in one of Oahu’s most serene beachfront settings. Contact us today for more details! Building Plans available. Listing by: List Sotheby's Int'l Realty (808) 397-4480

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202502497"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "68-247"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(16) "Lots/Acres/Farms"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(2) "Au"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["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) "1500000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIALUA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(613) "Rare Beachfront Opportunity in Waialua -Discover a rare chance to own a prime beachfront parcel in the breathtaking Waialua area, just steps from a pristine white sandy beach. This ready-to-build property features a solid foundation elevated 12 feet above sea level, along with installed perimeter walls.  Essential utilities—including sewer, water, electricity, and a septic system beneath the foundation—are already in place. Don’t miss this incredible opportunity to create your own paradise in one of Oahu’s most serene beachfront settings. Contact us today for more details! Building Plans available."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(27) "List Sotheby's Int'l Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "8850.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(20) "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) "LIST"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(19) "amallin@listsir.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 397-4480"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(16) "Akimi Sue Mallin"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-10-23"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18506017"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-10-23T09:50:38.023"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-01-28"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(11) "North Shore"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Ocean"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "09:50:38.023"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26858624"
  }
  ["listing_image"]=>
  array(22) {
    [0]=>
    string(8) "26858624"
    [1]=>
    string(8) "26858625"
    [2]=>
    string(8) "26863151"
    [3]=>
    string(8) "26863152"
    [4]=>
    string(8) "26863153"
    [5]=>
    string(8) "26863154"
    [6]=>
    string(8) "26863155"
    [7]=>
    string(8) "26863156"
    [8]=>
    string(8) "26863157"
    [9]=>
    string(8) "26863158"
    [10]=>
    string(8) "26863159"
    [11]=>
    string(8) "26863160"
    [12]=>
    string(8) "26863161"
    [13]=>
    string(8) "26863162"
    [14]=>
    string(8) "26863163"
    [15]=>
    string(8) "26894827"
    [16]=>
    string(8) "26894828"
    [17]=>
    string(8) "26894829"
    [18]=>
    string(8) "26894830"
    [19]=>
    string(8) "26894831"
    [20]=>
    string(8) "26894832"
    [21]=>
    string(8) "26894833"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202502497
        )

    [StreetNumber] => Array
        (
            [0] => 68-247
        )

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Rare Beachfront Opportunity in Waialua -Discover a rare chance to own a prime beachfront parcel in the breathtaking Waialua area, just steps from a pristine white sandy beach. This ready-to-build property features a solid foundation elevated 12 feet above sea level, along with installed perimeter walls.  Essential utilities—including sewer, water, electricity, and a septic system beneath the foundation—are already in place. Don’t miss this incredible opportunity to create your own paradise in one of Oahu’s most serene beachfront settings. Contact us today for more details! Building Plans available.
        )

    [ListOfficeName] => Array
        (
            [0] => List Sotheby's Int'l Realty
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => amallin@listsir.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 397-4480
        )

    [ListAgentFullName] => Array
        (
            [0] => Akimi Sue Mallin
        )

    [CloseDate] => Array
        (
            [0] => 2025-10-23
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-10-23T09:50:38.023
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-01-28
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 09:50:38.023
        )

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

    [listing_image] => Array
        (
            [0] => 26858624
            [1] => 26858625
            [2] => 26863151
            [3] => 26863152
            [4] => 26863153
            [5] => 26863154
            [6] => 26863155
            [7] => 26863156
            [8] => 26863157
            [9] => 26863158
            [10] => 26863159
            [11] => 26863160
            [12] => 26863161
            [13] => 26863162
            [14] => 26863163
            [15] => 26894827
            [16] => 26894828
            [17] => 26894829
            [18] => 26894830
            [19] => 26894831
            [20] => 26894832
            [21] => 26894833
        )

)

  • Land Area (sf): 8,850 sf

  • View: Ocean,Sunrise,Sunset
  • Listing Office: List Sotheby's Int'l Realty

  • 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 October 23, 2025 - 9:50 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.