59-497 Ke Waena Rd, Unit B

Haleiwa, HI 96712

$3,400,000
Last Sold Price
4
Beds
2,529 Sq. Ft.
$1,344 / Sq. Ft.
2,529
Sq. Ft.
$1,344
per Sq. Ft.

Description

Ultimate beachfront living on the North Shore! Unbeatable location, just steps to beautiful Log Cabins beach and world class waves. Built by renowned local builder, Trent Johnson, this 4 Bed 4 Bath beachfront masterpiece of design and craftsmanship features Two Ocean View Master Suites opening to a large covered lanai with spectacular views. Kids will love the oversized 3rd bedroom with custom built-in bunk beds and a private lanai. Main level features an additional guest bedroom and full bath. Premier...Ultimate beachfront living on the North Shore! Unbeatable location, just steps to beautiful Log Cabins beach and world class waves. Built by renowned local builder, Trent Johnson, this 4 Bed 4 Bath beachfront masterpiece of design and craftsmanship features Two Ocean View Master Suites opening to a large covered lanai with spectacular views. Kids will love the oversized 3rd bedroom with custom built-in bunk beds and a private lanai. Main level features an additional guest bedroom and full bath. Premier chef's kitchen with premium finishes including custom cabinets, black soapstone countertops, Subzero and Wolf gas range. Beautiful Ironwood floors and vaulted ceilings throughout provide an open concept and design. Huge pocket sliding doors connect indoor/outdoor living, leading to a spacious lanai, large grass area, and path straight to the sand and surf!
Link to video: https://bit.ly/2NbCvmg

Listing Agent

  1. Jason Carey

    Jason Carey

    Listing Agent

    Compass

    License #RS-76292

    jason.carey@compass.com

    P: (808)-679-1698

Property Details for 59-497 Ke Waena Road, Unit B

Architectural Style
CPR, Detach Single Family
View
Coastline, Ocean, Sunset
Zoning
05 - R-5 Residential District
Neighbourhood
SUNSET AREA
Flood Zone
Zone VE, Zone X
Stories/Levels
Two
Land Tenure
FS - Fee Simple
LISTING UPDATED: 06/10/2024 11:54 AM

Property Details for 59-497 Ke Waena Road, Unit B

StatusSold
MLS #201930110
Days on Market209
Taxes$2,427 / month
HOA Fees-
Condo/Co-op Fees-
Compass TypeSingle Family
MLS TypeResidential / Single Family
Year Built2004
Lot Size0.11 AC / 5,000 SF
CountyHonolulu County
Buyer's Agent Compensation2.5%

Location

Sold By Coldwell Banker Pacific Prop., Beth Chang, License #RB-14022; Coldwell Banker Pacific Prop., Scott A Langford, License #RS-60157

Add your commute

Building Information for 59-497 Ke Waena Road, Unit B

Stories-Year Built2004Building Size-Lot Size0.11 AC / 5,000 SF

Payment Calculator

$20,241 per month

30 year fixed, 6.845% Interest

Principal and Interest

$17,814

Property Taxes

$2,427

HOA Dues

$0

The Payment Calculator is for illustrative purposes only.

Property Information for 59-497 Ke Waena Road, Unit B

Summary
Location and General Information
  • Topography: Level
  • City: Haleiwa
  • County Or Parish: Oahu
  • State Or Province: HI
  • Location: Other
Taxes and HOA Information
  • Tax Amount: $2,427.22
  • Tax Assessed Value: $3,345,400.00
  • Tax Assessed Value Improvements: $759,900.00
  • Tax Assessed Value Land: $2,585,000.00
  • Tax Excemption Owner Occupancy: 0
  • Tax Paid By Seller: No
  • Tax Year: 2019
  • Parcel Number: 1-5-9-003-004-0002
  • HOA YN: No
School Information
  • Elementary School: Sunset Beach
  • High School: Kahuku
  • Middle Or Junior School: Kahuku
Parking
  • Parking Features: 3 Car+, Garage
  • Parking Total: 2
Property
Lot Information
  • Property Frontage: Ocean, Sandy Beach, Waterfront
  • Property Sub Type: Single Family
  • Property Type: Single Family
  • Road Frontage: Paved Rd
  • SQFT Garage Carport: 721.0
  • Open Other Spaces Total: 945.0
  • SQFT Roofed Living: 2529.0
  • Sqft Total: 3474.0
  • Land Recorded: Regular System
  • Lot Features: Other
  • Lot Size Area: 5000.0
  • Year Built: 2004
Property and Assessments
  • Appliances: Auto Garage Door Opener, Cable TV, Ceiling Fan, Compactor, Convection Oven, Dishwasher, Disposal, Dryer, Microwave, Range Hood, Range/Oven, Refrigerator, Security System, Washer
  • Photo Count: 1
  • New Development Construction: No
  • Property Condition: Excellent
  • Special Listing Conditions: None
  • Disclosures: None, Licensed Owner
  • Foreclosure: No
  • Fractional Ownership: No
  • Condo Property Regime: Yes
  • Set Backs: Of Record
  • TMK Area: 159
  • TMK Condo Property Regime Number: 2
  • TMK Division: 1
  • TMK Parcel: 4
  • TMKPLAT: 3
  • TMK Section: 9
  • TMK Zone: 5
