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

Listing
Overview

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

Ideal Starter Home VA & USDA Eligible! This is more than just a home—it’s a smart investment in your future. Whether you’re a first-time buyer or looking for a great opportunity near base, this is the place for you! Discover this newly updated 2-bedroom, 1-bath home nestled in the cooler climates of Mililani, perfectly positioned between Mililani Town and Wahiawa. Just minutes from Schofield Barracks and Wheeler Army Airfield with easy Access to H-2 Freeway, this unit is ideal for military members looking to maximize their BAH and invest in homeownership. Step inside to find brand-new flooring, modern kitchen cabinets, updated bathroom shower and a full-sized washer and dryer for ultimate convenience. 4k Vava projector and 120" projection screen included for your enjoyment. Extra perk! Building is equipped with PV Solar and electricity is sub-metered to occupant. Listing by: Soldier To Soldier HI Realty (808) 683-8244

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202512238"
  }
  ["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) "16A"
  }
  ["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) "325000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(32) "WAIPIO ACRES/WAIKALANI WOODLANDS"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(881) "Ideal Starter Home VA & USDA Eligible! This is more than just a home—it’s a smart investment in your future. Whether you’re a first-time buyer or looking for a great opportunity near base, this is the place for you! Discover this newly updated 2-bedroom, 1-bath home nestled in the cooler climates of Mililani, perfectly positioned between Mililani Town and Wahiawa. Just minutes from Schofield Barracks and Wheeler Army Airfield with easy Access to H-2 Freeway, this unit is ideal for military members looking to maximize their BAH and invest in homeownership. Step inside to find brand-new flooring, modern kitchen cabinets, updated bathroom shower and a full-sized washer and dryer for ultimate convenience. 4k Vava projector and 120" projection screen included for your enjoyment. Extra perk! Building is equipped with PV Solar and electricity is sub-metered to occupant."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(28) "Soldier To Soldier HI 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(13) "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) "770.00"
  }
  ["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) "STSH"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(27) "BarbaraDeLucca808@gmail.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 683-8244"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(16) "Barbara De Lucca"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18753147"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-07-27T16:00:02.100"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-05-16"
  }
  ["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) "16:00:02.100"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27000613"
  }
  ["listing_image"]=>
  array(16) {
    [0]=>
    string(8) "27000613"
    [1]=>
    string(8) "27000614"
    [2]=>
    string(8) "27000615"
    [3]=>
    string(8) "27000616"
    [4]=>
    string(8) "27000617"
    [5]=>
    string(8) "27000618"
    [6]=>
    string(8) "27000619"
    [7]=>
    string(8) "27000620"
    [8]=>
    string(8) "27000621"
    [9]=>
    string(8) "27000622"
    [10]=>
    string(8) "27000623"
    [11]=>
    string(8) "27000624"
    [12]=>
    string(8) "27000625"
    [13]=>
    string(8) "27000626"
    [14]=>
    string(8) "27000627"
    [15]=>
    string(8) "27000628"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202512238
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Ideal Starter Home VA & USDA Eligible! This is more than just a home—it’s a smart investment in your future. Whether you’re a first-time buyer or looking for a great opportunity near base, this is the place for you! Discover this newly updated 2-bedroom, 1-bath home nestled in the cooler climates of Mililani, perfectly positioned between Mililani Town and Wahiawa. Just minutes from Schofield Barracks and Wheeler Army Airfield with easy Access to H-2 Freeway, this unit is ideal for military members looking to maximize their BAH and invest in homeownership. Step inside to find brand-new flooring, modern kitchen cabinets, updated bathroom shower and a full-sized washer and dryer for ultimate convenience. 4k Vava projector and 120" projection screen included for your enjoyment. Extra perk! Building is equipped with PV Solar and electricity is sub-metered to occupant.
        )

    [ListOfficeName] => Array
        (
            [0] => Soldier To Soldier HI 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] => Above Average
        )

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => BarbaraDeLucca808@gmail.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 683-8244
        )

    [ListAgentFullName] => Array
        (
            [0] => Barbara De Lucca
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-07-27T16:00:02.100
        )

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

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 16:00:02.100
        )

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

    [listing_image] => Array
        (
            [0] => 27000613
            [1] => 27000614
            [2] => 27000615
            [3] => 27000616
            [4] => 27000617
            [5] => 27000618
            [6] => 27000619
            [7] => 27000620
            [8] => 27000621
            [9] => 27000622
            [10] => 27000623
            [11] => 27000624
            [12] => 27000625
            [13] => 27000626
            [14] => 27000627
            [15] => 27000628
        )

)

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

  • Property Condition: Above Average
  • Number of Parking Spaces: 1
  • View: None
  • Listing Office: Soldier To Soldier HI Realty

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

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 27, 2025 - 4: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.