Thanksgiving - The office will be closed on Thursday 11/27/25 and Friday 11/28/25
Christmas - The office will be closed on Thursday 12/25/25 and Friday 12/26/25
New Years - The office will be closed on Thursday 1/1/26 and Friday 1/2/26
RARE CLASSIC SINGLE LEVEL BEACHFRONT!!! Welcome to a timeless single-level beachfront residence on the coast of Waialua. Original owners meticulously cared for this treasured property and are offering on the market for the first time EVER! This perfect beach house features 3 bedrooms, 2 full bathrooms (primary ensuite) situated on an expansive level lot 9,897 sq ft private lot that stretches from quiet Kahaone Loop all the way to the sandy Waialua shoreline. 2-car carport features an extra storage room and driveway for extra parking. Generous front and back yard spaces with a patio create an idyllic setting for indoor/outdoor living. Enjoy quiet peaceful mornings with coffee or host large gatherings with enough space for volleyball by 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 provide added comfort in the bedrooms. Everyday feels like a vacation from this wonderful home! Close to Haleiwa Town and a truly rare find that will not last! 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(1105) "RARE CLASSIC SINGLE LEVEL BEACHFRONT!!! Welcome to a timeless single-level beachfront residence on the coast of Waialua. Original owners meticulously cared for this treasured property and are offering on the market for the first time EVER! This perfect beach house features 3 bedrooms, 2 full bathrooms (primary ensuite) situated on an expansive level lot 9,897 sq ft private lot that stretches from quiet Kahaone Loop all the way to the sandy Waialua shoreline. 2-car carport features an extra storage room and driveway for extra parking. Generous front and back yard spaces with a patio create an idyllic setting for indoor/outdoor living. Enjoy quiet peaceful mornings with coffee or host large gatherings with enough space for volleyball by 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 provide added comfort in the bedrooms. Everyday feels like a vacation from this wonderful home! Close to Haleiwa Town and a truly rare find that will not last!"
}
["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) "2025-12-12T16:00:01.730"
}
["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) "16:00:01.730"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27244725"
}
["listing_image"]=>
array(24) {
[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"
}
}
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 a timeless single-level beachfront residence on the coast of Waialua. Original owners meticulously cared for this treasured property and are offering on the market for the first time EVER! This perfect beach house features 3 bedrooms, 2 full bathrooms (primary ensuite) situated on an expansive level lot 9,897 sq ft private lot that stretches from quiet Kahaone Loop all the way to the sandy Waialua shoreline. 2-car carport features an extra storage room and driveway for extra parking. Generous front and back yard spaces with a patio create an idyllic setting for indoor/outdoor living. Enjoy quiet peaceful mornings with coffee or host large gatherings with enough space for volleyball by 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 provide added comfort in the bedrooms. Everyday feels like a vacation from this wonderful home! Close to Haleiwa Town and a truly rare find that will not last!
)
[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] => 2025-12-12T16:00:01.730
)
[ListingContractDate] => Array
(
[0] => 2025-12-12
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Ocean,Sandy Beach,Waterfront
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 16:00:01.730
)
[_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
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on December 12, 2025 - 4:00 PM
Information is deemed reliable but not guaranteed.
Copyright: 2025 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.
