Thanksgiving - The office will be closed on Thursday 11/27/25 and Friday 11/28/25
Christmas - The office will be closed on Thursday 12/25/25 and Friday 12/26/25
New Years - The office will be closed on Thursday 1/1/26 and Friday 1/2/26
Price: $324,999 Area: WAIPAHU-LOWER Status: Active
$5,000 Seller Concession + New Lower Price! The time is NOW to see what others are missing out on! New Range and Refrigerator on order! Newly installed cool ceiling fan, New mirrored medicine cabinet and flooring improvements completed Sept 2025. Prior tenant's TLC shows in this unit. Sellers are ready to welcome the next occupants HOME! This Comfortable, Convenient and Centrally located unit provides all the conveniences and easy access to go whereever your heart desires. Enjoy a plethra of eateries nearby to satisfy your appetite & TheBus and The SkyLine stations to get around. This home is a tune away from the Queen's Medical Center-West Oahu and the H-1 Freeway On Ramp. Melt your cares away after work in the pool. Friendly Resident Manager & a well kept building. This is a great community to own a starter home, investment property or just to downsize. The conveniences of comfortable living are all around you! Be HOME for the Holidays! Listing by: Engel & Volkers Honolulu (808) 550-0818
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202509624"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "94-246"
}
["PropertyType"]=>
array(1) {
[0]=>
string(15) "Condo/Townhouse"
}
["StreetName"]=>
array(1) {
[0]=>
string(5) "Leoku"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(5) "G/324"
}
["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(41) "https://player.vimeo.com/video/1074109848"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "324999.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(13) "WAIPAHU-LOWER"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(963) "$5,000 Seller Concession + New Lower Price! The time is NOW to see what others are missing out on! New Range and Refrigerator on order! Newly installed cool ceiling fan, New mirrored medicine cabinet and flooring improvements completed Sept 2025. Prior tenant's TLC shows in this unit. Sellers are ready to welcome the next occupants HOME! This Comfortable, Convenient and Centrally located unit provides all the conveniences and easy access to go whereever your heart desires. Enjoy a plethra of eateries nearby to satisfy your appetite & TheBus and The SkyLine stations to get around. This home is a tune away from the Queen's Medical Center-West Oahu and the H-1 Freeway On Ramp. Melt your cares away after work in the pool. Friendly Resident Manager & a well kept building. This is a great community to own a starter home, investment property or just to downsize. The conveniences of comfortable living are all around you! Be HOME for the Holidays!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(24) "Engel & Volkers Honolulu"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "1"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(9) "166878.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "712"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1969"
}
["BuildingName"]=>
array(1) {
[0]=>
string(13) "Leolua Regent"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(12) "Average,Fair"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(5) "Three"
}
["View"]=>
array(1) {
[0]=>
string(4) "None"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(6) "648.98"
}
["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) "PPRO"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(33) "sharmaine.curtis@evrealestate.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 550-0818"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(18) "Sharmaine A Curtis"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18678612"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-12-06T07:49:39.640"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-04-09"
}
["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) "07:49:39.640"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26951516"
}
["listing_image"]=>
array(24) {
[0]=>
string(8) "26951516"
[1]=>
string(8) "26951517"
[2]=>
string(8) "26951518"
[3]=>
string(8) "26951519"
[4]=>
string(8) "26951520"
[5]=>
string(8) "26951521"
[6]=>
string(8) "26951522"
[7]=>
string(8) "26951523"
[8]=>
string(8) "26951524"
[9]=>
string(8) "26951525"
[10]=>
string(8) "26951526"
[11]=>
string(8) "26951527"
[12]=>
string(8) "26951528"
[13]=>
string(8) "26951529"
[14]=>
string(8) "26951530"
[15]=>
string(8) "26951531"
[16]=>
string(8) "26951532"
[17]=>
string(8) "26951533"
[18]=>
string(8) "26951534"
[19]=>
string(8) "26951535"
[20]=>
string(8) "26951536"
[21]=>
string(8) "26951537"
[22]=>
string(8) "26951538"
[23]=>
string(8) "26951539"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202509624
)
[StreetNumber] => Array
(
[0] => 94-246
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Leoku
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => G/324
)
[City] => Array
(
[0] => Waipahu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96797
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://player.vimeo.com/video/1074109848
)
[ListPrice] => Array
(
[0] => 324999.00
)
[Neighbourhood] => Array
(
[0] => WAIPAHU-LOWER
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => $5,000 Seller Concession + New Lower Price! The time is NOW to see what others are missing out on! New Range and Refrigerator on order! Newly installed cool ceiling fan, New mirrored medicine cabinet and flooring improvements completed Sept 2025. Prior tenant's TLC shows in this unit. Sellers are ready to welcome the next occupants HOME! This Comfortable, Convenient and Centrally located unit provides all the conveniences and easy access to go whereever your heart desires. Enjoy a plethra of eateries nearby to satisfy your appetite & TheBus and The SkyLine stations to get around. This home is a tune away from the Queen's Medical Center-West Oahu and the H-1 Freeway On Ramp. Melt your cares away after work in the pool. Friendly Resident Manager & a well kept building. This is a great community to own a starter home, investment property or just to downsize. The conveniences of comfortable living are all around you! Be HOME for the Holidays!
)
[ListOfficeName] => Array
(
[0] => Engel & Volkers Honolulu
)
[BedsTotal] => Array
(
[0] => 2
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 166878.00
)
[SqftTotal] => Array
(
[0] => 712
)
[YearBuilt] => Array
(
[0] => 1969
)
[BuildingName] => Array
(
[0] => Leolua Regent
)
[PropertyCondition] => Array
(
[0] => Average,Fair
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => Three
)
[View] => Array
(
[0] => None
)
[MaintenanceExpense] => Array
(
[0] => 648.98
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => PPRO
)
[ListAgentEmail] => Array
(
[0] => sharmaine.curtis@evrealestate.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 550-0818
)
[ListAgentFullName] => Array
(
[0] => Sharmaine A Curtis
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18678612
)
[MatrixModifiedDT] => Array
(
[0] => 2025-12-06T07:49:39.640
)
[ListingContractDate] => Array
(
[0] => 2025-04-09
)
[MLSAreaMajor] => Array
(
[0] => Waipahu
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 07:49:39.640
)
[_thumbnail_id] => Array
(
[0] => 26951516
)
[listing_image] => Array
(
[0] => 26951516
[1] => 26951517
[2] => 26951518
[3] => 26951519
[4] => 26951520
[5] => 26951521
[6] => 26951522
[7] => 26951523
[8] => 26951524
[9] => 26951525
[10] => 26951526
[11] => 26951527
[12] => 26951528
[13] => 26951529
[14] => 26951530
[15] => 26951531
[16] => 26951532
[17] => 26951533
[18] => 26951534
[19] => 26951535
[20] => 26951536
[21] => 26951537
[22] => 26951538
[23] => 26951539
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on December 6, 2025 - 7:49 AM
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.
