| Description | Open House, SUNDAY, September 27, from 2-5pm. 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). Agent Rmks: "DO NOT contact the Seller because we have an Executed Listing Agreement." SHORT SALE APPROVED! |
|---|---|
| Status | Active since 09-16-2026 |
| MLS# | 202617689 |
| Price | $285,000 |
| Original Price | $285,000 |
| Price Change | (0.00%) |
| Beds / Baths / Half | 2 / 1 / 0 |
| Parking Spaces | 1 |
| Living Sq Ft | 712 |
| Land Tenure | FS - Fee Simple |
| Maintenance Fee | $767 |
| Building | Leolua Regent |
| Address | 94-246 Leoku Street E103 Waipahu HI 96797 |
| Region | Waipahu |
| Neighborhood | Waipahu-Lower |
| Days on Market | 11 |
| Year Built | 1969 |
| Year Remodeled | 2023 |
| Condition | Excellent |
| View | None |
| Parking | Assigned, Open - 1 |
| Zoning | 12 - A-2 Medium Density Apartme |
| Flood Zone | Zone D |
| Tax Amount | $112 |
| Assessed Land | $123,400 |
| Assessed Building | $260,300 |
| Assessed Total | $383,700 |
| Assessed Ratio | 74% |
| Inclusions | AC Window Unit, Ceiling Fan, Disposal, Microwave Hood, Microwave, Range/Oven, Refrigerator, Smoke Detector |
| Amenities | Condo Association Pool, Playground, Pool on Property, Resident Manager |
| Construction | Double Wall, Hollow Tile |
| Flooring | Ceramic Tile, Laminate |
| Disclosures | Lender Approval Required, Property Disclosure Stmt |
| Land Recorded | Regular System |
| Possession | At Closing |
| Sale Conditions | Short Sale |
| Building Style | Low-Rise 6 or Less Stories |
| Security | Key |
| Notice | Short Sale |
| Parcel # | 1-9-4-047-013-0099 |
| Listing courtesy of | Team Lally |
Property History from MLS
| Date | MLS# | Change | Old Value | New Value | List Price | Sold Price | Assessed Total | Land | Building |
|---|---|---|---|---|---|---|---|---|---|
| 09-16-2026 | 202617689 | New Listing | A | $285,000 | $0 | $383,700 | $123,400 | $260,300 | |
| 09-15-2026 | 202521727 | Cancelled | A | W | $285,000 | $0 | $383,700 | $123,400 | $260,300 |
| 07-17-2026 | 202521727 | Back On Market | C | A | $285,000 | $0 | $383,700 | $123,400 | $260,300 |
| 05-25-2026 | 202521727 | Active Under Contract | A | C | $285,000 | $0 | $383,700 | $123,400 | $260,300 |
| 01-06-2026 | 202521727 | Price Increase | $275,000 | $285,000 | $285,000 | $0 | $383,700 | $123,400 | $260,300 |
| 10-21-2025 | 202521727 | Price Decrease | $300,000 | $275,000 | $285,000 | $0 | $383,700 | $123,400 | $260,300 |
| 10-14-2025 | 202521727 | New Listing | CS | A | $285,000 | $0 | $383,700 | $123,400 | $260,300 |
| 08-07-2023 | 202306712 | Sold | C | S | $375,000 | $377,200 | $303,600 | $131,700 | $171,900 |
| 06-26-2023 | 202306712 | Active Under Contract | A | C | $375,000 | $377,200 | $303,600 | $131,700 | $171,900 |
| 05-29-2023 | 202306712 | Back On Market | C | A | $375,000 | $377,200 | $303,600 | $131,700 | $171,900 |
| 04-09-2023 | 202306712 | Active Under Contract | A | C | $375,000 | $377,200 | $303,600 | $131,700 | $171,900 |
| 03-23-2023 | 202306712 | New Listing | A | $375,000 | $377,200 | $303,600 | $131,700 | $171,900 | |
| 03-14-2020 | 202003956 | Withdrawn | A | W | $305,000 | $0 | $271,200 | $122,200 | $149,000 |
| 02-27-2020 | 202003956 | New Listing | A | $305,000 | $0 | $271,200 | $122,200 | $149,000 | |
| 03-28-2018 | 201804606 | Sold | P | S | $248,000 | $248,000 | $218,000 | $96,700 | $121,300 |
| 02-20-2018 | 201804606 | In Escrow Not Showing | C | P | $248,000 | $248,000 | $218,000 | $96,700 | $121,300 |
| 02-20-2018 | 201804606 | In Escrow Showing | A | C | $248,000 | $248,000 | $218,000 | $96,700 | $121,300 |
| 02-20-2018 | 201804606 | New Listing | A | $248,000 | $248,000 | $218,000 | $96,700 | $121,300 | |
| 04-05-2006 | 2603742 | Sold | P | S | $175,000 | $175,000 | $131,700 | $42,000 | $89,700 |
| 02-21-2006 | 2603742 | Pending | A | P | $175,000 | $175,000 | $131,700 | $42,000 | $89,700 |
| 02-21-2006 | 2603742 | New Listing | A | $175,000 | $175,000 | $131,700 | $42,000 | $89,700 | |
| 01-23-2001 | 2011705 | Sold | C | S | $29,990 | $23,000 | $54,400 | $14,000 | $40,400 |
| 01-23-2001 | 2011705 | Price Decrease | $29,990 | $23,000 | $29,990 | $23,000 | $54,400 | $14,000 | $40,400 |
| 11-30-2000 | 2011705 | New Listing | A | $29,990 | $23,000 | $54,400 | $14,000 | $40,400 |
View the public schools for this property · Google Maps · Supermarkets · Schools · Hospitals · Restaurants · Beaches · City Tax Record / Plat Map · View beach access points all over Oahu · Buyer Closing Cost Calculator · Seller Closing Cost Calculator