68-078 Au Street Unit 203 Waialua, HI 96791

Listing
Overview

Price: $339,000
Area: WAIALUA
Status: Active

Coastal charm meets fresh opportunity—just a block from the beach on Oahu’s North Shore! This 1-bed, 1-bath condo in peaceful Waialua is vacant, clean, and ready for its new owner. Enjoy a laid-back lifestyle with low maintenance fees in a no-frills, self-managed building. Ideal as a full-time home, North Shore getaway, or rental (last rented for $2,300/month). Located on the second floor, this unit offers convenience and lifestyle just minutes from surf breaks and sunset walks. A newly elected association board is already bringing fresh energy—don’t miss this chance to own a piece of the North Shore. Listing by: Coldwell Banker Realty (808) 971-1743

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202515824"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "68-078"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(15) "Condo/Townhouse"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(2) "Au"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(3) "203"
  }
  ["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(9) "339000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIALUA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(616) "Coastal charm meets fresh opportunity—just a block from the beach on Oahu’s North Shore! This 1-bed, 1-bath condo in peaceful Waialua is vacant, clean, and ready for its new owner. Enjoy a laid-back lifestyle with low maintenance fees in a no-frills, self-managed building. Ideal as a full-time home, North Shore getaway, or rental (last rented for $2,300/month). Located on the second floor, this unit offers convenience and lifestyle just minutes from surf breaks and sunset walks. A newly elected association board is already bringing fresh energy—don’t miss this chance to own a piece of the North Shore."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(8) "11543.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "381"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1974"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(17) "Puuiki Beach Apts"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "200.00"
  }
  ["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) "CBPP"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(23) "amber.hind@cbrealty.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 971-1743"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(12) "Amber R Hind"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18858109"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-07-10T09:54:26.610"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-07-10"
  }
  ["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:54:26.610"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27063672"
  }
  ["listing_image"]=>
  array(18) {
    [0]=>
    string(8) "27063672"
    [1]=>
    string(8) "27063673"
    [2]=>
    string(8) "27063674"
    [3]=>
    string(8) "27063675"
    [4]=>
    string(8) "27063676"
    [5]=>
    string(8) "27063677"
    [6]=>
    string(8) "27063678"
    [7]=>
    string(8) "27063679"
    [8]=>
    string(8) "27063680"
    [9]=>
    string(8) "27063681"
    [10]=>
    string(8) "27063682"
    [11]=>
    string(8) "27063683"
    [12]=>
    string(8) "27063684"
    [13]=>
    string(8) "27063685"
    [14]=>
    string(8) "27063686"
    [15]=>
    string(8) "27063687"
    [16]=>
    string(8) "27063688"
    [17]=>
    string(8) "27063689"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202515824
        )

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

    [PropertyType] => Array
        (
            [0] => Condo/Townhouse
        )

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Coastal charm meets fresh opportunity—just a block from the beach on Oahu’s North Shore! This 1-bed, 1-bath condo in peaceful Waialua is vacant, clean, and ready for its new owner. Enjoy a laid-back lifestyle with low maintenance fees in a no-frills, self-managed building. Ideal as a full-time home, North Shore getaway, or rental (last rented for $2,300/month). Located on the second floor, this unit offers convenience and lifestyle just minutes from surf breaks and sunset walks. A newly elected association board is already bringing fresh energy—don’t miss this chance to own a piece of the North Shore.
        )

    [ListOfficeName] => Array
        (
            [0] => Coldwell Banker Realty
        )

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

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

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

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

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

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

    [BuildingName] => Array
        (
            [0] => Puuiki Beach Apts
        )

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => amber.hind@cbrealty.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 971-1743
        )

    [ListAgentFullName] => Array
        (
            [0] => Amber R Hind
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-07-10T09:54:26.610
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-07-10
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 09:54:26.610
        )

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

    [listing_image] => Array
        (
            [0] => 27063672
            [1] => 27063673
            [2] => 27063674
            [3] => 27063675
            [4] => 27063676
            [5] => 27063677
            [6] => 27063678
            [7] => 27063679
            [8] => 27063680
            [9] => 27063681
            [10] => 27063682
            [11] => 27063683
            [12] => 27063684
            [13] => 27063685
            [14] => 27063686
            [15] => 27063687
            [16] => 27063688
            [17] => 27063689
        )

)

  • BedsTotal: 1
  • Full Baths: 1
  • Land Area (sf): 11,543 sf
  • Living (sf): 381
  • Year Built: 1974
  • Building Name: Puuiki Beach Apts

  • Property Condition: Above Average
  • Number of Parking Spaces: 1
  • View: None
  • Listing Office: Coldwell Banker Realty

  • Maintenance Fees: $200
  • 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 July 10, 2025 - 9:54 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.