Listing
Overview
Price: $3,150,000
Area: WAIALUA
Status: Active
Oceanfront living with investment potential on desirable Kahaone Place in Waialua! This rare, legal duplex features a 3-bedroom main home plus an attached 2-bedroom cottage ideal for maximizing rental income, multigenerational living, or both. With direct beach access and sweeping ocean views from your front yard, this is true North Shore beachfront living. Imagine sunrises over the water, daily surf sessions, and quiet evenings by the shore all from your own property. An upgraded septic system is already in place, and the home is being sold As-Is, offering a prime opportunity to renovate or adjust to suit your vision. Located on a peaceful, community-oriented street close to Haleiwa town, popular surf breaks, and the bike path. Whether you're looking to generate rental income, build equity, or create your dream coastal getaway, this property offers unbeatable lifestyle and long-term value. A rare beachfront investment you won’t want to miss! Listing by: REMAX Hawaii North Shore (808) 637-1500
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202520478"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "67-003"
}
["PropertyType"]=>
array(1) {
[0]=>
string(12) "Multi-Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(7) "Kahaone"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(5) "Place"
}
["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(59) "https://listings.hetproductions.com/sites/xajjpkq/unbranded"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "3150000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "WAIALUA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(958) "Oceanfront living with investment potential on desirable Kahaone Place in Waialua! This rare, legal duplex features a 3-bedroom main home plus an attached 2-bedroom cottage ideal for maximizing rental income, multigenerational living, or both. With direct beach access and sweeping ocean views from your front yard, this is true North Shore beachfront living. Imagine sunrises over the water, daily surf sessions, and quiet evenings by the shore all from your own property. An upgraded septic system is already in place, and the home is being sold As-Is, offering a prime opportunity to renovate or adjust to suit your vision. Located on a peaceful, community-oriented street close to Haleiwa town, popular surf breaks, and the bike path. Whether you're looking to generate rental income, build equity, or create your dream coastal getaway, this property offers unbeatable lifestyle and long-term value. A rare beachfront investment you won’t want to miss!"
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(24) "REMAX Hawaii North Shore"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsFull"]=>
array(1) {
[0]=>
string(0) ""
}
["BathsHalf"]=>
array(1) {
[0]=>
string(0) ""
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "8140.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "4282"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1964"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(7) "Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["StoriesType"]=>
array(1) {
[0]=>
string(5) "Three"
}
["View"]=>
array(1) {
[0]=>
string(24) "Coastline,Mountain,Ocean"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
NULL
}
["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) "ADNS"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(26) "Meme.Moody@remaxhawaii.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 637-1500"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(10) "Meme Moody"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18984303"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-09-29T19:37:36.507"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-09-24"
}
["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) "19:37:36.507"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27161575"
}
["listing_image"]=>
array(25) {
[0]=>
string(8) "27161575"
[1]=>
string(8) "27161576"
[2]=>
string(8) "27161577"
[3]=>
string(8) "27161578"
[4]=>
string(8) "27161579"
[5]=>
string(8) "27161580"
[6]=>
string(8) "27161581"
[7]=>
string(8) "27161582"
[8]=>
string(8) "27161583"
[9]=>
string(8) "27161584"
[10]=>
string(8) "27161585"
[11]=>
string(8) "27161586"
[12]=>
string(8) "27161587"
[13]=>
string(8) "27161588"
[14]=>
string(8) "27161589"
[15]=>
string(8) "27161590"
[16]=>
string(8) "27161591"
[17]=>
string(8) "27161592"
[18]=>
string(8) "27161593"
[19]=>
string(8) "27161594"
[20]=>
string(8) "27161595"
[21]=>
string(8) "27161596"
[22]=>
string(8) "27161597"
[23]=>
string(8) "27161598"
[24]=>
string(8) "27161599"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202520478
)
[StreetNumber] => Array
(
[0] => 67-003
)
[PropertyType] => Array
(
[0] => Multi-Family
)
[StreetName] => Array
(
[0] => Kahaone
)
[StreetSuffix] => Array
(
[0] => Place
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Waialua
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96791
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://listings.hetproductions.com/sites/xajjpkq/unbranded
)
[ListPrice] => Array
(
[0] => 3150000.00
)
[Neighbourhood] => Array
(
[0] => WAIALUA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Oceanfront living with investment potential on desirable Kahaone Place in Waialua! This rare, legal duplex features a 3-bedroom main home plus an attached 2-bedroom cottage ideal for maximizing rental income, multigenerational living, or both. With direct beach access and sweeping ocean views from your front yard, this is true North Shore beachfront living. Imagine sunrises over the water, daily surf sessions, and quiet evenings by the shore all from your own property. An upgraded septic system is already in place, and the home is being sold As-Is, offering a prime opportunity to renovate or adjust to suit your vision. Located on a peaceful, community-oriented street close to Haleiwa town, popular surf breaks, and the bike path. Whether you're looking to generate rental income, build equity, or create your dream coastal getaway, this property offers unbeatable lifestyle and long-term value. A rare beachfront investment you won’t want to miss!
)
[ListOfficeName] => Array
(
[0] => REMAX Hawaii North Shore
)
[BedsTotal] => Array
(
[0] =>
)
[BathsFull] => Array
(
[0] =>
)
[BathsHalf] => Array
(
[0] =>
)
[LotSizeArea] => Array
(
[0] => 8140.00
)
[SqftTotal] => Array
(
[0] => 4282
)
[YearBuilt] => Array
(
[0] => 1964
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Average
)
[ParkingTotal] => Array
(
[0] => 3
)
[StoriesType] => Array
(
[0] => Three
)
[View] => Array
(
[0] => Coastline,Mountain,Ocean
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => ADNS
)
[ListAgentEmail] => Array
(
[0] => Meme.Moody@remaxhawaii.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 637-1500
)
[ListAgentFullName] => Array
(
[0] => Meme Moody
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18984303
)
[MatrixModifiedDT] => Array
(
[0] => 2025-09-29T19:37:36.507
)
[ListingContractDate] => Array
(
[0] => 2025-09-24
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Ocean,Sandy Beach,Waterfront
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 19:37:36.507
)
[_thumbnail_id] => Array
(
[0] => 27161575
)
[listing_image] => Array
(
[0] => 27161575
[1] => 27161576
[2] => 27161577
[3] => 27161578
[4] => 27161579
[5] => 27161580
[6] => 27161581
[7] => 27161582
[8] => 27161583
[9] => 27161584
[10] => 27161585
[11] => 27161586
[12] => 27161587
[13] => 27161588
[14] => 27161589
[15] => 27161590
[16] => 27161591
[17] => 27161592
[18] => 27161593
[19] => 27161594
[20] => 27161595
[21] => 27161596
[22] => 27161597
[23] => 27161598
[24] => 27161599
)
)
- Land Area (sf): 8,140 sf
- Living (sf): 4,282
- Year Built: 1964
- Property Condition: Average
- Number of Parking Spaces: 3
- View: Coastline,Mountain,Ocean
- Listing Office: REMAX Hawaii North Shore
- Land Tenure: FS - Fee Simple
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on September 29, 2025 - 7:37 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.
© Marcus Realty. All Rights Reserved.
