Listing
Overview
Price: $300,000
Area: WAIPAHU-LOWER
Status: Active
Discover the wonderful Waipahu living experience at Leolua Regent, where comfort and convenience come together. This lovely ground-floor condo provides easy access, with a smooth transition from your parking spot to your front door. As you step inside, you'll be greeted by the spacious atmosphere created by soaring ceilings, adding a special touch to your new home. The kitchen is both beautiful and practical, featuring durable granite countertops that make meal prep a joy. What’s even better is that your monthly maintenance fee covers electricity, water, and sewer, making your budgeting a breeze. Plus, you’ll love the unbeatable location—just a short stroll to Waipahu Town Center and other shopping areas, so grocery runs, banking, and dining out are all conveniently close. The Waipahu Post Office is also nearby for your errands. This is a great opportunity to own a low-maintenance home right in the heart of central Oahu. Come and move in to start enjoying this fantastic lifestyle! This is a short sale and will be sold "As Is". Please add the Short Sale Agent Guideline (supplement) to all offers. Listing by: Keller Williams Honolulu (808) 227-2703
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) "300000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(13) "WAIPAHU-LOWER"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1118) "Discover the wonderful Waipahu living experience at Leolua Regent, where comfort and convenience come together. This lovely ground-floor condo provides easy access, with a smooth transition from your parking spot to your front door. As you step inside, you'll be greeted by the spacious atmosphere created by soaring ceilings, adding a special touch to your new home. The kitchen is both beautiful and practical, featuring durable granite countertops that make meal prep a joy. What’s even better is that your monthly maintenance fee covers electricity, water, and sewer, making your budgeting a breeze. Plus, you’ll love the unbeatable location—just a short stroll to Waipahu Town Center and other shopping areas, so grocery runs, banking, and dining out are all conveniently close. The Waipahu Post Office is also nearby for your errands. This is a great opportunity to own a low-maintenance home right in the heart of central Oahu. Come and move in to start enjoying this fantastic lifestyle! This is a short sale and will be sold "As Is". Please add the Short Sale Agent Guideline (supplement) to all offers."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(24) "Keller Williams 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(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(6) "KWPP01"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(22) "adrienne@teamlally.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 227-2703"
}
["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) "2025-10-14T12:22:51.610"
}
["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) "12:22:51.610"
}
["_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] => 300000.00
)
[Neighbourhood] => Array
(
[0] => WAIPAHU-LOWER
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Discover the wonderful Waipahu living experience at Leolua Regent, where comfort and convenience come together. This lovely ground-floor condo provides easy access, with a smooth transition from your parking spot to your front door. As you step inside, you'll be greeted by the spacious atmosphere created by soaring ceilings, adding a special touch to your new home. The kitchen is both beautiful and practical, featuring durable granite countertops that make meal prep a joy. What’s even better is that your monthly maintenance fee covers electricity, water, and sewer, making your budgeting a breeze. Plus, you’ll love the unbeatable location—just a short stroll to Waipahu Town Center and other shopping areas, so grocery runs, banking, and dining out are all conveniently close. The Waipahu Post Office is also nearby for your errands. This is a great opportunity to own a low-maintenance home right in the heart of central Oahu. Come and move in to start enjoying this fantastic lifestyle! This is a short sale and will be sold "As Is". Please add the Short Sale Agent Guideline (supplement) to all offers.
)
[ListOfficeName] => Array
(
[0] => Keller Williams 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] => 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] => KWPP01
)
[ListAgentEmail] => Array
(
[0] => adrienne@teamlally.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 227-2703
)
[ListAgentFullName] => Array
(
[0] => Adrienne W Lally
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 19015450
)
[MatrixModifiedDT] => Array
(
[0] => 2025-10-14T12:22:51.610
)
[ListingContractDate] => Array
(
[0] => 2025-10-14
)
[MLSAreaMajor] => Array
(
[0] => Waipahu
)
[PropertyFrontage] => Array
(
[0] =>
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 12:22:51.610
)
[_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: Keller Williams Honolulu
- Maintenance Fees: $649
- Land Tenure: FS - Fee Simple
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on October 14, 2025 - 12:22 PM
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.