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
94-686 Lumiauau Street Unit UU 204 Waipahu, HI 96797
Listing Overview
Price: $619,000 Area: WAIKELE Status: Active
Was already a good deal, but take advantage of another price drop. Everyone needs more space! Here's a 1,029 sq. ft., 3 BEDROOM w/ 2 full bath at the Village on the Green in Waikele. Enjoy this 2nd floor unit with tree top views and 2 parking stalls steps away from the unit. This home has been newly painted with brand new carpet, stove, light fixtures, fans and more. There is an AC unit in the living room. This home is in very good condition and is being sold "as is".
All of this in the planned community of Waikele with its golf course, restaurants, shopping, swimming pools and soccer field
near by. Prefer Rowena Yamane @ First American Title Kapolei Listing by: Marketing Properties (808) 256-1230
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202501366"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "94-686"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(8) "Lumiauau"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(6) "UU 204"
}
["City"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96797"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "619000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIKELE"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(662) "Was already a good deal, but take advantage of another price drop. Everyone needs more space! Here's a 1,029 sq. ft., 3 BEDROOM w/ 2 full bath at the Village on the Green in Waikele. Enjoy this 2nd floor unit with tree top views and 2 parking stalls steps away from the unit. This home has been newly painted with brand new carpet, stove, light fixtures, fans and more. There is an AC unit in the living room. This home is in very good condition and is being sold "as is".
All of this in the planned community of Waikele with its golf course, restaurants, shopping, swimming pools and soccer field
near by. Prefer Rowena Yamane @ First American Title Kapolei"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(20) "Marketing Properties"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(9) "174196.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1122"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1998"
}
["BuildingName"]=>
array(1) {
[0]=>
string(23) "Village On The Green 2A"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(0) ""
}
["View"]=>
array(1) {
[0]=>
string(14) "Garden,Sunrise"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "657.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(4) "MPRO"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(25) "mae.murakami808@gmail.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 256-1230"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(12) "Mae Murakami"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18475848"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-08-05T16:05:29.110"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-01-06"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "16:05:29.110"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26828917"
}
["listing_image"]=>
array(13) {
[0]=>
string(8) "26828917"
[1]=>
string(8) "26828918"
[2]=>
string(8) "26828919"
[3]=>
string(8) "26828920"
[4]=>
string(8) "26828921"
[5]=>
string(8) "26828922"
[6]=>
string(8) "26828923"
[7]=>
string(8) "26828924"
[8]=>
string(8) "26828925"
[9]=>
string(8) "26829094"
[10]=>
string(8) "26829095"
[11]=>
string(8) "26829096"
[12]=>
string(8) "26829097"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202501366
)
[StreetNumber] => Array
(
[0] => 94-686
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Lumiauau
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => UU 204
)
[City] => Array
(
[0] => Waipahu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96797
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 619000.00
)
[Neighbourhood] => Array
(
[0] => WAIKELE
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Was already a good deal, but take advantage of another price drop. Everyone needs more space! Here's a 1,029 sq. ft., 3 BEDROOM w/ 2 full bath at the Village on the Green in Waikele. Enjoy this 2nd floor unit with tree top views and 2 parking stalls steps away from the unit. This home has been newly painted with brand new carpet, stove, light fixtures, fans and more. There is an AC unit in the living room. This home is in very good condition and is being sold "as is".
All of this in the planned community of Waikele with its golf course, restaurants, shopping, swimming pools and soccer field
near by. Prefer Rowena Yamane @ First American Title Kapolei
)
[ListOfficeName] => Array
(
[0] => Marketing Properties
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 174196.00
)
[SqftTotal] => Array
(
[0] => 1122
)
[YearBuilt] => Array
(
[0] => 1998
)
[BuildingName] => Array
(
[0] => Village On The Green 2A
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] =>
)
[View] => Array
(
[0] => Garden,Sunrise
)
[MaintenanceExpense] => Array
(
[0] => 657.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => MPRO
)
[ListAgentEmail] => Array
(
[0] => mae.murakami808@gmail.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 256-1230
)
[ListAgentFullName] => Array
(
[0] => Mae Murakami
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18475848
)
[MatrixModifiedDT] => Array
(
[0] => 2025-08-05T16:05:29.110
)
[ListingContractDate] => Array
(
[0] => 2025-01-06
)
[MLSAreaMajor] => Array
(
[0] => Waipahu
)
[PropertyFrontage] => Array
(
[0] => Other
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 16:05:29.110
)
[_thumbnail_id] => Array
(
[0] => 26828917
)
[listing_image] => Array
(
[0] => 26828917
[1] => 26828918
[2] => 26828919
[3] => 26828920
[4] => 26828921
[5] => 26828922
[6] => 26828923
[7] => 26828924
[8] => 26828925
[9] => 26829094
[10] => 26829095
[11] => 26829096
[12] => 26829097
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on August 5, 2025 - 4:05 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.