94-686 Lumiauau Street Unit UU 204 Waipahu, HI 96797
Listing
Overview
Price: $625,000
Area: WAIKELE
Status: Active
Great price for this rare 3 Bedroom, 2 full bath unit in Village on the Green. This spacious 1,029 sq. ft. 2nd floor unit enjoys a 93 sq. ft. lanai with tree top views. Your 2 assigned parking stalls, one covered could not be closer. This home has been newly painted, with brand new carpeting throughout. New light fixtures and fans have been installed. There is an AC unit in the living room. All this in the planned community of Waikele with its golf course, Outlet Mall, restaurants, shopping and parks. Townhouse is very good condition and is being sold "as is". Request working with Mera Espera @ First American. Listing by: Marketing Properties (808) 256-1230
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202412019"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "94-686"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["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(620) "Great price for this rare 3 Bedroom, 2 full bath unit in Village on the Green. This spacious 1,029 sq. ft. 2nd floor unit enjoys a 93 sq. ft. lanai with tree top views. Your 2 assigned parking stalls, one covered could not be closer. This home has been newly painted, with brand new carpeting throughout. New light fixtures and fans have been installed. There is an AC unit in the living room. All this in the planned community of Waikele with its golf course, Outlet Mall, restaurants, shopping and parks. Townhouse is very good condition and is being sold "as is". Request working with 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(0) ""
}
["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(7) "Waikele"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["HighSchool"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["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-05-28T08:49:32.047"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18027237"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-05-28T08:44:27.710"
}
["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) "26493564"
}
["listing_image"]=>
array(14) {
[0]=>
string(8) "26493564"
[1]=>
string(8) "26493565"
[2]=>
string(8) "26493566"
[3]=>
string(8) "26493567"
[4]=>
string(8) "26493568"
[5]=>
string(8) "26493569"
[6]=>
string(8) "26493570"
[7]=>
string(8) "26493571"
[8]=>
string(8) "26493572"
[9]=>
string(8) "26493573"
[10]=>
string(8) "26493574"
[11]=>
string(8) "26493575"
[12]=>
string(8) "26493576"
[13]=>
string(8) "26493577"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202412019
)
[StreetNumber] => Array
(
[0] => 94-686
)
[PropertyType] => Array
(
[0] => Single Family
)
[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 this rare 3 Bedroom, 2 full bath unit in Village on the Green. This spacious 1,029 sq. ft. 2nd floor unit enjoys a 93 sq. ft. lanai with tree top views. Your 2 assigned parking stalls, one covered could not be closer. This home has been newly painted, with brand new carpeting throughout. New light fixtures and fans have been installed. There is an AC unit in the living room. All this in the planned community of Waikele with its golf course, Outlet Mall, restaurants, shopping and parks. Townhouse is very good condition and is being sold "as is". Request working with 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] =>
)
[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] => Waikele
)
[MiddleOrJuniorSchool] => Array
(
[0] => Waipahu
)
[HighSchool] => Array
(
[0] => Waipahu
)
[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-05-28T08:49:32.047
)
[Matrix_Unique_ID] => Array
(
[0] => 18027237
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-05-28T08:44:27.710
)
[MLSAreaMajor] => Array
(
[0] => Waipahu
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26493564
)
[listing_image] => Array
(
[0] => 26493564
[1] => 26493565
[2] => 26493566
[3] => 26493567
[4] => 26493568
[5] => 26493569
[6] => 26493570
[7] => 26493571
[8] => 26493572
[9] => 26493573
[10] => 26493574
[11] => 26493575
[12] => 26493576
[13] => 26493577
)
)
- BedsTotal: 3
- Full Baths: 2
- Land Area (sf): 174,196
- Living (sf): 1,122
- Year Built: 1998
- Property Condition: Average
- Number of Parking Spaces: 2
- View: Sunrise
- Listing Office: Marketing Properties
- Maintenance Fees: $500
- Land Tenure: FS - Fee Simple
- Elementary School: Waikele
- Middle School: Waipahu
- High School: Waipahu
