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-2035 Waikalani Place Unit B302 Mililani, HI 96789
Listing Overview
Price: $399,000 Area: WAIPIO ACRES/WAIKALANI WOODLANDS Status: Active
Welcome to Northbrook Melemanu in Waikalani! This spacious 2-bedroom, 1-bath condo offers 896 sqft of total living space and includes 2 parking stalls for added convenience. Remodeled in 2020, the unit features modern updates and a functional layout. Enjoy direct access from the parking garage, making loading and unloading a breeze, especially with no stairs from the 2nd-level garage to the front door. While stairs are present from the parking stall, the layout is ideal for easy drop-offs.
One of the standout features of this home is its serene, unobstructed view of lush greenery and a peaceful stream—no buildings in front, just nature at your doorstep. Perfect for those who value privacy and a tranquil setting. Conveniently located near Schofield Barracks and Wheeler Army Airfield, in a quiet, forested valley between Mililani and Wahiawa. Home warranty included for added peace of mind! Listing by: Coldwell Banker Realty (808) 561-0642
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202525458"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(7) "95-2035"
}
["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) "B302"
}
["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) "399000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(32) "WAIPIO ACRES/WAIKALANI WOODLANDS"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(902) "Welcome to Northbrook Melemanu in Waikalani! This spacious 2-bedroom, 1-bath condo offers 896 sqft of total living space and includes 2 parking stalls for added convenience. Remodeled in 2020, the unit features modern updates and a functional layout. Enjoy direct access from the parking garage, making loading and unloading a breeze, especially with no stairs from the 2nd-level garage to the front door. While stairs are present from the parking stall, the layout is ideal for easy drop-offs.
One of the standout features of this home is its serene, unobstructed view of lush greenery and a peaceful stream—no buildings in front, just nature at your doorstep. Perfect for those who value privacy and a tranquil setting. Conveniently located near Schofield Barracks and Wheeler Army Airfield, in a quiet, forested valley between Mililani and Wahiawa. Home warranty included for added peace of mind!"
}
["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(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(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(6) "Three+"
}
["View"]=>
array(1) {
[0]=>
string(8) "Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(7) "1018.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(6) "CBPP02"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(25) "cameron.chan@cbrealty.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 561-0642"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(12) "Cameron Chan"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "19118536"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-11-22T17:00:01.483"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-11-14"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Central"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(12) "Stream/Canal"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "17:00:01.483"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27219763"
}
["listing_image"]=>
array(18) {
[0]=>
string(8) "27219763"
[1]=>
string(8) "27219764"
[2]=>
string(8) "27219765"
[3]=>
string(8) "27219766"
[4]=>
string(8) "27219767"
[5]=>
string(8) "27219768"
[6]=>
string(8) "27219769"
[7]=>
string(8) "27219770"
[8]=>
string(8) "27219771"
[9]=>
string(8) "27219772"
[10]=>
string(8) "27219773"
[11]=>
string(8) "27219774"
[12]=>
string(8) "27219775"
[13]=>
string(8) "27219776"
[14]=>
string(8) "27219777"
[15]=>
string(8) "27219778"
[16]=>
string(8) "27219779"
[17]=>
string(8) "27219780"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202525458
)
[StreetNumber] => Array
(
[0] => 95-2035
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Waikalani
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] => B302
)
[City] => Array
(
[0] => Mililani
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96789
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 399000.00
)
[Neighbourhood] => Array
(
[0] => WAIPIO ACRES/WAIKALANI WOODLANDS
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Welcome to Northbrook Melemanu in Waikalani! This spacious 2-bedroom, 1-bath condo offers 896 sqft of total living space and includes 2 parking stalls for added convenience. Remodeled in 2020, the unit features modern updates and a functional layout. Enjoy direct access from the parking garage, making loading and unloading a breeze, especially with no stairs from the 2nd-level garage to the front door. While stairs are present from the parking stall, the layout is ideal for easy drop-offs.
One of the standout features of this home is its serene, unobstructed view of lush greenery and a peaceful stream—no buildings in front, just nature at your doorstep. Perfect for those who value privacy and a tranquil setting. Conveniently located near Schofield Barracks and Wheeler Army Airfield, in a quiet, forested valley between Mililani and Wahiawa. Home warranty included for added peace of mind!
)
[ListOfficeName] => Array
(
[0] => Coldwell Banker Realty
)
[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
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => Three+
)
[View] => Array
(
[0] => Mountain
)
[MaintenanceExpense] => Array
(
[0] => 1018.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => CBPP02
)
[ListAgentEmail] => Array
(
[0] => cameron.chan@cbrealty.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 561-0642
)
[ListAgentFullName] => Array
(
[0] => Cameron Chan
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 19118536
)
[MatrixModifiedDT] => Array
(
[0] => 2025-11-22T17:00:01.483
)
[ListingContractDate] => Array
(
[0] => 2025-11-14
)
[MLSAreaMajor] => Array
(
[0] => Central
)
[PropertyFrontage] => Array
(
[0] => Stream/Canal
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 17:00:01.483
)
[_thumbnail_id] => Array
(
[0] => 27219763
)
[listing_image] => Array
(
[0] => 27219763
[1] => 27219764
[2] => 27219765
[3] => 27219766
[4] => 27219767
[5] => 27219768
[6] => 27219769
[7] => 27219770
[8] => 27219771
[9] => 27219772
[10] => 27219773
[11] => 27219774
[12] => 27219775
[13] => 27219776
[14] => 27219777
[15] => 27219778
[16] => 27219779
[17] => 27219780
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on November 22, 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.