Previous Next

95-2027 Waikalani Place Unit A404 Mililani, HI 96789

Listing
Overview

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

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202517964"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(7) "95-2027"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(15) "Condo/Townhouse"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(9) "Waikalani"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(5) "Place"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(4) "A404"
  }
  ["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) "535000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(32) "WAIPIO ACRES/WAIKALANI WOODLANDS"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1197) "**SELLER offering a credit of $10,000 for Closing Costs**  
Stunningly Remodeled in 2023, Top-Floor, Corner Unit, No Stairs or Elevator Needed! Welcome to this three-bedroom, two-bathroom corner unit, with two assigned parking stalls. This home has been upgraded with high-end finishes, offering the perfect blend of style, comfort, & functionality. As you enter, you'll be greeted by the sleek stainless steel appliances & quartz countertops in the kitchen. The under-mount sinks & premium hardware throughout the kitchen & bathrooms highlight the meticulous attention to detail that went into the renovation. The spacious bedrooms feature ample closet space for easy organization, while the bathrooms exude luxury with a walk-in shower in the primary bath & sophisticated finishes. For added convenience, this unit comes with an in-unit washer/dryer, making daily chores a breeze. Step outside to enjoy not one, but two separate lanais perfect for sipping your morning coffee as you listen to the peaceful stream below, or unwinding with a glass of wine while surrounded by natures tranquility. This meticulously designed unit is a true gem. Don't miss the opportunity to call it your new home!"
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(23) "Century 21 Island Homes"
  }
  ["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(9) "170145.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1224"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1973"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(19) "Northbrook-Melemanu"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(9) "Excellent"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "4-7"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(6) "Garden"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(7) "1312.20"
  }
  ["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(6) "CENI03"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(25) "Deanna@C21islandhomes.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 382-9400"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(16) "Deanna L Cordier"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18921699"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-08-13T18:00:01.987"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-08-13"
  }
  ["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) "18:00:01.987"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27107404"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "27107404"
    [1]=>
    string(8) "27107405"
    [2]=>
    string(8) "27107406"
    [3]=>
    string(8) "27107407"
    [4]=>
    string(8) "27107408"
    [5]=>
    string(8) "27107409"
    [6]=>
    string(8) "27107410"
    [7]=>
    string(8) "27107411"
    [8]=>
    string(8) "27107412"
    [9]=>
    string(8) "27107413"
    [10]=>
    string(8) "27107414"
    [11]=>
    string(8) "27107415"
    [12]=>
    string(8) "27107416"
    [13]=>
    string(8) "27107417"
    [14]=>
    string(8) "27107418"
    [15]=>
    string(8) "27107419"
    [16]=>
    string(8) "27107420"
    [17]=>
    string(8) "27107421"
    [18]=>
    string(8) "27107422"
    [19]=>
    string(8) "27107423"
    [20]=>
    string(8) "27107424"
    [21]=>
    string(8) "27107425"
    [22]=>
    string(8) "27107426"
    [23]=>
    string(8) "27107427"
    [24]=>
    string(8) "27107428"
    [25]=>
    string(8) "27107429"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202517964
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => **SELLER offering a credit of $10,000 for Closing Costs**  
Stunningly Remodeled in 2023, Top-Floor, Corner Unit, No Stairs or Elevator Needed! Welcome to this three-bedroom, two-bathroom corner unit, with two assigned parking stalls. This home has been upgraded with high-end finishes, offering the perfect blend of style, comfort, & functionality. As you enter, you'll be greeted by the sleek stainless steel appliances & quartz countertops in the kitchen. The under-mount sinks & premium hardware throughout the kitchen & bathrooms highlight the meticulous attention to detail that went into the renovation. The spacious bedrooms feature ample closet space for easy organization, while the bathrooms exude luxury with a walk-in shower in the primary bath & sophisticated finishes. For added convenience, this unit comes with an in-unit washer/dryer, making daily chores a breeze. Step outside to enjoy not one, but two separate lanais perfect for sipping your morning coffee as you listen to the peaceful stream below, or unwinding with a glass of wine while surrounded by natures tranquility. This meticulously designed unit is a true gem. Don't miss the opportunity to call it your new home!
        )

    [ListOfficeName] => Array
        (
            [0] => Century 21 Island Homes
        )

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

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

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

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

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

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

    [BuildingName] => Array
        (
            [0] => Northbrook-Melemanu
        )

    [PropertyCondition] => Array
        (
            [0] => Excellent
        )

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

    [StoriesType] => Array
        (
            [0] => 4-7
        )

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => Deanna@C21islandhomes.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 382-9400
        )

    [ListAgentFullName] => Array
        (
            [0] => Deanna L Cordier
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-08-13T18:00:01.987
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-08-13
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 18:00:01.987
        )

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

    [listing_image] => Array
        (
            [0] => 27107404
            [1] => 27107405
            [2] => 27107406
            [3] => 27107407
            [4] => 27107408
            [5] => 27107409
            [6] => 27107410
            [7] => 27107411
            [8] => 27107412
            [9] => 27107413
            [10] => 27107414
            [11] => 27107415
            [12] => 27107416
            [13] => 27107417
            [14] => 27107418
            [15] => 27107419
            [16] => 27107420
            [17] => 27107421
            [18] => 27107422
            [19] => 27107423
            [20] => 27107424
            [21] => 27107425
            [22] => 27107426
            [23] => 27107427
            [24] => 27107428
            [25] => 27107429
        )

)

PROPERTY INFO

• BedsTotal: 3
• Full Baths: 2
• Land Area (sf): 170,145 sf
• Living (sf): 1,224
• Year Built: 1973
• Building Name: Northbrook-Melemanu

KEY FEATURES

• Property Condition: Excellent
• Number of Parking Spaces: 2
• View: Garden
• Listing Office: Century 21 Island Homes

FINANCIAL INFO

• Maintenance Fees: $1,312
• 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 August 13, 2025 - 6: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.