20% Rebate for Buyers
$3,500 Flat Fee for Sellers
2% Full Service for Sellers
54-237 Kamehameha Highway Hauula HI 96717
$1,599,000 | OahuRE Rebate $8,795 | Active
Listed on 03-25-2024
4 Bedrooms, 3 Full Baths, 0 Half Baths, 6 Parking Spaces
2,824 Square Feet Living * 11,890 Square Feet Land
Sell for a $3,500 Flat Fee or 2% With Full Service.
Learn How to Eliminate the Buyer’s Agent Commission..
Contact Us for a Showing and a 20% Commission Rebate.
View Virtual Tour
Property Last Viewed: 04/26/2024 04:47 PM, Total Views Today: 0, Total Views: 268, Viewed History
Save This Property to Receive Automatic Email Updates When the Status Changes
Short Cuts
- Details
- Instant Comparables
- Comparables by Sq. Ft.
- Other Comparable Options
- Short Link
- Similar Listings
- History from MLS
- Add to Saved Search
- Tax Info
- Tax Website
- Maps
- Showing Request
- Make Offer
- Buyer's Closing Cost Calculator
- Seller's Closing Cost Calculator
- Listing Traffic
- PDF No Photos
- PDF 2 Photos
- PDF All Photos
- Mortgage Calc
Update the default down payment and interest rate.
OahuRE.com Notes About This Property
View all new listings in the Hauula neighborhood since this property was listed.
Seller is selling `As Is` and may not want to do repairs or issue credits during the inspection period.
The last sale on July 9, 2021, used a VA loan, so it should be assumable at a lower interest rate.
Listed previously on February 22, 2021 for $1,325,000. View Details
Listed previously on April 18, 2020 for $1,399,800. View Details
Listed previously on April 14, 2019 for $1,577,700. View Details
Listed previously on June 1, 2017 for $1,585,900. View Details
Listed previously on December 19, 2016 for $1,527,900. View Details
Listed previously on May 19, 2016 for $1,527,900. View Details
Listed previously on November 9, 2015 for $1,600,000. View Details
Listed previously on August 25, 2003 for $625,000. View Details
Listed previously on November 11, 2002 for $499,000. View Details
Listed previously on July 27, 2002 for $558,000. View Details
Fell out of escrow or Temporarily Withdrawn 1 time. View Details
Price Decreased 5 times. View Details
Temporarily Withdrawn 2 times. View Details
Withdrawn 2 times. View Details
Expired 6 times. View Details
There were 46 homes sold in the last 2 years in the Hauula neighborhood.
Details * Showing Request * Top * 1 * Next
Click on any photo to view next photo.
Details * Showing Request * Top * 2 * Previous * Next
Details * Showing Request * Top * 3 * Previous * Next
Details * Showing Request * Top * 4 * Previous * Next
Details * Showing Request * Top * 5 * Previous * Next
Details * Showing Request * Top * 6 * Previous * Next
Details * Showing Request * Top * 7 * Previous * Next
Details * Showing Request * Top * 8 * Previous * Next
Details * Showing Request * Top * 9 * Previous * Next
Details * Showing Request * Top * 10 * Previous * Next
Details * Showing Request * Top * 11 * Previous * Next
Details * Showing Request * Top * 12 * Previous * Next
Details * Showing Request * Top * 13 * Previous * Next
Details * Showing Request * Top * 14 * Previous * Next
Details * Showing Request * Top * 15 * Previous * Next
Details * Showing Request * Top * 16 * Previous * Next
Details * Showing Request * Top * 17 * Previous * Next
Details * Showing Request * Top * 18 * Previous * Next
Details * Showing Request * Top * 19 * Previous * Next
Details * Showing Request * Top * 20 * Previous * Next
Details * Showing Request * Top * 21 * Previous * Next
Details * Showing Request * Top * 22 * Previous * Next
Details * Showing Request * Top * 23 * Previous * Next
Details * Showing Request * Top * 24 * Previous * Next
Details * Showing Request * Top * 25 * Previous
Older Photos From A Previous Listing
Property Details
Top of Page * Showing Request * Questions?
| MLS#: | 202407024 * Questions? |
| Status: | Active since 03-25-2024 See History |
| Price: | $1,599,000 |
| Rebate: | $ 8,795 from OahuRE.com. |
| Monthly: | $ 9,616.93 Update the default down payment and interest rate |
| Monthly payment estimate for $ 1,599,000 price, 10% down, 6.60% interest rate, 30 year loan, $ 426 taxes, and $ 0 fees. Insurance not included. | |
| Beds: | 4 Baths: 3 Half: 0 Parking Spaces: 6 |
| Living Sq Ft: | 2,824 |
| Land Sq Ft: | 11,890 |
| Land Tenure: | FS - Fee Simple |
| Address: | 54-237 Kamehameha Highway Hauula HI 96717 |
| Region: | Kaneohe - Activity |
| Neighborhood: | Hauula - Activity * Hauula Stats |
| Street: | Kamehameha - Activity * Kamehameha Highway Stats |
| Showing: | Showing Request |
| Original: | $1,599,000 |
| Change: | $0 0.00% |
| Parcel#: | 1-5-4-011-034-0000 |
| Link: | Tax Info/Plat Map/Parcel Map/Sketch |
| Days: | 33 days in Active or In Escrow Showing |
| Date: | Listed: 03-25-2024 |
| Date: | Status Change: 03-25-2024 |
| Recent History: | Last Sold on 07-09-2021 for $1,325,000 - MLS# 202104362 - Seller's Agent: Jason Wong, Buyer's Agent: Emily C Blinkhorn |
| Year Built: | 1981 Remodeled: |
| View: | Coastline, Ocean, Sunrise |
| Frontage: | Ocean, Waterfront |
| Monthly Tax: | $426 Year: 2023 |
| Land: | FS - Fee Simple |
| Condition: | Above Average |
| Description: | |
|
Assumable 2.25% VA Mortgage through Freedom Mortgage. Seller will leave their VA eligibility attached to mortgage so ANY qualifying buyer (NON-VA ok!) may assume. . 50 owned PV panels which resulted in only minimal HECO monthly payments. Solar water heating as well. Gated flag driveway for added privacy. Very well maintained home with main house configured as a 3/2 with a separate connected 1/1. First floor with bedroom option and full bathroom. New windows installed in 2022. Septic Tank. New exterior paint in 2024. 2 car garage and 2 car carport. Smooth river rock ocean frontage with a protective reef in front and a secondary reef further out. Small peninsula on the north side helps to deter north swells. Boundary wall with sandy yard. Beautiful sunrises and gentile ocean breezes. Truly a special home in the Country! Located just 45 minutes to Honolulu, 25 minutes to Kaneohe and 15 minutes to the North Shore. |
|
| Inclusions:
Auto Garage Door Opener, Ceiling Fan, Chandelier, Dishwasher, Disposal, Dryer, Microwave Hood, Photovoltaic - Owned, Range/Oven, Refrigerator, Solar Heater, Washer
Amenities: Full Bath on 1st Floor, Landscaped, Patio/Deck, Wall/Fence Utilities: Cable, Internet, Public Water, Septic, Underground Electricity Construction: Above Ground, Double Wall, Wood Frame Lot Features: Flag Lot Floor: Ceramic Tile, Other Disclosures: Pets Allowed (Verify), Photovoltaic, Property Disclosure Stmt Land Recorded: Land Court Furnished: Possession: At Closing Terms: Cash, Conventional, USDA Financing, VA Sale Conditions: None |
|
| Sold Price: | |
| Concession: | |
| Closed: | |
| Sold Ratio: | |
| Days Sold: | |
| Land: | $931,300 |
| Building: | $629,900 |
| Assessed Total: | $1,561,200 |
| Assessed Ratio: | 102.42% |
| Pool: | None |
| Location: | Inside |
| Parking: | 2 Car, Boat, Carport, Driveway, Garage |
| District Locator: | DOE Locator to Confirm District |
| Area Total: | 11,890 |
| Acres: | 0.2730 |
| Topography: | Level |
| Building Style: | Detach Single Family |
| Building: | |
| New Const: | No |
| Maint. Fee: | $0 |
| Assoc. Fee: | $0 |
| Other Fee: | $0 |
| Includes: | |
| Total Fees: | $0 |
| Exemption: | $100,000 |
| Other: | 0 |
| Lanai Sq Ft: | 465 |
| Garage Sq Ft: | 480 |
| Avg Sq Ft Living: | $566.22 |
| Avg Sq Ft Land: | $134.48 |
| Security: | Gated Community, Key |
| Rental Income: | $0 |
| Stories: | Two CPR: No |
| Zoning: | 05 - R-5 Residential District |
| Flood Zone: | Zone AE * 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: | Asphalt Shingle |
| Set-Backs: | C and C Roads: County Rd |
| Easements: | Driveway |
| 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. | |
Listing courtesy of BHGRE Advantage Realty (808) 384-1875
Top of Page * Showing Request * Questions?
| Date | MLS# | Change | Old Value | New Value | List Price | Sold Price | Assessed Total | Land | Building |
| 03-25-2024 | 202407024 | New Listing | Active | $1,599,000 | $0 | $1,561,200 | $931,300 | $629,900 | |
| 07-09-2021 | 202104362 | Sold | In Escrow Showing | Sold | $1,325,000 | $1,325,000 | $1,341,400 | $792,600 | $548,800 |
| 05-11-2021 | 202104362 | In Escrow Showing | Active | In Escrow Showing | $1,325,000 | $1,325,000 | $1,341,400 | $792,600 | $548,800 |
| 02-22-2021 | 202104362 | New Listing | Active | Active | $1,325,000 | $1,325,000 | $1,341,400 | $792,600 | $548,800 |
| 02-16-2021 | 202008313 | Withdrawn | Active | Cancelled | $1,149,000 | $0 | $1,397,400 | $743,000 | $654,400 |
| 11-05-2020 | 202008313 | Temporarily Withdrawn | Active | Cancelled | $1,149,000 | $0 | $1,397,400 | $743,000 | $654,400 |
| 11-05-2020 | 202008313 | Back On Market | In Escrow Showing | Active | $1,149,000 | $0 | $1,397,400 | $743,000 | $654,400 |
| 10-26-2020 | 202008313 | In Escrow Showing | Active | In Escrow Showing | $1,149,000 | $0 | $1,397,400 | $743,000 | $654,400 |
| 10-16-2020 | 202008313 | Price Decrease | $1,399,800 | $1,149,000 | $1,149,000 | $0 | $1,397,400 | $743,000 | $654,400 |
| 04-18-2020 | 202008313 | New Listing | $1,399,800 | Active | $1,149,000 | $0 | $1,397,400 | $743,000 | $654,400 |
| 04-15-2020 | 201910704 | Expired | Active | Expired | $1,399,800 | $0 | $1,397,400 | $743,000 | $654,400 |
| 11-30-2019 | 201910704 | Price Decrease | $1,577,700 | $1,399,800 | $1,399,800 | $0 | $1,397,400 | $743,000 | $654,400 |
| 04-14-2019 | 201910704 | New Listing | $1,577,700 | Active | $1,399,800 | $0 | $1,397,400 | $743,000 | $654,400 |
| 06-02-2018 | 201712020 | Expired | $1,577,700 | Expired | $1,585,900 | $0 | $1,164,400 | $619,200 | $545,200 |
| 05-27-2018 | 201712020 | Temporarily Withdrawn | Active | Expired | $1,585,900 | $0 | $1,164,400 | $619,200 | $545,200 |
| 06-01-2017 | 201712020 | New Listing | Active | Active | $1,585,900 | $0 | $1,164,400 | $619,200 | $545,200 |
| 05-01-2017 | 201629372 | Expired | Active | Expired | $1,585,900 | $0 | $1,036,500 | $535,000 | $501,500 |
| 03-13-2017 | 201629372 | Price Increase | $1,527,900 | $1,585,900 | $1,585,900 | $0 | $1,036,500 | $535,000 | $501,500 |
| 12-20-2016 | 201629372 | New Listing | $1,527,900 | Active | $1,585,900 | $0 | $1,036,500 | $535,000 | $501,500 |
| 12-20-2016 | 201612248 | Expired | Active | Expired | $1,527,900 | $0 | $1,036,500 | $535,000 | $501,500 |
| 05-20-2016 | 201612248 | New Listing | Active | Active | $1,527,900 | $0 | $1,036,500 | $535,000 | $501,500 |
| 05-19-2016 | 201520925 | Price Decrease | $1,600,000 | $1,527,900 | $1,527,900 | $0 | $1,036,500 | $535,000 | $501,500 |
| 04-19-2016 | 201520925 | Withdrawn | Active | Cancelled | $1,527,900 | $0 | $1,036,500 | $535,000 | $501,500 |
| 11-09-2015 | 201520925 | New Listing | Active | Active | $1,527,900 | $0 | $1,036,500 | $535,000 | $501,500 |
| 12-02-2003 | 2311034 | Sold | In Escrow Showing | Sold | $625,000 | $585,000 | $551,500 | $254,200 | $297,300 |
| 09-28-2003 | 2311034 | Active Continue to Show | Active | In Escrow Showing | $625,000 | $585,000 | $551,500 | $254,200 | $297,300 |
| 08-25-2003 | 2311034 | New Listing | Active | Active | $625,000 | $585,000 | $551,500 | $254,200 | $297,300 |
| 03-12-2003 | 2212391 | Sold | Expired | Sold | $469,000 | $464,000 | $551,500 | $254,200 | $297,300 |
| 03-12-2003 | 2212391 | Price Decrease | $469,000 | $464,000 | $469,000 | $464,000 | $551,500 | $254,200 | $297,300 |
| 02-11-2003 | 2212391 | Expired | In Escrow Showing | Expired | $469,000 | $464,000 | $551,500 | $254,200 | $297,300 |
| 01-18-2003 | 2212391 | Price Decrease | $499,000 | $469,000 | $469,000 | $464,000 | $551,500 | $254,200 | $297,300 |
| 11-12-2002 | 2212391 | New Listing | $499,000 | Active | $469,000 | $464,000 | $551,500 | $254,200 | $297,300 |
| 10-27-2002 | 2207865 | Expired | Active | Expired | $538,000 | $0 | $551,500 | $254,200 | $297,300 |
Top of Page * Showing Request * Questions?
Comparables
Going more years back returns closer matches.
Similar Properties Sorted by Smallest Price Difference First
Listings in Hauula 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 * Questions?
City and County Public Information Links
Sex Offender Information
View a map of Sex Offenders for this Zip Code
Top of Page * Showing Request * Questions?
Daily Watch List
Add to Daily Watch List by Parcel Number
Top of Page * Showing Request * 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 Hauula Neighborhood Boundary
All Neighborhood Boundaries in the Kaneohe Region
Top of Page * Showing Request * Questions?
Elementary Schools, Middle Schools, High Schools, Charter Schools, Private Schools, Preschools
Top of Page * Showing Request * 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 * Questions?
|
|
| Neighborhoods Near Hauula Shown on Google Earth | |
 |
