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-2048 Waikalani Place Unit D204 Mililani, HI 96789
Listing Overview
Price: $350,000 Area: WAIPIO ACRES/WAIKALANI WOODLANDS Status: Sold (Limited photos per MLS privacy policy)
It’s move in ready! This condo had been freshly painted, has ceramic tile flooring throughout, no popcorn ceiling, a full-size washer and dryer, ceiling fans, and a large lanai that overlooks a grassy area with forest and mountain views. You’ll also love the floor to ceiling jalousie windows that bring in cool breezes and create a bright, open feel in this spacious second-floor unit. The peace and quiet of living in this rarely available 1-bedroom condo, with a large walk-in closet, is a compelling reason to see it soon. The 2 covered parking spaces are conveniently located on the same level as the apartment. The Ridgecrest is a well-run, fully insured, pet-friendly community, with a very low HOA fee that includes water, sewer, a huge swimming pool, tennis courts, a new fully fenced in dog park, and plenty of guest parking. It also has an abundance of green common spaces that includes papaya, banana, mango, and avocado trees. Ridgecrest is in a fantastic location just minutes away from shopping, restaurants, entertainment, Schofield Barracks, and Wheeler. Melemanu park is just down the hill with a playground, basketball courts, and baseball fields. This home is waiting for you! Listing by: American Dream Realty LLC (808) 723-0927
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202524448"
}
["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) "D204"
}
["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) "350000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(32) "WAIPIO ACRES/WAIKALANI WOODLANDS"
}
["Status"]=>
array(1) {
[0]=>
string(4) "Sold"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1200) "It’s move in ready! This condo had been freshly painted, has ceramic tile flooring throughout, no popcorn ceiling, a full-size washer and dryer, ceiling fans, and a large lanai that overlooks a grassy area with forest and mountain views. You’ll also love the floor to ceiling jalousie windows that bring in cool breezes and create a bright, open feel in this spacious second-floor unit. The peace and quiet of living in this rarely available 1-bedroom condo, with a large walk-in closet, is a compelling reason to see it soon. The 2 covered parking spaces are conveniently located on the same level as the apartment. The Ridgecrest is a well-run, fully insured, pet-friendly community, with a very low HOA fee that includes water, sewer, a huge swimming pool, tennis courts, a new fully fenced in dog park, and plenty of guest parking. It also has an abundance of green common spaces that includes papaya, banana, mango, and avocado trees. Ridgecrest is in a fantastic location just minutes away from shopping, restaurants, entertainment, Schofield Barracks, and Wheeler. Melemanu park is just down the hill with a playground, basketball courts, and baseball fields. This home is waiting for you!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(25) "American Dream Realty LLC"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["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) "704"
}
["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) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "4-7"
}
["View"]=>
array(1) {
[0]=>
string(6) "Garden"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "379.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) "ADRL"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(23) "lisaa_resales@proton.me"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 723-0927"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(10) "Lisa L Alt"
}
["CloseDate"]=>
array(1) {
[0]=>
string(10) "2025-12-15"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "19070407"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-12-15T09:18:18.863"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-11-03"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Central"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "09:18:18.863"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27207995"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "27207995"
[1]=>
string(8) "27207996"
[2]=>
string(8) "27207997"
[3]=>
string(8) "27207998"
[4]=>
string(8) "27207999"
[5]=>
string(8) "27208000"
[6]=>
string(8) "27208001"
[7]=>
string(8) "27208002"
[8]=>
string(8) "27208003"
[9]=>
string(8) "27208004"
[10]=>
string(8) "27208005"
[11]=>
string(8) "27208006"
[12]=>
string(8) "27208007"
[13]=>
string(8) "27208008"
[14]=>
string(8) "27208009"
[15]=>
string(8) "27208010"
[16]=>
string(8) "27208011"
[17]=>
string(8) "27208012"
[18]=>
string(8) "27208013"
[19]=>
string(8) "27208014"
[20]=>
string(8) "27208015"
[21]=>
string(8) "27208016"
[22]=>
string(8) "27208017"
[23]=>
string(8) "27209219"
[24]=>
string(8) "27209220"
[25]=>
string(8) "27209221"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202524448
)
[StreetNumber] => Array
(
[0] => 95-2048
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Waikalani
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] => D204
)
[City] => Array
(
[0] => Mililani
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96789
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 350000.00
)
[Neighbourhood] => Array
(
[0] => WAIPIO ACRES/WAIKALANI WOODLANDS
)
[Status] => Array
(
[0] => Sold
)
[PublicRemarks] => Array
(
[0] => It’s move in ready! This condo had been freshly painted, has ceramic tile flooring throughout, no popcorn ceiling, a full-size washer and dryer, ceiling fans, and a large lanai that overlooks a grassy area with forest and mountain views. You’ll also love the floor to ceiling jalousie windows that bring in cool breezes and create a bright, open feel in this spacious second-floor unit. The peace and quiet of living in this rarely available 1-bedroom condo, with a large walk-in closet, is a compelling reason to see it soon. The 2 covered parking spaces are conveniently located on the same level as the apartment. The Ridgecrest is a well-run, fully insured, pet-friendly community, with a very low HOA fee that includes water, sewer, a huge swimming pool, tennis courts, a new fully fenced in dog park, and plenty of guest parking. It also has an abundance of green common spaces that includes papaya, banana, mango, and avocado trees. Ridgecrest is in a fantastic location just minutes away from shopping, restaurants, entertainment, Schofield Barracks, and Wheeler. Melemanu park is just down the hill with a playground, basketball courts, and baseball fields. This home is waiting for you!
)
[ListOfficeName] => Array
(
[0] => American Dream Realty LLC
)
[BedsTotal] => Array
(
[0] => 1
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 249076.00
)
[SqftTotal] => Array
(
[0] => 704
)
[YearBuilt] => Array
(
[0] => 1973
)
[BuildingName] => Array
(
[0] => Ridgecrest-Melemanu
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => 4-7
)
[View] => Array
(
[0] => Garden
)
[MaintenanceExpense] => Array
(
[0] => 379.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Kipapa
)
[MiddleOrJuniorSchool] => Array
(
[0] => Mililani
)
[HighSchool] => Array
(
[0] => Mililani
)
[ListOfficeMLSID] => Array
(
[0] => ADRL
)
[ListAgentEmail] => Array
(
[0] => lisaa_resales@proton.me
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 723-0927
)
[ListAgentFullName] => Array
(
[0] => Lisa L Alt
)
[CloseDate] => Array
(
[0] => 2025-12-15
)
[Matrix_Unique_ID] => Array
(
[0] => 19070407
)
[MatrixModifiedDT] => Array
(
[0] => 2025-12-15T09:18:18.863
)
[ListingContractDate] => Array
(
[0] => 2025-11-03
)
[MLSAreaMajor] => Array
(
[0] => Central
)
[PropertyFrontage] => Array
(
[0] => Other
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 09:18:18.863
)
[_thumbnail_id] => Array
(
[0] => 27207995
)
[listing_image] => Array
(
[0] => 27207995
[1] => 27207996
[2] => 27207997
[3] => 27207998
[4] => 27207999
[5] => 27208000
[6] => 27208001
[7] => 27208002
[8] => 27208003
[9] => 27208004
[10] => 27208005
[11] => 27208006
[12] => 27208007
[13] => 27208008
[14] => 27208009
[15] => 27208010
[16] => 27208011
[17] => 27208012
[18] => 27208013
[19] => 27208014
[20] => 27208015
[21] => 27208016
[22] => 27208017
[23] => 27209219
[24] => 27209220
[25] => 27209221
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on December 15, 2025 - 9:18 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.
