Our office will be closed on November 28 and 29, 2024, for Thanksgiving and the Day After Thanksgiving.
94-217 Lumiaina Place Unit A202 Waipahu, HI 96797
Listing Overview
Price: $565,000
Area: WAIKELE
Status: Active
Beautifully renovated in 2024 - This 2 bedroom, 2 bath unit with air conditioning & 2 assigned parking stalls in Parkview at Waikele is in move in condition.
New paint, cabinets, quartz counter tops, vinyl plank & tile flooring are just some of the features of this unit.
Enjoy this quiet second floor unit that is centrally located close to Waikele Shopping Center, Parks, Recreation Center (Pool), Schools, Restaurants, Public Transportation & Freeway Access. The Seller to conduct a 1031 Exchange and the Property is to be sold in " As Is" Condition. Listing by: Tsujimura & Associates, LLC (808) 388-3630
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202423439"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "94-217"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(8) "Lumiaina"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Place"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(4) "A202"
}
["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) "565000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(9) "565000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIKELE"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(558) "Beautifully renovated in 2024 - This 2 bedroom, 2 bath unit with air conditioning & 2 assigned parking stalls in Parkview at Waikele is in move in condition.
New paint, cabinets, quartz counter tops, vinyl plank & tile flooring are just some of the features of this unit.
Enjoy this quiet second floor unit that is centrally located close to Waikele Shopping Center, Parks, Recreation Center (Pool), Schools, Restaurants, Public Transportation & Freeway Access. The Seller to conduct a 1031 Exchange and the Property is to be sold in " As Is" Condition."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(27) "Tsujimura & Associates, 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(0) ""
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "920"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1992"
}
["BuildingName"]=>
array(1) {
[0]=>
string(19) "Parkview At Waikele"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["StoriesType"]=>
array(1) {
[0]=>
string(0) ""
}
["View"]=>
array(1) {
[0]=>
string(14) "Sunrise,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "369.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) "LTSU"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(24) "LTSUJIMURA@TAAREALTY.COM"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 388-3630"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(18) "Lester S Tsujimura"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-10-06T08:51:25.850"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18310805"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-10-06T08:51:25.850"
}
["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) "26720409"
}
["listing_image"]=>
array(11) {
[0]=>
string(8) "26720409"
[1]=>
string(8) "26720410"
[2]=>
string(8) "26720411"
[3]=>
string(8) "26720412"
[4]=>
string(8) "26720413"
[5]=>
string(8) "26720414"
[6]=>
string(8) "26720415"
[7]=>
string(8) "26720416"
[8]=>
string(8) "26720417"
[9]=>
string(8) "26720418"
[10]=>
string(8) "26720419"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202423439
)
[StreetNumber] => Array
(
[0] => 94-217
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Lumiaina
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] => A202
)
[City] => Array
(
[0] => Waipahu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96797
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 565000.00
)
[CurrentPrice] => Array
(
[0] => 565000.00
)
[Neighbourhood] => Array
(
[0] => WAIKELE
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Beautifully renovated in 2024 - This 2 bedroom, 2 bath unit with air conditioning & 2 assigned parking stalls in Parkview at Waikele is in move in condition.
New paint, cabinets, quartz counter tops, vinyl plank & tile flooring are just some of the features of this unit.
Enjoy this quiet second floor unit that is centrally located close to Waikele Shopping Center, Parks, Recreation Center (Pool), Schools, Restaurants, Public Transportation & Freeway Access. The Seller to conduct a 1031 Exchange and the Property is to be sold in " As Is" Condition.
)
[ListOfficeName] => Array
(
[0] => Tsujimura & Associates, LLC
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 920
)
[YearBuilt] => Array
(
[0] => 1992
)
[BuildingName] => Array
(
[0] => Parkview At Waikele
)
[PropertyCondition] => Array
(
[0] => Excellent
)
[ParkingTotal] => Array
(
[0] => 2
)
[StoriesType] => Array
(
[0] =>
)
[View] => Array
(
[0] => Sunrise,Sunset
)
[MaintenanceExpense] => Array
(
[0] => 369.00
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Waikele
)
[MiddleOrJuniorSchool] => Array
(
[0] => Waipahu
)
[HighSchool] => Array
(
[0] => Waipahu
)
[ListOfficeMLSID] => Array
(
[0] => LTSU
)
[ListAgentEmail] => Array
(
[0] => LTSUJIMURA@TAAREALTY.COM
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 388-3630
)
[ListAgentFullName] => Array
(
[0] => Lester S Tsujimura
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-10-06T08:51:25.850
)
[Matrix_Unique_ID] => Array
(
[0] => 18310805
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-10-06T08:51:25.850
)
[MLSAreaMajor] => Array
(
[0] => Waipahu
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_thumbnail_id] => Array
(
[0] => 26720409
)
[listing_image] => Array
(
[0] => 26720409
[1] => 26720410
[2] => 26720411
[3] => 26720412
[4] => 26720413
[5] => 26720414
[6] => 26720415
[7] => 26720416
[8] => 26720417
[9] => 26720418
[10] => 26720419
)
)
BedsTotal: 2
Full Baths: 2
Living (sf): 920
Year Built: 1992
Building Name: Parkview At Waikele
Property Condition: Excellent
Number of Parking Spaces: 2
View: Sunrise,Sunset
Listing Office: Tsujimura & Associates, LLC
Maintenance Fees: $369
Land Tenure: FS - Fee Simple
Elementary School: Waikele
Middle School: Waipahu
High School: Waipahu