95-23 Waihau Street Unit D133 Mililani, HI 96789

Listing
Overview

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

Enjoy the perfect blend of comfort and convenience in this move-in ready ground-floor 2-bedroom, 1-bath unit—ideal for first-time buyers or investors seeking great value. Ideally located near Schofield Barracks and Wheeler Air Force Base, you can skip the long commute and come home to relax and enjoy island living. Close to shopping centers, restaurants, 24 Hour Fitness, Costco, and Leilehua Golf Course—everything you need is nearby. With a great price, low maintenance fees, and easy access to major routes, this home is a rare find! Listing by: Coldwell Banker Realty (808) 479-1276

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202524578"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(5) "95-23"
  }
  ["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(4) "D133"
  }
  ["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(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(9) "345000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(32) "WAIPIO ACRES/WAIKALANI WOODLANDS"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(542) "Enjoy the perfect blend of comfort and convenience in this move-in ready ground-floor 2-bedroom, 1-bath unit—ideal for first-time buyers or investors seeking great value. Ideally located near Schofield Barracks and Wheeler Air Force Base, you can skip the long commute and come home to relax and enjoy island living. Close to shopping centers, restaurants, 24 Hour Fitness, Costco, and Leilehua Golf Course—everything you need is nearby. With a great price, low maintenance fees, and easy access to major routes, this home is a rare find!"
  }
  ["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) "57499.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "620"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1962"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(10) "Waipiolani"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "Two"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "363.80"
  }
  ["LandTenure"]=>
  array(1) {
    [0]=>
    string(15) "FS - Fee Simple"
  }
  ["ElementarySchool"]=>
  array(1) {
    [0]=>
    string(6) "Kipapa"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(8) "Mililani"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(8) "Mililani"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(6) "CBPP02"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(27) "susan.dacoscos@cbrealty.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 479-1276"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(16) "Susan B Dacoscos"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19074288"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-11-09T17:00:01.503"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-11-03"
  }
  ["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) "17:00:01.503"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27208114"
  }
  ["listing_image"]=>
  array(20) {
    [0]=>
    string(8) "27208114"
    [1]=>
    string(8) "27208115"
    [2]=>
    string(8) "27208116"
    [3]=>
    string(8) "27208117"
    [4]=>
    string(8) "27208118"
    [5]=>
    string(8) "27208119"
    [6]=>
    string(8) "27208120"
    [7]=>
    string(8) "27208121"
    [8]=>
    string(8) "27208122"
    [9]=>
    string(8) "27208123"
    [10]=>
    string(8) "27208124"
    [11]=>
    string(8) "27208125"
    [12]=>
    string(8) "27208126"
    [13]=>
    string(8) "27208127"
    [14]=>
    string(8) "27208128"
    [15]=>
    string(8) "27208129"
    [16]=>
    string(8) "27208130"
    [17]=>
    string(8) "27208131"
    [18]=>
    string(8) "27208132"
    [19]=>
    string(8) "27208133"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202524578
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Enjoy the perfect blend of comfort and convenience in this move-in ready ground-floor 2-bedroom, 1-bath unit—ideal for first-time buyers or investors seeking great value. Ideally located near Schofield Barracks and Wheeler Air Force Base, you can skip the long commute and come home to relax and enjoy island living. Close to shopping centers, restaurants, 24 Hour Fitness, Costco, and Leilehua Golf Course—everything you need is nearby. With a great price, low maintenance fees, and easy access to major routes, this home is a rare find!
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => susan.dacoscos@cbrealty.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 479-1276
        )

    [ListAgentFullName] => Array
        (
            [0] => Susan B Dacoscos
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-11-09T17:00:01.503
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-11-03
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 17:00:01.503
        )

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

    [listing_image] => Array
        (
            [0] => 27208114
            [1] => 27208115
            [2] => 27208116
            [3] => 27208117
            [4] => 27208118
            [5] => 27208119
            [6] => 27208120
            [7] => 27208121
            [8] => 27208122
            [9] => 27208123
            [10] => 27208124
            [11] => 27208125
            [12] => 27208126
            [13] => 27208127
            [14] => 27208128
            [15] => 27208129
            [16] => 27208130
            [17] => 27208131
            [18] => 27208132
            [19] => 27208133
        )

)

  • BedsTotal: 2
  • Full Baths: 1
  • Land Area (sf): 57,499 sf
  • Living (sf): 620
  • Year Built: 1962
  • Building Name: Waipiolani

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

  • Maintenance Fees: $364
  • Land Tenure: FS - Fee Simple

  • Elementary School: Kipapa
  • Middle School: Mililani
  • High School: Mililani

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 November 9, 2025 - 5:00 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.