Leolua Regent
94-246 Leoku Street Unit E306 Waipahu HI 96797
Important: See the Active listing for this property
This property was cancelled and is not for sale.
$370,000 | Cancelled
Contact us for an estimated $1,850 commission rebate and no obligation showing.
Sell for a $3,500 Flat Fee or 2% With Full Service.
Price dropped on 12-22-2025. Original price was $399,000
Listed on 03-07-2025 * 326 Days until Cancelled on 01-27-2026
3 Bedrooms, 1 Full Bath, 0 Half Baths, 1 Parking Spaces
868 Square Feet Living * $950 Total Association Fees
View Virtual Tour
Save This Property to Receive Automatic Email Updates When the Status Changes
Property Last Viewed: 07/28/2026 02:47 PM, Total Views Today: 0, Total Views: 163
Short Cuts
- Details
- Comparables by Bedrooms
- Waipahu Properties for Sale and Sold at $370,000 or Less
- Waipahu-lower Properties for Sale and Sold at $370,000 or Less
- Island-Wide Properties for Sale and Sold at $370,000 or Less
- History from MLS
- Add to Saved Search
- Tax Info
- Tax Website
- Parcel and Zoning Map Website
- Tsunami Evacuation Zone Website
- Flood Zone Website
- New Building Permit Website
- Old Building Permit Website
- Maps
- Buyer's Closing Cost Calculator
- Seller's Closing Cost Calculator
- Listing Traffic
- Mortgage Savings Calc
- Crime
- Sex Offenders
- Print Options: PDF No Photos
- PDF 2 Photos
- PDF All Photos
OahuRE.com Notes About This Property
View all new listings in the Leolua Regent since this property was listed.
The last sale on May 5, 2006, used Conventional financing, so it is not an assumable mortgage.
Listed previously on February 15, 2026 for $370,000. View Details
Listed previously on December 23, 2024 for $420,000. View Details
Listed previously on February 28, 2006 for $188,000. View Details
Listed previously on August 31, 2004 for $125,000. View Details
Fell out of escrow or Temporarily Withdrawn 1 time. View Details
Price Decreased 7 times. View Details
Withdrawn 1 time. View Details
Expired 1 time. View Details
There are 2 buildings in the same neighborhood with similar units for sale.
There are 2 buildings in the same region with similar units for sale.
There were 15 units sold in the last 2 years in the Leolua Regent building.
Details * Showing Request with 20% Rebate * Top * 1 * Next
Click on any photo to view the next photo.
Details * Showing Request with 20% Rebate * Top * 2 * Previous * Next
Details * Showing Request with 20% Rebate * Top * 3 * Previous * Next
Details * Showing Request with 20% Rebate * Top * 4 * Previous * Next
Details * Showing Request with 20% Rebate * Top * 5 * Previous * Next
Details * Showing Request with 20% Rebate * Top * 6 * Previous * Next
Details * Showing Request with 20% Rebate * Top * 7 * Previous * Next
Details * Showing Request with 20% Rebate * Top * 8 * Previous * Next
Details * Showing Request with 20% Rebate * Top * 9 * Previous * Next
Details * Showing Request with 20% Rebate * Top * 10 * Previous * Next
Details * Showing Request with 20% Rebate * Top * 11 * Previous * Next
Details * Showing Request with 20% Rebate * Top * 12 * Previous * Next
Details * Showing Request with 20% Rebate * Top * 13 * Previous * Next
Details * Showing Request with 20% Rebate * Top * 14 * Previous * Next
Details * Showing Request with 20% Rebate * Top * 15 * Previous * Next
Details * Showing Request with 20% Rebate * Top * 16 * Previous * Next
Details * Showing Request with 20% Rebate * Top * 17 * Previous * Next
Details * Showing Request with 20% Rebate * Top * 18 * Previous * Next
Details * Showing Request with 20% Rebate * Top * 19 * Previous * Next
Details * Showing Request with 20% Rebate * Top * 20 * Previous * Next
Details * Showing Request with 20% Rebate * Top * 21 * Previous
Property Details
Top of Page * Showing Request with 20% Rebate * Questions?
| MLS#: | 202506252 * Questions? |
| Status: | Cancelled See History |
| Price: | $370,000 |
| Monthly: | $ 3,215.56 Update the default down payment and interest rate |
| Monthly payment estimate for $ 370,000 price, 10% down, 6.69% interest rate, 30 year loan, $ 119 taxes, and $ 950 fees. Insurance not included. | |
| Beds: | 3 Baths: 1 Half: 0 Parking Spaces: 1 |
| Living Sq Ft: | 868 |
| Land Tenure: | FS - Fee Simple |
| Total Fees: | $950 |
| Lanai Sq Ft: | 0 |
| Address: | 94-246 Leoku Street E306 Waipahu HI 96797 |
| Region: | Waipahu - Activity |
| Neighborhood: | Waipahu-Lower - Activity |
| Street: | Leoku - Activity * Leoku Street E306 Stats |
| Building Name: | Activity in Leolua Regent * Leolua Regent Stats |
| Statistics: | Live Building Stats |
| Showing: | Showing Request with 20% Rebate |
| Original: | $399,000 |
| Change: | $-29,000 -7.27% |
| Parcel#: | 1-9-4-047-013-0154 |
| Link: | Tax Info/Plat Map/Parcel Map/Sketch |
| Days: | 326 days in Active or In Escrow Showing |
| Date: | Listed: 03-07-2025 |
| Date: | Status Change: 01-27-2026 |
| Year Built: | 1969 Remodeled: |
| View: | None |
| Frontage: | |
| Monthly Tax: | $119 Year: 2024 |
| Land: | FS - Fee Simple |
| Condition: | Above Average, Average |
| Description: | |
|
Attention O'ahu investors and first-time buyers — this is the ONE you’ve been waiting for! Imagine owning a turnkey condo on O'ahu priced below tax assessed value —get instant equity. Three bedrooms, one bath, massive natural light, and island trade-wind breezes keep it cool. Durable vinyl plank floors, huge living area built for hosting, and a kitchen ready for day-to-day life or rental. Maintenance fee includes electricity, cable/Internet, water & sewer. 1 assigned parking + minutes to groceries, restaurants. Schedule your showing today! |
|
| Inclusions:
Cable TV, Ceiling Fan, Range/Oven, Refrigerator
Amenities: Community Laundry, Pool on Property, Resident Manager Utilities: Construction: Concrete, Double Wall, Masonry/Stucco Lot Features: Floor: Laminate Disclosures: Property Disclosure Stmt Land Recorded: Regular System Furnished: Unknown Possession: 45 Days or Less Terms: Cash, Conventional, VA Sale Conditions: None Pet Friendly: No Occupancy: 68% Number of Parking Spaces: 1 Parking Spaces Number: 22 Floor Number: 3 Elevators: 0 Management Company Name & Phone: CenPac Properties 808-593-2902 |
|
| Sold Price: | |
| Concession: | |
| Closed: | |
| Sold Ratio: | |
| Days Sold: | |
| Land: | $163,100 |
| Building: | $246,500 |
| Assessed Total: | $409,600 |
| Assessed Ratio: | 90.33% |
| Pool: | |
| Location: | |
| Parking: | Assigned, Street |
| District Locator: | DOE Locator to Confirm District |
| Area Total: | 0 |
| Acres: | 0.0000 |
| Topography: | |
| Building Style: | Low-Rise 6 or Less Stories, Walk-Up |
| Building: | Leolua Regent |
| New Const: | No |
| Maint. Fee: | $803 |
| Assoc. Fee: | $0 |
| Other Fee: | $147 |
| Includes: | Cable TV, Electricity, Hot Water, Internet Service, Other Common Expenses, Sewer, Water |
| Total Fees: | $950 |
| Exemption: | $0 |
| Other: | 0 |
| Lanai Sq Ft: | 0 |
| Garage Sq Ft: | 0 |
| Avg Sq Ft Living: | $426.27 |
| Security: | Key |
| Rental Income: | $0 |
| Zoning: | 17 - AMX-2 Medium Density Apt M |
| Flood Zone: | Zone D * Check if this property is in a Flood Zone |
| Tsunami Zone: | Check if this property is in a Tsunami Zone * Tsunami Info * Oahu Tsunami Map |
| Roofing: | |
| Set-Backs: | Roads: |
| Easements: | |
| Links: | |
| Google Maps * Supermarkets * Schools * Private Schools * Hospitals * Restaurants * Gyms * Shopping * Attractions * Beaches * Churches * Tax Info including a Plat Map PDF and GIS Parcel Map and Building Sketch | |
| Commuting: | |
| Waikiki * Downtown * Ala Moana * Airport * Kapolei * Hawaii Kai * Kailua Town * Windward Mall * Waikele * North Shore | |
| Barbers Point * Camp Smith * Fort Shafter * Hickam * Lualualei * K-Bay Marine * Pearl Harbor * Schofield * Tripler * Wheeler * VA Mortgage Info | |
| Closing Cost Calculators: | |
| Buyer's Closing Cost Calculator to estimate the buyer's closing cost. | |
| Seller's Closing Cost Calculator to estimate the seller's closing cost. | |
Top of Page * Showing Request with 20% Rebate * Questions?
|
|
|||||||||
| Date | MLS# | Change | Old Value | New Value | List Price | Sold Price | Assessed Total | Land | Building |
| 07-22-2026 | 202602191 | Price Decrease | $365,000 | $350,000 | $350,000 | $0 | $370,100 | $152,700 | $217,400 |
| 02-28-2026 | 202602191 | Price Decrease | $370,000 | $365,000 | $350,000 | $0 | $370,100 | $152,700 | $217,400 |
| 02-15-2026 | 202602191 | New Listing | $370,000 | Active | $350,000 | $0 | $370,100 | $152,700 | $217,400 |
| 01-27-2026 | 202506252 | Cancelled | Active | Cancelled | $370,000 | $0 | $409,600 | $163,100 | $246,500 |
| 12-22-2025 | 202506252 | Price Decrease | $379,000 | $370,000 | $370,000 | $0 | $409,600 | $163,100 | $246,500 |
| 06-10-2025 | 202506252 | Price Decrease | $389,000 | $379,000 | $370,000 | $0 | $409,600 | $163,100 | $246,500 |
| 04-23-2025 | 202506252 | Price Decrease | $399,000 | $389,000 | $370,000 | $0 | $409,600 | $163,100 | $246,500 |
| 03-07-2025 | 202506252 | New Listing | $399,000 | Active | $370,000 | $0 | $409,600 | $163,100 | $246,500 |
| 03-05-2025 | 202428513 | Cancelled | Active | Cancelled | $405,000 | $0 | $409,600 | $163,100 | $246,500 |
| 01-04-2025 | 202428513 | Price Decrease | $420,000 | $405,000 | $405,000 | $0 | $409,600 | $163,100 | $246,500 |
| 12-23-2024 | 202428513 | New Listing | $420,000 | Active | $405,000 | $0 | $409,600 | $163,100 | $246,500 |
| 05-05-2006 | 2604516 | Sold | In Escrow Showing | Sold | $188,000 | $188,000 | $102,800 | $17,400 | $85,400 |
| 03-14-2006 | 2604516 | Active Continue to Show | Active | In Escrow Showing | $188,000 | $188,000 | $102,800 | $17,400 | $85,400 |
| 03-01-2006 | 2604516 | New Listing | Active | Active | $188,000 | $188,000 | $102,800 | $17,400 | $85,400 |
| 12-10-2004 | 2413796 | Withdrawn | Active | Cancelled | $118,000 | $0 | $63,000 | $17,400 | $45,600 |
| 09-19-2004 | 2413796 | Price Decrease | $125,000 | $118,000 | $118,000 | $0 | $63,000 | $17,400 | $45,600 |
| 09-01-2004 | 2413796 | Back On Market | Expired | Active | $118,000 | $0 | $63,000 | $17,400 | $45,600 |
| 09-01-2004 | 2413796 | Expired | Active | Expired | $118,000 | $0 | $63,000 | $17,400 | $45,600 |
| 08-31-2004 | 2413796 | New Listing | Active | Active | $118,000 | $0 | $63,000 | $17,400 | $45,600 |
Top of Page * Showing Request with 20% Rebate * Questions?
Comparables
Best Comparable Properties by Building
Comparable Properties Sorted by Smallest Price Difference First
Listings in Waipahu-Lower Neighborhood
View listings near this one sorted by the closest listing on the top: 1 Mile, 2 Miles, 3 Miles, 4 Miles, 5 Miles
Top of Page * Showing Request with 20% Rebate * Questions?
City and County Public Information Links
 |
