Listing
Overview
Price: $285,000
Area: WAIPAHU-LOWER
Status: Active
SHORT SALE APPROVED! Discover a wonderful Waipahu living experience at Leolua Regent, where convenience and comfort come together. This lovely ground-floor condo in Central Oahu offers easy access, with a smooth transition from your assigned parking stall to your front door. Step inside to a spacious atmosphere created by soaring ceilings, adding a special touch to this Waipahu-Lower home. The kitchen is both beautiful and practical, featuring durable granite countertops that make meal prep a joy. Your monthly maintenance fee covers electricity, water, and sewer, making budgeting a breeze. Enjoy an unbeatable location just a short stroll to Waipahu Town Center, with shopping, grocery, banking, dining, and the Waipahu Post Office all conveniently close. A great opportunity to own a low-maintenance condo in the heart of Central Oahu. This is a short sale and will be sold "As Is." Please add the Short Sale Agent Guideline (supplement) to all offers. View 3D tours, video, and high-res photos via the virtual tour link (chain link icon). Listing by: Team Lally (808) 212-9188
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202521727"
}
["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) "E103"
}
["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(51) "https://my.matterport.com/show/?m=9fpTdzUM2Mm&mls=1"
}
["ListPrice"]=>
array(1) {
[0]=>
string(9) "285000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(13) "WAIPAHU-LOWER"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1047) "SHORT SALE APPROVED! Discover a wonderful Waipahu living experience at Leolua Regent, where convenience and comfort come together. This lovely ground-floor condo in Central Oahu offers easy access, with a smooth transition from your assigned parking stall to your front door. Step inside to a spacious atmosphere created by soaring ceilings, adding a special touch to this Waipahu-Lower home. The kitchen is both beautiful and practical, featuring durable granite countertops that make meal prep a joy. Your monthly maintenance fee covers electricity, water, and sewer, making budgeting a breeze. Enjoy an unbeatable location just a short stroll to Waipahu Town Center, with shopping, grocery, banking, dining, and the Waipahu Post Office all conveniently close. A great opportunity to own a low-maintenance condo in the heart of Central Oahu. This is a short sale and will be sold "As Is." Please add the Short Sale Agent Guideline (supplement) to all offers. View 3D tours, video, and high-res photos via the virtual tour link (chain link icon)."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(10) "Team Lally"
}
["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(9) "Excellent"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "1"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["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) "LALY"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(22) "adrienne@teamlally.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 212-9188"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(16) "Adrienne W Lally"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "19015450"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2026-07-21T16:19:56.493"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-10-14"
}
["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) "16:19:56.493"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27186786"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "27186786"
[1]=>
string(8) "27186787"
[2]=>
string(8) "27186788"
[3]=>
string(8) "27186789"
[4]=>
string(8) "27186790"
[5]=>
string(8) "27186791"
[6]=>
string(8) "27186792"
[7]=>
string(8) "27186793"
[8]=>
string(8) "27186794"
[9]=>
string(8) "27186795"
[10]=>
string(8) "27186796"
[11]=>
string(8) "27186797"
[12]=>
string(8) "27186798"
[13]=>
string(8) "27186799"
[14]=>
string(8) "27186800"
[15]=>
string(8) "27186801"
[16]=>
string(8) "27186802"
[17]=>
string(8) "27186803"
[18]=>
string(8) "27186804"
[19]=>
string(8) "27186805"
[20]=>
string(8) "27186806"
[21]=>
string(8) "27186807"
[22]=>
string(8) "27186808"
[23]=>
string(8) "27186809"
[24]=>
string(8) "27186810"
[25]=>
string(8) "27186811"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202521727
)
[StreetNumber] => Array
(
[0] => 94-246
)
[PropertyType] => Array
(
[0] => Condo/Townhouse
)
[StreetName] => Array
(
[0] => Leoku
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] => E103
)
[City] => Array
(
[0] => Waipahu
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96797
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://my.matterport.com/show/?m=9fpTdzUM2Mm&mls=1
)
[ListPrice] => Array
(
[0] => 285000.00
)
[Neighbourhood] => Array
(
[0] => WAIPAHU-LOWER
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => SHORT SALE APPROVED! Discover a wonderful Waipahu living experience at Leolua Regent, where convenience and comfort come together. This lovely ground-floor condo in Central Oahu offers easy access, with a smooth transition from your assigned parking stall to your front door. Step inside to a spacious atmosphere created by soaring ceilings, adding a special touch to this Waipahu-Lower home. The kitchen is both beautiful and practical, featuring durable granite countertops that make meal prep a joy. Your monthly maintenance fee covers electricity, water, and sewer, making budgeting a breeze. Enjoy an unbeatable location just a short stroll to Waipahu Town Center, with shopping, grocery, banking, dining, and the Waipahu Post Office all conveniently close. A great opportunity to own a low-maintenance condo in the heart of Central Oahu. This is a short sale and will be sold "As Is." Please add the Short Sale Agent Guideline (supplement) to all offers. View 3D tours, video, and high-res photos via the virtual tour link (chain link icon).
)
[ListOfficeName] => Array
(
[0] => Team Lally
)
[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] => Excellent
)
[ParkingTotal] => Array
(
[0] => 1
)
[StoriesType] => Array
(
[0] => One
)
[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] => LALY
)
[ListAgentEmail] => Array
(
[0] => adrienne@teamlally.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 212-9188
)
[ListAgentFullName] => Array
(
[0] => Adrienne W Lally
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 19015450
)
[MatrixModifiedDT] => Array
(
[0] => 2026-07-21T16:19:56.493
)
[ListingContractDate] => Array
(
[0] => 2025-10-14
)
[MLSAreaMajor] => Array
(
[0] => Waipahu
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 16:19:56.493
)
[_thumbnail_id] => Array
(
[0] => 27186786
)
[listing_image] => Array
(
[0] => 27186786
[1] => 27186787
[2] => 27186788
[3] => 27186789
[4] => 27186790
[5] => 27186791
[6] => 27186792
[7] => 27186793
[8] => 27186794
[9] => 27186795
[10] => 27186796
[11] => 27186797
[12] => 27186798
[13] => 27186799
[14] => 27186800
[15] => 27186801
[16] => 27186802
[17] => 27186803
[18] => 27186804
[19] => 27186805
[20] => 27186806
[21] => 27186807
[22] => 27186808
[23] => 27186809
[24] => 27186810
[25] => 27186811
)
)
- BedsTotal: 2
- Full Baths: 1
- Land Area (sf): 166,878 sf
- Living (sf): 712
- Year Built: 1969
- Building Name: Leolua Regent
- Property Condition: Excellent
- Number of Parking Spaces: 1
- View: None
- Listing Office: Team Lally
- Maintenance Fees: $649
- Land Tenure: FS - Fee Simple
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on July 21, 2026 - 4:19 PM
Information is deemed reliable but not guaranteed.
Copyright: 2026 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.