Search Open Houses Buyer's Rebate Sell for 2% Sell for $3,500 Statistics Help Tools Saved Searches Testimonials Blog Contact

Oahu Real Estate Logo

20% Rebate for Buyers
$3,500 Flat Fee for Sellers
2% Full Service for Sellers


59-459 Ke Waena Road Haleiwa HI 96712

$3,950,000 | OahuRE Rebate $15,800 | Active

Price dropped on 03-31-2024. Original price was $5,500,000

Listed on 12-04-2023

3 Bedrooms, 2 Full Baths, 0 Half Baths, 2 Parking Spaces

1,500 Square Feet Living * 5,440 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.

Property Last Viewed: 04/28/2024 04:13 AM, Total Views Today: 1, Total Views: 196, Viewed History

Save This Property to Receive Automatic Email Updates When the Status Changes

Comparables by Square Feet

Short Cuts

Update the default down payment and interest rate.



OahuRE.com Notes About This Property

View all new listings in the Sunset Area neighborhood since this property was listed.

Price Decreased 2 times. View Details

Price trends for Sunset Area.

There were 21 homes sold in the last 2 years in the Sunset Area neighborhood.


59-459 Ke Waena Road

Details * Showing Request * Top * 1 * Next

Click on any photo to view next photo.

59-459 Ke Waena Road

Details * Showing Request * Top * 2 * Previous * Next

Learn More About Our Selling Options

59-459 Ke Waena Road

Details * Showing Request * Top * 3 * Previous * Next

59-459 Ke Waena Road

Details * Showing Request * Top * 4 * Previous * Next

59-459 Ke Waena Road

Details * Showing Request * Top * 5 * Previous * Next

59-459 Ke Waena Road

Details * Showing Request * Top * 6 * Previous * Next

59-459 Ke Waena Road

Details * Showing Request * Top * 7 * Previous * Next

59-459 Ke Waena Road

Details * Showing Request * Top * 8 * Previous * Next

59-459 Ke Waena Road

Details * Showing Request * Top * 9 * Previous * Next

59-459 Ke Waena Road

Details * Showing Request * Top * 10 * Previous * Next

59-459 Ke Waena Road

Details * Showing Request * Top * 11 * Previous * Next

59-459 Ke Waena Road

Details * Showing Request * Top * 12 * Previous * Next

59-459 Ke Waena Road

Details * Showing Request * Top * 13 * Previous * Next

59-459 Ke Waena Road

Details * Showing Request * Top * 14 * Previous * Next

59-459 Ke Waena Road

Details * Showing Request * Top * 15 * Previous * Next

59-459 Ke Waena Road

Details * Showing Request * Top * 16 * Previous * Next

59-459 Ke Waena Road

Details * Showing Request * Top * 17 * Previous * Next

59-459 Ke Waena Road

Details * Showing Request * Top * 18 * Previous * Next

59-459 Ke Waena Road

Details * Showing Request * Top * 19 * Previous * Next

59-459 Ke Waena Road

Details * Showing Request * Top * 20 * Previous * Next

59-459 Ke Waena Road

Details * Showing Request * Top * 21 * Previous * Next

59-459 Ke Waena Road

Details * Showing Request * Top * 22 * Previous * Next

59-459 Ke Waena Road

Details * Showing Request * Top * 23 * Previous * Next

59-459 Ke Waena Road

Details * Showing Request * Top * 24 * Previous * Next

59-459 Ke Waena Road

Details * Showing Request * Top * 25 * Previous

Property Details

Top of Page * Showing Request * Questions?


MLS#: 202326437 * Questions?
Status: Active since 12-04-2023 See History
Price: $3,950,000
Rebate: $ 15,800 from OahuRE.com.
Monthly: $ 23,690.32 Update the default down payment and interest rate
  Monthly payment estimate for $ 3,950,000 price, 10% down, 6.60% interest rate, 30 year loan, $ 986 taxes, and $ 0 fees. Insurance not included.
Beds: 3   Baths: 2   Half: 0  Parking Spaces: 2
Living Sq Ft: 1,500
Land Sq Ft: 5,440
Land Tenure: FS - Fee Simple
Address: 59-459 Ke Waena Road Haleiwa HI 96712
Region: North Shore - Activity
Neighborhood: Sunset Area - Activity * Sunset Area Stats
Street: Ke Waena - Activity * Ke Waena Road Stats
Showing: Showing Request

Top of Page * Showing Request * Questions?

Original: $5,500,000
Change: $-1,550,000    -28.18%
Parcel#: 1-5-9-003-035-0000
Link: Tax Info/Plat Map/Parcel Map/Sketch
Days: 146 days in Active or In Escrow Showing
Date: Listed: 12-04-2023
Date: Status Change: 01-03-2024
Recent History: Not on the MLS in the last 10 years
Year Built: 1958 Remodeled: 1968
View: Coastline, Mountain, Ocean, Sunset
Frontage: Ocean, Sandy Beach, Waterfront
Monthly Tax: $986 Year: 2023
Land: FS - Fee Simple
Condition: Average

Top of Page * Showing Request * Questions?

Description:

.

