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) "202612715"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "59-059"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["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(1172) "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 and even a boat. Some improvements do not show on tax office records, and all are in very poor/tear down condition. Buyer to conduct their own due diligence regarding legality & allowed use of the 2nd structure. 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 in the Sunset Beach neighborhood and enjoy golfing, hiking, seasonal watersports & pristine beaches. The North Shore lifestyle offers clean fresh air and a laid-back vibe. A relaxed Neighbor Island Country feel yet about an hour to Honolulu International Airport & Waikiki's vibrant art, cultural and entertainment venues. Sold strictly AS IS. Construction loan with 50% down potentially available."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(22) "Coldwell Banker Realty"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "1"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "6250.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1348"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1947"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(28) "Needs Major Repair,Tear Down"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "5"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(15) "Garden,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) "19552843"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2026-07-19T21:45:02.460"
  }
  ["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) "21:45:02.460"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27443587"
  }
  ["listing_image"]=>
  array(21) {
    [0]=>
    string(8) "27443587"
    [1]=>
    string(8) "27443588"
    [2]=>
    string(8) "27443589"
    [3]=>
    string(8) "27443590"
    [4]=>
    string(8) "27443591"
    [5]=>
    string(8) "27443592"
    [6]=>
    string(8) "27443593"
    [7]=>
    string(8) "27443594"
    [8]=>
    string(8) "27443595"
    [9]=>
    string(8) "27443596"
    [10]=>
    string(8) "27443597"
    [11]=>
    string(8) "27443598"
    [12]=>
    string(8) "27443599"
    [13]=>
    string(8) "27443600"
    [14]=>
    string(8) "27443601"
    [15]=>
    string(8) "27443602"
    [16]=>
    string(8) "27443603"
    [17]=>
    string(8) "27443604"
    [18]=>
    string(8) "27443605"
    [19]=>
    string(8) "27443606"
    [20]=>
    string(8) "27443607"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202612715
        )

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

    [PropertyType] => Array
        (
            [0] => Single Family
        )

    [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 and even a boat. Some improvements do not show on tax office records, and all are in very poor/tear down condition. Buyer to conduct their own due diligence regarding legality & allowed use of the 2nd structure. 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 in the Sunset Beach neighborhood and enjoy golfing, hiking, seasonal watersports & pristine beaches. The North Shore lifestyle offers clean fresh air and a laid-back vibe. A relaxed Neighbor Island Country feel yet about an hour to Honolulu International Airport & Waikiki's vibrant art, cultural and entertainment venues. Sold strictly AS IS. Construction loan with 50% down potentially available.
        )

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

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

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

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

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

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

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

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

    [PropertyCondition] => Array
        (
            [0] => Needs Major Repair,Tear Down
        )

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

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

    [View] => Array
        (
            [0] => Garden,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] => 19552843
        )

    [MatrixModifiedDT] => Array
        (
            [0] => 2026-07-19T21:45:02.460
        )

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

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

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

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

    [MatrixModifiedTime] => Array
        (
            [0] => 21:45:02.460
        )

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

    [listing_image] => Array
        (
            [0] => 27443587
            [1] => 27443588
            [2] => 27443589
            [3] => 27443590
            [4] => 27443591
            [5] => 27443592
            [6] => 27443593
            [7] => 27443594
            [8] => 27443595
            [9] => 27443596
            [10] => 27443597
            [11] => 27443598
            [12] => 27443599
            [13] => 27443600
            [14] => 27443601
            [15] => 27443602
            [16] => 27443603
            [17] => 27443604
            [18] => 27443605
            [19] => 27443606
            [20] => 27443607
        )

)

PROPERTY INFO

• BedsTotal: 3
• Full Baths: 1
• Half Baths: 1
• Land Area (sf): 6,250 sf
• Living (sf): 1,348
• Year Built: 1947

KEY FEATURES

• Property Condition: Needs Major Repair,Tear Down
• Number of Parking Spaces: 5
• View: Garden,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 19, 2026 - 9:45 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.