Previous Next

59-059 Hoalua Street Haleiwa, HI 96712

Listing
Overview

Price: $1,489,000
Area: SUNSET AREA
Status: Active

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202612726"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "59-059"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(16) "Lots/Acres/Farms"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(6) "Hoalua"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["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) "1489000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(11) "SUNSET AREA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(758) "This Sunset Point location is a recognizable & highly sought after destination for ocean loving enthusiasts worldwide. Imagine waking up to the sound
of the waves with the beach just 2 houses away. The property currently has two structures (each with its own electricity meter), large, covered lanai &
parking slab for multiple cars. Some improvements do not show on tax office records and are in very poor/tear down condition. Buyer to conduct their
own due diligence. Property is sold strictly as is land value only. The North Shore's Ke Ala Pupukea Bike/Walking Path meanders from Shark's Cove
diving spot (& Foodland grocery) to a short way just beyond this property. Build your dream home here! Construction loan with 50% down potentially available."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "6250.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(8) "Mountain"
  }
  ["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) "CBPP02"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(19) "jelhawaii@yahoo.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 225-0569"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(13) "James E Lewis"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "19552982"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-07-15T16:53:16.777"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2026-07-01"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(11) "North Shore"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(5) "Other"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "16:53:16.777"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27443660"
  }
  ["listing_image"]=>
  array(14) {
    [0]=>
    string(8) "27443660"
    [1]=>
    string(8) "27443661"
    [2]=>
    string(8) "27443662"
    [3]=>
    string(8) "27443663"
    [4]=>
    string(8) "27443664"
    [5]=>
    string(8) "27443665"
    [6]=>
    string(8) "27443666"
    [7]=>
    string(8) "27443667"
    [8]=>
    string(8) "27443668"
    [9]=>
    string(8) "27443669"
    [10]=>
    string(8) "27443670"
    [11]=>
    string(8) "27443671"
    [12]=>
    string(8) "27443672"
    [13]=>
    string(8) "27443673"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202612726
        )

    [StreetNumber] => Array
        (
            [0] => 59-059
        )

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

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

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

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

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

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

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

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

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

    [Neighbourhood] => Array
        (
            [0] => SUNSET AREA
        )

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

    [PublicRemarks] => Array
        (
            [0] => This Sunset Point location is a recognizable & highly sought after destination for ocean loving enthusiasts worldwide. Imagine waking up to the sound
of the waves with the beach just 2 houses away. The property currently has two structures (each with its own electricity meter), large, covered lanai &
parking slab for multiple cars. Some improvements do not show on tax office records and are in very poor/tear down condition. Buyer to conduct their
own due diligence. Property is sold strictly as is land value only. The North Shore's Ke Ala Pupukea Bike/Walking Path meanders from Shark's Cove
diving spot (& Foodland grocery) to a short way just beyond this property. Build your dream home here! Construction loan with 50% down potentially available.
        )

    [ListOfficeName] => Array
        (
            [0] => Coldwell Banker Realty
        )

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

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

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

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

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

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

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

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

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

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

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

    [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] => CBPP02
        )

    [ListAgentEmail] => Array
        (
            [0] => jelhawaii@yahoo.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 225-0569
        )

    [ListAgentFullName] => Array
        (
            [0] => James E Lewis
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-07-15T16:53:16.777
        )

    [ListingContractDate] => Array
        (
            [0] => 2026-07-01
        )

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 16:53:16.777
        )

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

    [listing_image] => Array
        (
            [0] => 27443660
            [1] => 27443661
            [2] => 27443662
            [3] => 27443663
            [4] => 27443664
            [5] => 27443665
            [6] => 27443666
            [7] => 27443667
            [8] => 27443668
            [9] => 27443669
            [10] => 27443670
            [11] => 27443671
            [12] => 27443672
            [13] => 27443673
        )

)

PROPERTY INFO

• Land Area (sf): 6,250 sf

KEY FEATURES

• View: Mountain
• Listing Office: Coldwell Banker Realty

FINANCIAL INFO

• Land Tenure: FS - Fee Simple

SCHOOLS

• Elementary School: Sunset Beach
• Middle School: Kahuku
• High School: Kahuku

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 July 15, 2026 - 4:53 PM Information is deemed reliable but not guaranteed. Copyright: 2026 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.