PEN HOUSE SUNDAY APRIL 21, 2024, NOON TO 5 PM! PLEASE COME! List Price under 4M!! Sellers are motivated! This is a family generation homestead property…all children and grandchildren raised here. Family owned since 1960. On one of the Most Incredible Beachfronts on the entire North Shore! Dramatic Ocean and Sunset Views and right on Rock Pile Beach! Direct view up the coast from Pipeline to Sunset Beach! Not in a Flood Zone & White Sand Beach is protected by "Rock Pile"! The house is a fixer upper but it's a good structure with lots of potential. "In the Action" but just far enough away from Pipeline to make it private! **Owners have just completed a top floor bedroom and full bathroom remodel with new Vinyl Plank flooring, new Jalousie windows** What a difference!

 
 
Inclusions: Cable TV, Refrigerator, Water Heater

Amenities: Landscaped, Patio/Deck, Storage, Wall/Fence

Utilities: Cable, Cesspool, Internet, Overhead Electricity, Public Water, Telephone Construction: Above Ground, Double Wall, Wood Frame Lot Features: Clear Floor: Hardwood Disclosures: Property Disclosure Stmt Land Recorded: Regular System Furnished: Partial

Possession: At Closing, Negotiable Terms: Cash, Conventional Sale Conditions: None

Top of Page * Showing Request * Questions?

Sold Price:
Concession:
Closed:
Sold Ratio:
Days Sold:
Land: $3,026,400
Building: $593,200  
Assessed Total: $3,619,600  
Assessed Ratio: 109.13%
Pool: None
Location: Inside
Parking: 2 Car, Garage

Top of Page * Showing Request * Questions?

District Locator: DOE Locator to Confirm District
Area Total: 5,440
Acres: 0.1249
Topography: Level
Building Style: Detach Single Family
Building:
New Const: No

Top of Page * Showing Request * Questions?

Maint. Fee: $0
Assoc. Fee: $0
Other Fee: $0
Includes:
Total Fees: $0
Exemption: yes
Other: 0
Lanai Sq Ft: 844
Garage Sq Ft: 468
Avg Sq Ft Living: $2,633.33
Avg Sq Ft Land: $726.10
Security:
Rental Income: $0
Stories: Two CPR: No
Zoning: 05 - R-5 Residential District
Flood Zone: Zone X * 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: Composition
Set-Backs: C and C Roads: County Rd
Easements: None

Top of Page * Showing Request * Questions?

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 Sterman Realty (808) 638-8600

Top of Page * Showing Request * Questions?


Core Logic Logo

Property History from MLS

Date MLS# Change Old Value New Value List Price Sold Price Assessed Total Land Building
03-31-2024 202326437 Price Decrease $4,000,000 $3,950,000 $3,950,000 $0 $3,619,600 $3,026,400 $593,200
01-31-2024 202326437 Price Decrease $5,500,000 $4,000,000 $3,950,000 $0 $3,619,600 $3,026,400 $593,200
01-03-2024 202326437 New Listing $5,500,000 Active $3,950,000 $0 $3,619,600 $3,026,400 $593,200

Top of Page * Showing Request * Questions?


Comparables

Instant Comparables

Comparables with Options

Multiple Comparable Options

Going more years back returns closer matches.

Last 6 Months Sold

Last 1 Year Sold

Last 2 Years Sold

Last 3 Years Sold

Similar Properties Sorted by Smallest Price Difference First

Listings in Sunset Area 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

City and County Logo

Tax Info including a Plat Map PDF and GIS Parcel Map

Department of Planning & Permitting General Information

Department of Planning & Permitting All Permits

Dept. of Emergency Management Public Safety Info

Tax Records and Property History in this Neighborhood

Tax Records and Property History on this Street

Building Sketch

Top of Page * Showing Request * Questions?


Sex Offender Information

Attorney General Logo

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?



Google Maps

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 Sunset Area Neighborhood Boundary

View Tax Records

All Neighborhood Boundaries in the North Shore Region

Neighborhood Boundaries

View Full Size in Google Maps

Top of Page * Showing Request * Questions?



Elementary Schools, Middle Schools, High Schools, Charter Schools, Private Schools, Preschools

School Map

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

Beach Access Map

Top of Page * Showing Request * Questions?



Google Earth

Neighborhoods Near Sunset Area Shown on Google Earth
 
Googe Earth View

Top of Page * Showing Request * Questions?



Google Traffic Maps

Example Traffic Map

Top of Page * Showing Request * Questions?



Estimated Monthly Mortgage Payment

View OahuRE Mortgage and Interest Savings Calculator

Save $75,392.68 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
$23,303$23,937$24,578$25,227$25,883$26,545$27,214$27,890$29,260
3.5% Down
$22,487$23,099$23,718$24,344$24,977$25,616$26,262$26,914$28,235
10% Down
$20,972$21,543$22,120$22,704$23,294$23,891$24,493$25,101$26,334
20% Down
$18,642$19,149$19,663$20,182$20,706$21,236$21,772$22,312$23,408
30% Down
$16,312$16,756$17,205$17,659$18,118$18,582$19,050$19,523$20,482
40% Down
$13,982$14,362$14,747$15,136$15,530$15,927$16,329$16,734$17,556
50% Down
$11,651$11,968$12,289$12,614$12,941$13,273$13,607$13,945$14,630

Top of Page * Showing Request * Questions?



Crime Mapping

Last 7 days of crime (you can then change it to go back further)

Top of Page * Showing Request * Questions?



Yelp

Popular Yelp Links Sorted by Review Count Near 59-459 Ke Waena Road

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.28.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

Our Privacy Policy