54-011 Waikulama Street Hauula, HI 96717

Listing
Overview

Price: $2,180,000
Area: HAUULA
Status: Active

A rare opportunity to own one of the few large parcels in the area—just steps from the ocean and directly across from the shoreline. This unique property consists of two adjacent R-5 zoned lots, totaling nearly 2 acres of land. Whether you're planning a multi-home development or seeking to build a private estate-style family compound, the property offers exceptional flexibility and potential. The lot currently features an attached two-unit residence, each unit offering 3 bedrooms and 1 bathroom—ideal for extended family living or rental income. Enjoy the natural beauty and peaceful charm of Hau?ula, located on O?ahu’s scenic windward coast. Listing by: Shimizu Gateways Inc (808) 222-3378

array(45) {
  ["MLSNumber"]=>
  array(1) {
    [0]=>
    string(9) "202512299"
  }
  ["StreetNumber"]=>
  array(1) {
    [0]=>
    string(6) "54-011"
  }
  ["PropertyType"]=>
  array(1) {
    [0]=>
    string(13) "Single Family"
  }
  ["StreetName"]=>
  array(1) {
    [0]=>
    string(9) "Waikulama"
  }
  ["StreetSuffix"]=>
  array(1) {
    [0]=>
    string(6) "Street"
  }
  ["UnitNumber"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["City"]=>
  array(1) {
    [0]=>
    string(6) "Hauula"
  }
  ["StateOrProvince"]=>
  array(1) {
    [0]=>
    string(2) "HI"
  }
  ["PostalCode"]=>
  array(1) {
    [0]=>
    string(5) "96717"
  }
  ["VirtualTourURLUnbranded"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["ListPrice"]=>
  array(1) {
    [0]=>
    string(10) "2180000.00"
  }
  ["Neighbourhood"]=>
  array(1) {
    [0]=>
    string(6) "HAUULA"
  }
  ["Status"]=>
  array(1) {
    [0]=>
    string(6) "Active"
  }
  ["PublicRemarks"]=>
  array(1) {
    [0]=>
    string(656) "A rare opportunity to own one of the few large parcels in the area—just steps from the ocean and directly across from the shoreline. This unique property consists of two adjacent R-5 zoned lots, totaling nearly 2 acres of land. Whether you're planning a multi-home development or seeking to build a private estate-style family compound, the property offers exceptional flexibility and potential.
The lot currently features an attached two-unit residence, each unit offering 3 bedrooms and 1 bathroom—ideal for extended family living or rental income.
Enjoy the natural beauty and peaceful charm of Hau?ula, located on O?ahu’s scenic windward coast."
  }
  ["ListOfficeName"]=>
  array(1) {
    [0]=>
    string(20) "Shimizu Gateways Inc"
  }
  ["BedsTotal"]=>
  array(1) {
    [0]=>
    string(1) "6"
  }
  ["BathsFull"]=>
  array(1) {
    [0]=>
    string(1) "2"
  }
  ["BathsHalf"]=>
  array(1) {
    [0]=>
    string(1) "0"
  }
  ["LotSizeArea"]=>
  array(1) {
    [0]=>
    string(8) "74378.00"
  }
  ["SqftTotal"]=>
  array(1) {
    [0]=>
    string(4) "1496"
  }
  ["YearBuilt"]=>
  array(1) {
    [0]=>
    string(4) "1973"
  }
  ["BuildingName"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["PropertyCondition"]=>
  array(1) {
    [0]=>
    string(7) "Average"
  }
  ["ParkingTotal"]=>
  array(1) {
    [0]=>
    string(2) "10"
  }
  ["StoriesType"]=>
  array(1) {
    [0]=>
    string(3) "One"
  }
  ["View"]=>
  array(1) {
    [0]=>
    string(14) "Mountain,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(4) "ASKA"
  }
  ["ListAgentEmail"]=>
  array(1) {
    [0]=>
    string(26) "Chikako@gatewayshawaii.com"
  }
  ["ListAgentDirectWorkPhone"]=>
  array(1) {
    [0]=>
    string(14) "(808) 222-3378"
  }
  ["ListAgentFullName"]=>
  array(1) {
    [0]=>
    string(14) "Chikako Tomita"
  }
  ["CloseDate"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["Matrix_Unique_ID"]=>
  array(1) {
    [0]=>
    string(8) "18754988"
  }
  ["MatrixModifiedDT"]=>
  array(1) {
    [0]=>
    string(23) "2025-06-16T13:30:17.810"
  }
  ["ListingContractDate"]=>
  array(1) {
    [0]=>
    string(10) "2025-06-16"
  }
  ["MLSAreaMajor"]=>
  array(1) {
    [0]=>
    string(7) "Kaneohe"
  }
  ["PropertyFrontage"]=>
  array(1) {
    [0]=>
    string(12) "Stream/Canal"
  }
  ["ExemptListingEntryTimestamp"]=>
  array(1) {
    [0]=>
    string(0) ""
  }
  ["MatrixModifiedTime"]=>
  array(1) {
    [0]=>
    string(12) "13:30:17.810"
  }
  ["_thumbnail_id"]=>
  array(1) {
    [0]=>
    string(8) "27032726"
  }
  ["listing_image"]=>
  array(16) {
    [0]=>
    string(8) "27032726"
    [1]=>
    string(8) "27032727"
    [2]=>
    string(8) "27032728"
    [3]=>
    string(8) "27032729"
    [4]=>
    string(8) "27032730"
    [5]=>
    string(8) "27032731"
    [6]=>
    string(8) "27032732"
    [7]=>
    string(8) "27032733"
    [8]=>
    string(8) "27032734"
    [9]=>
    string(8) "27032735"
    [10]=>
    string(8) "27032736"
    [11]=>
    string(8) "27032737"
    [12]=>
    string(8) "27032738"
    [13]=>
    string(8) "27032739"
    [14]=>
    string(8) "27032740"
    [15]=>
    string(8) "27032741"
  }
}
Array
(
    [MLSNumber] => Array
        (
            [0] => 202512299
        )

    [StreetNumber] => Array
        (
            [0] => 54-011
        )

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

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

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

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

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

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

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

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

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

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

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

    [PublicRemarks] => Array
        (
            [0] => A rare opportunity to own one of the few large parcels in the area—just steps from the ocean and directly across from the shoreline. This unique property consists of two adjacent R-5 zoned lots, totaling nearly 2 acres of land. Whether you're planning a multi-home development or seeking to build a private estate-style family compound, the property offers exceptional flexibility and potential.
The lot currently features an attached two-unit residence, each unit offering 3 bedrooms and 1 bathroom—ideal for extended family living or rental income.
Enjoy the natural beauty and peaceful charm of Hau?ula, located on O?ahu’s scenic windward coast.
        )

    [ListOfficeName] => Array
        (
            [0] => Shimizu Gateways Inc
        )

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    [ListAgentEmail] => Array
        (
            [0] => Chikako@gatewayshawaii.com
        )

    [ListAgentDirectWorkPhone] => Array
        (
            [0] => (808) 222-3378
        )

    [ListAgentFullName] => Array
        (
            [0] => Chikako Tomita
        )

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

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

    [MatrixModifiedDT] => Array
        (
            [0] => 2025-06-16T13:30:17.810
        )

    [ListingContractDate] => Array
        (
            [0] => 2025-06-16
        )

    [MLSAreaMajor] => Array
        (
            [0] => Kaneohe
        )

    [PropertyFrontage] => Array
        (
            [0] => Stream/Canal
        )

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

    [MatrixModifiedTime] => Array
        (
            [0] => 13:30:17.810
        )

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

    [listing_image] => Array
        (
            [0] => 27032726
            [1] => 27032727
            [2] => 27032728
            [3] => 27032729
            [4] => 27032730
            [5] => 27032731
            [6] => 27032732
            [7] => 27032733
            [8] => 27032734
            [9] => 27032735
            [10] => 27032736
            [11] => 27032737
            [12] => 27032738
            [13] => 27032739
            [14] => 27032740
            [15] => 27032741
        )

)

  • BedsTotal: 6
  • Full Baths: 2
  • Land Area (sf): 74,378 sf
  • Living (sf): 1,496
  • Year Built: 1973

  • Property Condition: Average
  • Number of Parking Spaces: 10
  • View: Mountain,Ocean
  • Listing Office: Shimizu Gateways Inc

  • 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 June 16, 2025 - 1:30 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.