68-090 Au Street Unit E304 Waialua, HI 96791

Listing
Overview

Price: $519,000
Area: WAIALUA
Status: Pending

Enjoy the best of North Shore living in this charming 2-bedroom, 1-bath condo in the desirable Ono Vista community in Waialua. This partially renovated, two-level unit features an upgraded kitchen and bathroom, a functional layout, and beautiful garden, mountain, and ocean views. Seller has a VA Assumable loan at a 3.75% interest rate (Subject to lender approval) With 788 sq ft of interior living space plus a spacious lanai, there’s plenty of room to relax and unwind. The unit also includes the rare convenience of two assigned parking stalls. Ono Vista is a well-managed community offering great amenities including a saltwater pool, extra-large sauna, resident manager, and secured entry. Ideally located just moments from Waialua Beach Park, you’ll enjoy easy access to swimming, snorkeling, and surfing at nearby breaks. Conveniently situated in the heart of Waialua, and just a short drive to Haleiwa Town for dining, and entertainment. The nearby polo fields and bike paths add to the relaxed, active North Shore lifestyle. An excellent opportunity to own in a peaceful, established community—perfect as a primary residence, or investment. *No flood damage from recent events Listing by: Hawaii Life (800) 667-5028

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202605937"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "68-090"
  }
  ["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(4) "E304"
  }
  ["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) "519000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIALUA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(7) "Pending"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1198) "Enjoy the best of North Shore living in this charming 2-bedroom, 1-bath condo in the desirable Ono Vista community in Waialua. This partially renovated, two-level unit features an upgraded kitchen and bathroom, a functional layout, and beautiful garden, mountain, and ocean views.
Seller has a VA Assumable loan at a 3.75% interest rate (Subject to lender approval)
With 788 sq ft of interior living space plus a spacious lanai, there’s plenty of room to relax and unwind. The unit also includes the rare convenience of two assigned parking stalls.
Ono Vista is a well-managed community offering great amenities including a saltwater pool, extra-large sauna, resident manager, and secured entry. Ideally located just moments from Waialua Beach Park, you’ll enjoy easy access to swimming, snorkeling, and surfing at nearby breaks.
Conveniently situated in the heart of Waialua, and just a short drive to Haleiwa Town for dining, and entertainment. The nearby polo fields and bike paths add to the relaxed, active North Shore lifestyle.
An excellent opportunity to own in a peaceful, established community—perfect as a primary residence, or investment.
*No flood damage from recent events"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(11) "Hawaii Life"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(8) "51662.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "864"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1975"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(9) "Ono Vista"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(13) "Other,Sunrise"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(7) "1079.00"
  }
  ["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) "HLRE"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(27) "jordanrussum@hawaiilife.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(800) 667-5028"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(13) "Jordan Russum"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19344753"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-04-13T10:09:32.230"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-03-25"
  }
  ["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) "10:09:32.230"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27341902"
  }
  ["listing_image"]=>
  array(25) {
    [0]=>
    string(8) "27341902"
    [1]=>
    string(8) "27341903"
    [2]=>
    string(8) "27341904"
    [3]=>
    string(8) "27341905"
    [4]=>
    string(8) "27341906"
    [5]=>
    string(8) "27341907"
    [6]=>
    string(8) "27341908"
    [7]=>
    string(8) "27341909"
    [8]=>
    string(8) "27341910"
    [9]=>
    string(8) "27341911"
    [10]=>
    string(8) "27341912"
    [11]=>
    string(8) "27341913"
    [12]=>
    string(8) "27341914"
    [13]=>
    string(8) "27341915"
    [14]=>
    string(8) "27341916"
    [15]=>
    string(8) "27341917"
    [16]=>
    string(8) "27341918"
    [17]=>
    string(8) "27341919"
    [18]=>
    string(8) "27341920"
    [19]=>
    string(8) "27341921"
    [20]=>
    string(8) "27341922"
    [21]=>
    string(8) "27341923"
    [22]=>
    string(8) "27341924"
    [23]=>
    string(8) "27341925"
    [24]=>
    string(8) "27341926"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202605937
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Enjoy the best of North Shore living in this charming 2-bedroom, 1-bath condo in the desirable Ono Vista community in Waialua. This partially renovated, two-level unit features an upgraded kitchen and bathroom, a functional layout, and beautiful garden, mountain, and ocean views.
Seller has a VA Assumable loan at a 3.75% interest rate (Subject to lender approval)
With 788 sq ft of interior living space plus a spacious lanai, there’s plenty of room to relax and unwind. The unit also includes the rare convenience of two assigned parking stalls.
Ono Vista is a well-managed community offering great amenities including a saltwater pool, extra-large sauna, resident manager, and secured entry. Ideally located just moments from Waialua Beach Park, you’ll enjoy easy access to swimming, snorkeling, and surfing at nearby breaks.
Conveniently situated in the heart of Waialua, and just a short drive to Haleiwa Town for dining, and entertainment. The nearby polo fields and bike paths add to the relaxed, active North Shore lifestyle.
An excellent opportunity to own in a peaceful, established community—perfect as a primary residence, or investment.
*No flood damage from recent events
        )

    [ListOfficeName] => Array
        (
            [0] => Hawaii Life
        )

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

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

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

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

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

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

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

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

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

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

    [View] => Array
        (
            [0] => Other,Sunrise
        )

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => jordanrussum@hawaiilife.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (800) 667-5028
        )

    [ListAgentFullName] => Array
        (
            [0] => Jordan Russum
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-04-13T10:09:32.230
        )

    [ListingContractDate] => Array
        (
            [0] => 2026-03-25
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 10:09:32.230
        )

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

    [listing_image] => Array
        (
            [0] => 27341902
            [1] => 27341903
            [2] => 27341904
            [3] => 27341905
            [4] => 27341906
            [5] => 27341907
            [6] => 27341908
            [7] => 27341909
            [8] => 27341910
            [9] => 27341911
            [10] => 27341912
            [11] => 27341913
            [12] => 27341914
            [13] => 27341915
            [14] => 27341916
            [15] => 27341917
            [16] => 27341918
            [17] => 27341919
            [18] => 27341920
            [19] => 27341921
            [20] => 27341922
            [21] => 27341923
            [22] => 27341924
            [23] => 27341925
            [24] => 27341926
        )

)

  • BedsTotal: 2
  • Full Baths: 1
  • Land Area (sf): 51,662 sf
  • Living (sf): 864
  • Year Built: 1975
  • Building Name: Ono Vista

  • Property Condition: Above Average
  • Number of Parking Spaces: 2
  • View: Other,Sunrise
  • Listing Office: Hawaii Life

  • Maintenance Fees: $1,079
  • Land Tenure: FS - Fee Simple

  • 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 April 13, 2026 - 10:09 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.

© Marcus Realty. All Rights Reserved.