94-686 Lumiauau Street Unit UU 204 Waipahu, HI 96797
Listing
Overview
Price: $625,000
Area: WAIKELE
Status: Active
BACK ON THE MARKET. Great price for a rare 3 BEDROOM, 2 Full Bath home at Village on the Green in Waikele. This spacious 1,029 sq. ft.,2nd floor unit also enjoys a large 93 sq. ft. lanai with tree top views. Your 2 assigned parking stalls, one covered, one open, could not be closer to the unit. This home has been newly painted and has brand new carpet throughout. New light fixtures, stove and fans have been installed. There is AC in the living room. All this in the planned community of Waikele with its golf course, restaurants, and shopping. Townhouse is in very good condition and being sold "as is". Please consider Mera Espera @ First American. Listing by: Marketing Properties (808) 256-1230
array(46) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202412023"
}
["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"
}
["CurrentPrice"]=>
array(1) {
[0]=>
NULL
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIKELE"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(658) "BACK ON THE MARKET. Great price for a rare 3 BEDROOM, 2 Full Bath home at Village on the Green in Waikele. This spacious 1,029 sq. ft.,2nd floor unit also enjoys a large 93 sq. ft. lanai with tree top views. Your 2 assigned parking stalls, one covered, one open, could not be closer to the unit. This home has been newly painted and has brand new carpet throughout. New light fixtures, stove and fans have been installed. There is AC in the living room. All this in the planned community of Waikele with its golf course, restaurants, and shopping. Townhouse is in very good condition and being sold "as is". Please consider Mera Espera @ First American."
}
["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(7) "Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(7) "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) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-11-22T17:26:19.340"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18027361"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
NULL
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
NULL
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26494486"
}
["listing_image"]=>
array(14) {
[0]=>
string(8) "26494486"
[1]=>
string(8) "26494487"
[2]=>
string(8) "26494488"
[3]=>
string(8) "26494489"
[4]=>
string(8) "26494490"
[5]=>
string(8) "26494491"
[6]=>
string(8) "26494492"
[7]=>
string(8) "26494493"
[8]=>
string(8) "26494494"
[9]=>
string(8) "26494495"
[10]=>
string(8) "26494496"
[11]=>
string(8) "26494497"
[12]=>
string(8) "26494498"
[13]=>
string(8) "26494499"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2024-05-28"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202412023
)
[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
)
[CurrentPrice] => Array
(
[0] =>
)
[Neighbourhood] => Array
(
[0] => WAIKELE
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => BACK ON THE MARKET. Great price for a rare 3 BEDROOM, 2 Full Bath home at Village on the Green in Waikele. This spacious 1,029 sq. ft.,2nd floor unit also enjoys a large 93 sq. ft. lanai with tree top views. Your 2 assigned parking stalls, one covered, one open, could not be closer to the unit. This home has been newly painted and has brand new carpet throughout. New light fixtures, stove and fans have been installed. There is AC in the living room. All this in the planned community of Waikele with its golf course, restaurants, and shopping. Townhouse is in very good condition and being sold "as is". Please consider Mera Espera @ First American.
)
[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] => Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => 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] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-11-22T17:26:19.340
)
[Matrix_Unique_ID] => Array
(
[0] => 18027361
)
[OriginalEntryTimestamp] => Array
(
[0] =>
)
[MLSAreaMajor] => Array
(
[0] => Waipahu
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] =>
)
[_thumbnail_id] => Array
(
[0] => 26494486
)
[listing_image] => Array
(
[0] => 26494486
[1] => 26494487
[2] => 26494488
[3] => 26494489
[4] => 26494490
[5] => 26494491
[6] => 26494492
[7] => 26494493
[8] => 26494494
[9] => 26494495
[10] => 26494496
[11] => 26494497
[12] => 26494498
[13] => 26494499
)
[ListingContractDate] => Array
(
[0] => 2024-05-28
)
)
- 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: Average
- Number of Parking Spaces: 2
- View: Sunrise
- Listing Office: Marketing Properties
- Maintenance Fees: $500
- Land Tenure: FS - Fee Simple
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on November 22, 2024 - 5:26 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.