|
Top of Page * Showing Request * Questions?
Top of Page * Showing Request * Questions?
Estimated Monthly Mortgage Payment
View OahuRE Mortgage and Interest Savings Calculator
Save $73,057.08 of interest charges by adding an extra payment of $100 per month. View details from the link above.
Rate: |
5.85% | 6.10% | 6.35% | 6.60% | 6.85% | 7.10% | 7.35% | 7.60% | 8.10% |
0% Down |
$9,433 | $9,690 | $9,950 | $10,212 | $10,478 | $10,746 | $11,017 | $11,290 | $11,845 |
3.5% Down |
$9,103 | $9,351 | $9,601 | $9,855 | $10,111 | $10,370 | $10,631 | $10,895 | $11,430 |
10% Down |
$8,490 | $8,721 | $8,955 | $9,191 | $9,430 | $9,671 | $9,915 | $10,161 | $10,660 |
20% Down |
$7,547 | $7,752 | $7,960 | $8,170 | $8,382 | $8,597 | $8,813 | $9,032 | $9,476 |
30% Down |
$6,603 | $6,783 | $6,965 | $7,149 | $7,334 | $7,522 | $7,712 | $7,903 | $8,291 |
40% Down |
$5,660 | $5,814 | $5,970 | $6,127 | $6,287 | $6,447 | $6,610 | $6,774 | $7,107 |
50% Down |
$4,717 | $4,845 | $4,975 | $5,106 | $5,239 | $5,373 | $5,508 | $5,645 | $5,922 |
Top of Page * Showing Request * Questions?
Last 7 days of crime (you can then change it to go back further)
Top of Page * Showing Request * Questions?
Popular Yelp Links Sorted by Review Count Near 54-237 Kamehameha Highway
Most Popular, Restaurants, Shopping, Arts & Entertainment, Active Life Activities
Top of Page * Showing Request * Questions?
| 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 04.27.24. Information is deemed reliable but not guaranteed. Copyright: 2024 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 |