Previous Next

658 Aipuni Street Honolulu, HI 96821

Listing
Overview

Price: $925,000
Area: AINA HAINA AREA
Status: Sold

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202428627"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(3) "658"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(6) "Aipuni"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(8) "Honolulu"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96821"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(9) "925000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(15) "AINA HAINA AREA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(4) "Sold"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(686) "Discover the incredible potential of this home's location on the rarely available Aipuni Street. Situated on a peaceful non-thoroughfare in the hillsides of Aina Haina, it offers stunning natural views. Original Owners built under owner/builder with help from contractors to create their family home. Later in life, it became a rental. This fixer-upper is a blank canvas where you can make the dream home you've always envisioned. With local shops, dining, and beautiful beaches just a short distance away, this is an opportunity you won't want to miss. Imagine the potential of this home that sits quietly on the upper east side of Honolulu.
One or more photos may have been enhanced."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(13) "Marcus Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "7500.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1790"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1962"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(26) "Above Average,Average,Fair"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(20) "Basement,Split Level"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(19) "City,Mountain,Ocean"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(10) "Aina Haina"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(10) "Niu Valley"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(6) "Kalani"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "MARC"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(21) "JoyY@marcushawaii.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 226-0332"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(18) "Joy K Yonemura Oda"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-04-14"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-04-14T09:03:32.550"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18447918"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2024-12-23"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(9) "DiamondHd"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "26814148"
  }
  ["listing_image"]=>
  array(25) {
    [0]=>
    string(8) "26814148"
    [1]=>
    string(8) "26814149"
    [2]=>
    string(8) "26814150"
    [3]=>
    string(8) "26814151"
    [4]=>
    string(8) "26814152"
    [5]=>
    string(8) "26814153"
    [6]=>
    string(8) "26814154"
    [7]=>
    string(8) "26814155"
    [8]=>
    string(8) "26814156"
    [9]=>
    string(8) "26814157"
    [10]=>
    string(8) "26814158"
    [11]=>
    string(8) "26814159"
    [12]=>
    string(8) "26814160"
    [13]=>
    string(8) "26814161"
    [14]=>
    string(8) "26814162"
    [15]=>
    string(8) "26814163"
    [16]=>
    string(8) "26814164"
    [17]=>
    string(8) "26814165"
    [18]=>
    string(8) "26814166"
    [19]=>
    string(8) "26814167"
    [20]=>
    string(8) "26814168"
    [21]=>
    string(8) "26814169"
    [22]=>
    string(8) "26814170"
    [23]=>
    string(8) "26814171"
    [24]=>
    string(8) "26814172"
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "09:03:32.550"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202428627
        )

    [StreetNumber] => Array
        (
            [0] => 658
        )

    [PropertyType] => Array
        (
            [0] => Single Family
        )

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

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

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

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

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

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

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

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

    [Neighbourhood] => Array
        (
            [0] => AINA HAINA AREA
        )

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

    [PublicRemarks] => Array
        (
            [0] => Discover the incredible potential of this home's location on the rarely available Aipuni Street. Situated on a peaceful non-thoroughfare in the hillsides of Aina Haina, it offers stunning natural views. Original Owners built under owner/builder with help from contractors to create their family home. Later in life, it became a rental. This fixer-upper is a blank canvas where you can make the dream home you've always envisioned. With local shops, dining, and beautiful beaches just a short distance away, this is an opportunity you won't want to miss. Imagine the potential of this home that sits quietly on the upper east side of Honolulu.
One or more photos may have been enhanced.
        )

    [ListOfficeName] => Array
        (
            [0] => Marcus Realty
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => JoyY@marcushawaii.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 226-0332
        )

    [ListAgentFullName] => Array
        (
            [0] => Joy K Yonemura Oda
        )

    [CloseDate] => Array
        (
            [0] => 2025-04-14
        )

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-04-14T09:03:32.550
        )

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

    [ListingContractDate] => Array
        (
            [0] => 2024-12-23
        )

    [MLSAreaMajor] => Array
        (
            [0] => DiamondHd
        )

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

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

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

    [listing_image] => Array
        (
            [0] => 26814148
            [1] => 26814149
            [2] => 26814150
            [3] => 26814151
            [4] => 26814152
            [5] => 26814153
            [6] => 26814154
            [7] => 26814155
            [8] => 26814156
            [9] => 26814157
            [10] => 26814158
            [11] => 26814159
            [12] => 26814160
            [13] => 26814161
            [14] => 26814162
            [15] => 26814163
            [16] => 26814164
            [17] => 26814165
            [18] => 26814166
            [19] => 26814167
            [20] => 26814168
            [21] => 26814169
            [22] => 26814170
            [23] => 26814171
            [24] => 26814172
        )

    [MatrixModifiedTime] => Array
        (
            [0] => 09:03:32.550
        )

)

PROPERTY INFO

• BedsTotal: 3
• Full Baths: 2
• Land Area (sf): 7,500 sf
• Living (sf): 1,790
• Year Built: 1962

KEY FEATURES

• Property Condition: Above Average,Average,Fair
• Number of Parking Spaces: 2
• View: City,Mountain,Ocean
• Listing Office: Marcus Realty

FINANCIAL INFO

• Land Tenure: FS - Fee Simple

SCHOOLS

• Elementary School: Aina Haina
• Middle School: Niu Valley
• High School: Kalani

CONTACT US

Joy K Yonemura Oda

(808) 226-0332
JoyY@marcushawaii.com

JoyY@marcushawaii.com

Based on information from the Multiple Listing Service of HiCentral MLS, Ltd. listings last updated on 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.