59-404 Makana Rd Haleiwa, HI 96712
North Shore Neighborhood
4
Beds
3
Baths
2,763
Sq Ft
1.65
Acres
Highlights
- Ocean View
- Wooded Lot
- Main Floor Bedroom
- 71,830 Sq Ft lot
- Wood Flooring
- 3 Car Garage
About This Home
As of May 2025Spectacular ocean views from Kaena Point to Sunset Beach from this bluff front home in Sunset Hills, Pupukea's finest subdivision!Underground Utilities, new roof and sub roof, four car garage, flexible floor plan with two entrances. Main level: Full kitchen with new cabinets and quartz countertops, two bedroom/two bath, small office and nearly new quality vinyl floor plus 933 sq ft. lanai with excellent views. Upper level: two bedroom, one large bath, large wet bar, Brazilian hardwood floor and 867 sq ft. lanai with panoramic views.House needs some work and upgrades or your discriminating Buyers can build their dream house. This is a rare opportunity to get such an amazing parcel as this and in one of the most sought after communities on the North Shore!Watch sunsets year round, spinner dolphin in the summer, epic surf and humpback whales breaching in the winter all from the comfort of your own home!
Last Agent to Sell the Property
Coldwell Banker Island Prop License #RB-15582 Listed on: 03/31/2025
Home Details
Home Type
- Single Family
Est. Annual Taxes
- $8,700
Year Built
- Built in 1992
Lot Details
- 1.65 Acre Lot
- Property fronts a county road
- Wooded Lot
- Zoning described as 56 - Country District
Parking
- 3 Car Garage
Property Views
- Ocean
- Coastline
Home Design
- Slab Foundation
- Shingle Roof
- Asphalt Roof
Interior Spaces
- 2,763 Sq Ft Home
- 2-Story Property
Flooring
- Wood
- Ceramic Tile
- Vinyl
Bedrooms and Bathrooms
- 4 Bedrooms
- Main Floor Bedroom
- 3 Full Bathrooms
Utilities
- Underground Utilities
Community Details
- Pupukea Subdivision
Listing and Financial Details
- Exclusions: Window Coverings
- Assessor Parcel Number 1-5-9-029-034-0000
Ownership History
Date
Name
Owned For
Owner Type
Purchase Details
Listed on
Mar 31, 2025
Closed on
May 13, 2025
Sold by
Oleary Youngblood John and Fletcher Youngblood Beau
Bought by
Makana Wt Llc
Seller's Agent
Juliana Simone
Coldwell Banker Island Prop
Buyer's Agent
Diane Anderson
Sundance Realty
List Price
$3,950,000
Sold Price
$3,550,000
Premium/Discount to List
-$400,000
-10.13%
Total Days on Market
53
Views
24
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Avg. Annual Appreciation
-42.00%
Purchase Details
Closed on
Sep 28, 2017
Sold by
Youngblood David Abert and Youngblood Sarah Agnes Blow
Bought by
Youngblood John O Leary and Youngblood Beau Fletcher
Purchase Details
Closed on
Sep 11, 2008
Sold by
Blow Youngblood Sarah Agnes
Bought by
Youngblood David Albert and The David Abert Youngblood Declaration O
Purchase Details
Closed on
Jan 15, 2002
Sold by
Schatzberg Richard F and Schatzberg Joyce A
Bought by
Blow Youngblood Sarah Agnes and The Sarah Agnes Blow Youngblood Declarat
Purchase Details
Closed on
Dec 23, 1994
Sold by
Schatzberg Richard F and Moore Daniel
Bought by
Schatzberg Richard F and Schatzberg Joyce A
Home Financials for this Owner
Home Financials are based on the most recent Mortgage that was taken out on this home.
Original Mortgage
$390,000
Interest Rate
9.27%
Similar Homes in Haleiwa, HI
Create a Home Valuation Report for This Property
The Home Valuation Report is an in-depth analysis detailing your home's value as well as a comparison with similar homes in the area
Home Values in the Area
Average Home Value in this Area
Purchase History
| Date | Type | Sale Price | Title Company |
|---|---|---|---|
| Warranty Deed | -- | Title Guaranty | |
| Warranty Deed | -- | Title Guaranty | |
| Warranty Deed | -- | None Available | |
| Warranty Deed | -- | None Available | |
| Warranty Deed | -- | None Available | |
| Warranty Deed | -- | None Available | |
| Warranty Deed | -- | None Available | |
| Warranty Deed | $765,000 | -- | |
| Interfamily Deed Transfer | $1,000 | -- |
Source: Public Records
Mortgage History
| Date | Status | Loan Amount | Loan Type |
|---|---|---|---|
| Previous Owner | $390,000 | No Value Available |
Source: Public Records
Property History
| Date | Event | Price | Change | Sq Ft Price |
|---|---|---|---|---|
| 05/16/2025 05/16/25 | Sold | $3,550,000 | -10.1% | $1,285 / Sq Ft |
| 05/08/2025 05/08/25 | Pending | -- | -- | -- |
| 03/16/2025 03/16/25 | For Sale | $3,950,000 | -- | $1,430 / Sq Ft |
Source: HiCentral MLS (Honolulu Board of REALTORS®)
Tax History Compared to Growth
Tax History
| Year | Tax Paid | Tax Assessment Tax Assessment Total Assessment is a certain percentage of the fair market value that is determined by local assessors to be the total taxable value of land and additions on the property. | Land | Improvement |
|---|---|---|---|---|
| 2025 | $8,700 | $2,514,600 | $1,842,400 | $672,200 |
| 2024 | $8,700 | $2,485,600 | $1,700,700 | $784,900 |
| 2023 | $7,947 | $2,270,500 | $1,700,700 | $569,800 |
| 2022 | $7,762 | $2,217,700 | $1,275,500 | $942,200 |
| 2021 | $5,815 | $1,707,900 | $1,190,500 | $517,400 |
| 2020 | $6,141 | $1,754,500 | $1,190,500 | $564,000 |
| 2019 | $6,763 | $1,932,400 | $1,275,500 | $656,900 |
| 2018 | $12,034 | $1,839,100 | $1,275,500 | $563,600 |
| 2017 | $4,635 | $1,444,200 | $992,100 | $452,100 |
| 2016 | $4,610 | $1,437,000 | $935,400 | $501,600 |
| 2015 | $4,337 | $1,359,100 | $822,000 | $537,100 |
| 2014 | -- | $1,289,700 | $779,500 | $510,200 |
Source: Public Records
Agents Affiliated with this Home
-
Juliana Simone
Seller's Agent in 2025
Juliana Simone
Coldwell Banker Island Prop
(808) 220-4702
1 in this area
4 Total Sales
-
Diane Anderson
D
Buyer's Agent in 2025
Diane Anderson
Sundance Realty
(808) 637-6808
2 in this area
10 Total Sales
Map
Source: HiCentral MLS (Honolulu Board of REALTORS®)
MLS Number: 202507227
APN: 1-5-9-029-034-0000
Disclaimer: Certain information contained herein is derived from information provided by parties other than Homes.com. All information provided is deemed reliable, but is not guaranteed to be accurate and should be independently verified.
Some of the active listings appearing on this site may be listed by other REALTORS(R). 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.
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd. Information is deemed reliable but not guaranteed. Copyright 2025 HiCentral MLS, Ltd
Nearby Homes
- 59-414 Makana Rd
- 59-402 Wilinau Rd
- 59-535 Ke Iki Rd Unit A
- 59-565 Ke Iki Rd Unit A
- 59-610 Kamehameha Hwy Unit A
- 59-495 Ke Waena Rd
- 59-471 Ke Waena Rd
- 59-66 Puula Rd
- 59-153 Kekiliohulani St
- 59-296 Alapio Rd
- 59-465 Kamehameha Hwy
- 59-130 Kekiliohulani St Unit 130
- 59-439 Alapio Rd
- 59-377 Ke Nui Rd
- 59-355 Ke Nui Rd
- 59-329 Ke Nui Rd
- 59-225 Ke Nui Rd Unit A
- 59-586 Pupukea Rd
- 59-555 Akanoho Place
- 59-147 Ke Nui Rd