Previous Next

95-2048 Waikalani Place Unit D205 Mililani, HI 96789

Listing
Overview

Price: $450,000
Area: WAIPIO ACRES/WAIKALANI WOODLANDS
Status: Active Under Contract

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202607423"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(7) "95-2048"
  }
  ["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) "D205"
  }
  ["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) "450000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(32) "WAIPIO ACRES/WAIKALANI WOODLANDS"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(21) "Active Under Contract"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1037) "VA assumable opportunity with a very low gap in desirable Ridgecrest-Melemanu! This 2-bedroom, 1-bath, 799 sq ft unit offers added
privacy with no rear neighbors and includes a covered lanai and one assigned covered parking stall. Thoughtfully upgraded with new vinyl flooring throughout, fresh interior paint, white shaker cabinets to the ceiling, quartz countertops, and a beautifully renovated bathroom. The kitchen is equipped with stainless steel appliances, including a full-size washer and dryer. Custom entertainment center with flush-mounted 65” TV conveys. Assumable VA loan features a 3.75% interest rate, approximately $407,000 remaining balance, and estimated monthly payment of $2,208. Loan serviced by Mr. Cooper; assumption available to qualified Veteran with COE. Well-managed community with low maintenance fees and strong association. Centrally located in Mililani with convenient access to Schofield Barracks, shopping, dining, and freeway access. Ideal for owner-occupants seeking value, efficiency, and location."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(27) "Coldwell Banker Island Prop"
  }
  ["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(9) "249076.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(3) "896"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1973"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(19) "Ridgecrest-Melemanu"
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(15) "Garden,Mountain"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(6) "480.00"
  }
  ["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) "CBIP04"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(17) "aytescd@yahoo.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 232-9460"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(13) "Casey D Aytes"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19385846"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-04-22T06:40:44.407"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-04-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) "06:40:44.407"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27360446"
  }
  ["listing_image"]=>
  array(22) {
    [0]=>
    string(8) "27360446"
    [1]=>
    string(8) "27360447"
    [2]=>
    string(8) "27360448"
    [3]=>
    string(8) "27360449"
    [4]=>
    string(8) "27360450"
    [5]=>
    string(8) "27360451"
    [6]=>
    string(8) "27360452"
    [7]=>
    string(8) "27360453"
    [8]=>
    string(8) "27360454"
    [9]=>
    string(8) "27360455"
    [10]=>
    string(8) "27360456"
    [11]=>
    string(8) "27360457"
    [12]=>
    string(8) "27360458"
    [13]=>
    string(8) "27360459"
    [14]=>
    string(8) "27360460"
    [15]=>
    string(8) "27360461"
    [16]=>
    string(8) "27360462"
    [17]=>
    string(8) "27360463"
    [18]=>
    string(8) "27360464"
    [19]=>
    string(8) "27360465"
    [20]=>
    string(8) "27360466"
    [21]=>
    string(8) "27360467"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202607423
        )

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

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => VA assumable opportunity with a very low gap in desirable Ridgecrest-Melemanu! This 2-bedroom, 1-bath, 799 sq ft unit offers added
privacy with no rear neighbors and includes a covered lanai and one assigned covered parking stall. Thoughtfully upgraded with new vinyl flooring throughout, fresh interior paint, white shaker cabinets to the ceiling, quartz countertops, and a beautifully renovated bathroom. The kitchen is equipped with stainless steel appliances, including a full-size washer and dryer. Custom entertainment center with flush-mounted 65” TV conveys. Assumable VA loan features a 3.75% interest rate, approximately $407,000 remaining balance, and estimated monthly payment of $2,208. Loan serviced by Mr. Cooper; assumption available to qualified Veteran with COE. Well-managed community with low maintenance fees and strong association. Centrally located in Mililani with convenient access to Schofield Barracks, shopping, dining, and freeway access. Ideal for owner-occupants seeking value, efficiency, and location.
        )

    [ListOfficeName] => Array
        (
            [0] => Coldwell Banker Island Prop
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => aytescd@yahoo.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 232-9460
        )

    [ListAgentFullName] => Array
        (
            [0] => Casey D Aytes
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-04-22T06:40:44.407
        )

    [ListingContractDate] => Array
        (
            [0] => 2026-04-15
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 06:40:44.407
        )

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

    [listing_image] => Array
        (
            [0] => 27360446
            [1] => 27360447
            [2] => 27360448
            [3] => 27360449
            [4] => 27360450
            [5] => 27360451
            [6] => 27360452
            [7] => 27360453
            [8] => 27360454
            [9] => 27360455
            [10] => 27360456
            [11] => 27360457
            [12] => 27360458
            [13] => 27360459
            [14] => 27360460
            [15] => 27360461
            [16] => 27360462
            [17] => 27360463
            [18] => 27360464
            [19] => 27360465
            [20] => 27360466
            [21] => 27360467
        )

)

PROPERTY INFO

• BedsTotal: 2
• Full Baths: 1
• Land Area (sf): 249,076 sf
• Living (sf): 896
• Year Built: 1973
• Building Name: Ridgecrest-Melemanu

KEY FEATURES

• Property Condition: Above Average
• Number of Parking Spaces: 1
• View: Garden,Mountain
• Listing Office: Coldwell Banker Island Prop

FINANCIAL INFO

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

SCHOOLS

• 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 April 22, 2026 - 6:40 AM Information is deemed reliable but not guaranteed. Copyright: 2026 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.