Utilities
  • Utilities: Cable, Internet, Overhead Electricity, Public Water, Septic, Telephone
Interior and Exterior Features
Exterior Features
  • Amenities: Bedroom on 1st Floor, Full Bath on 1st Floor, Landscaped, Patio/Deck
  • Construction Materials: Double Wall, Wood Frame
  • Easements: None
  • Flooring: Ceramic Tile, Hardwood
  • Pool Features: None
  • Roof: Wood Shake
  • Security Features: Key
Interior Features
  • Baths Full: 4
  • Baths Half: 0
  • Baths Total: 4.0
  • Beds Total: 4.0
  • Room Count: 0
Multi Family
Multi-Family Information
  • Unit Number: B
Agent
Sale and Listing
  • Active Open House Count: 0
  • DOM: 209
  • Listing Service: Full Service
  • Lock Box: No
  • MLS: HI Central
  • MLS Area Major: North Shore
  • Open House Count: 3
  • Status: Sold
  • Public Remarks: Ultimate beachfront living on the North Shore! Unbeatable location, just steps to beautiful Log Cabins beach and world class waves. Built by renowned local builder, Trent Johnson, this 4 Bed 4 Bath beachfront masterpiece of design and craftsmanship features Two Ocean View Master Suites opening to a large covered lanai with spectacular views. Kids will love the oversized 3rd bedroom with custom built-in bunk beds and a private lanai. Main level features an additional guest bedroom and full bath. Premier chef's kitchen with premium finishes including custom cabinets, black soapstone countertops, Subzero and Wolf gas range. Beautiful Ironwood floors and vaulted ceilings throughout provide an open concept and design. Huge pocket sliding doors connect indoor/outdoor living, leading to a spacious lanai, large grass area, and path straight to the sand and surf! Link to video: https://bit.ly/2NbCvmg
  • Possession: At Closing
Showing and Remarks
  • Showing Instructions: Call Listor
Rental
Rent Information
  • Occupant Type: Owner

Property History for 59-497 Ke Waena Road, Unit B

DateEvent & SourcePriceAppreciation
Jul 13, 2020

Sold

HICENTRAL #201930110

$3,400,000
Jul 13, 2020

Contract Signed

HICENTRAL #201930110

Jul 7, 2020

Sold (Public Record)

Public Record #672354512

$3,400,000

+9.9% / yr

Oct 26, 2019

Listed (Active)

HICENTRAL #201930110

$3,990,000
Oct 2, 2019

Permanently Off Market

HICENTRAL #201913662

$3,990,000
May 10, 2019

Listed (Active)

HICENTRAL #201913662

$4,300,000
Dec 24, 2002

Sold (Public Record)

Public Record #105562548

$650,000
DateEvent & SourcePrice
07/13/2020

Sold

HICENTRAL #201930110

$3,400,000
07/13/2020

Contract Signed

HICENTRAL #201930110

07/07/2020

Sold (Public Record)

Public Record #672354512

$3,400,000

+9.9% / yr

10/26/2019

Listed (Active)

HICENTRAL #201930110

$3,990,000
10/02/2019

Permanently Off Market

HICENTRAL #201913662

$3,990,000
05/10/2019

Listed (Active)

HICENTRAL #201913662

$4,300,000
12/24/2002

Sold (Public Record)

Public Record #105562548

$650,000

For completeness, Compass often displays two records for one sale: the MLS record and the public record.

Public Records for 59-497 Ke Waena Road, Unit B

Taxable ValueLand$2,992,500Additions$1,204,400Total$4,196,900
Tax Record2025$39,089 ($3,257 / month)
Home Facts
Beds4Baths4Total Finished SqFt2,308 SqFtAbove Grade Finished SqFt2,308 SqFtStories1Lot Size5,000 SqFtStyleCondominiumYear Built2003ZoningR-5 RESIDENTICountyHONOLULUAPN1-5-9-003-004-0002

Schools near 59-497 Ke Waena Road, Unit B

This home is within Hawaii Department Of Education.
Rating
School
Type
Grades
Distance
Public - PK to 6
Public - 7 to 12
Charter - PK to 8
Charter - K to 12
Rating
School
Distance
Sunset Beach Elementary School
PublicPK to 6

Kahuku High & Intermediate School
Public7 to 12

Kamalani Academy
CharterPK to 8

Hawaii Technology Academy
CharterK to 12

School ratings and boundaries are provided by GreatSchools.org and Pitney Bowes. This information should only be used as a reference. Proximity or boundaries shown here are not a guarantee of enrollment. Please reach out to schools directly to verify all information and enrollment eligibility.

Similar Homes

Similar Sold Homes

No guarantee, warranty or representation of any kind is made regarding the completeness or accuracy of descriptions or measurements (including square footage measurements and property condition), such should be independently verified, and Compass expressly disclaims any liability in connection therewith. Photos may be virtually staged or digitally enhanced and may not reflect actual property conditions. Offers of compensation are subject to change at the discretion of the seller. No financial or legal advice provided. Equal Housing Opportunity. Subject to change at any time. Compass makes no guarantee, warranty or representation regarding the accuracy of any waterfront feature, water view or waterfront view.