Listing
Overview
Price: $1,950,000
Area: PUPUKEA
Status: Active
Looking to make your dream home a reality? Discover the ultimate location with this stunning vacant lot in Pupukea, nestled in the breathtaking North Shore of Oahu. Spanning over an expansive 1.30 acres, this property grants you the freedom to construct your dream home, complete with all the luxurious amenities you've envisioned. As if the generous space weren't enough, picture yourself surrounded by a lush oasis of fruit trees, including mature avocado, mango, papaya, and banana trees. With the nearest grocery store and beach within arm's reach, convenience becomes an everyday luxury. And just a short distance away, you'll find yourself in the vibrant Haleiwa Town, a place renowned for its charm and character. As one of the few available lots in this sought-after hilltop area, this county district land is a true gem. Gaze upon the majestic mountain vistas and enjoy glimpses of the sparkling ocean, providing an idyllic backdrop for your dream home. Whether you seek a serene vacation getaway or a forever home, the possibilities are boundless. Seize this remarkable opportunity to own a piece of paradise on the legendary North Shore of Oahu. Please note no structure on property. Listing by: Engel & Volkers Honolulu (808) 369-8880
array(45) {
["MLSNumber"]=>
array(1) {
[0]=>
string(9) "202312894"
}
["StreetNumber"]=>
array(1) {
[0]=>
string(6) "59-439"
}
["PropertyType"]=>
array(1) {
[0]=>
string(13) "Single Family"
}
["StreetName"]=>
array(1) {
[0]=>
string(6) "Alapio"
}
["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(40) "https://player.vimeo.com/video/832378482"
}
["ListPrice"]=>
array(1) {
[0]=>
string(10) "1950000.00"
}
["CurrentPrice"]=>
array(1) {
[0]=>
string(10) "1950000.00"
}
["Neighbourhood"]=>
array(1) {
[0]=>
string(7) "PUPUKEA"
}
["Status"]=>
array(1) {
[0]=>
string(6) "Active"
}
["PublicRemarks"]=>
array(1) {
[0]=>
string(1194) "Looking to make your dream home a reality? Discover the ultimate location with this stunning vacant lot in Pupukea, nestled in the breathtaking North Shore of Oahu. Spanning over an expansive 1.30 acres, this property grants you the freedom to construct your dream home, complete with all the luxurious amenities you've envisioned. As if the generous space weren't enough, picture yourself surrounded by a lush oasis of fruit trees, including mature avocado, mango, papaya, and banana trees. With the nearest grocery store and beach within arm's reach, convenience becomes an everyday luxury. And just a short distance away, you'll find yourself in the vibrant Haleiwa Town, a place renowned for its charm and character. As one of the few available lots in this sought-after hilltop area, this county district land is a true gem. Gaze upon the majestic mountain vistas and enjoy glimpses of the sparkling ocean, providing an idyllic backdrop for your dream home. Whether you seek a serene vacation getaway or a forever home, the possibilities are boundless. Seize this remarkable opportunity to own a piece of paradise on the legendary North Shore of Oahu. Please note no structure on property."
}
["ListOfficeName"]=>
array(1) {
[0]=>
string(24) "Engel & Volkers Honolulu"
}
["BedsTotal"]=>
array(1) {
[0]=>
string(1) "0"
}
["BathsFull"]=>
array(1) {
[0]=>
string(1) "0"
}
["BathsHalf"]=>
array(1) {
[0]=>
string(1) "0"
}
["LotSizeArea"]=>
array(1) {
[0]=>
string(8) "58370.00"
}
["SqftTotal"]=>
array(1) {
[0]=>
string(1) "0"
}
["YearBuilt"]=>
array(1) {
[0]=>
string(1) "0"
}
["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(3) "One"
}
["View"]=>
array(1) {
[0]=>
string(28) "Garden,Mountain,Ocean,Sunset"
}
["MaintenanceExpense"]=>
array(1) {
[0]=>
string(0) ""
}
["LandTenure"]=>
array(1) {
[0]=>
string(15) "FS - Fee Simple"
}
["ElementarySchool"]=>
array(1) {
[0]=>
string(12) "Sunset Beach"
}
["MiddleOrJuniorSchool"]=>
array(1) {
[0]=>
string(6) "Kahuku"
}
["HighSchool"]=>
array(1) {
[0]=>
string(6) "Kahuku"
}
["ListOfficeMLSID"]=>
array(1) {
[0]=>
string(6) "PPRO03"
}
["ListAgentEmail"]=>
array(1) {
[0]=>
string(29) "claudine.yim@evrealestate.com"
}
["ListAgentDirectWorkPhone"]=>
array(1) {
[0]=>
string(14) "(808) 369-8880"
}
["ListAgentFullName"]=>
array(1) {
[0]=>
string(12) "Claudine Yim"
}
["CloseDate"]=>
array(1) {
[0]=>
string(0) ""
}
["MatrixModifiedDT"]=>
array(1) {
[0]=>
string(23) "2024-05-27T08:06:47.500"
}
["Matrix_Unique_ID"]=>
array(1) {
[0]=>
string(8) "17361327"
}
["OriginalEntryTimestamp"]=>
array(1) {
[0]=>
string(23) "2023-06-01T18:41:51.220"
}
["_thumbnail_id"]=>
array(1) {
[0]=>
string(8) "25853236"
}
["listing_image"]=>
array(21) {
[0]=>
string(8) "25853236"
[1]=>
string(8) "25853237"
[2]=>
string(8) "25853238"
[3]=>
string(8) "25853239"
[4]=>
string(8) "25853240"
[5]=>
string(8) "25853241"
[6]=>
string(8) "25853242"
[7]=>
string(8) "25853243"
[8]=>
string(8) "25853244"
[9]=>
string(8) "25853245"
[10]=>
string(8) "25853246"
[11]=>
string(8) "25853247"
[12]=>
string(8) "25853248"
[13]=>
string(8) "25853249"
[14]=>
string(8) "25853250"
[15]=>
string(8) "25853251"
[16]=>
string(8) "25853252"
[17]=>
string(8) "25853253"
[18]=>
string(8) "25853254"
[19]=>
string(8) "25853255"
[20]=>
string(8) "25853256"
}
["MLSAreaMajor"]=>
array(1) {
[0]=>
string(11) "North Shore"
}
["PropertyFrontage"]=>
array(1) {
[0]=>
string(0) ""
}
["SpecialListingConditions"]=>
array(1) {
[0]=>
string(4) "None"
}
}
Array
(
[MLSNumber] => Array
(
[0] => 202312894
)
[StreetNumber] => Array
(
[0] => 59-439
)
[PropertyType] => Array
(
[0] => Single Family
)
[StreetName] => Array
(
[0] => Alapio
)
[StreetSuffix] => Array
(
[0] => Road
)
[UnitNumber] => Array
(
[0] =>
)
[City] => Array
(
[0] => Haleiwa
)
[StateOrProvince] => Array
(
[0] => HI
)
[PostalCode] => Array
(
[0] => 96712
)
[VirtualTourURLUnbranded] => Array
(
[0] => https://player.vimeo.com/video/832378482
)
[ListPrice] => Array
(
[0] => 1950000.00
)
[CurrentPrice] => Array
(
[0] => 1950000.00
)
[Neighbourhood] => Array
(
[0] => PUPUKEA
)
[Status] => Array
(
[0] => Active
)
[PublicRemarks] => Array
(
[0] => Looking to make your dream home a reality? Discover the ultimate location with this stunning vacant lot in Pupukea, nestled in the breathtaking North Shore of Oahu. Spanning over an expansive 1.30 acres, this property grants you the freedom to construct your dream home, complete with all the luxurious amenities you've envisioned. As if the generous space weren't enough, picture yourself surrounded by a lush oasis of fruit trees, including mature avocado, mango, papaya, and banana trees. With the nearest grocery store and beach within arm's reach, convenience becomes an everyday luxury. And just a short distance away, you'll find yourself in the vibrant Haleiwa Town, a place renowned for its charm and character. As one of the few available lots in this sought-after hilltop area, this county district land is a true gem. Gaze upon the majestic mountain vistas and enjoy glimpses of the sparkling ocean, providing an idyllic backdrop for your dream home. Whether you seek a serene vacation getaway or a forever home, the possibilities are boundless. Seize this remarkable opportunity to own a piece of paradise on the legendary North Shore of Oahu. Please note no structure on property.
)
[ListOfficeName] => Array
(
[0] => Engel & Volkers Honolulu
)
[BedsTotal] => Array
(
[0] => 0
)
[BathsFull] => Array
(
[0] => 0
)
[BathsHalf] => Array
(
[0] => 0
)
[LotSizeArea] => Array
(
[0] => 58370.00
)
[SqftTotal] => Array
(
[0] => 0
)
[YearBuilt] => Array
(
[0] => 0
)
[BuildingName] => Array
(
[0] =>
)
[PropertyCondition] => Array
(
[0] => Average
)
[ParkingTotal] => Array
(
[0] => 3
)
[StoriesType] => Array
(
[0] => One
)
[View] => Array
(
[0] => Garden,Mountain,Ocean,Sunset
)
[MaintenanceExpense] => Array
(
[0] =>
)
[LandTenure] => Array
(
[0] => FS - Fee Simple
)
[ElementarySchool] => Array
(
[0] => Sunset Beach
)
[MiddleOrJuniorSchool] => Array
(
[0] => Kahuku
)
[HighSchool] => Array
(
[0] => Kahuku
)
[ListOfficeMLSID] => Array
(
[0] => PPRO03
)
[ListAgentEmail] => Array
(
[0] => claudine.yim@evrealestate.com
)
[ListAgentDirectWorkPhone] => Array
(
[0] => (808) 369-8880
)
[ListAgentFullName] => Array
(
[0] => Claudine Yim
)
[CloseDate] => Array
(
[0] =>
)
[MatrixModifiedDT] => Array
(
[0] => 2024-05-27T08:06:47.500
)
[Matrix_Unique_ID] => Array
(
[0] => 17361327
)
[OriginalEntryTimestamp] => Array
(
[0] => 2023-06-01T18:41:51.220
)
[_thumbnail_id] => Array
(
[0] => 25853236
)
[listing_image] => Array
(
[0] => 25853236
[1] => 25853237
[2] => 25853238
[3] => 25853239
[4] => 25853240
[5] => 25853241
[6] => 25853242
[7] => 25853243
[8] => 25853244
[9] => 25853245
[10] => 25853246
[11] => 25853247
[12] => 25853248
[13] => 25853249
[14] => 25853250
[15] => 25853251
[16] => 25853252
[17] => 25853253
[18] => 25853254
[19] => 25853255
[20] => 25853256
)
[MLSAreaMajor] => Array
(
[0] => North Shore
)
[PropertyFrontage] => Array
(
[0] =>
)
[SpecialListingConditions] => Array
(
[0] => None
)
)
- Property Condition: Average
- Number of Parking Spaces: 3
- View: Garden,Mountain,Ocean,Sunset
- Listing Office: Engel & Volkers Honolulu
- Land Tenure: FS - Fee Simple
- Elementary School: Sunset Beach
- Middle School: Kahuku
- High School: Kahuku
