Previous Next

59-75 Hoalua Street Haleiwa, HI 96712

Take a Virtual Tour

Listing
Overview

Price: $3,999,000
Area: SUNSET AREA
Status: Active

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202520591"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(5) "59-75"
  }
  ["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(51) "https://my.matterport.com/show/?m=vJnp4G7AiQt&mls=1"
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "3999000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(11) "SUNSET AREA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(986) "OPEN HOUSE on SUNDAY, 11/9 from 2-5pm. 
Discover the Ultimate North Shore sanctuary, where a private path leads directly to the sand. This oceanfront retreat is designed to showcase breathtaking views of the surf and sunsets from its open-concept living space and updated modern kitchen. Step outside to your private oasis with an expansive back deck and a spacious front lawn—perfect for entertaining or simply soaking in the coastal beauty.

Unlock Future Potential: Per architectural guidance, a two-story home could be built near the existing home's location, providing the opportunity to create your own custom oceanfront masterpiece. An elevation certificate is available, which eliminates the need for flood insurance. Natural sand accumulation in the area enhances the authentic beachside experience and connection to the shoreline.

Co-ownership Opportunity Available for $1,050,000: The seller will consider selling a 25% co-ownership interest to 4 suitable candidates."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(24) "Keller Williams Honolulu"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(7) "6744.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1814"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1956"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(13) "Above Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(5) "Ocean"
  }
  ["MaintenanceExpense"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["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(6) "KWPP01"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(22) "adrienne@teamlally.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 227-2703"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(16) "Adrienne W Lally"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18986774"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-11-05T10:00:01.373"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-09-18"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(11) "North Shore"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(28) "Ocean,Sandy Beach,Waterfront"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "10:00:01.373"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27153946"
  }
  ["listing_image"]=>
  array(26) {
    [0]=>
    string(8) "27153946"
    [1]=>
    string(8) "27153947"
    [2]=>
    string(8) "27153948"
    [3]=>
    string(8) "27153949"
    [4]=>
    string(8) "27153950"
    [5]=>
    string(8) "27153951"
    [6]=>
    string(8) "27153952"
    [7]=>
    string(8) "27153953"
    [8]=>
    string(8) "27153954"
    [9]=>
    string(8) "27153955"
    [10]=>
    string(8) "27153956"
    [11]=>
    string(8) "27153957"
    [12]=>
    string(8) "27153958"
    [13]=>
    string(8) "27153959"
    [14]=>
    string(8) "27153960"
    [15]=>
    string(8) "27153961"
    [16]=>
    string(8) "27153962"
    [17]=>
    string(8) "27153963"
    [18]=>
    string(8) "27153964"
    [19]=>
    string(8) "27153965"
    [20]=>
    string(8) "27153966"
    [21]=>
    string(8) "27153967"
    [22]=>
    string(8) "27153968"
    [23]=>
    string(8) "27153969"
    [24]=>
    string(8) "27153970"
    [25]=>
    string(8) "27153971"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202520591
        )

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

    [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] => https://my.matterport.com/show/?m=vJnp4G7AiQt&mls=1
        )

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

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

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

    [PublicRemarks] => Array
        (
            [0] => OPEN HOUSE on SUNDAY, 11/9 from 2-5pm. 
Discover the Ultimate North Shore sanctuary, where a private path leads directly to the sand. This oceanfront retreat is designed to showcase breathtaking views of the surf and sunsets from its open-concept living space and updated modern kitchen. Step outside to your private oasis with an expansive back deck and a spacious front lawn—perfect for entertaining or simply soaking in the coastal beauty.

Unlock Future Potential: Per architectural guidance, a two-story home could be built near the existing home's location, providing the opportunity to create your own custom oceanfront masterpiece. An elevation certificate is available, which eliminates the need for flood insurance. Natural sand accumulation in the area enhances the authentic beachside experience and connection to the shoreline.

Co-ownership Opportunity Available for $1,050,000: The seller will consider selling a 25% co-ownership interest to 4 suitable candidates.
        )

    [ListOfficeName] => Array
        (
            [0] => Keller Williams Honolulu
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => adrienne@teamlally.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 227-2703
        )

    [ListAgentFullName] => Array
        (
            [0] => Adrienne W Lally
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-11-05T10:00:01.373
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-09-18
        )

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

    [PropertyFrontage] => Array
        (
            [0] => Ocean,Sandy Beach,Waterfront
        )

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

    [MatrixModifiedTime] => Array
        (
            [0] => 10:00:01.373
        )

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

    [listing_image] => Array
        (
            [0] => 27153946
            [1] => 27153947
            [2] => 27153948
            [3] => 27153949
            [4] => 27153950
            [5] => 27153951
            [6] => 27153952
            [7] => 27153953
            [8] => 27153954
            [9] => 27153955
            [10] => 27153956
            [11] => 27153957
            [12] => 27153958
            [13] => 27153959
            [14] => 27153960
            [15] => 27153961
            [16] => 27153962
            [17] => 27153963
            [18] => 27153964
            [19] => 27153965
            [20] => 27153966
            [21] => 27153967
            [22] => 27153968
            [23] => 27153969
            [24] => 27153970
            [25] => 27153971
        )

)

PROPERTY INFO

• BedsTotal: 4
• Full Baths: 2
• Land Area (sf): 6,744 sf
• Living (sf): 1,814
• Year Built: 1956

KEY FEATURES

• Property Condition: Above Average
• Number of Parking Spaces: 3
• View: Ocean
• Listing Office: Keller Williams Honolulu

FINANCIAL INFO

• Land Tenure: FS - Fee Simple

SCHOOLS

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 November 5, 2025 - 10:00 AM 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.