Listing
Overview
Price: $2,650,000
Area: WAIALUA
Status: Active
RARE CLASSIC SINGLE LEVEL BEACHFRONT!!! Welcome to the North Shore lifestyle with a classic, timeless, well-maintained single-level beachfront residence! Situated on a quieter loop within the Waialua neighborhood, the original owners meticulously cared for this treasured property and are offering to the market for the first time EVER! This well-maintained home features 3 bedrooms, 2 full bathrooms (primary ensuite) situated on an expansive level lot 9,897 sq ft private lot that stretches from to the sandy Waialua shoreline. A 2-car carport features an extra storage room and driveway for extra parking. Generous front and back yard spaces with a patio space create an idyllic setting for indoor/outdoor living. Enjoy quiet peaceful mornings with coffee or host large gatherings with enough space for volleyball next to the ocean. Thoughtfully upgraded with a newly renovated primary bathroom (2024), fresh interior and exterior paint, (2012) kitchen and bath renovation with roof and window replacements. Window A/C units in the bedrooms provide added comfort. Everyday feels like a vacation from this wonderful home! Close to Haleiwa Town and a truly rare find that you do not want to miss! Listing by: Koi Realty (808) 429-0341
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202524880"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "67-259"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Kahaone"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(4) "Loop"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(7) "Waialua"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96791"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(85) "https://listings.hetproductions.com/videos/019b140e-f3d6-731e-9024-c9569ac59617?v=430"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "2650000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIALUA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1197) "RARE CLASSIC SINGLE LEVEL BEACHFRONT!!! Welcome to the North Shore lifestyle with a classic, timeless, well-maintained single-level beachfront residence! Situated on a quieter loop within the Waialua neighborhood, the original owners meticulously cared for this treasured property and are offering to the market for the first time EVER! This well-maintained home features 3 bedrooms, 2 full bathrooms (primary ensuite) situated on an expansive level lot 9,897 sq ft private lot that stretches from to the sandy Waialua shoreline. A 2-car carport features an extra storage room and driveway for extra parking. Generous front and back yard spaces with a patio space create an idyllic setting for indoor/outdoor living. Enjoy quiet peaceful mornings with coffee or host large gatherings with enough space for volleyball next to the ocean. Thoughtfully upgraded with a newly renovated primary bathroom (2024), fresh interior and exterior paint, (2012) kitchen and bath renovation with roof and window replacements. Window A/C units in the bedrooms provide added comfort. Everyday feels like a vacation from this wonderful home! Close to Haleiwa Town and a truly rare find that you do not want to miss!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(10) "Koi Realty"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "9897.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1116"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1975"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(30) "Coastline,Ocean,Sunrise,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(0) ""
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["HighSchool"]=>
array(1) {
[0]=>
string(0) ""
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(4) "KOHI"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(18) "will@koihawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 429-0341"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(11) "Will Tanaka"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "19082101"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2026-03-01T17:00:01.977"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-12-12"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(28) "Ocean,Sandy Beach,Waterfront"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "17:00:01.977"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27244725"
}
["listing_image"]=>
array(25) {
[0]=>
string(8) "27244725"
[1]=>
string(8) "27244726"
[2]=>
string(8) "27244727"
[3]=>
string(8) "27244728"
[4]=>
string(8) "27244729"
[5]=>
string(8) "27244730"
[6]=>
string(8) "27244731"
[7]=>
string(8) "27244732"
[8]=>
string(8) "27244733"
[9]=>
string(8) "27244734"
[10]=>
string(8) "27244735"
[11]=>
string(8) "27244736"
[12]=>
string(8) "27244737"
[13]=>
string(8) "27244738"
[14]=>
string(8) "27244739"
[15]=>
string(8) "27244740"
[16]=>
string(8) "27244741"
[17]=>
string(8) "27244742"
[18]=>
string(8) "27244743"
[19]=>
string(8) "27244744"
[20]=>
string(8) "27244745"
[21]=>
string(8) "27244746"
[22]=>
string(8) "27244747"
[23]=>
string(8) "27244748"
[24]=>
string(8) "27303090"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202524880
)
[StreetNumber] => Array
(
[0] => 67-259
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Kahaone
)
[StreetSuffix] => Array
(
[0] => Loop
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Waialua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96791
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://listings.hetproductions.com/videos/019b140e-f3d6-731e-9024-c9569ac59617?v=430
)
[ListPrice] => Array
(
[0] => 2650000.00
)
[Neighbourhood] => Array
(
[0] => WAIALUA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => RARE CLASSIC SINGLE LEVEL BEACHFRONT!!! Welcome to the North Shore lifestyle with a classic, timeless, well-maintained single-level beachfront residence! Situated on a quieter loop within the Waialua neighborhood, the original owners meticulously cared for this treasured property and are offering to the market for the first time EVER! This well-maintained home features 3 bedrooms, 2 full bathrooms (primary ensuite) situated on an expansive level lot 9,897 sq ft private lot that stretches from to the sandy Waialua shoreline. A 2-car carport features an extra storage room and driveway for extra parking. Generous front and back yard spaces with a patio space create an idyllic setting for indoor/outdoor living. Enjoy quiet peaceful mornings with coffee or host large gatherings with enough space for volleyball next to the ocean. Thoughtfully upgraded with a newly renovated primary bathroom (2024), fresh interior and exterior paint, (2012) kitchen and bath renovation with roof and window replacements. Window A/C units in the bedrooms provide added comfort. Everyday feels like a vacation from this wonderful home! Close to Haleiwa Town and a truly rare find that you do not want to miss!
)
[ListOfficeName] => Array
(
[0] => Koi Realty
)
[BedsTotal] => Array
(
[0] => 3
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 9897.00
)
[SqftTotal] => Array
(
[0] => 1116
)
[YearBuilt] => Array
(
[0] => 1975
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 4
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Coastline,Ocean,Sunrise,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => KOHI
)
[ListAgentEmail] => Array
(
[0] => will@koihawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 429-0341
)
[ListAgentFullName] => Array
(
[0] => Will Tanaka
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 19082101
)
[MatrixModifiedDT] => Array
(
[0] => 2026-03-01T17:00:01.977
)
[ListingContractDate] => Array
(
[0] => 2025-12-12
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Ocean,Sandy Beach,Waterfront
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 17:00:01.977
)
[_thumbnail_id] => Array
(
[0] => 27244725
)
[listing_image] => Array
(
[0] => 27244725
[1] => 27244726
[2] => 27244727
[3] => 27244728
[4] => 27244729
[5] => 27244730
[6] => 27244731
[7] => 27244732
[8] => 27244733
[9] => 27244734
[10] => 27244735
[11] => 27244736
[12] => 27244737
[13] => 27244738
[14] => 27244739
[15] => 27244740
[16] => 27244741
[17] => 27244742
[18] => 27244743
[19] => 27244744
[20] => 27244745
[21] => 27244746
[22] => 27244747
[23] => 27244748
[24] => 27303090
)
)
- BedsTotal: 3
- Full Baths: 2
- Land Area (sf): 9,897 sf
- Living (sf): 1,116
- Year Built: 1975
- Property Condition: Above Average
- Number of Parking Spaces: 4
- View: Coastline,Ocean,Sunrise,Sunset
- Listing Office: Koi Realty
- Land Tenure: FS - Fee Simple
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on March 1, 2026 - 5:00 PM
Information is deemed reliable but not guaranteed.
Copyright: 2026 by HiCentral MLS, Ltd.
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.
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.
© Marcus Realty. All Rights Reserved.
