94-686 Lumiauau Street Unit UU 204 Waipahu, HI 96797
Listing
Overview
Price: $625,000
Area: WAIKELE
Status: Active
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 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(45) {
["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]=>
string(9) "625000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIKELE"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(630) "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 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-06-03T15:54:33.877"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18027361"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-05-28T09:46:43.547"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_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"
}
}
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] => 625000.00
)
[Neighbourhood] => Array
(
[0] => WAIKELE
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => 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 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-06-03T15:54:33.877
)
[Matrix_Unique_ID] => Array
(
[0] => 18027361
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-05-28T09:46:43.547
)
[MLSAreaMajor] => Array
(
[0] => Waipahu
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_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
)
)
- BedsTotal: 3
- Full Baths: 2
- Land Area (sf): 174,196
- 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
