Previous Next

68-024 Apuhihi Street Unit W511 Waialua, HI 96791

Take a Virtual Tour

Listing
Overview

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

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202512044"
  }
  ["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) "W511"
  }
  ["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(52) "https://68-024-apuhihi-511w.showthisproperty.com/mls"
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(9) "599000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "WAIALUA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1197) "Owner Financing Available! 
This beautifully remodeled split-level condo features 2 bed/1 bath, perfectly situated one block from the stunning sandy beaches of the North Shore. Ideal for swimming, snorkeling, and sunbathing, the nearby barrier reef creates a serene environment for beach lovers year-round. Step inside to discover a bright, spacious, and quiet ambiance. Enjoy privacy, as this unit is at the opposite end of the elevator and top floor, offering a tranquil retreat. With a fresh coat of paint and tasteful furnishings, the unit is turn key. The covered lanai provides breathtaking views of the ocean and Kaena Point, making it the perfect spot to relax. Imagine yourself dining while watching the sky's vibrant sunset colors. The layout of this condo sets it apart from the rest of the complex, featuring an open kitchen and a stylish island/peninsula that enhances both functionality and aesthetics.
As part of the building’s amenities, you'll have access to a refreshing pool and a relaxing sauna. Nestled in a quiet, breezy, and local ocean community, this condo offers a rare blend of beauty, comfort, and affordability. Don’t miss your chance to own a piece of paradise!"
  }
  ["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(9) "Excellent"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(15) "Two,Split Level"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(31) "Coastline,Mountain,Ocean,Sunset"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(7) "1134.05"
  }
  ["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(26) "leanehorton@hawaiilife.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 366-4996"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(12) "Leane Horton"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18747518"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-07-07T11:19:57.037"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-05-14"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(11) "North Shore"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "11:19:57.037"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26996912"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "26996912"
    [1]=>
    string(8) "26996913"
    [2]=>
    string(8) "26996914"
    [3]=>
    string(8) "26996915"
    [4]=>
    string(8) "26996916"
    [5]=>
    string(8) "26996917"
    [6]=>
    string(8) "26996918"
    [7]=>
    string(8) "26996919"
    [8]=>
    string(8) "26996920"
    [9]=>
    string(8) "26996921"
    [10]=>
    string(8) "26996922"
    [11]=>
    string(8) "26996923"
    [12]=>
    string(8) "26996924"
    [13]=>
    string(8) "26996925"
    [14]=>
    string(8) "26996926"
    [15]=>
    string(8) "26996927"
    [16]=>
    string(8) "26996928"
    [17]=>
    string(8) "26996929"
    [18]=>
    string(8) "26996930"
    [19]=>
    string(8) "26996931"
    [20]=>
    string(8) "26996932"
    [21]=>
    string(8) "26996933"
    [22]=>
    string(8) "26996934"
    [23]=>
    string(8) "26996935"
    [24]=>
    string(8) "26996936"
    [25]=>
    string(8) "26997058"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202512044
        )

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

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

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

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

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

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

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

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

    [VirtualTourURLUnbranded] => Array
        (
            [0] => https://68-024-apuhihi-511w.showthisproperty.com/mls
        )

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Owner Financing Available! 
This beautifully remodeled split-level condo features 2 bed/1 bath, perfectly situated one block from the stunning sandy beaches of the North Shore. Ideal for swimming, snorkeling, and sunbathing, the nearby barrier reef creates a serene environment for beach lovers year-round. Step inside to discover a bright, spacious, and quiet ambiance. Enjoy privacy, as this unit is at the opposite end of the elevator and top floor, offering a tranquil retreat. With a fresh coat of paint and tasteful furnishings, the unit is turn key. The covered lanai provides breathtaking views of the ocean and Kaena Point, making it the perfect spot to relax. Imagine yourself dining while watching the sky's vibrant sunset colors. The layout of this condo sets it apart from the rest of the complex, featuring an open kitchen and a stylish island/peninsula that enhances both functionality and aesthetics.
As part of the building’s amenities, you'll have access to a refreshing pool and a relaxing sauna. Nestled in a quiet, breezy, and local ocean community, this condo offers a rare blend of beauty, comfort, and affordability. Don’t miss your chance to own a piece of paradise!
        )

    [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] => Excellent
        )

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

    [StoriesType] => Array
        (
            [0] => Two,Split Level
        )

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

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

    [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] => leanehorton@hawaiilife.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 366-4996
        )

    [ListAgentFullName] => Array
        (
            [0] => Leane Horton
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-07-07T11:19:57.037
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-05-14
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 11:19:57.037
        )

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

    [listing_image] => Array
        (
            [0] => 26996912
            [1] => 26996913
            [2] => 26996914
            [3] => 26996915
            [4] => 26996916
            [5] => 26996917
            [6] => 26996918
            [7] => 26996919
            [8] => 26996920
            [9] => 26996921
            [10] => 26996922
            [11] => 26996923
            [12] => 26996924
            [13] => 26996925
            [14] => 26996926
            [15] => 26996927
            [16] => 26996928
            [17] => 26996929
            [18] => 26996930
            [19] => 26996931
            [20] => 26996932
            [21] => 26996933
            [22] => 26996934
            [23] => 26996935
            [24] => 26996936
            [25] => 26997058
        )

)

PROPERTY INFO

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

KEY FEATURES

• Property Condition: Excellent
• Number of Parking Spaces: 1
• View: Coastline,Mountain,Ocean,Sunset
• Listing Office: Hawaii Life

FINANCIAL INFO

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

SCHOOLS

• 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 July 7, 2025 - 11:19 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.