94-670 Lumiauau Street Unit YY/203 Waipahu, HI 96797
Listing
Overview
Price: $598,000
Area: WAIKELE
Status: Active Under Contract
Experience this beautifully renovated Waikele townhome, including a fresh, open floor plan. The unit boasts a full size
open kitchen, one of the largest in comparable townhomes. Almost everything has been tastefully designed and
constructed and is centrally located in the desirable community close to community parks, pools, Waikele shopping
center, and freeway entrances. This 2 bedroom, 2 bath, 2 parking unit is the perfect starter townhome or investment
property. Contact your agent today! Listing by: Locations LLC (808) 228-9912
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202501857"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "94-670"
}
["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) "YY/203"
}
["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) "598000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIKELE"
}
["Status"]=>
array(1) {
[0]=>
string(21) "Active Under Contract"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(498) "Experience this beautifully renovated Waikele townhome, including a fresh, open floor plan. The unit boasts a full size
open kitchen, one of the largest in comparable townhomes. Almost everything has been tastefully designed and
constructed and is centrally located in the desirable community close to community parks, pools, Waikele shopping
center, and freeway entrances. This 2 bedroom, 2 bath, 2 parking unit is the perfect starter townhome or investment
property. Contact your agent today!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(13) "Locations LLC"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(4) "0.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "811"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1998"
}
["BuildingName"]=>
array(1) {
[0]=>
string(23) "Village on the Green 2A"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(23) "Excellent,Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(0) ""
}
["View"]=>
array(1) {
[0]=>
string(13) "City,Mountain"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "517.91"
}
["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(6) "LOCA03"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(33) "John.Quindara@LocationsHawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 228-9912"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(13) "John Quindara"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18488803"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-02-04T14:28:19.840"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-01-13"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(7) "Waipahu"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "14:28:19.840"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26838613"
}
["listing_image"]=>
array(18) {
[0]=>
string(8) "26838613"
[1]=>
string(8) "26838614"
[2]=>
string(8) "26838615"
[3]=>
string(8) "26838616"
[4]=>
string(8) "26838617"
[5]=>
string(8) "26838618"
[6]=>
string(8) "26838619"
[7]=>
string(8) "26838620"
[8]=>
string(8) "26838621"
[9]=>
string(8) "26838622"
[10]=>
string(8) "26838623"
[11]=>
string(8) "26838624"
[12]=>
string(8) "26838625"
[13]=>
string(8) "26838626"
[14]=>
string(8) "26838627"
[15]=>
string(8) "26838628"
[16]=>
string(8) "26838629"
[17]=>
string(8) "26838630"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202501857
)
[StreetNumber] => Array
(
[0] => 94-670
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Lumiauau
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => YY/203
)
[City] => Array
(
[0] => Waipahu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96797
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 598000.00
)
[Neighbourhood] => Array
(
[0] => WAIKELE
)
[Status] => Array
(
[0] => Active Under Contract
)
[PublicRemarks] => Array
(
[0] => Experience this beautifully renovated Waikele townhome, including a fresh, open floor plan. The unit boasts a full size
open kitchen, one of the largest in comparable townhomes. Almost everything has been tastefully designed and
constructed and is centrally located in the desirable community close to community parks, pools, Waikele shopping
center, and freeway entrances. This 2 bedroom, 2 bath, 2 parking unit is the perfect starter townhome or investment
property. Contact your agent today!
)
[ListOfficeName] => Array
(
[0] => Locations LLC
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 0.00
)
[SqftTotal] => Array
(
[0] => 811
)
[YearBuilt] => Array
(
[0] => 1998
)
[BuildingName] => Array
(
[0] => Village on the Green 2A
)
[PropertyCondition] => Array
(
[0] => Excellent,Above Average
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] =>
)
[View] => Array
(
[0] => City,Mountain
)
[MaintenanceExpense] => Array
(
[0] => 517.91
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => LOCA03
)
[ListAgentEmail] => Array
(
[0] => John.Quindara@LocationsHawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 228-9912
)
[ListAgentFullName] => Array
(
[0] => John Quindara
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18488803
)
[MatrixModifiedDT] => Array
(
[0] => 2025-02-04T14:28:19.840
)
[ListingContractDate] => Array
(
[0] => 2025-01-13
)
[MLSAreaMajor] => Array
(
[0] => Waipahu
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 14:28:19.840
)
[_thumbnail_id] => Array
(
[0] => 26838613
)
[listing_image] => Array
(
[0] => 26838613
[1] => 26838614
[2] => 26838615
[3] => 26838616
[4] => 26838617
[5] => 26838618
[6] => 26838619
[7] => 26838620
[8] => 26838621
[9] => 26838622
[10] => 26838623
[11] => 26838624
[12] => 26838625
[13] => 26838626
[14] => 26838627
[15] => 26838628
[16] => 26838629
[17] => 26838630
)
)
- BedsTotal: 2
- Full Baths: 2
- Land Area (sf): 0 sf
- Living (sf): 811
- Year Built: 1998
- Building Name: Village on the Green 2A
- Property Condition: Excellent,Above Average
- Number of Parking Spaces: 2
- View: City,Mountain
- Listing Office: Locations LLC
- Maintenance Fees: $518
- Land Tenure: FS - Fee Simple