Previous Next

68-024 Apuhihi Street Unit 301W Waialua, HI 96791

Listing
Overview

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

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202609150"
  }
  ["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) "301W"
  }
  ["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) "535000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIALUA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1116) "Welcome home to Oahu North Shore living at its best.  Located just minutes from the world famous beaches, surf spots, and the charm of historic Hale'iwa Town, the Ono Vista offers the ideal balance of tranquility and convenience. Whether you're looking for a full time residence, weekend retreat, or investment opportunity, this is your chance to own a slice of paradise on Oahu's North Shore. Located on the 3rd floor, this split level townhome with 2 bedrooms, 1 bath & 1 open assigned parking stall is waiting for you.  Enjoy a bright corner unit with extra windows that creates a brighter, more open living environment while enhancing cross ventilation- allowing cool trade winds to flow effortlessly through the home. Welcome home to Oahu North Shore living at its best.  Located just minutes from the world famous beaches, surf spots, and the charm of historic Hale'iwa Town, the Ono Vista offers the ideal balance of tranquility and convenience. Whether you're looking for a full time residence, weekend retreat, or investment opportunity, this is your chance to own a slice of paradise on Oahu's North Shore."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(13) "Locations LLC"
  }
  ["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) "952"
  }
  ["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(0) ""
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(21) "Mountain,Other,Sunset"
  }
  ["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(6) "LOCA05"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(39) "carolina.cristancho@locationshawaii.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 375-1580"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(19) "Carolina Cristancho"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19449090"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-05-28T13:09:57.710"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-05-08"
  }
  ["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) "13:09:57.710"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27385771"
  }
  ["listing_image"]=>
  array(19) {
    [0]=>
    string(8) "27385771"
    [1]=>
    string(8) "27385772"
    [2]=>
    string(8) "27385773"
    [3]=>
    string(8) "27385774"
    [4]=>
    string(8) "27385775"
    [5]=>
    string(8) "27385776"
    [6]=>
    string(8) "27385777"
    [7]=>
    string(8) "27385778"
    [8]=>
    string(8) "27385779"
    [9]=>
    string(8) "27385780"
    [10]=>
    string(8) "27385781"
    [11]=>
    string(8) "27385782"
    [12]=>
    string(8) "27385783"
    [13]=>
    string(8) "27385784"
    [14]=>
    string(8) "27385785"
    [15]=>
    string(8) "27385786"
    [16]=>
    string(8) "27385787"
    [17]=>
    string(8) "27385788"
    [18]=>
    string(8) "27385789"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202609150
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Welcome home to Oahu North Shore living at its best.  Located just minutes from the world famous beaches, surf spots, and the charm of historic Hale'iwa Town, the Ono Vista offers the ideal balance of tranquility and convenience. Whether you're looking for a full time residence, weekend retreat, or investment opportunity, this is your chance to own a slice of paradise on Oahu's North Shore. Located on the 3rd floor, this split level townhome with 2 bedrooms, 1 bath & 1 open assigned parking stall is waiting for you.  Enjoy a bright corner unit with extra windows that creates a brighter, more open living environment while enhancing cross ventilation- allowing cool trade winds to flow effortlessly through the home. Welcome home to Oahu North Shore living at its best.  Located just minutes from the world famous beaches, surf spots, and the charm of historic Hale'iwa Town, the Ono Vista offers the ideal balance of tranquility and convenience. Whether you're looking for a full time residence, weekend retreat, or investment opportunity, this is your chance to own a slice of paradise on Oahu's North Shore.
        )

    [ListOfficeName] => Array
        (
            [0] => Locations LLC
        )

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

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

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

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

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

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

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

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

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

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

    [View] => Array
        (
            [0] => Mountain,Other,Sunset
        )

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => carolina.cristancho@locationshawaii.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 375-1580
        )

    [ListAgentFullName] => Array
        (
            [0] => Carolina Cristancho
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-05-28T13:09:57.710
        )

    [ListingContractDate] => Array
        (
            [0] => 2026-05-08
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 13:09:57.710
        )

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

    [listing_image] => Array
        (
            [0] => 27385771
            [1] => 27385772
            [2] => 27385773
            [3] => 27385774
            [4] => 27385775
            [5] => 27385776
            [6] => 27385777
            [7] => 27385778
            [8] => 27385779
            [9] => 27385780
            [10] => 27385781
            [11] => 27385782
            [12] => 27385783
            [13] => 27385784
            [14] => 27385785
            [15] => 27385786
            [16] => 27385787
            [17] => 27385788
            [18] => 27385789
        )

)

PROPERTY INFO

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

KEY FEATURES

• Property Condition: Excellent,Above Average
• Number of Parking Spaces: 1
• View: Mountain,Other,Sunset
• Listing Office: Locations LLC

FINANCIAL INFO

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

SCHOOLS

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 May 28, 2026 - 1:09 PM 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.