59-439 Alapio Road Haleiwa, HI 96712

Take a Virtual Tour

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) 255-6014

array(42) {
  ["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) 255-6014"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(12) "Claudine Yim"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2023-06-01T18:54:15.820"
  }
  ["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"
  }
}
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) 255-6014
        )

    [ListAgentFullName] => Array
        (
            [0] => Claudine Yim
        )

    [CloseDate] => Array
        (
            [0] => 
        )

    [MatrixModifiedDT] => Array
        (
            [0] => 2023-06-01T18:54:15.820
        )

    [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
        )

)

  • Land Area (sf): 58,370

  • 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

CONTACT US

Marcus Realty

#RB-7120
info@marcushawaii.com
(808)839-7446