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 C104 Mililani, HI 96789
Listing Overview
Price: $349,900
Area: WAIPIO ACRES/WAIKALANI WOODLANDS
Status: Active
Absolute bargain! Unbelievable price! Priced low and firm for your pre-approved buyer who wants a great value on the best condo in Mililani! It won't last long at this low, low price, so hurry and do your buyer a favor and write me a squeaky clean, full price offer today and save yourself all the fun of a full price counter offer! Listing by: Coldwell Banker Realty (808) 738-3904
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202524490"
}
["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) "C104"
}
["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) "349900.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(32) "WAIPIO ACRES/WAIKALANI WOODLANDS"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(332) "Absolute bargain! Unbelievable price! Priced low and firm for your pre-approved buyer who wants a great value on the best condo in Mililani! It won't last long at this low, low price, so hurry and do your buyer a favor and write me a squeaky clean, full price offer today and save yourself all the fun of a full price counter offer!"
}
["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(9) "170145.00"
}
["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(7) "Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(0) ""
}
["View"]=>
array(1) {
[0]=>
string(4) "None"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(7) "1018.00"
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(5) "Kapaa"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(7) "Wheeler"
}
["HighSchool"]=>
array(1) {
[0]=>
string(8) "Mililani"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(6) "CBPP02"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(27) "chad@youngpacificrealty.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 738-3904"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(10) "Chad Young"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "19071518"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-11-20T09:54:49.153"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-10-28"
}
["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) "09:54:49.153"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27202670"
}
["listing_image"]=>
array(7) {
[0]=>
string(8) "27202670"
[1]=>
string(8) "27202671"
[2]=>
string(8) "27204479"
[3]=>
string(8) "27204480"
[4]=>
string(8) "27204481"
[5]=>
string(8) "27204482"
[6]=>
string(8) "27204483"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202524490
)
[StreetNumber] => Array
(
[0] => 95-2039
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Waikalani
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] => C104
)
[City] => Array
(
[0] => Mililani
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96789
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 349900.00
)
[Neighbourhood] => Array
(
[0] => WAIPIO ACRES/WAIKALANI WOODLANDS
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Absolute bargain! Unbelievable price! Priced low and firm for your pre-approved buyer who wants a great value on the best condo in Mililani! It won't last long at this low, low price, so hurry and do your buyer a favor and write me a squeaky clean, full price offer today and save yourself all the fun of a full price counter offer!
)
[ListOfficeName] => Array
(
[0] => Coldwell Banker Realty
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 170145.00
)
[SqftTotal] => Array
(
[0] => 896
)
[YearBuilt] => Array
(
[0] => 1973
)
[BuildingName] => Array
(
[0] => Northbrook-Melemanu
)
[PropertyCondition] => Array
(
[0] => Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] =>
)
[View] => Array
(
[0] => None
)
[MaintenanceExpense] => Array
(
[0] => 1018.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Kapaa
)
[MiddleOrJuniorSchool] => Array
(
[0] => Wheeler
)
[HighSchool] => Array
(
[0] => Mililani
)
[ListOfficeMLSID] => Array
(
[0] => CBPP02
)
[ListAgentEmail] => Array
(
[0] => chad@youngpacificrealty.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 738-3904
)
[ListAgentFullName] => Array
(
[0] => Chad Young
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 19071518
)
[MatrixModifiedDT] => Array
(
[0] => 2025-11-20T09:54:49.153
)
[ListingContractDate] => Array
(
[0] => 2025-10-28
)
[MLSAreaMajor] => Array
(
[0] => Central
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 09:54:49.153
)
[_thumbnail_id] => Array
(
[0] => 27202670
)
[listing_image] => Array
(
[0] => 27202670
[1] => 27202671
[2] => 27204479
[3] => 27204480
[4] => 27204481
[5] => 27204482
[6] => 27204483
)
)
BedsTotal: 2
Full Baths: 1
Land Area (sf): 170,145 sf
Living (sf): 896
Year Built: 1973
Building Name: Northbrook-Melemanu
Property Condition: Average
Number of Parking Spaces: 2
View: None
Listing Office: Coldwell Banker Realty
Maintenance Fees: $1,018
Land Tenure: FS - Fee Simple
Elementary School: Kapaa
Middle School: Wheeler
High School: Mililani
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on November 20, 2025 - 9:54 AM
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.