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
Price: $3,999,000 Area: SUNSET AREA Status: Active
Discover the Ultimate North Shore sanctuary, where a private path leads directly to the sand. This oceanfront retreat is designed to showcase breathtaking views of the surf and sunsets from its open-concept living space and updated modern kitchen. Step outside to your private oasis with an expansive back deck and a spacious front lawn—perfect for entertaining or simply soaking in the coastal beauty.
Unlock Future Potential: Per architectural guidance, a two-story home could be built near the existing home's location, providing the opportunity to create your own custom oceanfront masterpiece. An elevation certificate is available, which eliminates the need for flood insurance. Natural sand accumulation in the area enhances the authentic beachside experience and connection to the shoreline.
Co-ownership Opportunity Available for $1,050,000: The seller will consider selling a 25% co-ownership interest to 4 suitable candidates. Listing by: Keller Williams Honolulu (808) 227-2703
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202520591"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(5) "59-75"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(6) "Hoalua"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(6) "Street"
}
["UnitNumber"]=>
array(1) {
[0]=>
string(0) ""
}
["City"]=>
array(1) {
[0]=>
string(7) "Haleiwa"
}
["StateOrProvince"]=>
array(1) {
[0]=>
string(2) "HI"
}
["PostalCode"]=>
array(1) {
[0]=>
string(5) "96712"
}
["VirtualTourURLUnbranded"]=>
array(1) {
[0]=>
string(51) "https://my.matterport.com/show/?m=vJnp4G7AiQt&mls=1"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "3999000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(11) "SUNSET AREA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(945) "Discover the Ultimate North Shore sanctuary, where a private path leads directly to the sand. This oceanfront retreat is designed to showcase breathtaking views of the surf and sunsets from its open-concept living space and updated modern kitchen. Step outside to your private oasis with an expansive back deck and a spacious front lawn—perfect for entertaining or simply soaking in the coastal beauty.
Unlock Future Potential: Per architectural guidance, a two-story home could be built near the existing home's location, providing the opportunity to create your own custom oceanfront masterpiece. An elevation certificate is available, which eliminates the need for flood insurance. Natural sand accumulation in the area enhances the authentic beachside experience and connection to the shoreline.
Co-ownership Opportunity Available for $1,050,000: The seller will consider selling a 25% co-ownership interest to 4 suitable candidates."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(24) "Keller Williams Honolulu"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "2"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(7) "6744.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "1814"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1956"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(13) "Above Average"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(5) "Ocean"
}
["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(6) "KWPP01"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(22) "adrienne@teamlally.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 227-2703"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(16) "Adrienne W Lally"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "18986774"
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-12-22T16:53:48.470"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2025-09-18"
}
["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:53:48.470"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "27153946"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "27153946"
[1]=>
string(8) "27153947"
[2]=>
string(8) "27153948"
[3]=>
string(8) "27153949"
[4]=>
string(8) "27153950"
[5]=>
string(8) "27153951"
[6]=>
string(8) "27153952"
[7]=>
string(8) "27153953"
[8]=>
string(8) "27153954"
[9]=>
string(8) "27153955"
[10]=>
string(8) "27153956"
[11]=>
string(8) "27153957"
[12]=>
string(8) "27153958"
[13]=>
string(8) "27153959"
[14]=>
string(8) "27153960"
[15]=>
string(8) "27153961"
[16]=>
string(8) "27153962"
[17]=>
string(8) "27153963"
[18]=>
string(8) "27153964"
[19]=>
string(8) "27153965"
[20]=>
string(8) "27153966"
[21]=>
string(8) "27153967"
[22]=>
string(8) "27153968"
[23]=>
string(8) "27153969"
[24]=>
string(8) "27153970"
[25]=>
string(8) "27153971"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202520591
)
[StreetNumber] => Array
(
[0] => 59-75
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Hoalua
)
[StreetSuffix] => Array
(
[0] => Street
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Haleiwa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96712
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://my.matterport.com/show/?m=vJnp4G7AiQt&mls=1
)
[ListPrice] => Array
(
[0] => 3999000.00
)
[Neighbourhood] => Array
(
[0] => SUNSET AREA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Discover the Ultimate North Shore sanctuary, where a private path leads directly to the sand. This oceanfront retreat is designed to showcase breathtaking views of the surf and sunsets from its open-concept living space and updated modern kitchen. Step outside to your private oasis with an expansive back deck and a spacious front lawn—perfect for entertaining or simply soaking in the coastal beauty.
Unlock Future Potential: Per architectural guidance, a two-story home could be built near the existing home's location, providing the opportunity to create your own custom oceanfront masterpiece. An elevation certificate is available, which eliminates the need for flood insurance. Natural sand accumulation in the area enhances the authentic beachside experience and connection to the shoreline.
Co-ownership Opportunity Available for $1,050,000: The seller will consider selling a 25% co-ownership interest to 4 suitable candidates.
)
[ListOfficeName] => Array
(
[0] => Keller Williams Honolulu
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 2
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 6744.00
)
[SqftTotal] => Array
(
[0] => 1814
)
[YearBuilt] => Array
(
[0] => 1956
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Above Average
)
[ParkingTotal] => Array
(
[0] => 3
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Ocean
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => KWPP01
)
[ListAgentEmail] => Array
(
[0] => adrienne@teamlally.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 227-2703
)
[ListAgentFullName] => Array
(
[0] => Adrienne W Lally
)
[CloseDate] => Array
(
[0] =>
)
[Matrix_Unique_ID] => Array
(
[0] => 18986774
)
[MatrixModifiedDT] => Array
(
[0] => 2025-12-22T16:53:48.470
)
[ListingContractDate] => Array
(
[0] => 2025-09-18
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Ocean,Sandy Beach,Waterfront
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 16:53:48.470
)
[_thumbnail_id] => Array
(
[0] => 27153946
)
[listing_image] => Array
(
[0] => 27153946
[1] => 27153947
[2] => 27153948
[3] => 27153949
[4] => 27153950
[5] => 27153951
[6] => 27153952
[7] => 27153953
[8] => 27153954
[9] => 27153955
[10] => 27153956
[11] => 27153957
[12] => 27153958
[13] => 27153959
[14] => 27153960
[15] => 27153961
[16] => 27153962
[17] => 27153963
[18] => 27153964
[19] => 27153965
[20] => 27153966
[21] => 27153967
[22] => 27153968
[23] => 27153969
[24] => 27153970
[25] => 27153971
)
)
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on December 22, 2025 - 4:53 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.
