68-24 Apuhihi Street Unit 104 Waialua, HI 96791

Listing
Overview

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

Beatiful Waialua Beach Community awaits at Ono Vista, just steps to the beach with a pool on property. Conviently located just 5min drive from Haleiwa town, 15min to Schofield Barracks/Wahiawa/Mililani & 50min to Honolulu. Come see the interior custom upgrades and lovely neighborhood atmosphere on this part of the North Shore. Aweoweo Beach Park with playground and basketball court is just a short walking distance away. Listing by: Hawaii Seaside Realty (808) 371-4641

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202517977"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(5) "68-24"
  }
  ["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(3) "104"
  }
  ["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) "435000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIALUA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(424) "Beatiful Waialua Beach Community awaits at Ono Vista, just steps to the beach with a pool on property.  Conviently located just 5min drive from Haleiwa town, 15min to Schofield Barracks/Wahiawa/Mililani & 50min to Honolulu. Come see the interior custom upgrades and lovely neighborhood atmosphere on this part of the North Shore. Aweoweo Beach Park with playground and basketball court is just a short walking distance away."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(21) "Hawaii Seaside 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) "51662.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "736"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1975"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(9) "Ono Vista"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(7) "Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(6) "Garden"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(7) "1077.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) "HISR"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(24) "rockyhiseaside@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 371-4641"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(16) "Rockwell K Canon"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18922124"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-08-13T17:18:41.130"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-08-13"
  }
  ["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) "17:18:41.130"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27107382"
  }
  ["listing_image"]=>
  array(2) {
    [0]=>
    string(8) "27107382"
    [1]=>
    string(8) "27107383"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202517977
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Beatiful Waialua Beach Community awaits at Ono Vista, just steps to the beach with a pool on property.  Conviently located just 5min drive from Haleiwa town, 15min to Schofield Barracks/Wahiawa/Mililani & 50min to Honolulu. Come see the interior custom upgrades and lovely neighborhood atmosphere on this part of the North Shore. Aweoweo Beach Park with playground and basketball court is just a short walking distance away.
        )

    [ListOfficeName] => Array
        (
            [0] => Hawaii Seaside Realty
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => rockyhiseaside@gmail.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 371-4641
        )

    [ListAgentFullName] => Array
        (
            [0] => Rockwell K Canon
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-08-13T17:18:41.130
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-08-13
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 17:18:41.130
        )

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

    [listing_image] => Array
        (
            [0] => 27107382
            [1] => 27107383
        )

)

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

  • Property Condition: Average
  • Number of Parking Spaces: 1
  • View: Garden
  • Listing Office: Hawaii Seaside Realty

  • Maintenance Fees: $1,077
  • 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 August 13, 2025 - 5:18 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.