94-686 Lumiauau Street Unit UU 204 Waipahu, HI 96797
Listing
Overview
Price: $625,000
Area: WAIKELE
Status: Active
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. Here's
a 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. 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) "625000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIKELE"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(542) "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. Here's
a 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."
}
["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) "500.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-01-15T13:45:55.160"
}
["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) "13:45:55.160"
}
["_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] => 625000.00
)
[Neighbourhood] => Array
(
[0] => WAIKELE
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => 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. Here's
a 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.
)
[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] => 500.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-01-15T13:45:55.160
)
[ListingContractDate] => Array
(
[0] => 2025-01-06
)
[MLSAreaMajor] => Array
(
[0] => Waipahu
)
[PropertyFrontage] => Array
(
[0] => Other
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 13:45:55.160
)
[_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
)
)
- BedsTotal: 3
- Full Baths: 2
- Land Area (sf): 174,196 sf
- Living (sf): 1,122
- Year Built: 1998
- Building Name: Village On The Green 2A
- Property Condition: Above Average
- Number of Parking Spaces: 2
- View: Garden,Sunrise
- Listing Office: Marketing Properties
- Maintenance Fees: $500
- Land Tenure: FS - Fee Simple