|
Tax Info including a Plat Map PDF and GIS Parcel Map Department of Planning & Permitting All Permits Tax Records and Property History in this Neighborhood |
Sex Offender Information
View a map of Sex Offenders for this Zip Code
Top of Page * Showing Request with 20% Rebate * Questions?
Daily Watch List
Add to Daily Watch List by Parcel Number
Top of Page * Showing Request with 20% Rebate * Questions?
View this property's location * Top of Page
View Nearby Schools on Google Maps - Preschools, Elementary Schools, Middle Schools, or High Schools
View Nearby Parks, Farmer's Markets, and Best Restaurants on Google Maps
Directions from this property to nearest Grocery Store, Hospital, Gas Station, Beach Park, and Park
View Waipahu-Lower Neighborhood Boundary
All Neighborhood Boundaries in the Waipahu Region
Top of Page * Showing Request with 20% Rebate * Questions?
Elementary Schools, Middle Schools, High Schools, Charter Schools, Private Schools, Preschools
Top of Page * Showing Request with 20% Rebate * Questions?
View Directions on Google Maps to nearest Beach Access
View Beach Access Points All Over Oahu including Street View, Directions, and Facilities Info
Top of Page * Showing Request with 20% Rebate * Questions?
|
|
|
| Neighborhoods Near Waipahu-lower Shown on Google Earth | |
 |
