59-414 Makana Road Haleiwa, HI 96712
Listing
Overview
Price: $3,995,000
Area: PUPUKEA
Status: Active
Once in a lifetime opportunity to own 2 acres of prime real estate in Pupukea at an unbeatable price! This remarkable estate is found on a prized rim lot location between Waimea Bay and Sunset Beach, in the highly coveted subdivision of Sunset Hills. Perched above Oahu's fabled North Shore, this property provides unobstructed views from Ka'ena Point to the world-famous Banzai Pipeline surf break- so close you can hear the waves breaking! Entering the property you will find a charming studio with plenty of room to expand upon. Follow the paved driveway down to a private 4 bedroom home where the views become even more mystifying. Highly valued in this area is an existing septic system, approved for use up to 5 bedrooms. Captivating sunsets and consistent trade winds add to the property's charm and appeal. Mature fruit trees are a symbol of the abundance this land has to offer. Additionally, there is a 2 unit CPR development in progress. Each unit will have a separate fee simple ownership and TMK number, which can be separately sold or leased. Zoning approval for 2 single-family homes allows the development to designate each CPR unit to have its own single-family home. Listing by: Corcoran Pacific Properties (808) 589-2040
array(48) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202408763"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "59-414"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(6) "Makana"
}
["StreetSuffix"]=>
array(1) {
[0]=>
string(4) "Road"
}
["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(0) ""
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "3995000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
NULL
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "PUPUKEA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1184) "Once in a lifetime opportunity to own 2 acres of prime real estate in Pupukea at an unbeatable price! This remarkable estate is found on a prized rim lot location between Waimea Bay and Sunset Beach, in the highly coveted subdivision of Sunset Hills. Perched above Oahu's fabled North Shore, this property provides unobstructed views from Ka'ena Point to the world-famous Banzai Pipeline surf break- so close you can hear the waves breaking! Entering the property you will find a charming studio with plenty of room to expand upon. Follow the paved driveway down to a private 4 bedroom home where the views become even more mystifying. Highly valued in this area is an existing septic system, approved for use up to 5 bedrooms. Captivating sunsets and consistent trade winds add to the property's charm and appeal. Mature fruit trees are a symbol of the abundance this land has to offer. Additionally, there is a 2 unit CPR development in progress. Each unit will have a separate fee simple ownership and TMK number, which can be separately sold or leased. Zoning approval for 2 single-family homes allows the development to designate each CPR unit to have its own single-family home."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(27) "Corcoran Pacific Properties"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "4"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "87120.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(4) "5298"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(4) "1999"
}
["BuildingName"]=>
array(1) {
[0]=>
string(0) ""
}
["PropertyCondition"]=>
array(1) {
[0]=>
string(4) "Fair"
}
["ParkingTotal"]=>
array(1) {
[0]=>
string(1) "3"
}
["StoriesType"]=>
array(1) {
[0]=>
string(3) "Two"
}
["View"]=>
array(1) {
[0]=>
string(38) "Coastline,Garden,Mountain,Ocean,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) "ELIT"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(34) "stephen.cipres@corcoranpacific.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 589-2040"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(16) "Stephen A Cipres"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2025-04-17T09:40:36.797"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17954146"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
NULL
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
NULL
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26175370"
}
["listing_image"]=>
array(26) {
[0]=>
string(8) "26175370"
[1]=>
string(8) "26175371"
[2]=>
string(8) "26175372"
[3]=>
string(8) "26175373"
[4]=>
string(8) "26175374"
[5]=>
string(8) "26175375"
[6]=>
string(8) "26175376"
[7]=>
string(8) "26175377"
[8]=>
string(8) "26175378"
[9]=>
string(8) "26175379"
[10]=>
string(8) "26175380"
[11]=>
string(8) "26175381"
[12]=>
string(8) "26175382"
[13]=>
string(8) "26175383"
[14]=>
string(8) "26175384"
[15]=>
string(8) "26175385"
[16]=>
string(8) "26175386"
[17]=>
string(8) "26175387"
[18]=>
string(8) "26175388"
[19]=>
string(8) "26175389"
[20]=>
string(8) "26175390"
[21]=>
string(8) "26914259"
[22]=>
string(8) "26914260"
[23]=>
string(8) "26914261"
[24]=>
string(8) "26914262"
[25]=>
string(8) "26914263"
}
["ListingContractDate"]=>
array(1) {
[0]=>
string(10) "2024-04-19"
}
["ExemptListingEntryTimestamp"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedTime"]=>
array(1) {
[0]=>
string(12) "09:40:36.797"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202408763
)
[StreetNumber] => Array
(
[0] => 59-414
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Makana
)
[StreetSuffix] => Array
(
[0] => Road
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Haleiwa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96712
)
[VirtualTourURLUnbranded] => Array
(
[0] =>
)
[ListPrice] => Array
(
[0] => 3995000.00
)
[CurrentPrice] => Array
(
[0] =>
)
[Neighbourhood] => Array
(
[0] => PUPUKEA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Once in a lifetime opportunity to own 2 acres of prime real estate in Pupukea at an unbeatable price! This remarkable estate is found on a prized rim lot location between Waimea Bay and Sunset Beach, in the highly coveted subdivision of Sunset Hills. Perched above Oahu's fabled North Shore, this property provides unobstructed views from Ka'ena Point to the world-famous Banzai Pipeline surf break- so close you can hear the waves breaking! Entering the property you will find a charming studio with plenty of room to expand upon. Follow the paved driveway down to a private 4 bedroom home where the views become even more mystifying. Highly valued in this area is an existing septic system, approved for use up to 5 bedrooms. Captivating sunsets and consistent trade winds add to the property's charm and appeal. Mature fruit trees are a symbol of the abundance this land has to offer. Additionally, there is a 2 unit CPR development in progress. Each unit will have a separate fee simple ownership and TMK number, which can be separately sold or leased. Zoning approval for 2 single-family homes allows the development to designate each CPR unit to have its own single-family home.
)
[ListOfficeName] => Array
(
[0] => Corcoran Pacific Properties
)
[BedsTotal] => Array
(
[0] => 4
)
[BathsFull] => Array
(
[0] => 4
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 87120.00
)
[SqftTotal] => Array
(
[0] => 5298
)
[YearBuilt] => Array
(
[0] => 1999
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Fair
)
[ParkingTotal] => Array
(
[0] => 3
)
[StoriesType] => Array
(
[0] => Two
)
[View] => Array
(
[0] => Coastline,Garden,Mountain,Ocean,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] =>
)
[MiddleOrJuniorSchool] => Array
(
[0] =>
)
[HighSchool] => Array
(
[0] =>
)
[ListOfficeMLSID] => Array
(
[0] => ELIT
)
[ListAgentEmail] => Array
(
[0] => stephen.cipres@corcoranpacific.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 589-2040
)
[ListAgentFullName] => Array
(
[0] => Stephen A Cipres
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2025-04-17T09:40:36.797
)
[Matrix_Unique_ID] => Array
(
[0] => 17954146
)
[OriginalEntryTimestamp] => Array
(
[0] =>
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] =>
)
[_thumbnail_id] => Array
(
[0] => 26175370
)
[listing_image] => Array
(
[0] => 26175370
[1] => 26175371
[2] => 26175372
[3] => 26175373
[4] => 26175374
[5] => 26175375
[6] => 26175376
[7] => 26175377
[8] => 26175378
[9] => 26175379
[10] => 26175380
[11] => 26175381
[12] => 26175382
[13] => 26175383
[14] => 26175384
[15] => 26175385
[16] => 26175386
[17] => 26175387
[18] => 26175388
[19] => 26175389
[20] => 26175390
[21] => 26914259
[22] => 26914260
[23] => 26914261
[24] => 26914262
[25] => 26914263
)
[ListingContractDate] => Array
(
[0] => 2024-04-19
)
[ExemptListingEntryTimestamp] => Array
(
[0] =>
)
[MatrixModifiedTime] => Array
(
[0] => 09:40:36.797
)
)
- BedsTotal: 4
- Full Baths: 4
- Land Area (sf): 87,120 sf
- Living (sf): 5,298
- Year Built: 1999
- Property Condition: Fair
- Number of Parking Spaces: 3
- View: Coastline,Garden,Mountain,Ocean,Sunset
- Listing Office: Corcoran Pacific Properties
- Land Tenure: FS - Fee Simple
Based on information from the Multiple Listing Service of HiCentral MLS, Ltd.
listings last updated on April 17, 2025 - 9:40 AM
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.
