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
Listing Overview
Price: $379,000
Area: WAIPAHU-LOWER
Status: Active
Great Opportunity! $6,000 in seller credits. Priced under tax assessed value. Spacious, 3 bedroom 1 bath condo in prime location! Don't miss out on this fantastic opportunity. This gem is perfect as a starter home or an investment that has great rental potential attractive option for both first time home buyers or investors seeking rental property. Key features: Large living room vinyl flooring throughout, perfect for entertaining or relaxing with natural light bright and cooled by breezes. Convenient location: Minutes to grocery stores and restaurants, you'll love easy access to everything you need. 1 assigned parking maintenance fee covers everything! Electricity, cable tv, internet, water sewer. Schedule your showing today! Listing by: REMAX Hawaii (808) 738-3600
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202506252"
}
["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(4) "E306"
}
["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(60) "https://my.matterport.com/show/?m=K32rfwtws6i&brand=0&mls=1&"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "379000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(13) "WAIPAHU-LOWER"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(737) "Great Opportunity! $6,000 in seller credits. Priced under tax assessed value. Spacious, 3 bedroom 1 bath condo in prime location! Don't miss out on this fantastic opportunity. This gem is perfect as a starter home or an investment that has great rental potential attractive option for both first time home buyers or investors seeking rental property. Key features: Large living room vinyl flooring throughout, perfect for entertaining or relaxing with natural light bright and cooled by breezes. Convenient location: Minutes to grocery stores and restaurants, you'll love easy access to everything you need. 1 assigned parking maintenance fee covers everything! Electricity, cable tv, internet, water sewer. Schedule your showing today!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(12) "REMAX Hawaii"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "1"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(0) ""
}
["SqftTotal"]=>
array(1) {
[0]=>
string(3) "868"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1969"
}
["BuildingName"]=>
array(1) {
[0]=>
string(13) "Leolua Regent"
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(21) "Above Average,Average"
}
["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) "803.25"
}
["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) "ADVG"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(27) "Tahiti.Reed@remaxhawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 738-3600"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(13) "Tahiti V Reed"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18590396"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-11-26T09:27:30.810"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-03-07"
}
["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) "09:27:30.810"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26908840"
}
["listing_image"]=>
array(22) {
[0]=>
string(8) "26908840"
[1]=>
string(8) "26908841"
[2]=>
string(8) "26908842"
[3]=>
string(8) "26908843"
[4]=>
string(8) "26908844"
[5]=>
string(8) "26908845"
[6]=>
string(8) "26908846"
[7]=>
string(8) "26908847"
[8]=>
string(8) "26908848"
[9]=>
string(8) "26908849"
[10]=>
string(8) "26908850"
[11]=>
string(8) "26908851"
[12]=>
string(8) "26908852"
[13]=>
string(8) "26908853"
[14]=>
string(8) "26908854"
[15]=>
string(8) "26908855"
[16]=>
string(8) "26908856"
[17]=>
string(8) "26908857"
[18]=>
string(8) "26908858"
[19]=>
string(8) "26908859"
[20]=>
string(8) "26908860"
[21]=>
string(8) "26908861"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202506252
)
[StreetNumber] => Array
(
[0] => 94-246
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Leoku
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => E306
)
[City] => Array
(
[0] => Waipahu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96797
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://my.matterport.com/show/?m=K32rfwtws6i&brand=0&mls=1&
)
[ListPrice] => Array
(
[0] => 379000.00
)
[Neighbourhood] => Array
(
[0] => WAIPAHU-LOWER
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Great Opportunity! $6,000 in seller credits. Priced under tax assessed value. Spacious, 3 bedroom 1 bath condo in prime location! Don't miss out on this fantastic opportunity. This gem is perfect as a starter home or an investment that has great rental potential attractive option for both first time home buyers or investors seeking rental property. Key features: Large living room vinyl flooring throughout, perfect for entertaining or relaxing with natural light bright and cooled by breezes. Convenient location: Minutes to grocery stores and restaurants, you'll love easy access to everything you need. 1 assigned parking maintenance fee covers everything! Electricity, cable tv, internet, water sewer. Schedule your showing today!
)
[ListOfficeName] => Array
(
[0] => REMAX Hawaii
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 1
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] =>
)
[SqftTotal] => Array
(
[0] => 868
)
[YearBuilt] => Array
(
[0] => 1969
)
[BuildingName] => Array
(
[0] => Leolua Regent
)
[PropertyCondition] => Array
(
[0] => Above Average,Average
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => Three
)
[View] => Array
(
[0] => None
)
[MaintenanceExpense] => Array
(
[0] => 803.25
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => ADVG
)
[ListAgentEmail] => Array
(
[0] => Tahiti.Reed@remaxhawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 738-3600
)
[ListAgentFullName] => Array
(
[0] => Tahiti V Reed
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18590396
)
[MatrixModifiedDT] => Array
(
[0] => 2025-11-26T09:27:30.810
)
[ListingContractDate] => Array
(
[0] => 2025-03-07
)
[MLSAreaMajor] => Array
(
[0] => Waipahu
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 09:27:30.810
)
[_thumbnail_id] => Array
(
[0] => 26908840
)
[listing_image] => Array
(
[0] => 26908840
[1] => 26908841
[2] => 26908842
[3] => 26908843
[4] => 26908844
[5] => 26908845
[6] => 26908846
[7] => 26908847
[8] => 26908848
[9] => 26908849
[10] => 26908850
[11] => 26908851
[12] => 26908852
[13] => 26908853
[14] => 26908854
[15] => 26908855
[16] => 26908856
[17] => 26908857
[18] => 26908858
[19] => 26908859
[20] => 26908860
[21] => 26908861
)
)
BedsTotal: 3
Full Baths: 1
Living (sf): 868
Year Built: 1969
Building Name: Leolua Regent
Property Condition: Above Average,Average
Number of Parking Spaces: 1
View: None
Listing Office: REMAX Hawaii
Maintenance Fees: $803
Land Tenure: FS - Fee Simple
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on November 26, 2025 - 9:27 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.
© Marcus Realty. All Rights Reserved.