Thanksgiving - The office will be closed on Thursday 11/27/25 and Friday 11/28/25
Christmas - The office will be closed on Thursday 12/25/25 and Friday 12/26/25
New Years - The office will be closed on Thursday 1/1/26 and Friday 1/2/26
95-2039 Waikalani Place Unit C202 Mililani, HI 96789
Price: $399,999 Area: WAIPIO ACRES/WAIKALANI WOODLANDS Status: Active
Welcome home to Northbrook Melemanu in Mililani! This charming 2-bedroom, 1-bath unit offers a renovated kitchen and bath, in-unit washer/dryer, and a private balcony with peaceful green views and no back neighbors. Enjoy the convenience of 2 ASSIGNED PARKING STALLS, plus community amenities like a pool, BBQ areas, and walking paths. Nestled in the Mililani neighborhood, known for its award-winning schools, and just minutes from shopping, dining, Schofield and Wheeler military bases, and freeway access. This property offers a VA assumable loan at an incredible 2.25% interest rate with a loan balance of approximately $270,000 — a rare opportunity for VA qualified buyers! NOTE: There is NO INCREASE in maintenance fees for 2026! Listing by: REMAX Hawaii (808) 220-9212
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202524602"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(7) "95-2039"
}
["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) "C202"
}
["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(59) "https://listings.hetproductions.com/sites/xaqgwqw/unbranded"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "399999.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(32) "WAIPIO ACRES/WAIKALANI WOODLANDS"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(737) "Welcome home to Northbrook Melemanu in Mililani! This charming 2-bedroom, 1-bath unit offers a renovated kitchen and bath, in-unit washer/dryer, and a private balcony with peaceful green views and no back neighbors. Enjoy the convenience of 2 ASSIGNED PARKING STALLS, plus community amenities like a pool, BBQ areas, and walking paths. Nestled in the Mililani neighborhood, known for its award-winning schools, and just minutes from shopping, dining, Schofield and Wheeler military bases, and freeway access. This property offers a VA assumable loan at an incredible 2.25% interest rate with a loan balance of approximately $270,000 — a rare opportunity for VA qualified buyers! NOTE: There is NO INCREASE in maintenance fees for 2026!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(12) "REMAX Hawaii"
}
["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(0) ""
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "896"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1973"
}
["BuildingName"]=>
array(1) {
[0]=>
string(19) "Northbrook-Melemanu"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(21) "Above Average,Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(4) "None"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(7) "1019.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(4) "ADVG"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(30) "Rolanda.Racoma@remaxhawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 220-9212"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(17) "Rolanda Li Racoma"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "19074923"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-11-30T15:00:02.170"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-10-31"
}
["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) "15:00:02.170"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27205408"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "27205408"
[1]=>
string(8) "27205409"
[2]=>
string(8) "27205410"
[3]=>
string(8) "27205411"
[4]=>
string(8) "27205412"
[5]=>
string(8) "27205413"
[6]=>
string(8) "27205414"
[7]=>
string(8) "27205415"
[8]=>
string(8) "27205416"
[9]=>
string(8) "27205417"
[10]=>
string(8) "27205418"
[11]=>
string(8) "27205419"
[12]=>
string(8) "27205420"
[13]=>
string(8) "27205421"
[14]=>
string(8) "27205422"
[15]=>
string(8) "27205423"
[16]=>
string(8) "27205424"
[17]=>
string(8) "27205425"
[18]=>
string(8) "27205426"
[19]=>
string(8) "27205427"
[20]=>
string(8) "27205428"
[21]=>
string(8) "27205429"
[22]=>
string(8) "27205430"
[23]=>
string(8) "27205431"
[24]=>
string(8) "27205432"
[25]=>
string(8) "27205433"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202524602
)
[StreetNumber] => Array
(
[0] => 95-2039
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Waikalani
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] => C202
)
[City] => Array
(
[0] => Mililani
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96789
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://listings.hetproductions.com/sites/xaqgwqw/unbranded
)
[ListPrice] => Array
(
[0] => 399999.00
)
[Neighbourhood] => Array
(
[0] => WAIPIO ACRES/WAIKALANI WOODLANDS
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Welcome home to Northbrook Melemanu in Mililani! This charming 2-bedroom, 1-bath unit offers a renovated kitchen and bath, in-unit washer/dryer, and a private balcony with peaceful green views and no back neighbors. Enjoy the convenience of 2 ASSIGNED PARKING STALLS, plus community amenities like a pool, BBQ areas, and walking paths. Nestled in the Mililani neighborhood, known for its award-winning schools, and just minutes from shopping, dining, Schofield and Wheeler military bases, and freeway access. This property offers a VA assumable loan at an incredible 2.25% interest rate with a loan balance of approximately $270,000 — a rare opportunity for VA qualified buyers! NOTE: There is NO INCREASE in maintenance fees for 2026!
)
[ListOfficeName] => Array
(
[0] => REMAX Hawaii
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 896
)
[YearBuilt] => Array
(
[0] => 1973
)
[BuildingName] => Array
(
[0] => Northbrook-Melemanu
)
[PropertyCondition] => Array
(
[0] => Above Average,Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => None
)
[MaintenanceExpense] => Array
(
[0] => 1019.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Kipapa
)
[MiddleOrJuniorSchool] => Array
(
[0] => Mililani
)
[HighSchool] => Array
(
[0] => Mililani
)
[ListOfficeMLSID] => Array
(
[0] => ADVG
)
[ListAgentEmail] => Array
(
[0] => Rolanda.Racoma@remaxhawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 220-9212
)
[ListAgentFullName] => Array
(
[0] => Rolanda Li Racoma
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 19074923
)
[MatrixModifiedDT] => Array
(
[0] => 2025-11-30T15:00:02.170
)
[ListingContractDate] => Array
(
[0] => 2025-10-31
)
[MLSAreaMajor] => Array
(
[0] => Central
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 15:00:02.170
)
[_thumbnail_id] => Array
(
[0] => 27205408
)
[listing_image] => Array
(
[0] => 27205408
[1] => 27205409
[2] => 27205410
[3] => 27205411
[4] => 27205412
[5] => 27205413
[6] => 27205414
[7] => 27205415
[8] => 27205416
[9] => 27205417
[10] => 27205418
[11] => 27205419
[12] => 27205420
[13] => 27205421
[14] => 27205422
[15] => 27205423
[16] => 27205424
[17] => 27205425
[18] => 27205426
[19] => 27205427
[20] => 27205428
[21] => 27205429
[22] => 27205430
[23] => 27205431
[24] => 27205432
[25] => 27205433
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on November 30, 2025 - 3: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.
