59-75 HOALUA Street Haleiwa, HI 96712

Listing
Overview

Price: $5,500,000
Area: SUNSET AREA
Status: Active

Beach front bungalow on the North Shore of Oahu with private access to the sand! Amazing surf in the winter and glassy water in the summer. Walk out your back door across your lawn and onto the sand. Spend the day running up and down the bike path to come home and enjoy an open kitchen with a massive view of the ocean. Plenty of outdoor space to garden, meditate, and bask in the sun. Potential to add a garage with an Ohana suite. Listing by: RE/MAX ALOHA HOMES

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202311070"
  }
  ["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(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "5500000.00"
  }
  ["CurrentPrice"]=>
  array(1) {
    [0]=>
    string(10) "5500000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(11) "SUNSET AREA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(433) "Beach front bungalow on the North Shore of Oahu with private access to the sand! Amazing surf in the winter and glassy water in the summer. Walk out your back door across your lawn and onto the sand. Spend the day running up and down the bike path to come home and enjoy an open kitchen with a massive view of the ocean. Plenty of outdoor space to garden, meditate, and bask in the sun. Potential to add a garage with an Ohana suite."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(18) "RE/MAX ALOHA HOMES"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "4"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "3"
  }
  ["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(12) "Sunset Beach"
  }
  ["MiddleOrJuniorSchool"]=>
  array(1) {
    [0]=>
    string(6) "Kahuku"
  }
  ["HighSchool"]=>
  array(1) {
    [0]=>
    string(6) "Kahuku"
  }
  ["ListOfficeMLSID"]=>
  array(1) {
    [0]=>
    string(4) "RMXA"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(26) "sasha@alohahomesagents.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(11) "Sasha Ellul"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2023-11-17T05:37:56.370"
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "17326800"
  }
  ["OriginalEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(23) "2023-05-25T14:05:13.293"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "25850096"
  }
  ["listing_image"]=>
  array(25) {
    [0]=>
    string(8) "25850096"
    [1]=>
    string(8) "25850097"
    [2]=>
    string(8) "25850098"
    [3]=>
    string(8) "25850099"
    [4]=>
    string(8) "25850100"
    [5]=>
    string(8) "25850101"
    [6]=>
    string(8) "25850102"
    [7]=>
    string(8) "25850103"
    [8]=>
    string(8) "25850104"
    [9]=>
    string(8) "25850105"
    [10]=>
    string(8) "25850106"
    [11]=>
    string(8) "25850107"
    [12]=>
    string(8) "25850108"
    [13]=>
    string(8) "25850109"
    [14]=>
    string(8) "25850110"
    [15]=>
    string(8) "25850111"
    [16]=>
    string(8) "25850112"
    [17]=>
    string(8) "25850113"
    [18]=>
    string(8) "25850114"
    [19]=>
    string(8) "25850115"
    [20]=>
    string(8) "25850116"
    [21]=>
    string(8) "25850117"
    [22]=>
    string(8) "25850118"
    [23]=>
    string(8) "25850119"
    [24]=>
    string(8) "25850120"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(11) "North Shore"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(16) "Ocean,Waterfront"
  }
  ["SpecialListingConditions"]=>
  array(1) {
    [0]=>
    string(4) "None"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202311070
        )

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => Beach front bungalow on the North Shore of Oahu with private access to the sand! Amazing surf in the winter and glassy water in the summer. Walk out your back door across your lawn and onto the sand. Spend the day running up and down the bike path to come home and enjoy an open kitchen with a massive view of the ocean. Plenty of outdoor space to garden, meditate, and bask in the sun. Potential to add a garage with an Ohana suite.
        )

    [ListOfficeName] => Array
        (
            [0] => RE/MAX ALOHA HOMES
        )

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => sasha@alohahomesagents.com
        )

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

    [ListAgentFullName] => Array
        (
            [0] => Sasha Ellul
        )

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2023-11-17T05:37:56.370
        )

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

    [OriginalEntryTimestamp] => Array
        (
            [0] => 2023-05-25T14:05:13.293
        )

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

    [listing_image] => Array
        (
            [0] => 25850096
            [1] => 25850097
            [2] => 25850098
            [3] => 25850099
            [4] => 25850100
            [5] => 25850101
            [6] => 25850102
            [7] => 25850103
            [8] => 25850104
            [9] => 25850105
            [10] => 25850106
            [11] => 25850107
            [12] => 25850108
            [13] => 25850109
            [14] => 25850110
            [15] => 25850111
            [16] => 25850112
            [17] => 25850113
            [18] => 25850114
            [19] => 25850115
            [20] => 25850116
            [21] => 25850117
            [22] => 25850118
            [23] => 25850119
            [24] => 25850120
        )

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

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

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

)

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

  • Property Condition: Above Average
  • Number of Parking Spaces: 3
  • View: Ocean
  • Listing Office: RE/MAX ALOHA HOMES

  • 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