59-414 Makana Road Haleiwa, HI 96712
Listing
Overview
Price: $5,700,000
Area: PUPUKEA
Status: Active
In the Pupukea neighborhood, found on the hills above Oahu's North Shore, perfectly situated between Waimea and Sunset Beach, lies an amazing opportunity to own 2 acres of country zoned land in the highly coveted subdivision of Sunset Hills. With its mature royal palms, various fruit trees and unobstructed coastline views from Kaiena Point to Bonzai Pipeline; this estate is truly remarkable. The property's rare rim lot location, often compared to Hollywood Hills, provides a unique vantage point of the world-famous Banzai Pipeline surf break. The consistent trade winds that blow through the area add to the charm and appeal of the land. Additionally, there is a CPR (Condominium Property Regime) development in progress. Each CPR unit will have its own separate fee simple ownership and TMK number, and can be separately sold or leased. The development will designate each unit to be permitted to have one single-family home, offering flexibility for future development or renovation plans. This property presents an enticing opportunity for those seeking a prime, one of a kind location to build a private luxury estate. Listing by: Corcoran Pacific Properties (808) 589-2040
array(45) {
["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) "5700000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "5700000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "PUPUKEA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1128) "In the Pupukea neighborhood, found on the hills above Oahu's North Shore, perfectly situated between Waimea and Sunset Beach, lies an amazing opportunity to own 2 acres of country zoned land in the highly coveted subdivision of Sunset Hills. With its mature royal palms, various fruit trees and unobstructed coastline views from Kaiena Point to Bonzai Pipeline; this estate is truly remarkable. The property's rare rim lot location, often compared to Hollywood Hills, provides a unique vantage point of the world-famous Banzai Pipeline surf break. The consistent trade winds that blow through the area add to the charm and appeal of the land. Additionally, there is a CPR (Condominium Property Regime) development in progress. Each CPR unit will have its own separate fee simple ownership and TMK number, and can be separately sold or leased. The development will designate each unit to be permitted to have one single-family home, offering flexibility for future development or renovation plans. This property presents an enticing opportunity for those seeking a prime, one of a kind location to build a private luxury estate."
}
["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) "2024-09-12T11:21:20.290"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17954146"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2024-04-22T14:43:45.607"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(5) "Other"
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "26175370"
}
["listing_image"]=>
array(21) {
[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"
}
}
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] => 5700000.00
)
[CurrentPrice] => Array
(
[0] => 5700000.00
)
[Neighbourhood] => Array
(
[0] => PUPUKEA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => In the Pupukea neighborhood, found on the hills above Oahu's North Shore, perfectly situated between Waimea and Sunset Beach, lies an amazing opportunity to own 2 acres of country zoned land in the highly coveted subdivision of Sunset Hills. With its mature royal palms, various fruit trees and unobstructed coastline views from Kaiena Point to Bonzai Pipeline; this estate is truly remarkable. The property's rare rim lot location, often compared to Hollywood Hills, provides a unique vantage point of the world-famous Banzai Pipeline surf break. The consistent trade winds that blow through the area add to the charm and appeal of the land. Additionally, there is a CPR (Condominium Property Regime) development in progress. Each CPR unit will have its own separate fee simple ownership and TMK number, and can be separately sold or leased. The development will designate each unit to be permitted to have one single-family home, offering flexibility for future development or renovation plans. This property presents an enticing opportunity for those seeking a prime, one of a kind location to build a private luxury estate.
)
[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] => 2024-09-12T11:21:20.290
)
[Matrix_Unique_ID] => Array
(
[0] => 17954146
)
[OriginalEntryTimestamp] => Array
(
[0] => 2024-04-22T14:43:45.607
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] => Other
)
[SpecialListingConditions] => Array
(
[0] => None
)
[_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
)
)
- BedsTotal: 4
- Full Baths: 4
- Land Area (sf): 87,120
- 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