|
Top of Page * Showing Request with 20% Rebate * Questions?
Top of Page * Showing Request with 20% Rebate * Questions?
Estimated Monthly Mortgage Payment
View OahuRE Mortgage and Interest Savings Calculator
Save $63,920.63 of interest charges by adding an extra payment of $100 per month. View details from the link above.
Rate: |
5.94% | 6.19% | 6.44% | 6.69% | 6.94% | 7.19% | 7.44% | 7.69% | 8.19% |
0% Down |
$2,204 | $2,264 | $2,324 | $2,385 | $2,447 | $2,509 | $2,572 | $2,635 | $2,764 |
3.5% Down |
$2,127 | $2,185 | $2,243 | $2,302 | $2,361 | $2,421 | $2,482 | $2,543 | $2,667 |
10% Down |
$1,984 | $2,037 | $2,092 | $2,147 | $2,202 | $2,258 | $2,315 | $2,372 | $2,488 |
20% Down |
$1,763 | $1,811 | $1,859 | $1,908 | $1,957 | $2,007 | $2,058 | $2,108 | $2,211 |
30% Down |
$1,543 | $1,585 | $1,627 | $1,670 | $1,713 | $1,756 | $1,800 | $1,845 | $1,935 |
40% Down |
$1,322 | $1,358 | $1,394 | $1,431 | $1,468 | $1,505 | $1,543 | $1,581 | $1,658 |
50% Down |
$1,102 | $1,132 | $1,162 | $1,193 | $1,223 | $1,255 | $1,286 | $1,318 | $1,382 |
Top of Page * Showing Request with 20% Rebate * Questions?
Last 7 days of crime (you can then change it to go back further)
Top of Page * Showing Request with 20% Rebate * Questions?
Listing courtesy of REMAX Hawaii
| Active means currently for sale. Active Under Contract means in escrow but still showing and looking for offers. Pending means in escrow and not looking for offers. Hold means the property is temporarily off the market. Cancelled means it is off the market. |
Buyer's rebate is 20% of our commission when we represent the buyer. Based on the information from the Multiple Listing Service of HiCentral MLS, Ltd. Active listings last updated on 08.08.26. Information is deemed reliable but not guaranteed. Copyright: 2026 by HiCentral MLS, Ltd. IDX information is provided exclusively for consumers’ personal, non-commercial use and may not be used for any purpose other than to identify prospective properties consumers may be interested in purchasing. 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 and we offer you are 20% rebate on our commission. 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. The offer of compensation to cooperating participants is made only to the Participants and MLS Subscribers of HICMLS or Participants and MLS Subscribers of other Reciprocating Boards as set forth in that certain Multiple Listing Service Reciprocal Agreement, as amended from time to time, which is incorporated herein by reference |