68-024 Apuhihi Street Unit W503 Waialua, HI 96791

Listing
Overview

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

Experience coastal living in this beautifully updated 2-bedroom, 1-bath condominium in the Ono Vista community of Waialua. This move-in ready home features thoughtful upgrades throughout, including sleek quartz countertops, fresh interior paint, recessed lighting, and durable vinyl flooring that enhances both style and function. A screened-in lanai extends the living area, creating a versatile space for relaxing, dining, or enjoying the tradewinds. The primary bedroom offers a custom closet designed for efficient storage, and the unit captures pleasant mount Ka'ala views. Ono Vista is a well-maintained community with a swimming pool and convenient access to nearby beaches. This updated condo presents an excellent opportunity for those seeking a clean, modern space in a highly desired North Shore setting. Listing by: REMAX Hawaii North Shore (808) 741-3835 

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202526132"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "68-024"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(15) "Condo/Townhouse"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(7) "Apuhihi"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(4) "W503"
  }
  ["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) "560000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIALUA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(815) "Experience coastal living in this beautifully updated 2-bedroom, 1-bath condominium in the Ono Vista community of Waialua. This move-in ready home features thoughtful upgrades throughout, including sleek quartz countertops, fresh interior paint, recessed lighting, and durable vinyl flooring that enhances both style and function. A screened-in lanai extends the living area, creating a versatile space for relaxing, dining, or enjoying the tradewinds. The primary bedroom offers a custom closet designed for efficient storage, and the unit captures pleasant mount Ka'ala views. Ono Vista is a well-maintained community with a swimming pool and convenient access to nearby beaches. This updated condo presents an excellent opportunity for those seeking a clean, modern space in a highly desired North Shore setting."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(24) "REMAX Hawaii North Shore"
  }
  ["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(0) ""
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "788"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1975"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(9) "Ono Vista"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(23) "Excellent,Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(8) "Mountain"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(7) "1134.05"
  }
  ["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) "ADNS"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(26) "Meme.Moody@remaxhawaii.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 741-3835"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(10) "Meme Moody"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-03-02"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19138129"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-03-04T10:34:06.457"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-12-01"
  }
  ["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:34:06.457"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27234315"
  }
  ["listing_image"]=>
  array(17) {
    [0]=>
    string(8) "27234315"
    [1]=>
    string(8) "27234316"
    [2]=>
    string(8) "27234317"
    [3]=>
    string(8) "27234318"
    [4]=>
    string(8) "27234319"
    [5]=>
    string(8) "27234320"
    [6]=>
    string(8) "27234321"
    [7]=>
    string(8) "27234322"
    [8]=>
    string(8) "27234323"
    [9]=>
    string(8) "27234324"
    [10]=>
    string(8) "27234325"
    [11]=>
    string(8) "27234326"
    [12]=>
    string(8) "27234327"
    [13]=>
    string(8) "27234328"
    [14]=>
    string(8) "27234329"
    [15]=>
    string(8) "27234330"
    [16]=>
    string(8) "27234331"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202526132
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Experience coastal living in this beautifully updated 2-bedroom, 1-bath condominium in the Ono Vista community of Waialua. This move-in ready home features thoughtful upgrades throughout, including sleek quartz countertops, fresh interior paint, recessed lighting, and durable vinyl flooring that enhances both style and function. A screened-in lanai extends the living area, creating a versatile space for relaxing, dining, or enjoying the tradewinds. The primary bedroom offers a custom closet designed for efficient storage, and the unit captures pleasant mount Ka'ala views. Ono Vista is a well-maintained community with a swimming pool and convenient access to nearby beaches. This updated condo presents an excellent opportunity for those seeking a clean, modern space in a highly desired North Shore setting.
        )

    [ListOfficeName] => Array
        (
            [0] => REMAX Hawaii North Shore
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => Meme.Moody@remaxhawaii.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 741-3835
        )

    [ListAgentFullName] => Array
        (
            [0] => Meme Moody
        )

    [CloseDate] => Array
        (
            [0] => 2026-03-02
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-03-04T10:34:06.457
        )

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

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 10:34:06.457
        )

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

    [listing_image] => Array
        (
            [0] => 27234315
            [1] => 27234316
            [2] => 27234317
            [3] => 27234318
            [4] => 27234319
            [5] => 27234320
            [6] => 27234321
            [7] => 27234322
            [8] => 27234323
            [9] => 27234324
            [10] => 27234325
            [11] => 27234326
            [12] => 27234327
            [13] => 27234328
            [14] => 27234329
            [15] => 27234330
            [16] => 27234331
        )

)

  • BedsTotal: 2
  • Full Baths: 1
  • Living (sf): 788
  • Year Built: 1975
  • Building Name: Ono Vista

  • Property Condition: Excellent,Above Average
  • Number of Parking Spaces: 1
  • View: Mountain
  • Listing Office: REMAX Hawaii North Shore

  • Maintenance Fees: $1,134
  • 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 4, 2026 - 10:34 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.

Terms of Use Privacy Policy DMCA Policy
© Marcus Realty. All Rights Reserved.