Previous Next

95-024 Waihau Street Unit 17A Mililani, HI 96789

Take a Virtual Tour

Listing
Overview

Price: $339,000
Area: WAIPIO ACRES/WAIKALANI WOODLANDS
Status: Active

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202527808"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "95-024"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(15) "Condo/Townhouse"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(6) "Waihau"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(3) "17A"
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(8) "Mililani"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96789"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(51) "https://my.matterport.com/show/?m=1KQiNUQbffU&mls=1"
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(9) "339000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(32) "WAIPIO ACRES/WAIKALANI WOODLANDS"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(797) "Welcome home to Waipio Gardens, where comfort and convenience meet in this desirable 2-bedroom, 1-bathroom corner-end ground-floor unit with parking, attractively priced at $339,000—offering excellent value in today’s market. This residence has been tastefully updated with newer flooring, refreshed cabinetry and countertops, and the removal of the popcorn ceiling, creating a clean and modern living space. The preferred corner location provides added privacy and natural light, while the ground-floor setting allows for easy access and everyday convenience. Ideally situated near Schofield Barracks, Wheeler Army Airfield, Mililani Golf Club, and Mililani Shopping Center, this move-in-ready home is perfect for owner-occupants or investors seeking a well-located Central O?ahu opportunity."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["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) "89080.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "682"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1965"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(14) "Waipio Gardens"
  }
  ["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(4) "None"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "679.55"
  }
  ["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) "CBPP"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(30) "andrew.leitheiser@cbrealty.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 781-5378"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(19) "Andrew J Leitheiser"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19167933"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-12-21T07:45:01.367"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-12-15"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Central"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "07:45:01.367"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27246201"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "27246201"
    [1]=>
    string(8) "27246202"
    [2]=>
    string(8) "27246203"
    [3]=>
    string(8) "27246204"
    [4]=>
    string(8) "27246205"
    [5]=>
    string(8) "27246206"
    [6]=>
    string(8) "27246207"
    [7]=>
    string(8) "27246208"
    [8]=>
    string(8) "27246209"
    [9]=>
    string(8) "27246210"
    [10]=>
    string(8) "27246211"
    [11]=>
    string(8) "27246212"
    [12]=>
    string(8) "27246213"
    [13]=>
    string(8) "27246214"
    [14]=>
    string(8) "27246215"
    [15]=>
    string(8) "27246216"
    [16]=>
    string(8) "27246217"
    [17]=>
    string(8) "27246218"
    [18]=>
    string(8) "27246219"
    [19]=>
    string(8) "27246220"
    [20]=>
    string(8) "27246221"
    [21]=>
    string(8) "27246222"
    [22]=>
    string(8) "27246223"
    [23]=>
    string(8) "27246224"
    [24]=>
    string(8) "27246225"
    [25]=>
    string(8) "27246226"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202527808
        )

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

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

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

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

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

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

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

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

    [VirtualTourURLUnbranded] => Array
        (
            [0] => https://my.matterport.com/show/?m=1KQiNUQbffU&mls=1
        )

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

    [Neighbourhood] => Array
        (
            [0] => WAIPIO ACRES/WAIKALANI WOODLANDS
        )

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

    [PublicRemarks] => Array
        (
            [0] => Welcome home to Waipio Gardens, where comfort and convenience meet in this desirable 2-bedroom, 1-bathroom corner-end ground-floor unit with parking, attractively priced at $339,000—offering excellent value in today’s market. This residence has been tastefully updated with newer flooring, refreshed cabinetry and countertops, and the removal of the popcorn ceiling, creating a clean and modern living space. The preferred corner location provides added privacy and natural light, while the ground-floor setting allows for easy access and everyday convenience. Ideally situated near Schofield Barracks, Wheeler Army Airfield, Mililani Golf Club, and Mililani Shopping Center, this move-in-ready home is perfect for owner-occupants or investors seeking a well-located Central O?ahu opportunity.
        )

    [ListOfficeName] => Array
        (
            [0] => Coldwell Banker Realty
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => andrew.leitheiser@cbrealty.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 781-5378
        )

    [ListAgentFullName] => Array
        (
            [0] => Andrew J Leitheiser
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-12-21T07:45:01.367
        )

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

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 07:45:01.367
        )

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

    [listing_image] => Array
        (
            [0] => 27246201
            [1] => 27246202
            [2] => 27246203
            [3] => 27246204
            [4] => 27246205
            [5] => 27246206
            [6] => 27246207
            [7] => 27246208
            [8] => 27246209
            [9] => 27246210
            [10] => 27246211
            [11] => 27246212
            [12] => 27246213
            [13] => 27246214
            [14] => 27246215
            [15] => 27246216
            [16] => 27246217
            [17] => 27246218
            [18] => 27246219
            [19] => 27246220
            [20] => 27246221
            [21] => 27246222
            [22] => 27246223
            [23] => 27246224
            [24] => 27246225
            [25] => 27246226
        )

)

PROPERTY INFO

• BedsTotal: 2
• Full Baths: 1
• Land Area (sf): 89,080 sf
• Living (sf): 682
• Year Built: 1965
• Building Name: Waipio Gardens

KEY FEATURES

• Property Condition: Excellent,Above Average
• Number of Parking Spaces: 1
• View: None
• Listing Office: Coldwell Banker Realty

FINANCIAL INFO

• Maintenance Fees: $680
• 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 December 21, 2025 - 7:45 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.