0000 Kamehameha Highway Unit Lot 38 Haleiwa, HI 96712

Take a Virtual Tour

Listing
Overview

Price: $850,000
Area: HALEIWA
Status: Active

Haleiwa Anahulu Stream front with 1.678 acres, fruit trees, water tank and small guest shed to enjoy while planning your custom home. This is a Kuleana parcel, which allows 1 farm dwelling up to 5,000 sqft on the 1st floor and can have a second floor and supporting AG sheds and structures. Can build up to a maximum of 1,000 sq.ft AG structures with out a permit for fast use. Perfect for farming or grazing. Private gated community with one way in and out. Paddleboard or kayak from the river to Haleiwa Harbor and Beach Park for fun in the sun. You can hike for miles into the mountains along the stream. Visitors say this is one of the most beautiful pieces of land they have seen in rural Oahu and is the best-kept secret on the North Shore. Perfect for a family farm or yoga retreat. Enjoy the yurt and the land while you design your custom farm dwelling. Ten-minute bike ride to the center of Haleiwa town. Easy access to Kamehameha Hwy and no North Shore traffic. A magical place in the Anahulu Valley. Listing by: Hawaii Homes International (808) 949-0020

array(46) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202407003"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(4) "0000"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(16) "Lots/Acres/Farms"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(10) "Kamehameha"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(7) "Highway"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(6) "Lot 38"
  }
  ["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(41) "https://www.youtube.com/embed/Guqfr5aUTf0"
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(9) "850000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(9) "850000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(7) "HALEIWA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(1010) "Haleiwa Anahulu Stream front with 1.678 acres, fruit trees, water tank and small guest shed to enjoy while planning your custom home. This is a Kuleana parcel, which allows 1 farm dwelling up to 5,000 sqft on the 1st floor and can have a second floor and supporting AG sheds and structures. Can build up to a maximum of 1,000 sq.ft AG structures with out a permit for fast use. Perfect for farming or grazing. Private gated community with one way in and out. Paddleboard or kayak from the river to Haleiwa Harbor and Beach Park for fun in the sun. You can hike for miles into the mountains along the stream. Visitors say this is one of the most beautiful pieces of land they have seen in rural Oahu and is the best-kept secret on the North Shore. Perfect for a family farm or yoga retreat. Enjoy the yurt and the land while you design your custom farm dwelling. Ten-minute bike ride to the center of Haleiwa town. Easy access to Kamehameha Hwy and no North Shore traffic. A magical place in the Anahulu Valley."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(26) "Hawaii Homes International"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(8) "73094.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    NULL
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(14) "Mountain,Other"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(4) "0.00"
  }
  ["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) "REEW"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(15) "bgwvrdr@aol.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 949-0020"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(12) "Ralph S Gray"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2024-09-24T12:46:04.860"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "17905466"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2024-03-25T14:19:31.350"
  }
  ["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) "26141596"
  }
  ["listing_image"]=>
  array(25) {
    [0]=>
    string(8) "26141596"
    [1]=>
    string(8) "26141597"
    [2]=>
    string(8) "26141598"
    [3]=>
    string(8) "26141599"
    [4]=>
    string(8) "26141600"
    [5]=>
    string(8) "26141601"
    [6]=>
    string(8) "26141602"
    [7]=>
    string(8) "26141603"
    [8]=>
    string(8) "26141604"
    [9]=>
    string(8) "26141605"
    [10]=>
    string(8) "26141606"
    [11]=>
    string(8) "26141607"
    [12]=>
    string(8) "26141608"
    [13]=>
    string(8) "26141609"
    [14]=>
    string(8) "26141610"
    [15]=>
    string(8) "26141611"
    [16]=>
    string(8) "26141612"
    [17]=>
    string(8) "26141613"
    [18]=>
    string(8) "26141614"
    [19]=>
    string(8) "26141615"
    [20]=>
    string(8) "26141616"
    [21]=>
    string(8) "26141617"
    [22]=>
    string(8) "26141618"
    [23]=>
    string(8) "26141619"
    [24]=>
    string(8) "26141620"
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "12:46:04.860"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202407003
        )

    [StreetNumber] => Array
        (
            [0] => 0000
        )

    [PropertyType] => Array
        (
            [0] => Lots/Acres/Farms
        )

    [StreetName] => Array
        (
            [0] => Kamehameha
        )

    [StreetSuffix] => Array
        (
            [0] => Highway
        )

    [UnitNumber] => Array
        (
            [0] => Lot 38
        )

    [City] => Array
        (
            [0] => Haleiwa
        )

    [StateOrProvince] => Array
        (
            [0] => HI
        )

    [PostalCode] => Array
        (
            [0] => 96712
        )

    [VirtualTourURLUnbranded] => Array
        (
            [0] => https://www.youtube.com/embed/Guqfr5aUTf0
        )

    [ListPrice] => Array
        (
            [0] => 850000.00
        )

    [CurrentPrice] => Array
        (
            [0] => 850000.00
        )

    [Neighbourhood] => Array
        (
            [0] => HALEIWA
        )

    [Status] => Array
        (
            [0] => Active
        )

    [PublicRemarks] => Array
        (
            [0] => Haleiwa Anahulu Stream front with 1.678 acres, fruit trees, water tank and small guest shed to enjoy while planning your custom home. This is a Kuleana parcel, which allows 1 farm dwelling up to 5,000 sqft on the 1st floor and can have a second floor and supporting AG sheds and structures. Can build up to a maximum of 1,000 sq.ft AG structures with out a permit for fast use. Perfect for farming or grazing. Private gated community with one way in and out. Paddleboard or kayak from the river to Haleiwa Harbor and Beach Park for fun in the sun. You can hike for miles into the mountains along the stream. Visitors say this is one of the most beautiful pieces of land they have seen in rural Oahu and is the best-kept secret on the North Shore. Perfect for a family farm or yoga retreat. Enjoy the yurt and the land while you design your custom farm dwelling. Ten-minute bike ride to the center of Haleiwa town. Easy access to Kamehameha Hwy and no North Shore traffic. A magical place in the Anahulu Valley.
        )

    [ListOfficeName] => Array
        (
            [0] => Hawaii Homes International
        )

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

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

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

    [LotSizeArea] => Array
        (
            [0] => 73094.00
        )

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

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

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

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

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

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

    [View] => Array
        (
            [0] => Mountain,Other
        )

    [MaintenanceExpense] => Array
        (
            [0] => 0.00
        )

    [LandTenure] => Array
        (
            [0] => FS - Fee Simple
        )

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

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

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

    [ListOfficeMLSID] => Array
        (
            [0] => REEW
        )

    [ListAgentEmail] => Array
        (
            [0] => bgwvrdr@aol.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 949-0020
        )

    [ListAgentFullName] => Array
        (
            [0] => Ralph S Gray
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2024-09-24T12:46:04.860
        )

    [Matrix_Unique_ID] => Array
        (
            [0] => 17905466
        )

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2024-03-25T14:19:31.350
        )

    [MLSAreaMajor] => Array
        (
            [0] => North Shore
        )

    [PropertyFrontage] => Array
        (
            [0] => Other
        )

    [SpecialListingConditions] => Array
        (
            [0] => None
        )

    [_thumbnail_id] => Array
        (
            [0] => 26141596
        )

    [listing_image] => Array
        (
            [0] => 26141596
            [1] => 26141597
            [2] => 26141598
            [3] => 26141599
            [4] => 26141600
            [5] => 26141601
            [6] => 26141602
            [7] => 26141603
            [8] => 26141604
            [9] => 26141605
            [10] => 26141606
            [11] => 26141607
            [12] => 26141608
            [13] => 26141609
            [14] => 26141610
            [15] => 26141611
            [16] => 26141612
            [17] => 26141613
            [18] => 26141614
            [19] => 26141615
            [20] => 26141616
            [21] => 26141617
            [22] => 26141618
            [23] => 26141619
            [24] => 26141620
        )

    [MatrixModifiedTime] => Array
        (
            [0] => 12:46:04.860
        )

)

  • Land Area (sf): 73,094 sf

  • View: Mountain,Other
  • Listing Office: Hawaii Homes International

  • Maintenance Fees: $0
  • Land Tenure: FS - Fee Simple

CONTACT US

Marcus Realty

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

Based on information from the Multiple Listing Service of HiCentral MLS, Ltd. listings last updated on September 24, 2024 - 12:46 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.

© Marcus Realty. All Rights Reserved.